| 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 `4love_ro`.`shops` AS `Shop` LEFT JOIN `4love_ro`.`sellers` AS `Seller` ON (`Shop`.`seller_id` = `Seller`.`id`) WHERE `slug` = '4love' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`slug`, `Category`.`name` FROM `4love_ro`.`categories` AS `Category` WHERE `slug` IN ('sex-shop', 'papusi-si-vagine', 'vagine-fara-vibratii') ORDER BY `lft` asc | 3 | 3 | 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`.`date_added`, `Category`.`date_modified`, `Category`.`views`, `Category`.`special` FROM `4love_ro`.`categories` AS `Category` WHERE `slug` = 'vagine-fara-vibratii' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `4love_ro`.`categories` AS `Category` WHERE 1 = 1 AND `Category`.`parent_id` = 30 ORDER BY `Category`.`lft` asc | 0 | 0 | 0 | |
| SELECT `Category`.`id` FROM `4love_ro`.`categories` AS `Category` WHERE id = (30) | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `CategoriesProduct`.`product_id`, `CategoriesProduct`.`category_id` FROM `4love_ro`.`products` AS `Product` JOIN `4love_ro`.`categories_products` AS `CategoriesProduct` ON (`CategoriesProduct`.`category_id` = 30 AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' | 147 | 147 | 3 | |
| SELECT `AttributeValue`.`attribute_id` FROM `4love_ro`.`attribute_values` AS `AttributeValue` WHERE `AttributeValue`.`entity_id` IN (7981, 29001, 10393, 34933, 7415, 38003, 37452, 36118, 17159, 18851, 18857, 18858, 27284, 32067, 22508, 22509, 22517, 22518, 18733, 34896, 23385, 23465, 23467, 23472, 23474, 23478, 23479, 37917, 24827, 24831, 24833, 24961, 24963, 24966, 24984, 24986, 25488, 28898, 33117, 26422, 34932, 35073, 34931, 26546, 26548, 26550, 26553, 31629, 26946, 26840, 31522, 28998, 28831, 25490, 34940, 24979, 38072, 34963, 34941, 28657, 28815, 28816, 28817, 34936, 34937, 34938, 34935, 34934, 30238, 22507, 31432, 34964, 31529, 31679, 26831, 37909, 28999, 26841, 31421, 28818, 28649, 34562, 34565, 34567, 34569, 34571, 34573, 34576, 34523, 34572, 34821, 35138, 35690, 37928, 35684, 35674, 26842, 24981, 33118, 26868, 38071, 35671, 35668, 35667, 35663, 30014, 31486, 27298, 35649, 35645, 35642, 35574, 35634, 35631, 28658, 22512, 25417, 18092, 26404, 37195, 37435, 37919, 28570, 36020, 36041, 36042, 36047, 36050, 36052, 36054, 36072, 36087, 36160, 36161, 36162, 36163, 36164, 36165, 24968, 37196, 25414, 37907, 37999, 37963, 37972, 26396, 27287) AND `AttributeValue`.`model` = 'Product' GROUP BY `AttributeValue`.`attribute_id` | 6 | 6 | 3 | maybe slow |
| SELECT `Attribute`.`id` FROM `4love_ro`.`attributes` AS `Attribute` WHERE `Attribute`.`name` IN ('Baterii', 'Functii') | 2 | 2 | 0 | |
| SELECT `Attribute`.`id`, `Attribute`.`name` FROM `4love_ro`.`attributes` AS `Attribute` WHERE `Attribute`.`id` IN (1, 2, 3, 6, 13, 18) ORDER BY `Attribute`.`name` asc | 6 | 6 | 0 | |
| SELECT `Attribute`.`id` FROM `4love_ro`.`attributes` AS `Attribute` WHERE `Attribute`.`name` IN ('Baterii', 'Functii') | 2 | 2 | 0 | |
| SELECT `Attribute`.`id`, `Attribute`.`name` FROM `4love_ro`.`attributes` AS `Attribute` WHERE `Attribute`.`id` IN (1, 2, 3, 6, 13, 18) ORDER BY `Attribute`.`name` asc | 6 | 6 | 0 | |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7981,29001,10393,34933,7415,38003,37452,36118,17159,18851,18857,18858,27284,32067,22508,22509,22517,22518,18733,34896,23385,23465,23467,23472,23474,23478,23479,37917,24827,24831,24833,24961,24963,24966,24984,24986,25488,28898,33117,26422,34932,35073,34931,26546,26548,26550,26553,31629,26946,26840,31522,28998,28831,25490,34940,24979,38072,34963,34941,28657,28815,28816,28817,34936,34937,34938,34935,34934,30238,22507,31432,34964,31529,31679,26831,37909,28999,26841,31421,28818,28649,34562,34565,34567,34569,34571,34573,34576,34523,34572,34821,35138,35690,37928,35684,35674,26842,24981,33118,26868,38071,35671,35668,35667,35663,30014,31486,27298,35649,35645,35642,35574,35634,35631,28658,22512,25417,18092,26404,37195,37435,37919,28570,36020,36041,36042,36047,36050,36052,36054,36072,36087,36160,36161,36162,36163,36164,36165,24968,37196,25414,37907,37999,37963,37972,26396,27287)
AND attribute_values.attribute_id = 1
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 6 | 6 | 3 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7981,29001,10393,34933,7415,38003,37452,36118,17159,18851,18857,18858,27284,32067,22508,22509,22517,22518,18733,34896,23385,23465,23467,23472,23474,23478,23479,37917,24827,24831,24833,24961,24963,24966,24984,24986,25488,28898,33117,26422,34932,35073,34931,26546,26548,26550,26553,31629,26946,26840,31522,28998,28831,25490,34940,24979,38072,34963,34941,28657,28815,28816,28817,34936,34937,34938,34935,34934,30238,22507,31432,34964,31529,31679,26831,37909,28999,26841,31421,28818,28649,34562,34565,34567,34569,34571,34573,34576,34523,34572,34821,35138,35690,37928,35684,35674,26842,24981,33118,26868,38071,35671,35668,35667,35663,30014,31486,27298,35649,35645,35642,35574,35634,35631,28658,22512,25417,18092,26404,37195,37435,37919,28570,36020,36041,36042,36047,36050,36052,36054,36072,36087,36160,36161,36162,36163,36164,36165,24968,37196,25414,37907,37999,37963,37972,26396,27287)
AND attribute_values.attribute_id = 2
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 35 | 35 | 3 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7981,29001,10393,34933,7415,38003,37452,36118,17159,18851,18857,18858,27284,32067,22508,22509,22517,22518,18733,34896,23385,23465,23467,23472,23474,23478,23479,37917,24827,24831,24833,24961,24963,24966,24984,24986,25488,28898,33117,26422,34932,35073,34931,26546,26548,26550,26553,31629,26946,26840,31522,28998,28831,25490,34940,24979,38072,34963,34941,28657,28815,28816,28817,34936,34937,34938,34935,34934,30238,22507,31432,34964,31529,31679,26831,37909,28999,26841,31421,28818,28649,34562,34565,34567,34569,34571,34573,34576,34523,34572,34821,35138,35690,37928,35684,35674,26842,24981,33118,26868,38071,35671,35668,35667,35663,30014,31486,27298,35649,35645,35642,35574,35634,35631,28658,22512,25417,18092,26404,37195,37435,37919,28570,36020,36041,36042,36047,36050,36052,36054,36072,36087,36160,36161,36162,36163,36164,36165,24968,37196,25414,37907,37999,37963,37972,26396,27287)
AND attribute_values.attribute_id = 3
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 3 | 3 | 3 | |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7981,29001,10393,34933,7415,38003,37452,36118,17159,18851,18857,18858,27284,32067,22508,22509,22517,22518,18733,34896,23385,23465,23467,23472,23474,23478,23479,37917,24827,24831,24833,24961,24963,24966,24984,24986,25488,28898,33117,26422,34932,35073,34931,26546,26548,26550,26553,31629,26946,26840,31522,28998,28831,25490,34940,24979,38072,34963,34941,28657,28815,28816,28817,34936,34937,34938,34935,34934,30238,22507,31432,34964,31529,31679,26831,37909,28999,26841,31421,28818,28649,34562,34565,34567,34569,34571,34573,34576,34523,34572,34821,35138,35690,37928,35684,35674,26842,24981,33118,26868,38071,35671,35668,35667,35663,30014,31486,27298,35649,35645,35642,35574,35634,35631,28658,22512,25417,18092,26404,37195,37435,37919,28570,36020,36041,36042,36047,36050,36052,36054,36072,36087,36160,36161,36162,36163,36164,36165,24968,37196,25414,37907,37999,37963,37972,26396,27287)
AND attribute_values.attribute_id = 6
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 7 | 7 | 3 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7981,29001,10393,34933,7415,38003,37452,36118,17159,18851,18857,18858,27284,32067,22508,22509,22517,22518,18733,34896,23385,23465,23467,23472,23474,23478,23479,37917,24827,24831,24833,24961,24963,24966,24984,24986,25488,28898,33117,26422,34932,35073,34931,26546,26548,26550,26553,31629,26946,26840,31522,28998,28831,25490,34940,24979,38072,34963,34941,28657,28815,28816,28817,34936,34937,34938,34935,34934,30238,22507,31432,34964,31529,31679,26831,37909,28999,26841,31421,28818,28649,34562,34565,34567,34569,34571,34573,34576,34523,34572,34821,35138,35690,37928,35684,35674,26842,24981,33118,26868,38071,35671,35668,35667,35663,30014,31486,27298,35649,35645,35642,35574,35634,35631,28658,22512,25417,18092,26404,37195,37435,37919,28570,36020,36041,36042,36047,36050,36052,36054,36072,36087,36160,36161,36162,36163,36164,36165,24968,37196,25414,37907,37999,37963,37972,26396,27287)
AND attribute_values.attribute_id = 13
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 2 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7981,29001,10393,34933,7415,38003,37452,36118,17159,18851,18857,18858,27284,32067,22508,22509,22517,22518,18733,34896,23385,23465,23467,23472,23474,23478,23479,37917,24827,24831,24833,24961,24963,24966,24984,24986,25488,28898,33117,26422,34932,35073,34931,26546,26548,26550,26553,31629,26946,26840,31522,28998,28831,25490,34940,24979,38072,34963,34941,28657,28815,28816,28817,34936,34937,34938,34935,34934,30238,22507,31432,34964,31529,31679,26831,37909,28999,26841,31421,28818,28649,34562,34565,34567,34569,34571,34573,34576,34523,34572,34821,35138,35690,37928,35684,35674,26842,24981,33118,26868,38071,35671,35668,35667,35663,30014,31486,27298,35649,35645,35642,35574,35634,35631,28658,22512,25417,18092,26404,37195,37435,37919,28570,36020,36041,36042,36047,36050,36052,36054,36072,36087,36160,36161,36162,36163,36164,36165,24968,37196,25414,37907,37999,37963,37972,26396,27287)
AND attribute_values.attribute_id = 18
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 2 | maybe slow |
|
SELECT
MIN(COALESCE(
(SELECT price FROM product_discounts
WHERE product_discounts.product_id = products.id
AND product_discounts.start_date <= NOW()
AND (product_discounts.end_date >= NOW() OR product_discounts.end_date = '0000-00-00')
ORDER BY product_discounts.priority ASC LIMIT 1),
products.price
)) as min_price,
MAX(COALESCE(
(SELECT price FROM product_discounts
WHERE product_discounts.product_id = products.id
AND product_discounts.start_date <= NOW()
AND (product_discounts.end_date >= NOW() OR product_discounts.end_date = '0000-00-00')
ORDER BY product_discounts.priority ASC LIMIT 1),
products.price
)) as max_price,
COUNT(CASE WHEN EXISTS(
SELECT 1 FROM product_discounts
WHERE product_discounts.product_id = products.id
AND product_discounts.start_date <= NOW()
AND (product_discounts.end_date >= NOW() OR product_discounts.end_date = '0000-00-00')
) THEN 1 END) as discounted_count
FROM products
WHERE products.id IN (7981,29001,10393,34933,7415,38003,37452,36118,17159,18851,18857,18858,27284,32067,22508,22509,22517,22518,18733,34896,23385,23465,23467,23472,23474,23478,23479,37917,24827,24831,24833,24961,24963,24966,24984,24986,25488,28898,33117,26422,34932,35073,34931,26546,26548,26550,26553,31629,26946,26840,31522,28998,28831,25490,34940,24979,38072,34963,34941,28657,28815,28816,28817,34936,34937,34938,34935,34934,30238,22507,31432,34964,31529,31679,26831,37909,28999,26841,31421,28818,28649,34562,34565,34567,34569,34571,34573,34576,34523,34572,34821,35138,35690,37928,35684,35674,26842,24981,33118,26868,38071,35671,35668,35667,35663,30014,31486,27298,35649,35645,35642,35574,35634,35631,28658,22512,25417,18092,26404,37195,37435,37919,28570,36020,36041,36042,36047,36050,36052,36054,36072,36087,36160,36161,36162,36163,36164,36165,24968,37196,25414,37907,37999,37963,37972,26396,27287)
AND products.status = 1
| 1 | 1 | 3 | maybe slow |
| SELECT `Product`.`id`, `Product`.`name`, `Product`.`display_name`, `Product`.`slug`, `Product`.`image`, `Product`.`price`, `Product`.`description`, `Product`.`internal_code`, `Product`.`adult`, `Product`.`status`, `Product`.`temp_1` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` IN (7981, 29001, 10393, 34933, 7415, 38003, 37452, 36118, 17159, 18851, 18857, 18858, 27284, 32067, 22508, 22509, 22517, 22518, 18733, 34896, 23385, 23465, 23467, 23472, 23474, 23478, 23479, 37917, 24827, 24831, 24833, 24961, 24963, 24966, 24984, 24986, 25488, 28898, 33117, 26422, 34932, 35073, 34931, 26546, 26548, 26550, 26553, 31629, 26946, 26840, 31522, 28998, 28831, 25490, 34940, 24979, 38072, 34963, 34941, 28657, 28815, 28816, 28817, 34936, 34937, 34938, 34935, 34934, 30238, 22507, 31432, 34964, 31529, 31679, 26831, 37909, 28999, 26841, 31421, 28818, 28649, 34562, 34565, 34567, 34569, 34571, 34573, 34576, 34523, 34572, 34821, 35138, 35690, 37928, 35684, 35674, 26842, 24981, 33118, 26868, 38071, 35671, 35668, 35667, 35663, 30014, 31486, 27298, 35649, 35645, 35642, 35574, 35634, 35631, 28658, 22512, 25417, 18092, 26404, 37195, 37435, 37919, 28570, 36020, 36041, 36042, 36047, 36050, 36052, 36054, 36072, 36087, 36160, 36161, 36162, 36163, 36164, 36165, 24968, 37196, 25414, 37907, 37999, 37963, 37972, 26396, 27287) ORDER BY `Product`.`priority` desc, `Product`.`id` desc LIMIT 60 | 60 | 60 | 2 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (10393) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (31629) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (31522) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (29001) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (31432) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (26842) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (31486) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (24833) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (18092) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (26831) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (24831) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (7981) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (7415) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (38072) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (38071) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (38003) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37999) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37972) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37963) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37928) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37919) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37917) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37909) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37907) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37452) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37435) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37196) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37195) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36165) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36164) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36163) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36162) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36161) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36160) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36118) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36087) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36072) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36054) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36052) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36050) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36047) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36042) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36041) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (36020) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35690) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35684) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35674) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35671) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35668) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35667) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35663) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35649) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35645) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35642) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35634) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35631) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35574) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35138) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (35073) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (34964) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` IN (7981, 29001, 10393, 34933, 7415, 38003, 37452, 36118, 17159, 18851, 18857, 18858, 27284, 32067, 22508, 22509, 22517, 22518, 18733, 34896, 23385, 23465, 23467, 23472, 23474, 23478, 23479, 37917, 24827, 24831, 24833, 24961, 24963, 24966, 24984, 24986, 25488, 28898, 33117, 26422, 34932, 35073, 34931, 26546, 26548, 26550, 26553, 31629, 26946, 26840, 31522, 28998, 28831, 25490, 34940, 24979, 38072, 34963, 34941, 28657, 28815, 28816, 28817, 34936, 34937, 34938, 34935, 34934, 30238, 22507, 31432, 34964, 31529, 31679, 26831, 37909, 28999, 26841, 31421, 28818, 28649, 34562, 34565, 34567, 34569, 34571, 34573, 34576, 34523, 34572, 34821, 35138, 35690, 37928, 35684, 35674, 26842, 24981, 33118, 26868, 38071, 35671, 35668, 35667, 35663, 30014, 31486, 27298, 35649, 35645, 35642, 35574, 35634, 35631, 28658, 22512, 25417, 18092, 26404, 37195, 37435, 37919, 28570, 36020, 36041, 36042, 36047, 36050, 36052, 36054, 36072, 36087, 36160, 36161, 36162, 36163, 36164, 36165, 24968, 37196, 25414, 37907, 37999, 37963, 37972, 26396, 27287) | 1 | 1 | 1 | |
| UPDATE `4love_ro`.`categories` AS `Category` SET `Category`.`views` = `Category`.`views` + 1 WHERE `Category`.`id` = 30 | 1 | 1 | 0 | |
| SELECT `Manufacturer`.`id`, `Manufacturer`.`name`, `Manufacturer`.`slug`, `Manufacturer`.`image`, `Manufacturer`.`sort_order`, `Manufacturer`.`status` FROM `4love_ro`.`manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`status` = 1 ORDER BY `name` ASC | 47 | 47 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 106 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 110 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 35 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 36 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 37 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 38 AND `Product`.`status` = '1' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 126 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 75 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 70 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 98 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 108 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 107 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 64 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 31 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 42 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 128 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 123 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 125 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 122 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 89 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 32 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 104 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 102 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 83 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 96 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 127 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 116 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 95 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 129 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 124 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 47 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 90 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 49 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 112 AND `Product`.`status` = '1' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 130 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 50 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 51 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 109 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 101 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 111 AND `Product`.`status` = '1' | 1 | 1 | 3 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 54 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 105 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 103 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 55 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 118 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 97 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 63 AND `Product`.`status` = '1' | 1 | 1 | 1 | |