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 `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`open`, `Category`.`subcategory_count`, `Category`.`type_count`, `Category`.`order` FROM `profsh_pfshopro`.`categories` AS `Category` WHERE `Category`.`slug` = 'manichiura' ORDER BY `Category`.`order` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Subcategory`.`id`, `Subcategory`.`category_id`, `Subcategory`.`name`, `Subcategory`.`slug`, `Subcategory`.`order` FROM `profsh_pfshopro`.`subcategories` AS `Subcategory` WHERE `Subcategory`.`category_id` = (21) | 5 | 5 | 0 | |
SELECT `Producer`.`id`, `Producer`.`name`, `Producer`.`special`, `Producer`.`slug`, `Producer`.`description`, `Producer`.`logo`, `Producer`.`photo`, `Producer`.`catalogue_file`, `Producer`.`catalogue_embed`, `CategoriesProducer`.`id`, `CategoriesProducer`.`category_id`, `CategoriesProducer`.`producer_id` FROM `profsh_pfshopro`.`producers` AS `Producer` JOIN `profsh_pfshopro`.`categories_producers` AS `CategoriesProducer` ON (`CategoriesProducer`.`category_id` = 21 AND `CategoriesProducer`.`producer_id` = `Producer`.`id`) | 2 | 2 | 0 | |
SELECT `Type`.`id`, `Type`.`category_id`, `Type`.`name`, `Type`.`slug` FROM `profsh_pfshopro`.`types` AS `Type` WHERE `Type`.`category_id` = 21 | 4 | 4 | 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`.`category_filters` LIKE '%{21}%' AND `Product`.`special` = '1' ORDER BY `Product`.`id` DESC LIMIT 18 | 3 | 3 | 10 | maybe slow |
SELECT `RelatedProduct`.`id`, `RelatedProduct`.`product_id`, `RelatedProduct`.`related_id` FROM `profsh_pfshopro`.`related_products` AS `RelatedProduct` WHERE `RelatedProduct`.`product_id` IN (3270, 883, 879) | 0 | 0 | 1 | maybe slow |
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 (3270, 883, 879) AND `ProductsType`.`type_id` = `Type`.`id`) | 4 | 4 | 1 | maybe slow |
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 (3270, 883, 879) AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 4 | 4 | 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 (3270, 883, 879) AND `ProductsSubcategory`.`subcategory_id` = `Subcategory`.`id`) | 5 | 5 | 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 (3270, 883, 879) AND `ProductsPromoCode`.`promo_code_id` = `PromoCode`.`id`) | 0 | 0 | 0 | |