Quintaesencias Aura-Soma

(default) 22 queries took 50 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` IS NULL 15151
2SELECT `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
3SELECT `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
4SELECT `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` = 26 LIMIT 1111
5SELECT `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` = 26 AND `CategoriesProduct`.`product_id` = `Product`.`id`) 000
6SELECT `Category`.`id`, `Category`.`parent_id` FROM `categories` AS `Category` WHERE `Category`.`id` = 26 LIMIT 1110
7SELECT `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` = 26 AND `CategoriesProduct`.`product_id` = `Product`.`id`) 001
8SELECT `Category`.`id`, `Category`.`parent_id` FROM `categories` AS `Category` WHERE `Category`.`id` = 9 LIMIT 1111
9SELECT `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` = 9 AND `CategoriesProduct`.`product_id` = `Product`.`id`) 001
10SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` IS NULL ORDER BY `Category`.`order` ASC 15151
11SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 9 ORDER BY `Category`.`order` ASC 441
12SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 26 ORDER BY `Category`.`order` ASC 221
13SELECT `Category`.`id` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 26 221
14SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 26 ORDER BY `Category`.`order` ASC 220
15SELECT `Product`.`id`, `Product`.`name`, `Product`.`category_id`, `Product`.`products_group_id`, `Product`.`detalle`, `Product`.`price`, `Product`.`tax`, `Product`.`special_price`, `Product`.`special_tax`, `Product`.`precio_usdollar`, `Product`.`stock` FROM `products` AS `Product` LEFT JOIN `medidas` AS `Medida` ON (`Product`.`medida_id` = `Medida`.`id`) LEFT JOIN `stocks` AS `Stock` ON (`Stock`.`product_id` = `Product`.`id`) WHERE `Product`.`category_id` = 158 AND `Product`.`products_group_id` <> 0 GROUP BY `Product`.`products_group_id` ORDER BY `Product`.`name` ASC 004
16SELECT `Product`.`id`, `Product`.`name`, `Product`.`category_id`, `Product`.`products_group_id`, `Product`.`detalle`, `Product`.`price`, `Product`.`tax`, `Product`.`special_price`, `Product`.`special_tax`, `Product`.`precio_usdollar`, `Product`.`stock` FROM `products` AS `Product` LEFT JOIN `medidas` AS `Medida` ON (`Product`.`medida_id` = `Medida`.`id`) LEFT JOIN `stocks` AS `Stock` ON (`Stock`.`product_id` = `Product`.`id`) LEFT JOIN `categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `CategoriesProduct`.`category_id` = 158 AND `Product`.`products_group_id` = 0 ORDER BY `Product`.`name` ASC 141414
17SELECT `MeasuresProduct`.`id`, `MeasuresProduct`.`measure_id`, `MeasuresProduct`.`product_id`, `MeasuresProduct`.`code`, `MeasuresProduct`.`price`, `MeasuresProduct`.`tax`, `MeasuresProduct`.`special_price`, `MeasuresProduct`.`special_tax`, `MeasuresProduct`.`usd` FROM `measures_products` AS `MeasuresProduct` WHERE `MeasuresProduct`.`product_id` IN (502, 500, 501, 499, 495, 492, 494, 503, 493, 491, 504, 497, 496, 490) 14141
18SELECT `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`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories` AS `Category` JOIN `categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` IN (502, 500, 501, 499, 495, 492, 494, 503, 493, 491, 504, 497, 496, 490) AND `CategoriesProduct`.`category_id` = `Category`.`id`) 20201
19SELECT `Product`.`id`, `Product`.`name`, `Product`.`category_id`, `Product`.`products_group_id`, `Product`.`detalle`, `Product`.`price`, `Product`.`tax`, `Product`.`special_price`, `Product`.`special_tax`, `Product`.`precio_usdollar`, `Product`.`stock` FROM `products` AS `Product` LEFT JOIN `medidas` AS `Medida` ON (`Product`.`medida_id` = `Medida`.`id`) LEFT JOIN `stocks` AS `Stock` ON (`Stock`.`product_id` = `Product`.`id`) WHERE `Product`.`category_id` = 159 AND `Product`.`products_group_id` <> 0 GROUP BY `Product`.`products_group_id` ORDER BY `Product`.`name` ASC 003
20SELECT `Product`.`id`, `Product`.`name`, `Product`.`category_id`, `Product`.`products_group_id`, `Product`.`detalle`, `Product`.`price`, `Product`.`tax`, `Product`.`special_price`, `Product`.`special_tax`, `Product`.`precio_usdollar`, `Product`.`stock` FROM `products` AS `Product` LEFT JOIN `medidas` AS `Medida` ON (`Product`.`medida_id` = `Medida`.`id`) LEFT JOIN `stocks` AS `Stock` ON (`Stock`.`product_id` = `Product`.`id`) LEFT JOIN `categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `CategoriesProduct`.`category_id` = 159 AND `Product`.`products_group_id` = 0 ORDER BY `Product`.`name` ASC 151515
21SELECT `MeasuresProduct`.`id`, `MeasuresProduct`.`measure_id`, `MeasuresProduct`.`product_id`, `MeasuresProduct`.`code`, `MeasuresProduct`.`price`, `MeasuresProduct`.`tax`, `MeasuresProduct`.`special_price`, `MeasuresProduct`.`special_tax`, `MeasuresProduct`.`usd` FROM `measures_products` AS `MeasuresProduct` WHERE `MeasuresProduct`.`product_id` IN (527, 523, 534, 528, 522, 530, 535, 533, 525, 532, 531, 524, 521, 526, 529) 12121
22SELECT `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`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories` AS `Category` JOIN `categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` IN (527, 523, 534, 528, 522, 530, 535, 533, 525, 532, 531, 524, 521, 526, 529) AND `CategoriesProduct`.`category_id` = `Category`.`id`) 16161