Aromas

(default) 25 queries took 146 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `measures_products`996
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
3SHOW FULL COLUMNS FROM `measures`449
4SHOW FULL COLUMNS FROM `details`775
5SHOW FULL COLUMNS FROM `orders`29297
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';111
7SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
8SHOW FULL COLUMNS FROM `users`9923
9SHOW FULL COLUMNS FROM `profiles`151513
10SHOW FULL COLUMNS FROM `countries`5511
11SHOW FULL COLUMNS FROM `districts`5534
12SHOW FULL COLUMNS FROM `prepareds`777
13SHOW FULL COLUMNS FROM `categories_products`226
14SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` IS NULL 15150
15SHOW FULL COLUMNS FROM `ads`7712
16SELECT `Ad`.`id`, `Ad`.`types`, `Ad`.`title`, `Ad`.`picture`, `Ad`.`link`, `Ad`.`created`, `Ad`.`modified` FROM `ads` AS `Ad` WHERE `Ad`.`types` = 0 ORDER BY `Ad`.`created` DESC LIMIT 1111
17SELECT `Ad`.`id`, `Ad`.`types`, `Ad`.`title`, `Ad`.`picture`, `Ad`.`link`, `Ad`.`created`, `Ad`.`modified` FROM `ads` AS `Ad` WHERE `Ad`.`types` = 1 ORDER BY `Ad`.`created` DESC LIMIT 1110
18SHOW FULL COLUMNS FROM `products_groups`555
19SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`slug_url`, `Category`.`slug`, `Category`.`description`, `Category`.`foto`, `Category`.`thumb`, `Category`.`nombre_css`, `Category`.`order`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`id` = 8 LIMIT 1111
20SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`products_group_id`, `Product`.`name`, `Product`.`description`, `Product`.`description2`, `Product`.`label_1`, `Product`.`label_2`, `Product`.`code`, `Product`.`price`, `Product`.`tax`, `Product`.`special_price`, `Product`.`special_tax`, `Product`.`precio_usdollar`, `Product`.`etiqueta`, `Product`.`detalle_medida`, `Product`.`medida_id`, `Product`.`stock`, `Product`.`product_new`, `Product`.`picture`, `Product`.`detalle`, `Product`.`thumb`, `Product`.`picture_2`, `Product`.`detalle_2`, `Product`.`thumb_2`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `products` AS `Product` JOIN `categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 8 AND `CategoriesProduct`.`product_id` = `Product`.`id`) 001
21SELECT `Category`.`id`, `Category`.`parent_id` FROM `categories` AS `Category` WHERE `Category`.`id` = 8 LIMIT 1110
22SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`products_group_id`, `Product`.`name`, `Product`.`description`, `Product`.`description2`, `Product`.`label_1`, `Product`.`label_2`, `Product`.`code`, `Product`.`price`, `Product`.`tax`, `Product`.`special_price`, `Product`.`special_tax`, `Product`.`precio_usdollar`, `Product`.`etiqueta`, `Product`.`detalle_medida`, `Product`.`medida_id`, `Product`.`stock`, `Product`.`product_new`, `Product`.`picture`, `Product`.`detalle`, `Product`.`thumb`, `Product`.`picture_2`, `Product`.`detalle_2`, `Product`.`thumb_2`, `Product`.`created`, `Product`.`modified`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `products` AS `Product` JOIN `categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 8 AND `CategoriesProduct`.`product_id` = `Product`.`id`) 000
23SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` IS NULL ORDER BY `Category`.`order` ASC 15150
24SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 8 ORDER BY `Category`.`order` ASC 221
25SELECT `Category`.`id`, `Category`.`name`, `Category`.`thumb` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 8 ORDER BY `Category`.`order` ASC 221