Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Shop`.`id`, `Shop`.`seller_id`, `Shop`.`name`, `Shop`.`slug`, `Shop`.`description`, `Seller`.`id`, `Seller`.`member_id` FROM `lenjerieerotica_ro`.`shops` AS `Shop` LEFT JOIN `lenjerieerotica_ro`.`sellers` AS `Seller` ON (`Shop`.`seller_id` = `Seller`.`id`) WHERE `slug` = 'lenjerieerotica' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `slug` IS NULL | 0 | 0 | 0 | |
SELECT `Product`.`id` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `Product`.`id` = 8983 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`categories` AS `Category` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 8983 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
SELECT `Category`.`lft`, `Category`.`rght` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `Category`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 2 AND `Category`.`rght` >= 3 ORDER BY `Category`.`lft` asc | 2 | 2 | 0 | |
SELECT `Product`.`id` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `id` = 8983 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductRelated`.`id`, `RelatedProduct`.`product_id`, `RelatedProduct`.`related_id` FROM `lenjerieerotica_ro`.`products` AS `ProductRelated` JOIN `lenjerieerotica_ro`.`related_products` AS `RelatedProduct` ON (`RelatedProduct`.`product_id` = 8983 AND `RelatedProduct`.`related_id` = `ProductRelated`.`id`) WHERE `status` = '1' | 0 | 0 | 0 | |
SELECT `Product`.`id` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `id` = 8983 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductRelatedCategory`.`id`, `ProductRelatedCategory`.`name`, `ProductCategoriesRelation`.`category_id`, `ProductCategoriesRelation`.`model_id` FROM `lenjerieerotica_ro`.`categories` AS `ProductRelatedCategory` JOIN `lenjerieerotica_ro`.`product_categories_relations` AS `ProductCategoriesRelation` ON (`ProductCategoriesRelation`.`model_id` = 8983 AND `ProductCategoriesRelation`.`category_id` = `ProductRelatedCategory`.`id`) | 0 | 0 | 0 | |
SELECT `Product`.`id` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `Product`.`id` = 8983 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`categories` AS `Category` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 8983 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
SELECT `Category`.`lft`, `Category`.`rght` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `Category`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 2 AND `Category`.`rght` >= 3 ORDER BY `Category`.`lft` asc | 2 | 2 | 0 | |
SELECT `Category`.`id` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `id` = 15 LIMIT 1 | 1 | 1 | 0 | |
SELECT `RelatedCategory`.`id`, `CategoryToCategory`.`category_id`, `CategoryToCategory`.`related_id` FROM `lenjerieerotica_ro`.`categories` AS `RelatedCategory` JOIN `lenjerieerotica_ro`.`category_to_categories` AS `CategoryToCategory` ON (`CategoryToCategory`.`category_id` = 15 AND `CategoryToCategory`.`related_id` = `RelatedCategory`.`id`) | 0 | 0 | 0 | |
SELECT `RelatedCategoryProduct`.`id`, `CategoryRelatedProduct`.`category_id`, `CategoryRelatedProduct`.`product_id` FROM `lenjerieerotica_ro`.`products` AS `RelatedCategoryProduct` JOIN `lenjerieerotica_ro`.`category_related_products` AS `CategoryRelatedProduct` ON (`CategoryRelatedProduct`.`category_id` = 15 AND `CategoryRelatedProduct`.`product_id` = `RelatedCategoryProduct`.`id`) WHERE `status` = '1' | 0 | 0 | 0 | |
SELECT `Product`.`id` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `Product`.`id` = 8983 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`categories` AS `Category` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` = 8983 AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 1 | 1 | 0 | |
SELECT `Category`.`lft`, `Category`.`rght` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `Category`.`id` = 15 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`name`, `Category`.`slug` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`lft` <= 2 AND `Category`.`rght` >= 3 ORDER BY `Category`.`lft` asc | 2 | 2 | 0 | |
SELECT `Category`.`id` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `Category`.`id` = 15 AND `status` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`display_name`, `Product`.`slug`, `Product`.`image`, `Product`.`price`, `Product`.`temp_1`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`products` AS `Product` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 15 AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE NOT (`Product`.`id` = 8983) AND `Product`.`status` = '1' ORDER BY RAND() ASC LIMIT 4 | 4 | 4 | 1 | maybe slow |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (10422) LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8973) LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8971) LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`id`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8974) LIMIT 1 | 0 | 0 | 0 | |
UPDATE `lenjerieerotica_ro`.`products` AS `Product` SET `Product`.`views` = `Product`.`views` + 1 WHERE `Product`.`id` = 8983 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`display_name`, `Product`.`slug`, `Product`.`image`, `Product`.`temp_1`, `Product`.`price` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE id IN (8983, 10040) AND `status` = '1' ORDER BY FIND_IN_SET(id, '8983, 10040') desc LIMIT 6 | 2 | 2 | 0 | |
SELECT DISTINCT(product_id) FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` LEFT JOIN `lenjerieerotica_ro`.`products` AS `Product` ON (`ProductDiscount`.`product_id` = `Product`.`id`) WHERE 1 = 1 | 33 | 33 | 0 | |
SELECT `Product`.`id`, `Product`.`display_name`, `Product`.`slug`, `Product`.`price`, `Product`.`image`, `Product`.`temp_1` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE id IN (94, 95, 97, 98, 100, 101, 304, 305, 684, 688, 689, 692, 693, 698, 699, 700, 701, 702, 704, 755, 758, 770, 927, 985, 987, 5863, 5872, 5874, 6011, 6032, 6215, 6268, 6326) AND `status` = '1' ORDER BY RAND() ASC LIMIT 4 | 2 | 2 | 1 | maybe slow |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (95) LIMIT 1 | 1 | 1 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (97) LIMIT 1 | 1 | 1 | 0 | |