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', 'accesorii') 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` = 'accesorii' 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` = 11 ORDER BY `sort_order` ASC | 0 | 0 | 0 | |
SELECT `Category`.`id` FROM `lenjerieerotica_ro`.`categories` AS `Category` WHERE id = (11) | 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` = 11 AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' | 161 | 161 | 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 (1013, 1014, 1015, 1016, 1825, 1830, 1832, 1851, 1853, 1855, 1857, 1860, 1863, 1865, 1866, 1869, 4672, 4676, 4689, 4921, 4943, 4945, 4950, 4952, 4957, 4958, 4959, 4963, 4964, 4966, 4968, 4975, 4986, 4990, 5023, 5095, 5124, 5144, 5195, 5214, 5216, 5286, 5342, 5343, 5344, 5349, 5350, 5351, 5357, 5360, 5419, 5420, 5430, 5436, 5440, 5485, 5489, 5498, 5499, 5500, 5501, 5503, 5504, 6279, 6307, 6318, 6333, 6453, 6455, 6458, 6481, 6483, 6485, 6486, 6618, 6633, 6636, 6638, 6641, 6643, 6646, 6675, 6701, 6702, 6703, 7227, 7355, 7417, 7463, 7465, 7867, 7946, 7947, 7950, 7951, 8002, 8003, 8522, 8736, 8737, 8904, 9120, 9128, 9129, 9130, 9134, 9136, 9239, 9243, 9347, 9348, 9349, 9842, 9843, 9844, 9845, 9847, 9848, 9849, 9850, 9851, 9852, 9853, 9854, 9855, 9856, 9857, 9858, 9859, 9860, 9861, 9862, 9863, 9864, 9866, 9867, 9868, 9869, 9871, 9872, 9873, 9874, 9875, 9876, 9877, 9878, 9879, 9880, 9883, 9884, 9885, 9886, 10121, 10129, 10153, 10158, 10159, 10163, 10165, 10168, 10206) ORDER BY `Product`.`priority` desc, `Product`.`id` desc LIMIT 24, 24 | 24 | 24 | 4 | maybe slow |
SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `lenjerieerotica_ro`.`product_discounts` AS `ProductDiscount` WHERE `ProductDiscount`.`product_id` = (9868) 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` = (9867) 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` = (9866) 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` = (9864) 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` = (9863) 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` = (9862) 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` = (9861) 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` = (9860) 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` = (9859) 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` = (9858) 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` = (9857) 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` = (9856) 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` = (9855) 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` = (9854) 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` = (9853) 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` = (9852) 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` = (9851) 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` = (9850) 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` = (9849) 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` = (9848) 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` = (9847) 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` = (9845) 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` = (9844) 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` = (9843) 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 (9868, 9867, 9866, 9864, 9863, 9862, 9861, 9860, 9859, 9858, 9857, 9856, 9855, 9854, 9853, 9852, 9851, 9850, 9849, 9848, 9847, 9845, 9844, 9843) AND `CategoriesProduct`.`category_id` = `Category`.`id`) | 24 | 24 | 0 | |
SELECT COUNT(*) AS `count` FROM `lenjerieerotica_ro`.`products` AS `Product` WHERE `Product`.`id` IN (1013, 1014, 1015, 1016, 1825, 1830, 1832, 1851, 1853, 1855, 1857, 1860, 1863, 1865, 1866, 1869, 4672, 4676, 4689, 4921, 4943, 4945, 4950, 4952, 4957, 4958, 4959, 4963, 4964, 4966, 4968, 4975, 4986, 4990, 5023, 5095, 5124, 5144, 5195, 5214, 5216, 5286, 5342, 5343, 5344, 5349, 5350, 5351, 5357, 5360, 5419, 5420, 5430, 5436, 5440, 5485, 5489, 5498, 5499, 5500, 5501, 5503, 5504, 6279, 6307, 6318, 6333, 6453, 6455, 6458, 6481, 6483, 6485, 6486, 6618, 6633, 6636, 6638, 6641, 6643, 6646, 6675, 6701, 6702, 6703, 7227, 7355, 7417, 7463, 7465, 7867, 7946, 7947, 7950, 7951, 8002, 8003, 8522, 8736, 8737, 8904, 9120, 9128, 9129, 9130, 9134, 9136, 9239, 9243, 9347, 9348, 9349, 9842, 9843, 9844, 9845, 9847, 9848, 9849, 9850, 9851, 9852, 9853, 9854, 9855, 9856, 9857, 9858, 9859, 9860, 9861, 9862, 9863, 9864, 9866, 9867, 9868, 9869, 9871, 9872, 9873, 9874, 9875, 9876, 9877, 9878, 9879, 9880, 9883, 9884, 9885, 9886, 10121, 10129, 10153, 10158, 10159, 10163, 10165, 10168, 10206) | 1 | 1 | 2 | maybe slow |
UPDATE `lenjerieerotica_ro`.`categories` AS `Category` SET `Category`.`views` = `Category`.`views` + 1 WHERE `Category`.`id` = 11 | 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 (10004, 6570, 10220, 7842, 9664, 8963) AND `status` = '1' ORDER BY FIND_IN_SET(id, '10004, 6570, 10220, 7842, 9664, 8963') desc LIMIT 6 | 6 | 6 | 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 | |