Aromas de los Andes

Antibacteriales
Jabones Líquidos
Cremas hidratantes
Aceites para masajes
Sales marinas
Inciensos orgánicos
Bolsas aromatizadoras
(default) 61 queries took 544 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `categories`14148
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `products`272716
4SHOW FULL COLUMNS FROM `medidas`448
5SHOW FULL COLUMNS FROM `stocks`8825
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
7SHOW FULL COLUMNS FROM `measures_products`9936
8SHOW FULL COLUMNS FROM `measures`4423
9SHOW FULL COLUMNS FROM `details`7730
10SHOW FULL COLUMNS FROM `orders`292913
11SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';111
12SHOW FULL COLUMNS FROM `users`9937
13SHOW FULL COLUMNS FROM `profiles`15159
14SHOW FULL COLUMNS FROM `countries`5515
15SHOW FULL COLUMNS FROM `districts`5541
16SHOW FULL COLUMNS FROM `prepareds`7768
17SHOW FULL COLUMNS FROM `categories_products`2255
18SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` IS NULL 15151
19SHOW FULL COLUMNS FROM `ads`7756
20SELECT `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 1110
21SELECT `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
22SHOW FULL COLUMNS FROM `products_groups`558
23SELECT `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` = 154 LIMIT 1111
24SELECT `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` = 154 AND `CategoriesProduct`.`product_id` = `Product`.`id`) 001
25SELECT `Category`.`id`, `Category`.`parent_id` FROM `categories` AS `Category` WHERE `Category`.`id` = 154 LIMIT 1110
26SELECT `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` = 154 AND `CategoriesProduct`.`product_id` = `Product`.`id`) 001
27SELECT `Category`.`id`, `Category`.`parent_id` FROM `categories` AS `Category` WHERE `Category`.`id` = 12 LIMIT 1110
28SELECT `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` = 12 AND `CategoriesProduct`.`product_id` = `Product`.`id`) 000
29SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` IS NULL ORDER BY `Category`.`order` ASC 15150
30SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 12 ORDER BY `Category`.`order` ASC 330
31SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 154 ORDER BY `Category`.`order` ASC 771
32SELECT `Category`.`id` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 154 771
33SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 154 ORDER BY `Category`.`order` ASC 770
34SELECT `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` = 194 AND `Product`.`products_group_id` <> 0 GROUP BY `Product`.`products_group_id` ORDER BY `Product`.`name` ASC 004
35SELECT `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` = 194 AND `Product`.`products_group_id` = 0 ORDER BY `Product`.`name` ASC 225
36SELECT `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 (1198, 1395) 221
37SELECT `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 (1198, 1395) AND `CategoriesProduct`.`category_id` = `Category`.`id`) 331
38SELECT `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` = 180 AND `Product`.`products_group_id` <> 0 GROUP BY `Product`.`products_group_id` ORDER BY `Product`.`name` ASC 004
39SELECT `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` = 180 AND `Product`.`products_group_id` = 0 ORDER BY `Product`.`name` ASC 446
40SELECT `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 (1184, 1181, 1182, 1180) 441
41SELECT `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 (1184, 1181, 1182, 1180) AND `CategoriesProduct`.`category_id` = `Category`.`id`) 881
42SELECT `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` = 181 AND `Product`.`products_group_id` <> 0 GROUP BY `Product`.`products_group_id` ORDER BY `Product`.`name` ASC 004
43SELECT `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` = 181 AND `Product`.`products_group_id` = 0 ORDER BY `Product`.`name` ASC 668
44SELECT `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 (1185, 1186, 1190, 1188, 1187, 1191) 661
45SELECT `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 (1185, 1186, 1190, 1188, 1187, 1191) AND `CategoriesProduct`.`category_id` = `Category`.`id`) 12121
46SELECT `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` = 182 AND `Product`.`products_group_id` <> 0 GROUP BY `Product`.`products_group_id` ORDER BY `Product`.`name` ASC 005
47SELECT `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` = 182 AND `Product`.`products_group_id` = 0 ORDER BY `Product`.`name` ASC 113
48SELECT `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` = (1192) 111
49SELECT `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` = 1192 AND `CategoriesProduct`.`category_id` = `Category`.`id`) 221
50SELECT `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` = 183 AND `Product`.`products_group_id` <> 0 GROUP BY `Product`.`products_group_id` ORDER BY `Product`.`name` ASC 004
51SELECT `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` = 183 AND `Product`.`products_group_id` = 0 ORDER BY `Product`.`name` ASC 669
52SELECT `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 (1194, 1197, 1195, 1196, 1396, 1193) 661
53SELECT `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 (1194, 1197, 1195, 1196, 1396, 1193) AND `CategoriesProduct`.`category_id` = `Category`.`id`) 11111
54SELECT `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` = 184 AND `Product`.`products_group_id` <> 0 GROUP BY `Product`.`products_group_id` ORDER BY `Product`.`name` ASC 004
55SELECT `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` = 184 AND `Product`.`products_group_id` = 0 ORDER BY `Product`.`name` ASC 113
56SELECT `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` = (1205) 111
57SELECT `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` = 1205 AND `CategoriesProduct`.`category_id` = `Category`.`id`) 331
58SELECT `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` = 185 AND `Product`.`products_group_id` <> 0 GROUP BY `Product`.`products_group_id` ORDER BY `Product`.`name` ASC 005
59SELECT `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` = 185 AND `Product`.`products_group_id` = 0 ORDER BY `Product`.`name` ASC 558
60SELECT `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 (1208, 1210, 1206, 1209, 1207) 551
61SELECT `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 (1208, 1210, 1206, 1209, 1207) AND `CategoriesProduct`.`category_id` = `Category`.`id`) 10102