Código: CTM500003
Direccion
Av. Blanco Galindo km. 2 1/2 Nº 1859, zona Hipódromo, Cochabamba
Teléfono
+591 (4) 4246027 - 4242116 - 4294967
Fax
+591 (4) 4242116
Warning (2): Trying to access array offset on value of type null [APP/View/Products/index.ctp, line 49]
Warning (2): Trying to access array offset on value of type null [APP/View/Products/index.ctp, line 49]
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `polobete_cimatel_db`.`categories` AS `Category` WHERE `Category`.`slug` = '53' LIMIT 1 | 0 | 0 | 0 | |
2 | SELECT `Product`.`id`, `Product`.`in_home`, `Product`.`code`, `Product`.`slug`, `Product`.`content`, `Product`.`keywords`, `Product`.`specifications`, `Product`.`price`, `Product`.`show_price`, `Product`.`amount`, `Product`.`views`, `Product`.`enabled`, `Product`.`in_offer`, `Product`.`position` FROM `polobete_cimatel_db`.`products` AS `Product` WHERE 1 = 1 GROUP BY `Product`.`id` ORDER BY `Product`.`content` ASC LIMIT 936, 18 | 18 | 18 | 4 | |
3 | SELECT `Catalog`.`id`, `Catalog`.`name`, `Catalog`.`file_name`, `Catalog`.`path`, `CatalogsProduct`.`catalog_id`, `CatalogsProduct`.`product_id` FROM `polobete_cimatel_db`.`catalogs` AS `Catalog` JOIN `polobete_cimatel_db`.`catalogs_products` AS `CatalogsProduct` ON (`CatalogsProduct`.`product_id` IN (2717, 2718, 2719, 2720, 2721, 2722, 2723, 2229, 2230, 2231, 2232, 2233, 2228, 129, 1348, 1349, 2448, 2451) AND `CatalogsProduct`.`catalog_id` = `Catalog`.`id`) | 0 | 0 | 0 | |
4 | SELECT `Image`.`id`, `Image`.`path`, `Image`.`position`, `Image`.`name`, `ImagesProduct`.`product_id`, `ImagesProduct`.`image_id` FROM `polobete_cimatel_db`.`images` AS `Image` JOIN `polobete_cimatel_db`.`images_products` AS `ImagesProduct` ON (`ImagesProduct`.`product_id` IN (2717, 2718, 2719, 2720, 2721, 2722, 2723, 2229, 2230, 2231, 2232, 2233, 2228, 129, 1348, 1349, 2448, 2451) AND `ImagesProduct`.`image_id` = `Image`.`id`) | 8 | 8 | 0 | |
5 | SELECT COUNT(*) AS `count` FROM `polobete_cimatel_db`.`products` AS `Product` WHERE 1 = 1 GROUP BY `Product`.`id` | 3119 | 3119 | 1 | |
6 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2717 LIMIT 2 | 1 | 1 | 1 | |
7 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2718 LIMIT 2 | 1 | 1 | 1 | |
8 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2719 LIMIT 2 | 1 | 1 | 1 | |
9 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2720 LIMIT 2 | 1 | 1 | 1 | |
10 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2721 LIMIT 2 | 1 | 1 | 1 | |
11 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2722 LIMIT 2 | 1 | 1 | 1 | |
12 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2723 LIMIT 2 | 1 | 1 | 1 | |
13 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2229 LIMIT 2 | 1 | 1 | 1 | |
14 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2230 LIMIT 2 | 1 | 1 | 1 | |
15 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2231 LIMIT 2 | 1 | 1 | 1 | |
16 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2232 LIMIT 2 | 1 | 1 | 1 | |
17 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2233 LIMIT 2 | 1 | 1 | 1 | |
18 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2228 LIMIT 2 | 1 | 1 | 1 | |
19 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 129 LIMIT 2 | 1 | 1 | 1 | |
20 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 1348 LIMIT 2 | 1 | 1 | 1 | |
21 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 1349 LIMIT 2 | 1 | 1 | 1 | |
22 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2448 LIMIT 2 | 1 | 1 | 1 | |
23 | SELECT `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id`, `Category`.`name`, `Category`.`slug`, `Subcategory`.`name`, `Subcategory`.`slug` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` LEFT JOIN `polobete_cimatel_db`.`categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `polobete_cimatel_db`.`categories` AS `Subcategory` ON (`CategoriesProduct`.`subcategory_id` = `Subcategory`.`id`) WHERE `CategoriesProduct`.`product_id` = 2451 LIMIT 2 | 1 | 1 | 1 | |
24 | SELECT `Macrocategory`.`id`, `Macrocategory`.`name`, `Macrocategory`.`slug`, `Macrocategory`.`position` FROM `polobete_cimatel_db`.`macrocategories` AS `Macrocategory` WHERE 1 = 1 ORDER BY `Macrocategory`.`position` ASC | 10 | 10 | 0 | |
25 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug`, `Category`.`position`, `Category`.`image`, `CategoriesMacrocategory`.`id`, `CategoriesMacrocategory`.`category_id`, `CategoriesMacrocategory`.`macrocategory_id`, `CategoriesMacrocategory`.`position` FROM `polobete_cimatel_db`.`categories` AS `Category` JOIN `polobete_cimatel_db`.`categories_macrocategories` AS `CategoriesMacrocategory` ON (`CategoriesMacrocategory`.`macrocategory_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) AND `CategoriesMacrocategory`.`category_id` = `Category`.`id`) ORDER BY `CategoriesMacrocategory`.`position` ASC | 89 | 89 | 0 | |
26 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug`, `Category`.`position`, `Category`.`image` FROM `polobete_cimatel_db`.`categories` AS `Category` WHERE `Category`.`id` = 39 LIMIT 1 | 1 | 1 | 0 | |
27 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug`, `Category`.`position`, `Category`.`image` FROM `polobete_cimatel_db`.`categories` AS `Category` WHERE `Category`.`id` = 53 LIMIT 1 | 1 | 1 | 0 |