Snatam Kaur

Notice (8): Undefined index:  etiqueta [APP\views\categories\view.ctp, line 319]
(default) 69 queries took 436 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `categories`141423
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';112
3SHOW FULL COLUMNS FROM `products`272723
4SHOW FULL COLUMNS FROM `medidas`4423
5SHOW FULL COLUMNS FROM `stocks`8812
6SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
7SHOW FULL COLUMNS FROM `measures_products`9915
8SHOW FULL COLUMNS FROM `measures`446
9SHOW FULL COLUMNS FROM `details`777
10SHOW FULL COLUMNS FROM `orders`29296
11SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';111
12SHOW FULL COLUMNS FROM `users`9929
13SHOW FULL COLUMNS FROM `profiles`151530
14SHOW FULL COLUMNS FROM `countries`5521
15SHOW FULL COLUMNS FROM `districts`5510
16SHOW FULL COLUMNS FROM `prepareds`7717
17SHOW FULL COLUMNS FROM `categories_products`2241
18SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` IS NULL 15151
19SHOW FULL COLUMNS FROM `ads`7759
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 1111
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 1111
22SHOW FULL COLUMNS FROM `products_groups`5544
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` = 76 LIMIT 1112
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` = 76 AND `CategoriesProduct`.`product_id` = `Product`.`id`) 11112
25SELECT `Category`.`id`, `Category`.`parent_id` FROM `categories` AS `Category` WHERE `Category`.`id` = 76 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` = 76 AND `CategoriesProduct`.`product_id` = `Product`.`id`) 11111
27SELECT `Category`.`id`, `Category`.`parent_id` FROM `categories` AS `Category` WHERE `Category`.`id` = 11 LIMIT 1111
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` = 11 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` = 11 ORDER BY `Category`.`order` ASC 770
31SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 76 ORDER BY `Category`.`order` ASC 001
32SELECT `Category`.`id` FROM `categories` AS `Category` WHERE `Category`.`parent_id` = 76 002
33SELECT `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` = 76 AND `Product`.`products_group_id` <> 0 GROUP BY `Product`.`products_group_id` ORDER BY `Product`.`name` ASC 004
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`) LEFT JOIN `categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `CategoriesProduct`.`category_id` = 76 AND `Product`.`products_group_id` = 0 ORDER BY `Product`.`name` ASC 111117
35SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 1057 112
36SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 1057 111
37SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 1055 113
38SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 1055 112
39SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 1062 111
40SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 1062 111
41SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 1061 111
42SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 1061 111
43SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 1056 112
44SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 1056 111
45SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 1059 111
46SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 1059 111
47SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 1058 111
48SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 1058 111
49SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 1054 111
50SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 1054 111
51SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 1052 112
52SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 1052 111
53SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 1053 111
54SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 1053 111
55SELECT `Stock`.`id`, `Stock`.`product_id`, `Stock`.`measures_product_id`, `Stock`.`code`, `Stock`.`stock`, `Stock`.`status`, `Stock`.`created`, `Stock`.`modified` FROM `stocks` AS `Stock` WHERE `Stock`.`product_id` = 38 111
56SELECT `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` FROM `products` AS `Product` WHERE `Product`.`id` = 38 111
57SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 1057 330
58SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 1055 331
59SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 1062 331
60SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 1061 330
61SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 1056 330
62SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 1059 330
63SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 1058 330
64SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 1054 331
65SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 1052 330
66SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 1053 330
67SELECT `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`product_id` = 38 330
68SELECT `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 (1057, 1055, 1062, 1061, 1056, 1059, 1058, 1054, 1052, 1053, 38) 001
69SELECT `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 (1057, 1055, 1062, 1061, 1056, 1059, 1058, 1054, 1052, 1053, 38) AND `CategoriesProduct`.`category_id` = `Category`.`id`) 33331