Cod. DTY -1
Marca DIGIMEC Brasil
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT COUNT(*) AS `count` FROM `polobete_cimatel_db`.`products` AS `Product` WHERE `Product`.`id` = 1708 | 1 | 1 | 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 `Product`.`id` = 1708 LIMIT 1 | 1 | 1 | 0 | |
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` = 1708 AND `CatalogsProduct`.`catalog_id` = `Catalog`.`id`) | 1 | 1 | 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` = 1708 AND `ImagesProduct`.`image_id` = `Image`.`id`) | 1 | 1 | 0 | |
5 | 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` = 1708 | 1 | 1 | 1 | |
6 | 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 `id` < 1708 ORDER BY `id` desc LIMIT 1 | 1 | 1 | 0 | |
7 | 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 `id` > 1708 LIMIT 1 | 1 | 1 | 0 | |
8 | SELECT `CategoriesProduct`.`product_id` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`category_id` = 44 AND `CategoriesProduct`.`product_id` NOT IN (1708, 1707, 1709) | 34 | 34 | 0 | |
9 | 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 (1700, 1701, 1703, 1705, 1706, 1710, 1712, 1713, 1714, 1715, 1716, 1717, 1718, 1719, 1720, 1721, 1723, 1724, 1725, 1726, 1727, 1728, 1729, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1704, 1722, 1730) LIMIT 5 | 5 | 5 | 0 | |
10 | SELECT `Detail`.`id`, `Detail`.`quote_id`, `Detail`.`product_id`, `Detail`.`detail`, `Detail`.`unit_price`, `Detail`.`amount`, `Detail`.`total_price` FROM `polobete_cimatel_db`.`details` AS `Detail` WHERE `Detail`.`product_id` IN (1700, 1701, 1703, 1704, 1705) | 6 | 6 | 1 | |
11 | SELECT `Cart`.`id`, `Cart`.`quantity`, `Cart`.`created_at`, `CartsProduct`.`id`, `CartsProduct`.`cart_id`, `CartsProduct`.`product_id`, `CartsProduct`.`quantity` FROM `polobete_cimatel_db`.`carts` AS `Cart` JOIN `polobete_cimatel_db`.`carts_products` AS `CartsProduct` ON (`CartsProduct`.`product_id` IN (1700, 1701, 1703, 1704, 1705) AND `CartsProduct`.`cart_id` = `Cart`.`id`) | 25 | 25 | 0 | |
12 | 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 (1700, 1701, 1703, 1704, 1705) AND `CatalogsProduct`.`catalog_id` = `Catalog`.`id`) | 1 | 1 | 0 | |
13 | SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug`, `Category`.`position`, `Category`.`image`, `CategoriesProduct`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`subcategory_id` FROM `polobete_cimatel_db`.`categories` AS `Category` JOIN `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` IN (1700, 1701, 1703, 1704, 1705) AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 5 | 5 | 1 | |
14 | 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 (1700, 1701, 1703, 1704, 1705) AND `ImagesProduct`.`image_id` = `Image`.`id`) | 1 | 1 | 0 |