Código: TRA303001
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` = 'linea-tramontina' LIMIT 1 | 1 | 1 | 0 | |
2 | SELECT `CategoriesProduct`.`product_id` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`category_id` = 65 | 49 | 49 | 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 (517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565) 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 (523, 524, 525, 537, 550, 564, 530, 544, 557, 535, 548, 562, 534, 547, 561, 531, 545, 558) AND `CatalogsProduct`.`catalog_id` = `Catalog`.`id`) | 48 | 48 | 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 (523, 524, 525, 537, 550, 564, 530, 544, 557, 535, 548, 562, 534, 547, 561, 531, 545, 558) AND `ImagesProduct`.`image_id` = `Image`.`id`) | 20 | 20 | 0 | |
6 | SELECT COUNT(*) AS `count` FROM `polobete_cimatel_db`.`products` AS `Product` WHERE `Product`.`id` IN (517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565) GROUP BY `Product`.`id` | 49 | 49 | 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` = 523 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` = 524 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` = 525 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` = 537 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` = 550 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` = 564 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` = 530 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` = 544 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` = 557 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` = 535 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` = 548 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` = 562 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` = 534 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` = 547 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` = 561 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` = 531 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` = 545 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` = 558 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 |