| 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`.`id`, `Category`.`parent_id`, `Category`.`slug`, `Category`.`name` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE slug IN ('lenjerie-1', 'catsuit') ORDER BY `lft` asc | 2 | 2 | 0 | |
| 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` = 'catsuit' 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` = 5 ORDER BY `sort_order` ASC | 0 | 0 | 0 | |
| SELECT `Category`.`id` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE id = (5) | 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` = 5 AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' | 118 | 118 | 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 (4103, 4104, 4106, 4351, 4353, 4365, 4366, 4369, 4370, 4372, 4373, 4377, 4677, 5012, 6293, 6296, 6535, 6695, 6696, 6697, 7294, 7295, 7296, 7297, 7298, 7301, 7302, 7303, 7304, 7305, 7306, 7308, 7310, 7369, 7371, 7375, 7377, 8298, 8299, 8300, 8302, 8303, 8305, 8307, 8311, 8312, 8314, 8347, 8354, 8357, 8361, 8363, 8365, 8367, 8369, 8371, 8372, 8376, 8384, 8386, 8388, 8399, 8401, 8403, 8404, 8405, 8406, 8408, 8409, 8410, 8411, 8412, 8414, 8416, 8421, 8461, 8462, 8827, 8829, 10053, 10057, 10061, 10066, 10073, 10077, 10086, 10100, 10102, 10105, 10109, 10117, 10130, 10135, 10145, 10151, 10157, 10164, 10173, 10175, 10180, 10185, 10188, 10194, 10207, 10212, 10216, 10220, 10222, 10233, 10239, 10247, 10254, 10261, 10267, 10285, 10301, 10322, 10340) ORDER BY `Product`.`priority` desc, `Product`.`id` desc LIMIT 24 | 24 | 24 | 3 | maybe slow |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (10340) 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` = (10322) 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` = (10301) 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` = (10285) 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` = (10267) 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` = (10261) 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` = (10254) 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` = (10247) 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` = (10239) 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` = (10233) 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` = (10222) 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` = (10220) 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` = (10216) 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` = (10212) 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` = (10207) 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` = (10194) 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` = (10188) 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` = (10185) 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` = (10180) 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` = (10175) 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` = (10173) 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` = (10164) 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` = (10157) 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` = (10151) 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 (10340, 10322, 10301, 10285, 10267, 10261, 10254, 10247, 10239, 10233, 10222, 10220, 10216, 10212, 10207, 10194, 10188, 10185, 10180, 10175, 10173, 10164, 10157, 10151) AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 24 | 24 | 0 | |
| SELECT COUNT(*) AS `count` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `Product`.`id` IN (4103, 4104, 4106, 4351, 4353, 4365, 4366, 4369, 4370, 4372, 4373, 4377, 4677, 5012, 6293, 6296, 6535, 6695, 6696, 6697, 7294, 7295, 7296, 7297, 7298, 7301, 7302, 7303, 7304, 7305, 7306, 7308, 7310, 7369, 7371, 7375, 7377, 8298, 8299, 8300, 8302, 8303, 8305, 8307, 8311, 8312, 8314, 8347, 8354, 8357, 8361, 8363, 8365, 8367, 8369, 8371, 8372, 8376, 8384, 8386, 8388, 8399, 8401, 8403, 8404, 8405, 8406, 8408, 8409, 8410, 8411, 8412, 8414, 8416, 8421, 8461, 8462, 8827, 8829, 10053, 10057, 10061, 10066, 10073, 10077, 10086, 10100, 10102, 10105, 10109, 10117, 10130, 10135, 10145, 10151, 10157, 10164, 10173, 10175, 10180, 10185, 10188, 10194, 10207, 10212, 10216, 10220, 10222, 10233, 10239, 10247, 10254, 10261, 10267, 10285, 10301, 10322, 10340) | 1 | 1 | 1 | |
| UPDATE `lenjerieerotica_ro`.`categories` AS `Category` SET `Category`.`views` = `Category`.`views` + 1 WHERE `Category`.`id` = 5 | 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 | 5 | maybe slow |
| 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 | |
REDUCERI
ZILNICE
LIVRARE
GRATUITA Pentru comenzi > 300 lei
