Código: MAI100001
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 46]
Warning (2): Trying to access array offset on value of type null [APP/View/Products/index.ctp, line 46]
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` = 'aislacion' LIMIT 1 | 1 | 1 | 0 | |
2 | SELECT `CategoriesProduct`.`product_id` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`category_id` = 1 | 51 | 51 | 0 | |
3 | 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 `Product`.`id` IN (3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 3051, 3052, 3053, 3054, 3055, 3056, 3057, 3058, 3059, 3061, 3062, 3063, 3064, 3065, 3066, 3067, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3086, 3036, 3037, 3060) GROUP BY `Product`.`id` ORDER BY `Product`.`content` ASC LIMIT 18 | 18 | 18 | 0 | |
4 | 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 (3036, 3037, 3043, 3040, 3044, 3038, 3039, 3060, 3046, 3047, 3048, 3049, 3050, 3051, 3052, 3053, 3054, 3055) AND `CatalogsProduct`.`catalog_id` = `Catalog`.`id`) | 22 | 22 | 0 | |
5 | 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 (3036, 3037, 3043, 3040, 3044, 3038, 3039, 3060, 3046, 3047, 3048, 3049, 3050, 3051, 3052, 3053, 3054, 3055) AND `ImagesProduct`.`image_id` = `Image`.`id`) | 22 | 22 | 0 | |
6 | SELECT COUNT(*) AS `count` FROM `polobete_cimatel_db`.`products` AS `Product` WHERE `Product`.`id` IN (3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3050, 3051, 3052, 3053, 3054, 3055, 3056, 3057, 3058, 3059, 3061, 3062, 3063, 3064, 3065, 3066, 3067, 3068, 3069, 3070, 3071, 3072, 3073, 3074, 3075, 3076, 3077, 3078, 3079, 3080, 3081, 3082, 3083, 3084, 3085, 3086, 3036, 3037, 3060) GROUP BY `Product`.`id` | 51 | 51 | 0 | |
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` = 3036 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` = 3037 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` = 3043 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` = 3040 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` = 3044 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` = 3038 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` = 3039 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` = 3060 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` = 3046 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` = 3047 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` = 3048 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` = 3049 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` = 3050 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` = 3051 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` = 3052 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` = 3053 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` = 3054 LIMIT 2 | 1 | 1 | 1 | |
24 | 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` = 3055 LIMIT 2 | 1 | 1 | 1 | |
25 | 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 | |
26 | 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 | |
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` = 39 LIMIT 1 | 1 | 1 | 0 | |
28 | 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 |