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 | 1 | maybe slow |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`slug`, `Category`.`name` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE slug IN ('lenjerie-fetish', 'ea') ORDER BY `lft` asc | 2 | 2 | 1 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`banner`, `Category`.`banner_url`, `Category`.`description`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`top`, `Category`.`column`, `Category`.`sort_order`, `Category`.`status`, `Category`.`views` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE `slug` = 'ea' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`banner` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 33 ORDER BY `sort_order` ASC | 0 | 0 | 0 | |
SELECT `Category`.`id` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE id = (33) | 1 | 1 | 0 | |
SELECT `Product`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`products` AS `Product` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 33 AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' | 79 | 79 | 2 | |
SELECT `Product`.`id`, `Product`.`name`, `Product`.`display_name`, `Product`.`slug`, `Product`.`image`, `Product`.`price`, `Product`.`description`, `Product`.`temp_1` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `Product`.`id` IN (4645, 6620, 6624, 8215, 8217, 8227, 8233, 8235, 8476, 8237, 8239, 8240, 8478, 8241, 8247, 8248, 8255, 8483, 8259, 8270, 8485, 8494, 8272, 8273, 8516, 8519, 8274, 8275, 8276, 8277, 8512, 8507, 8292, 8304, 8308, 8503, 8325, 8502, 8326, 8501, 8327, 8328, 8493, 8491, 8488, 8329, 8330, 8333, 8334, 8335, 8336, 8337, 8338, 8439, 8339, 8341, 8433, 8432, 8352, 8431, 8430, 8429, 8356, 8358, 8360, 8362, 8425, 8420, 8418, 8382, 8383, 8385, 8387, 8413, 8392, 8398, 8394, 8396, 8496) ORDER BY `Product`.`priority` desc, `Product`.`id` desc LIMIT 24 | 24 | 24 | 2 | maybe slow |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8519) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8516) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8512) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8507) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8503) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8502) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8501) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8496) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8494) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8493) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8491) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8488) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8485) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8483) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8478) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8476) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8439) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8433) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8432) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8431) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8430) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8429) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8425) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (8420) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `Category`.`name`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `lenjerieerotica_ro`.`categories` AS `Category` JOIN `lenjerieerotica_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`product_id` IN (8519, 8516, 8512, 8507, 8503, 8502, 8501, 8496, 8494, 8493, 8491, 8488, 8485, 8483, 8478, 8476, 8439, 8433, 8432, 8431, 8430, 8429, 8425, 8420) AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 24 | 24 | 1 | |
SELECT COUNT(*) AS `count` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `Product`.`id` IN (4645, 6620, 6624, 8215, 8217, 8227, 8233, 8235, 8476, 8237, 8239, 8240, 8478, 8241, 8247, 8248, 8255, 8483, 8259, 8270, 8485, 8494, 8272, 8273, 8516, 8519, 8274, 8275, 8276, 8277, 8512, 8507, 8292, 8304, 8308, 8503, 8325, 8502, 8326, 8501, 8327, 8328, 8493, 8491, 8488, 8329, 8330, 8333, 8334, 8335, 8336, 8337, 8338, 8439, 8339, 8341, 8433, 8432, 8352, 8431, 8430, 8429, 8356, 8358, 8360, 8362, 8425, 8420, 8418, 8382, 8383, 8385, 8387, 8413, 8392, 8398, 8394, 8396, 8496) | 1 | 1 | 1 | |
UPDATE `lenjerieerotica_ro`.`categories` AS `Category` SET `Category`.`views` = `Category`.`views` + 1 WHERE `Category`.`id` = 33 | 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 `status` = '1' ORDER BY RAND() ASC LIMIT 6 | 6 | 6 | 6 | |
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 | |