| 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', 'vibratoare-1', 'vibratoare-anale') ORDER BY `lft` asc | 3 | 3 | 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`.`date_added`, `Category`.`date_modified`, `Category`.`views`, `Category`.`special` FROM `4love_ro`.`categories` AS `Category` WHERE `slug` = 'vibratoare-anale' 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` = 56 ORDER BY `Category`.`lft` asc | 0 | 0 | 0 | |
| SELECT `Category`.`id` FROM `4love_ro`.`categories` AS `Category` WHERE id = (56) | 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` = 56 AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' | 119 | 119 | 3 | |
| SELECT `AttributeValue`.`attribute_id` FROM `4love_ro`.`attribute_values` AS `AttributeValue` WHERE `AttributeValue`.`entity_id` IN (27844, 32561, 9040, 38704, 10342, 32550, 38708, 38705, 27576, 38702, 38686, 38688, 37982, 13249, 13251, 13261, 27842, 38699, 38706, 15209, 15880, 16029, 16066, 17162, 21435, 25584, 17267, 27041, 32073, 25086, 21498, 27336, 32076, 35278, 34902, 9975, 26895, 27031, 27846, 35477, 27357, 37142, 37873, 27660, 27663, 32564, 28608, 37797, 28639, 37796, 36877, 28833, 37163, 37795, 27847, 29419, 33025, 30012, 31470, 31499, 31515, 31669, 31675, 37911, 27349, 28644, 37429, 35114, 29445, 36815, 20482, 35263, 35265, 35266, 35267, 35268, 35276, 35279, 24241, 37891, 35869, 35898, 31478, 35277, 37131, 37144, 33024, 35867, 35890, 25565, 36986, 36995, 37794, 36040, 36044, 36081, 37274, 37273, 37382, 37386, 37388, 37390, 37392, 37368, 37367, 37384, 37956, 37992, 37981, 37980, 37979, 27394, 27071, 38204, 38211, 38216, 38257, 38244, 37836) AND `AttributeValue`.`model` = 'Product' GROUP BY `AttributeValue`.`attribute_id` | 9 | 9 | 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, 4, 6, 13, 17) ORDER BY `Attribute`.`name` asc | 7 | 7 | 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, 4, 6, 13, 17) ORDER BY `Attribute`.`name` asc | 7 | 7 | 0 | |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27844,32561,9040,38704,10342,32550,38708,38705,27576,38702,38686,38688,37982,13249,13251,13261,27842,38699,38706,15209,15880,16029,16066,17162,21435,25584,17267,27041,32073,25086,21498,27336,32076,35278,34902,9975,26895,27031,27846,35477,27357,37142,37873,27660,27663,32564,28608,37797,28639,37796,36877,28833,37163,37795,27847,29419,33025,30012,31470,31499,31515,31669,31675,37911,27349,28644,37429,35114,29445,36815,20482,35263,35265,35266,35267,35268,35276,35279,24241,37891,35869,35898,31478,35277,37131,37144,33024,35867,35890,25565,36986,36995,37794,36040,36044,36081,37274,37273,37382,37386,37388,37390,37392,37368,37367,37384,37956,37992,37981,37980,37979,27394,27071,38204,38211,38216,38257,38244,37836)
AND attribute_values.attribute_id = 1
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 9 | 9 | 3 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27844,32561,9040,38704,10342,32550,38708,38705,27576,38702,38686,38688,37982,13249,13251,13261,27842,38699,38706,15209,15880,16029,16066,17162,21435,25584,17267,27041,32073,25086,21498,27336,32076,35278,34902,9975,26895,27031,27846,35477,27357,37142,37873,27660,27663,32564,28608,37797,28639,37796,36877,28833,37163,37795,27847,29419,33025,30012,31470,31499,31515,31669,31675,37911,27349,28644,37429,35114,29445,36815,20482,35263,35265,35266,35267,35268,35276,35279,24241,37891,35869,35898,31478,35277,37131,37144,33024,35867,35890,25565,36986,36995,37794,36040,36044,36081,37274,37273,37382,37386,37388,37390,37392,37368,37367,37384,37956,37992,37981,37980,37979,27394,27071,38204,38211,38216,38257,38244,37836)
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 (27844,32561,9040,38704,10342,32550,38708,38705,27576,38702,38686,38688,37982,13249,13251,13261,27842,38699,38706,15209,15880,16029,16066,17162,21435,25584,17267,27041,32073,25086,21498,27336,32076,35278,34902,9975,26895,27031,27846,35477,27357,37142,37873,27660,27663,32564,28608,37797,28639,37796,36877,28833,37163,37795,27847,29419,33025,30012,31470,31499,31515,31669,31675,37911,27349,28644,37429,35114,29445,36815,20482,35263,35265,35266,35267,35268,35276,35279,24241,37891,35869,35898,31478,35277,37131,37144,33024,35867,35890,25565,36986,36995,37794,36040,36044,36081,37274,37273,37382,37386,37388,37390,37392,37368,37367,37384,37956,37992,37981,37980,37979,27394,27071,38204,38211,38216,38257,38244,37836)
AND attribute_values.attribute_id = 3
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 9 | 9 | 3 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27844,32561,9040,38704,10342,32550,38708,38705,27576,38702,38686,38688,37982,13249,13251,13261,27842,38699,38706,15209,15880,16029,16066,17162,21435,25584,17267,27041,32073,25086,21498,27336,32076,35278,34902,9975,26895,27031,27846,35477,27357,37142,37873,27660,27663,32564,28608,37797,28639,37796,36877,28833,37163,37795,27847,29419,33025,30012,31470,31499,31515,31669,31675,37911,27349,28644,37429,35114,29445,36815,20482,35263,35265,35266,35267,35268,35276,35279,24241,37891,35869,35898,31478,35277,37131,37144,33024,35867,35890,25565,36986,36995,37794,36040,36044,36081,37274,37273,37382,37386,37388,37390,37392,37368,37367,37384,37956,37992,37981,37980,37979,27394,27071,38204,38211,38216,38257,38244,37836)
AND attribute_values.attribute_id = 4
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 3 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27844,32561,9040,38704,10342,32550,38708,38705,27576,38702,38686,38688,37982,13249,13251,13261,27842,38699,38706,15209,15880,16029,16066,17162,21435,25584,17267,27041,32073,25086,21498,27336,32076,35278,34902,9975,26895,27031,27846,35477,27357,37142,37873,27660,27663,32564,28608,37797,28639,37796,36877,28833,37163,37795,27847,29419,33025,30012,31470,31499,31515,31669,31675,37911,27349,28644,37429,35114,29445,36815,20482,35263,35265,35266,35267,35268,35276,35279,24241,37891,35869,35898,31478,35277,37131,37144,33024,35867,35890,25565,36986,36995,37794,36040,36044,36081,37274,37273,37382,37386,37388,37390,37392,37368,37367,37384,37956,37992,37981,37980,37979,27394,27071,38204,38211,38216,38257,38244,37836)
AND attribute_values.attribute_id = 6
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 10 | 10 | 3 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27844,32561,9040,38704,10342,32550,38708,38705,27576,38702,38686,38688,37982,13249,13251,13261,27842,38699,38706,15209,15880,16029,16066,17162,21435,25584,17267,27041,32073,25086,21498,27336,32076,35278,34902,9975,26895,27031,27846,35477,27357,37142,37873,27660,27663,32564,28608,37797,28639,37796,36877,28833,37163,37795,27847,29419,33025,30012,31470,31499,31515,31669,31675,37911,27349,28644,37429,35114,29445,36815,20482,35263,35265,35266,35267,35268,35276,35279,24241,37891,35869,35898,31478,35277,37131,37144,33024,35867,35890,25565,36986,36995,37794,36040,36044,36081,37274,37273,37382,37386,37388,37390,37392,37368,37367,37384,37956,37992,37981,37980,37979,27394,27071,38204,38211,38216,38257,38244,37836)
AND attribute_values.attribute_id = 13
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 3 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27844,32561,9040,38704,10342,32550,38708,38705,27576,38702,38686,38688,37982,13249,13251,13261,27842,38699,38706,15209,15880,16029,16066,17162,21435,25584,17267,27041,32073,25086,21498,27336,32076,35278,34902,9975,26895,27031,27846,35477,27357,37142,37873,27660,27663,32564,28608,37797,28639,37796,36877,28833,37163,37795,27847,29419,33025,30012,31470,31499,31515,31669,31675,37911,27349,28644,37429,35114,29445,36815,20482,35263,35265,35266,35267,35268,35276,35279,24241,37891,35869,35898,31478,35277,37131,37144,33024,35867,35890,25565,36986,36995,37794,36040,36044,36081,37274,37273,37382,37386,37388,37390,37392,37368,37367,37384,37956,37992,37981,37980,37979,27394,27071,38204,38211,38216,38257,38244,37836)
AND attribute_values.attribute_id = 17
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 3 | 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 (27844,32561,9040,38704,10342,32550,38708,38705,27576,38702,38686,38688,37982,13249,13251,13261,27842,38699,38706,15209,15880,16029,16066,17162,21435,25584,17267,27041,32073,25086,21498,27336,32076,35278,34902,9975,26895,27031,27846,35477,27357,37142,37873,27660,27663,32564,28608,37797,28639,37796,36877,28833,37163,37795,27847,29419,33025,30012,31470,31499,31515,31669,31675,37911,27349,28644,37429,35114,29445,36815,20482,35263,35265,35266,35267,35268,35276,35279,24241,37891,35869,35898,31478,35277,37131,37144,33024,35867,35890,25565,36986,36995,37794,36040,36044,36081,37274,37273,37382,37386,37388,37390,37392,37368,37367,37384,37956,37992,37981,37980,37979,27394,27071,38204,38211,38216,38257,38244,37836)
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 (27844, 32561, 9040, 38704, 10342, 32550, 38708, 38705, 27576, 38702, 38686, 38688, 37982, 13249, 13251, 13261, 27842, 38699, 38706, 15209, 15880, 16029, 16066, 17162, 21435, 25584, 17267, 27041, 32073, 25086, 21498, 27336, 32076, 35278, 34902, 9975, 26895, 27031, 27846, 35477, 27357, 37142, 37873, 27660, 27663, 32564, 28608, 37797, 28639, 37796, 36877, 28833, 37163, 37795, 27847, 29419, 33025, 30012, 31470, 31499, 31515, 31669, 31675, 37911, 27349, 28644, 37429, 35114, 29445, 36815, 20482, 35263, 35265, 35266, 35267, 35268, 35276, 35279, 24241, 37891, 35869, 35898, 31478, 35277, 37131, 37144, 33024, 35867, 35890, 25565, 36986, 36995, 37794, 36040, 36044, 36081, 37274, 37273, 37382, 37386, 37388, 37390, 37392, 37368, 37367, 37384, 37956, 37992, 37981, 37980, 37979, 27394, 27071, 38204, 38211, 38216, 38257, 38244, 37836) 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` = (37429) 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` = (27847) 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` = (27576) 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` = (16029) 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` = (15880) 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` = (31478) 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` = (38708) 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` = (38706) 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` = (38705) 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` = (38704) 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` = (38702) 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` = (38699) 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` = (38688) 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` = (38686) 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` = (38257) 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` = (38244) 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` = (38216) 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` = (38211) 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` = (38204) 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` = (37992) 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` = (37982) 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` = (37981) 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` = (37980) 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` = (37979) 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` = (37956) 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` = (37911) 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` = (37891) 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` = (37873) 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` = (37836) 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` = (37797) 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` = (37796) 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` = (37795) 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` = (37794) 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` = (37392) 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` = (37390) 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` = (37388) 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` = (37386) 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` = (37384) 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` = (37382) 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` = (37368) 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` = (37367) 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` = (37274) 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` = (37273) 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` = (37163) 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` = (37144) 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` = (37142) 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` = (37131) 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` = (36995) 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` = (36986) 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` = (36877) 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` = (36815) 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` = (36081) 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` = (36044) 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` = (36040) 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` = (35898) 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` = (35890) 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` = (35869) 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` = (35867) 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` = (35477) 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` = (35279) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` IN (27844, 32561, 9040, 38704, 10342, 32550, 38708, 38705, 27576, 38702, 38686, 38688, 37982, 13249, 13251, 13261, 27842, 38699, 38706, 15209, 15880, 16029, 16066, 17162, 21435, 25584, 17267, 27041, 32073, 25086, 21498, 27336, 32076, 35278, 34902, 9975, 26895, 27031, 27846, 35477, 27357, 37142, 37873, 27660, 27663, 32564, 28608, 37797, 28639, 37796, 36877, 28833, 37163, 37795, 27847, 29419, 33025, 30012, 31470, 31499, 31515, 31669, 31675, 37911, 27349, 28644, 37429, 35114, 29445, 36815, 20482, 35263, 35265, 35266, 35267, 35268, 35276, 35279, 24241, 37891, 35869, 35898, 31478, 35277, 37131, 37144, 33024, 35867, 35890, 25565, 36986, 36995, 37794, 36040, 36044, 36081, 37274, 37273, 37382, 37386, 37388, 37390, 37392, 37368, 37367, 37384, 37956, 37992, 37981, 37980, 37979, 27394, 27071, 38204, 38211, 38216, 38257, 38244, 37836) | 1 | 1 | 1 | |
| UPDATE `4love_ro`.`categories` AS `Category` SET `Category`.`views` = `Category`.`views` + 1 WHERE `Category`.`id` = 56 | 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 | 1 | |
| 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 | 2 | maybe slow |
| 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 | |
