Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT COUNT(*) AS `count` FROM `polobete_cimatel_db`.`products` AS `Product` WHERE `Product`.`id` = 2189 | 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` = 2189 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` = 2189 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` = 2189 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` = 2189 | 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` < 2189 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` > 2189 LIMIT 1 | 1 | 1 | 0 | |
8 | SELECT `CategoriesProduct`.`product_id` FROM `polobete_cimatel_db`.`categories_products` AS `CategoriesProduct` WHERE `CategoriesProduct`.`category_id` = 34 AND `CategoriesProduct`.`product_id` NOT IN (2189, 2188, 2190) | 170 | 170 | 1 | |
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 (2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2151, 2152, 2153, 2154, 2155, 2156, 2157, 2158, 2159, 2160, 2161, 2162, 2163, 2164, 2165, 2166, 2167, 2168, 2169, 2170, 2171, 2172, 2173, 2174, 2175, 2176, 2177, 2178, 2179, 2180, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2191, 2192, 2193, 2194, 2195, 2196, 2197, 2198, 2199, 2200, 2201, 2202, 2203, 2204, 2205, 2206, 2207, 2208, 2209, 2210, 2211, 2212, 2213, 2214, 2215, 2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 2250, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2263, 2264, 2265, 2266, 2267, 2268, 2269, 2270, 2271, 2272, 2273, 2274, 2275, 2276, 2277, 2278, 2279, 2280, 2281, 2282, 2283, 2284, 2285, 2286, 2287, 2288, 2289, 2290, 2291, 2292, 2293, 2294, 2295, 2296, 2297, 2298, 2299, 2300, 2301, 2302, 2303, 2304, 2305, 2306, 2307) LIMIT 5 | 5 | 5 | 1 | |
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 (2135, 2136, 2137, 2138, 2139) | 13 | 13 | 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 (2135, 2136, 2137, 2138, 2139) AND `CartsProduct`.`cart_id` = `Cart`.`id`) | 9 | 9 | 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 (2135, 2136, 2137, 2138, 2139) AND `CatalogsProduct`.`catalog_id` = `Catalog`.`id`) | 5 | 5 | 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 (2135, 2136, 2137, 2138, 2139) 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 (2135, 2136, 2137, 2138, 2139) AND `ImagesProduct`.`image_id` = `Image`.`id`) | 5 | 5 | 0 |