Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`open`, `Category`.`subcategory_count`, `Category`.`type_count`, `Category`.`order` FROM `profsh_pfshopro`.`categories` AS `Category` WHERE 1 = 1 ORDER BY `Category`.`order` ASC | 7 | 7 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`name`, `Subcategory`.`slug`, `Subcategory`.`order` FROM `profsh_pfshopro`.`subcategories` AS `Subcategory` WHERE `Subcategory`.`category_id` IN (17, 18, 24, 19, 20, 21, 26) | 40 | 40 | 0 | |
SELECT `Producer`.`id`, `Producer`.`name`, `Producer`.`special`, `Producer`.`slug`, `Producer`.`description`, `Producer`.`logo`, `Producer`.`photo`, `Producer`.`catalogue_file`, `Producer`.`catalogue_embed` FROM `profsh_pfshopro`.`producers` AS `Producer` WHERE `Producer`.`special` = '1' | 6 | 6 | 0 | |
SELECT `Store`.`id`, `Store`.`name` FROM `profsh_pfshopro`.`stores` AS `Store` WHERE 1 = 1 | 3 | 3 | 0 | |
SELECT `Producer`.`id`, `Producer`.`name`, `Producer`.`special`, `Producer`.`slug`, `Producer`.`description`, `Producer`.`logo`, `Producer`.`photo`, `Producer`.`catalogue_file`, `Producer`.`catalogue_embed` FROM `profsh_pfshopro`.`producers` AS `Producer` WHERE 1 = 1 | 18 | 18 | 0 | |
SELECT *, `Product`.`id` FROM `profsh_pfshopro`.`products` AS `Product` LEFT JOIN `profsh_pfshopro`.`producers` AS `Producer` ON (`Product`.`producer_id` = `Producer`.`id`) LEFT JOIN `profsh_pfshopro`.`emag_categories` AS `EmagCategory` ON (`Product`.`emag_category_id` = `EmagCategory`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`professional` = '0' AND `Product`.`special` = '1' ORDER BY `Product`.`id` DESC LIMIT 18, 18 | 18 | 18 | 9 | maybe slow |
SELECT `RelatedProduct`.`id`, `RelatedProduct`.`product_id`, `RelatedProduct`.`related_id` FROM `profsh_pfshopro`.`related_products` AS `RelatedProduct` WHERE `RelatedProduct`.`product_id` IN (3135, 3134, 3133, 3132, 3095, 2645, 2644, 2643, 2642, 2319, 1264, 1263, 1262, 1153, 1152, 883, 879, 734) | 47 | 47 | 0 | |
SELECT `Type`.`id`, `Type`.`category_id`, `Type`.`name`, `Type`.`slug`, `ProductsType`.`id`, `ProductsType`.`product_id`, `ProductsType`.`type_id` FROM `profsh_pfshopro`.`types` AS `Type` JOIN `profsh_pfshopro`.`products_types` AS `ProductsType` ON (`ProductsType`.`product_id` IN (3135, 3134, 3133, 3132, 3095, 2645, 2644, 2643, 2642, 2319, 1264, 1263, 1262, 1153, 1152, 883, 879, 734) AND `ProductsType`.`type_id` = `Type`.`id`) | 22 | 22 | 1 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`open`, `Category`.`subcategory_count`, `Category`.`type_count`, `Category`.`order`, `CategoriesProduct`.`id`, `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id` FROM `profsh_pfshopro`.`categories` AS `Category` JOIN `profsh_pfshopro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` IN (3135, 3134, 3133, 3132, 3095, 2645, 2644, 2643, 2642, 2319, 1264, 1263, 1262, 1153, 1152, 883, 879, 734) AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 17 | 17 | 1 | maybe slow |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`name`, `Subcategory`.`slug`, `Subcategory`.`order`, `ProductsSubcategory`.`id`, `ProductsSubcategory`.`product_id`, `ProductsSubcategory`.`subcategory_id` FROM `profsh_pfshopro`.`subcategories` AS `Subcategory` JOIN `profsh_pfshopro`.`products_subcategories` AS `ProductsSubcategory` ON (`ProductsSubcategory`.`product_id` IN (3135, 3134, 3133, 3132, 3095, 2645, 2644, 2643, 2642, 2319, 1264, 1263, 1262, 1153, 1152, 883, 879, 734) AND `ProductsSubcategory`.`subcategory_id` = `Subcategory`.`id`) | 17 | 17 | 1 | maybe slow |
SELECT `PromoCode`.`id`, `PromoCode`.`product_id`, `PromoCode`.`code`, `PromoCode`.`apply_to`, `PromoCode`.`type`, `PromoCode`.`min_order_value`, `PromoCode`.`available_from`, `PromoCode`.`available_to`, `PromoCode`.`value`, `PromoCode`.`created`, `ProductsPromoCode`.`id`, `ProductsPromoCode`.`product_id`, `ProductsPromoCode`.`promo_code_id` FROM `profsh_pfshopro`.`promo_codes` AS `PromoCode` JOIN `profsh_pfshopro`.`products_promo_codes` AS `ProductsPromoCode` ON (`ProductsPromoCode`.`product_id` IN (3135, 3134, 3133, 3132, 3095, 2645, 2644, 2643, 2642, 2319, 1264, 1263, 1262, 1153, 1152, 883, 879, 734) AND `ProductsPromoCode`.`promo_code_id` = `PromoCode`.`id`) | 0 | 0 | 0 | |
SELECT COUNT(*) AS `count` FROM `profsh_pfshopro`.`products` AS `Product` LEFT JOIN `profsh_pfshopro`.`producers` AS `Producer` ON (`Product`.`producer_id` = `Producer`.`id`) LEFT JOIN `profsh_pfshopro`.`emag_categories` AS `EmagCategory` ON (`Product`.`emag_category_id` = `EmagCategory`.`id`) WHERE `Product`.`active` = '1' AND `Product`.`professional` = '0' AND `Product`.`special` = '1' | 1 | 1 | 3 | maybe slow |