| 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', 'fetish-si-sm') ORDER BY `lft` asc | 2 | 2 | 0 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`banner`, `Category`.`banner_url`, `Category`.`description`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`top`, `Category`.`column`, `Category`.`sort_order`, `Category`.`status`, `Category`.`date_added`, `Category`.`date_modified`, `Category`.`views`, `Category`.`special` FROM `4love_ro`.`categories` AS `Category` WHERE `slug` = 'fetish-si-sm' 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` = 17 ORDER BY `Category`.`lft` asc | 12 | 12 | 0 | |
| SELECT `Category`.`id` FROM `4love_ro`.`categories` AS `Category` WHERE `id` IN (17, 18, 19, 20, 21, 23, 171, 172, 173, 174, 175, 178, 180) | 13 | 13 | 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` IN (17, 18, 19, 20, 21, 23, 171, 172, 173, 174, 175, 178, 180) AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' | 436 | 436 | 7 | |
| SELECT `AttributeValue`.`attribute_id` FROM `4love_ro`.`attribute_values` AS `AttributeValue` WHERE `AttributeValue`.`entity_id` IN (4367, 4368, 13123, 13701, 16135, 17260, 17434, 17437, 17784, 17795, 17796, 17798, 17800, 17841, 18890, 18892, 18893, 21220, 21425, 24642, 25403, 25704, 25706, 26279, 26577, 26750, 26752, 26767, 26769, 27192, 27193, 27194, 27198, 27199, 27200, 29499, 30058, 30060, 30061, 30065, 30091, 30110, 30128, 30149, 30170, 30683, 32175, 34647, 34648, 34767, 35013, 35259, 35260, 23510, 34030, 34031, 36276, 36873, 38019, 38020, 12249, 15390, 17301, 17819, 21675, 23354, 24925, 25426, 25429, 25433, 25442, 25568, 26282, 26350, 27180, 27181, 27186, 29009, 29010, 29011, 29400, 29470, 29488, 30098, 30100, 30102, 30104, 32524, 37352, 37734, 15296, 16123, 17287, 22822, 22823, 23534, 23546, 23820, 24003, 24047, 24049, 24054, 24055, 24057, 24061, 24062, 24073, 24271, 24363, 29501, 29502, 30088, 30090, 30107, 31700, 31702, 31709, 31713, 31714, 31715, 31716, 31717, 31723, 31729, 31740, 31743, 31744, 31745, 31746, 31747, 31757, 31760, 31762, 31764, 31765, 31766, 31767, 31769, 31772, 31773, 31774, 31779, 31780, 31781, 31783, 31788, 31795, 31796, 31797, 31798, 31805, 31806, 31807, 31815, 31817, 31818, 31823, 31829, 31833, 31835, 31840, 31841, 31843, 31846, 31848, 31851, 31872, 31876, 31881, 31883, 31884, 31897, 31904, 31908, 31915, 31923, 31936, 34494, 34495, 34496, 34498, 34499, 34501, 34503, 34505, 34508, 34509, 34510, 34511, 36166, 36174, 36175, 36179, 36180, 36181, 36183, 36648, 36682, 36686, 36867, 37464, 37465, 37466, 38016, 38017, 38021, 38022, 38595, 989, 4503, 9043, 10352, 11437, 12745, 12750, 12778, 12793, 13252, 14964, 16040, 17230, 17298, 17807, 21948, 24038, 24039, 24078, 24080, 25708, 26191, 26731, 26735, 26737, 26766, 26768, 26798, 26979, 26980, 27179, 27182, 27185, 27187, 27188, 27189, 27190, 27207, 27208, 27209, 27210, 27211, 27212, 29468, 29471, 29473, 29475, 29476, 30056, 30079, 30106, 30123, 30131, 30168, 33029, 34613, 34666, 34705, 34714, 34987, 34989, 34990, 35027, 37467, 38048, 38049, 38082, 10149, 10314, 11572, 12286, 12287, 12807, 13231, 13260, 15170, 17211, 18982, 18988, 26803, 27184, 27203, 28929, 29442, 29486, 30099, 30172, 32665, 33036, 33056, 34600, 34618, 34619, 34621, 34629, 34636, 34695, 34696, 38079, 38080, 8065, 10329, 15008, 15224, 15273, 17254, 17270, 17279, 17280, 17848, 27183, 27201, 27202, 28861, 29477, 29478, 29479, 29483, 29484, 29485, 34516, 34517, 34615, 13230, 15212, 16072, 17257, 17864, 17962, 21949, 23557, 23558, 23575, 23579, 26733, 30052, 30053, 30054, 38075, 38081, 3547, 26785, 29004, 29005, 29393, 32173, 37803, 7984, 13238, 13256, 19044, 22838, 23498, 23590, 23608, 24034, 24045, 25461, 26974, 34477, 36168, 36169, 36171, 36172, 36178, 37468, 37801, 37802, 38015, 38018, 38050, 38317, 38649, 38650, 38651, 38652, 38653, 38654, 38655, 38656, 38657, 38709, 2262, 2263, 2264, 33066, 35438, 35439, 35441, 35442, 35443, 35444, 35697, 35704, 35706, 35707, 35708, 35709, 35711, 35712, 35713, 35714, 35715, 35716, 35720, 35722, 35723, 35728, 35730, 35731, 35981, 35982, 35983, 4435, 17214, 18966, 18967, 18968, 26286, 26287, 27219, 35100, 35101, 36422, 38710) AND `AttributeValue`.`model` = 'Product' GROUP BY `AttributeValue`.`attribute_id` | 10 | 10 | 5 | 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, 5, 6, 13, 17, 20) ORDER BY `Attribute`.`name` asc | 8 | 8 | 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, 5, 6, 13, 17, 20) ORDER BY `Attribute`.`name` asc | 8 | 8 | 0 | |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (4367,4368,13123,13701,16135,17260,17434,17437,17784,17795,17796,17798,17800,17841,18890,18892,18893,21220,21425,24642,25403,25704,25706,26279,26577,26750,26752,26767,26769,27192,27193,27194,27198,27199,27200,29499,30058,30060,30061,30065,30091,30110,30128,30149,30170,30683,32175,34647,34648,34767,35013,35259,35260,23510,34030,34031,36276,36873,38019,38020,12249,15390,17301,17819,21675,23354,24925,25426,25429,25433,25442,25568,26282,26350,27180,27181,27186,29009,29010,29011,29400,29470,29488,30098,30100,30102,30104,32524,37352,37734,15296,16123,17287,22822,22823,23534,23546,23820,24003,24047,24049,24054,24055,24057,24061,24062,24073,24271,24363,29501,29502,30088,30090,30107,31700,31702,31709,31713,31714,31715,31716,31717,31723,31729,31740,31743,31744,31745,31746,31747,31757,31760,31762,31764,31765,31766,31767,31769,31772,31773,31774,31779,31780,31781,31783,31788,31795,31796,31797,31798,31805,31806,31807,31815,31817,31818,31823,31829,31833,31835,31840,31841,31843,31846,31848,31851,31872,31876,31881,31883,31884,31897,31904,31908,31915,31923,31936,34494,34495,34496,34498,34499,34501,34503,34505,34508,34509,34510,34511,36166,36174,36175,36179,36180,36181,36183,36648,36682,36686,36867,37464,37465,37466,38016,38017,38021,38022,38595,989,4503,9043,10352,11437,12745,12750,12778,12793,13252,14964,16040,17230,17298,17807,21948,24038,24039,24078,24080,25708,26191,26731,26735,26737,26766,26768,26798,26979,26980,27179,27182,27185,27187,27188,27189,27190,27207,27208,27209,27210,27211,27212,29468,29471,29473,29475,29476,30056,30079,30106,30123,30131,30168,33029,34613,34666,34705,34714,34987,34989,34990,35027,37467,38048,38049,38082,10149,10314,11572,12286,12287,12807,13231,13260,15170,17211,18982,18988,26803,27184,27203,28929,29442,29486,30099,30172,32665,33036,33056,34600,34618,34619,34621,34629,34636,34695,34696,38079,38080,8065,10329,15008,15224,15273,17254,17270,17279,17280,17848,27183,27201,27202,28861,29477,29478,29479,29483,29484,29485,34516,34517,34615,13230,15212,16072,17257,17864,17962,21949,23557,23558,23575,23579,26733,30052,30053,30054,38075,38081,3547,26785,29004,29005,29393,32173,37803,7984,13238,13256,19044,22838,23498,23590,23608,24034,24045,25461,26974,34477,36168,36169,36171,36172,36178,37468,37801,37802,38015,38018,38050,38317,38649,38650,38651,38652,38653,38654,38655,38656,38657,38709,2262,2263,2264,33066,35438,35439,35441,35442,35443,35444,35697,35704,35706,35707,35708,35709,35711,35712,35713,35714,35715,35716,35720,35722,35723,35728,35730,35731,35981,35982,35983,4435,17214,18966,18967,18968,26286,26287,27219,35100,35101,36422,38710)
AND attribute_values.attribute_id = 1
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 23 | 23 | 6 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (4367,4368,13123,13701,16135,17260,17434,17437,17784,17795,17796,17798,17800,17841,18890,18892,18893,21220,21425,24642,25403,25704,25706,26279,26577,26750,26752,26767,26769,27192,27193,27194,27198,27199,27200,29499,30058,30060,30061,30065,30091,30110,30128,30149,30170,30683,32175,34647,34648,34767,35013,35259,35260,23510,34030,34031,36276,36873,38019,38020,12249,15390,17301,17819,21675,23354,24925,25426,25429,25433,25442,25568,26282,26350,27180,27181,27186,29009,29010,29011,29400,29470,29488,30098,30100,30102,30104,32524,37352,37734,15296,16123,17287,22822,22823,23534,23546,23820,24003,24047,24049,24054,24055,24057,24061,24062,24073,24271,24363,29501,29502,30088,30090,30107,31700,31702,31709,31713,31714,31715,31716,31717,31723,31729,31740,31743,31744,31745,31746,31747,31757,31760,31762,31764,31765,31766,31767,31769,31772,31773,31774,31779,31780,31781,31783,31788,31795,31796,31797,31798,31805,31806,31807,31815,31817,31818,31823,31829,31833,31835,31840,31841,31843,31846,31848,31851,31872,31876,31881,31883,31884,31897,31904,31908,31915,31923,31936,34494,34495,34496,34498,34499,34501,34503,34505,34508,34509,34510,34511,36166,36174,36175,36179,36180,36181,36183,36648,36682,36686,36867,37464,37465,37466,38016,38017,38021,38022,38595,989,4503,9043,10352,11437,12745,12750,12778,12793,13252,14964,16040,17230,17298,17807,21948,24038,24039,24078,24080,25708,26191,26731,26735,26737,26766,26768,26798,26979,26980,27179,27182,27185,27187,27188,27189,27190,27207,27208,27209,27210,27211,27212,29468,29471,29473,29475,29476,30056,30079,30106,30123,30131,30168,33029,34613,34666,34705,34714,34987,34989,34990,35027,37467,38048,38049,38082,10149,10314,11572,12286,12287,12807,13231,13260,15170,17211,18982,18988,26803,27184,27203,28929,29442,29486,30099,30172,32665,33036,33056,34600,34618,34619,34621,34629,34636,34695,34696,38079,38080,8065,10329,15008,15224,15273,17254,17270,17279,17280,17848,27183,27201,27202,28861,29477,29478,29479,29483,29484,29485,34516,34517,34615,13230,15212,16072,17257,17864,17962,21949,23557,23558,23575,23579,26733,30052,30053,30054,38075,38081,3547,26785,29004,29005,29393,32173,37803,7984,13238,13256,19044,22838,23498,23590,23608,24034,24045,25461,26974,34477,36168,36169,36171,36172,36178,37468,37801,37802,38015,38018,38050,38317,38649,38650,38651,38652,38653,38654,38655,38656,38657,38709,2262,2263,2264,33066,35438,35439,35441,35442,35443,35444,35697,35704,35706,35707,35708,35709,35711,35712,35713,35714,35715,35716,35720,35722,35723,35728,35730,35731,35981,35982,35983,4435,17214,18966,18967,18968,26286,26287,27219,35100,35101,36422,38710)
AND attribute_values.attribute_id = 2
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 47 | 47 | 5 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (4367,4368,13123,13701,16135,17260,17434,17437,17784,17795,17796,17798,17800,17841,18890,18892,18893,21220,21425,24642,25403,25704,25706,26279,26577,26750,26752,26767,26769,27192,27193,27194,27198,27199,27200,29499,30058,30060,30061,30065,30091,30110,30128,30149,30170,30683,32175,34647,34648,34767,35013,35259,35260,23510,34030,34031,36276,36873,38019,38020,12249,15390,17301,17819,21675,23354,24925,25426,25429,25433,25442,25568,26282,26350,27180,27181,27186,29009,29010,29011,29400,29470,29488,30098,30100,30102,30104,32524,37352,37734,15296,16123,17287,22822,22823,23534,23546,23820,24003,24047,24049,24054,24055,24057,24061,24062,24073,24271,24363,29501,29502,30088,30090,30107,31700,31702,31709,31713,31714,31715,31716,31717,31723,31729,31740,31743,31744,31745,31746,31747,31757,31760,31762,31764,31765,31766,31767,31769,31772,31773,31774,31779,31780,31781,31783,31788,31795,31796,31797,31798,31805,31806,31807,31815,31817,31818,31823,31829,31833,31835,31840,31841,31843,31846,31848,31851,31872,31876,31881,31883,31884,31897,31904,31908,31915,31923,31936,34494,34495,34496,34498,34499,34501,34503,34505,34508,34509,34510,34511,36166,36174,36175,36179,36180,36181,36183,36648,36682,36686,36867,37464,37465,37466,38016,38017,38021,38022,38595,989,4503,9043,10352,11437,12745,12750,12778,12793,13252,14964,16040,17230,17298,17807,21948,24038,24039,24078,24080,25708,26191,26731,26735,26737,26766,26768,26798,26979,26980,27179,27182,27185,27187,27188,27189,27190,27207,27208,27209,27210,27211,27212,29468,29471,29473,29475,29476,30056,30079,30106,30123,30131,30168,33029,34613,34666,34705,34714,34987,34989,34990,35027,37467,38048,38049,38082,10149,10314,11572,12286,12287,12807,13231,13260,15170,17211,18982,18988,26803,27184,27203,28929,29442,29486,30099,30172,32665,33036,33056,34600,34618,34619,34621,34629,34636,34695,34696,38079,38080,8065,10329,15008,15224,15273,17254,17270,17279,17280,17848,27183,27201,27202,28861,29477,29478,29479,29483,29484,29485,34516,34517,34615,13230,15212,16072,17257,17864,17962,21949,23557,23558,23575,23579,26733,30052,30053,30054,38075,38081,3547,26785,29004,29005,29393,32173,37803,7984,13238,13256,19044,22838,23498,23590,23608,24034,24045,25461,26974,34477,36168,36169,36171,36172,36178,37468,37801,37802,38015,38018,38050,38317,38649,38650,38651,38652,38653,38654,38655,38656,38657,38709,2262,2263,2264,33066,35438,35439,35441,35442,35443,35444,35697,35704,35706,35707,35708,35709,35711,35712,35713,35714,35715,35716,35720,35722,35723,35728,35730,35731,35981,35982,35983,4435,17214,18966,18967,18968,26286,26287,27219,35100,35101,36422,38710)
AND attribute_values.attribute_id = 3
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 12 | 12 | 5 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (4367,4368,13123,13701,16135,17260,17434,17437,17784,17795,17796,17798,17800,17841,18890,18892,18893,21220,21425,24642,25403,25704,25706,26279,26577,26750,26752,26767,26769,27192,27193,27194,27198,27199,27200,29499,30058,30060,30061,30065,30091,30110,30128,30149,30170,30683,32175,34647,34648,34767,35013,35259,35260,23510,34030,34031,36276,36873,38019,38020,12249,15390,17301,17819,21675,23354,24925,25426,25429,25433,25442,25568,26282,26350,27180,27181,27186,29009,29010,29011,29400,29470,29488,30098,30100,30102,30104,32524,37352,37734,15296,16123,17287,22822,22823,23534,23546,23820,24003,24047,24049,24054,24055,24057,24061,24062,24073,24271,24363,29501,29502,30088,30090,30107,31700,31702,31709,31713,31714,31715,31716,31717,31723,31729,31740,31743,31744,31745,31746,31747,31757,31760,31762,31764,31765,31766,31767,31769,31772,31773,31774,31779,31780,31781,31783,31788,31795,31796,31797,31798,31805,31806,31807,31815,31817,31818,31823,31829,31833,31835,31840,31841,31843,31846,31848,31851,31872,31876,31881,31883,31884,31897,31904,31908,31915,31923,31936,34494,34495,34496,34498,34499,34501,34503,34505,34508,34509,34510,34511,36166,36174,36175,36179,36180,36181,36183,36648,36682,36686,36867,37464,37465,37466,38016,38017,38021,38022,38595,989,4503,9043,10352,11437,12745,12750,12778,12793,13252,14964,16040,17230,17298,17807,21948,24038,24039,24078,24080,25708,26191,26731,26735,26737,26766,26768,26798,26979,26980,27179,27182,27185,27187,27188,27189,27190,27207,27208,27209,27210,27211,27212,29468,29471,29473,29475,29476,30056,30079,30106,30123,30131,30168,33029,34613,34666,34705,34714,34987,34989,34990,35027,37467,38048,38049,38082,10149,10314,11572,12286,12287,12807,13231,13260,15170,17211,18982,18988,26803,27184,27203,28929,29442,29486,30099,30172,32665,33036,33056,34600,34618,34619,34621,34629,34636,34695,34696,38079,38080,8065,10329,15008,15224,15273,17254,17270,17279,17280,17848,27183,27201,27202,28861,29477,29478,29479,29483,29484,29485,34516,34517,34615,13230,15212,16072,17257,17864,17962,21949,23557,23558,23575,23579,26733,30052,30053,30054,38075,38081,3547,26785,29004,29005,29393,32173,37803,7984,13238,13256,19044,22838,23498,23590,23608,24034,24045,25461,26974,34477,36168,36169,36171,36172,36178,37468,37801,37802,38015,38018,38050,38317,38649,38650,38651,38652,38653,38654,38655,38656,38657,38709,2262,2263,2264,33066,35438,35439,35441,35442,35443,35444,35697,35704,35706,35707,35708,35709,35711,35712,35713,35714,35715,35716,35720,35722,35723,35728,35730,35731,35981,35982,35983,4435,17214,18966,18967,18968,26286,26287,27219,35100,35101,36422,38710)
AND attribute_values.attribute_id = 5
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 9 | 9 | 5 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (4367,4368,13123,13701,16135,17260,17434,17437,17784,17795,17796,17798,17800,17841,18890,18892,18893,21220,21425,24642,25403,25704,25706,26279,26577,26750,26752,26767,26769,27192,27193,27194,27198,27199,27200,29499,30058,30060,30061,30065,30091,30110,30128,30149,30170,30683,32175,34647,34648,34767,35013,35259,35260,23510,34030,34031,36276,36873,38019,38020,12249,15390,17301,17819,21675,23354,24925,25426,25429,25433,25442,25568,26282,26350,27180,27181,27186,29009,29010,29011,29400,29470,29488,30098,30100,30102,30104,32524,37352,37734,15296,16123,17287,22822,22823,23534,23546,23820,24003,24047,24049,24054,24055,24057,24061,24062,24073,24271,24363,29501,29502,30088,30090,30107,31700,31702,31709,31713,31714,31715,31716,31717,31723,31729,31740,31743,31744,31745,31746,31747,31757,31760,31762,31764,31765,31766,31767,31769,31772,31773,31774,31779,31780,31781,31783,31788,31795,31796,31797,31798,31805,31806,31807,31815,31817,31818,31823,31829,31833,31835,31840,31841,31843,31846,31848,31851,31872,31876,31881,31883,31884,31897,31904,31908,31915,31923,31936,34494,34495,34496,34498,34499,34501,34503,34505,34508,34509,34510,34511,36166,36174,36175,36179,36180,36181,36183,36648,36682,36686,36867,37464,37465,37466,38016,38017,38021,38022,38595,989,4503,9043,10352,11437,12745,12750,12778,12793,13252,14964,16040,17230,17298,17807,21948,24038,24039,24078,24080,25708,26191,26731,26735,26737,26766,26768,26798,26979,26980,27179,27182,27185,27187,27188,27189,27190,27207,27208,27209,27210,27211,27212,29468,29471,29473,29475,29476,30056,30079,30106,30123,30131,30168,33029,34613,34666,34705,34714,34987,34989,34990,35027,37467,38048,38049,38082,10149,10314,11572,12286,12287,12807,13231,13260,15170,17211,18982,18988,26803,27184,27203,28929,29442,29486,30099,30172,32665,33036,33056,34600,34618,34619,34621,34629,34636,34695,34696,38079,38080,8065,10329,15008,15224,15273,17254,17270,17279,17280,17848,27183,27201,27202,28861,29477,29478,29479,29483,29484,29485,34516,34517,34615,13230,15212,16072,17257,17864,17962,21949,23557,23558,23575,23579,26733,30052,30053,30054,38075,38081,3547,26785,29004,29005,29393,32173,37803,7984,13238,13256,19044,22838,23498,23590,23608,24034,24045,25461,26974,34477,36168,36169,36171,36172,36178,37468,37801,37802,38015,38018,38050,38317,38649,38650,38651,38652,38653,38654,38655,38656,38657,38709,2262,2263,2264,33066,35438,35439,35441,35442,35443,35444,35697,35704,35706,35707,35708,35709,35711,35712,35713,35714,35715,35716,35720,35722,35723,35728,35730,35731,35981,35982,35983,4435,17214,18966,18967,18968,26286,26287,27219,35100,35101,36422,38710)
AND attribute_values.attribute_id = 6
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 15 | 15 | 6 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (4367,4368,13123,13701,16135,17260,17434,17437,17784,17795,17796,17798,17800,17841,18890,18892,18893,21220,21425,24642,25403,25704,25706,26279,26577,26750,26752,26767,26769,27192,27193,27194,27198,27199,27200,29499,30058,30060,30061,30065,30091,30110,30128,30149,30170,30683,32175,34647,34648,34767,35013,35259,35260,23510,34030,34031,36276,36873,38019,38020,12249,15390,17301,17819,21675,23354,24925,25426,25429,25433,25442,25568,26282,26350,27180,27181,27186,29009,29010,29011,29400,29470,29488,30098,30100,30102,30104,32524,37352,37734,15296,16123,17287,22822,22823,23534,23546,23820,24003,24047,24049,24054,24055,24057,24061,24062,24073,24271,24363,29501,29502,30088,30090,30107,31700,31702,31709,31713,31714,31715,31716,31717,31723,31729,31740,31743,31744,31745,31746,31747,31757,31760,31762,31764,31765,31766,31767,31769,31772,31773,31774,31779,31780,31781,31783,31788,31795,31796,31797,31798,31805,31806,31807,31815,31817,31818,31823,31829,31833,31835,31840,31841,31843,31846,31848,31851,31872,31876,31881,31883,31884,31897,31904,31908,31915,31923,31936,34494,34495,34496,34498,34499,34501,34503,34505,34508,34509,34510,34511,36166,36174,36175,36179,36180,36181,36183,36648,36682,36686,36867,37464,37465,37466,38016,38017,38021,38022,38595,989,4503,9043,10352,11437,12745,12750,12778,12793,13252,14964,16040,17230,17298,17807,21948,24038,24039,24078,24080,25708,26191,26731,26735,26737,26766,26768,26798,26979,26980,27179,27182,27185,27187,27188,27189,27190,27207,27208,27209,27210,27211,27212,29468,29471,29473,29475,29476,30056,30079,30106,30123,30131,30168,33029,34613,34666,34705,34714,34987,34989,34990,35027,37467,38048,38049,38082,10149,10314,11572,12286,12287,12807,13231,13260,15170,17211,18982,18988,26803,27184,27203,28929,29442,29486,30099,30172,32665,33036,33056,34600,34618,34619,34621,34629,34636,34695,34696,38079,38080,8065,10329,15008,15224,15273,17254,17270,17279,17280,17848,27183,27201,27202,28861,29477,29478,29479,29483,29484,29485,34516,34517,34615,13230,15212,16072,17257,17864,17962,21949,23557,23558,23575,23579,26733,30052,30053,30054,38075,38081,3547,26785,29004,29005,29393,32173,37803,7984,13238,13256,19044,22838,23498,23590,23608,24034,24045,25461,26974,34477,36168,36169,36171,36172,36178,37468,37801,37802,38015,38018,38050,38317,38649,38650,38651,38652,38653,38654,38655,38656,38657,38709,2262,2263,2264,33066,35438,35439,35441,35442,35443,35444,35697,35704,35706,35707,35708,35709,35711,35712,35713,35714,35715,35716,35720,35722,35723,35728,35730,35731,35981,35982,35983,4435,17214,18966,18967,18968,26286,26287,27219,35100,35101,36422,38710)
AND attribute_values.attribute_id = 13
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 5 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (4367,4368,13123,13701,16135,17260,17434,17437,17784,17795,17796,17798,17800,17841,18890,18892,18893,21220,21425,24642,25403,25704,25706,26279,26577,26750,26752,26767,26769,27192,27193,27194,27198,27199,27200,29499,30058,30060,30061,30065,30091,30110,30128,30149,30170,30683,32175,34647,34648,34767,35013,35259,35260,23510,34030,34031,36276,36873,38019,38020,12249,15390,17301,17819,21675,23354,24925,25426,25429,25433,25442,25568,26282,26350,27180,27181,27186,29009,29010,29011,29400,29470,29488,30098,30100,30102,30104,32524,37352,37734,15296,16123,17287,22822,22823,23534,23546,23820,24003,24047,24049,24054,24055,24057,24061,24062,24073,24271,24363,29501,29502,30088,30090,30107,31700,31702,31709,31713,31714,31715,31716,31717,31723,31729,31740,31743,31744,31745,31746,31747,31757,31760,31762,31764,31765,31766,31767,31769,31772,31773,31774,31779,31780,31781,31783,31788,31795,31796,31797,31798,31805,31806,31807,31815,31817,31818,31823,31829,31833,31835,31840,31841,31843,31846,31848,31851,31872,31876,31881,31883,31884,31897,31904,31908,31915,31923,31936,34494,34495,34496,34498,34499,34501,34503,34505,34508,34509,34510,34511,36166,36174,36175,36179,36180,36181,36183,36648,36682,36686,36867,37464,37465,37466,38016,38017,38021,38022,38595,989,4503,9043,10352,11437,12745,12750,12778,12793,13252,14964,16040,17230,17298,17807,21948,24038,24039,24078,24080,25708,26191,26731,26735,26737,26766,26768,26798,26979,26980,27179,27182,27185,27187,27188,27189,27190,27207,27208,27209,27210,27211,27212,29468,29471,29473,29475,29476,30056,30079,30106,30123,30131,30168,33029,34613,34666,34705,34714,34987,34989,34990,35027,37467,38048,38049,38082,10149,10314,11572,12286,12287,12807,13231,13260,15170,17211,18982,18988,26803,27184,27203,28929,29442,29486,30099,30172,32665,33036,33056,34600,34618,34619,34621,34629,34636,34695,34696,38079,38080,8065,10329,15008,15224,15273,17254,17270,17279,17280,17848,27183,27201,27202,28861,29477,29478,29479,29483,29484,29485,34516,34517,34615,13230,15212,16072,17257,17864,17962,21949,23557,23558,23575,23579,26733,30052,30053,30054,38075,38081,3547,26785,29004,29005,29393,32173,37803,7984,13238,13256,19044,22838,23498,23590,23608,24034,24045,25461,26974,34477,36168,36169,36171,36172,36178,37468,37801,37802,38015,38018,38050,38317,38649,38650,38651,38652,38653,38654,38655,38656,38657,38709,2262,2263,2264,33066,35438,35439,35441,35442,35443,35444,35697,35704,35706,35707,35708,35709,35711,35712,35713,35714,35715,35716,35720,35722,35723,35728,35730,35731,35981,35982,35983,4435,17214,18966,18967,18968,26286,26287,27219,35100,35101,36422,38710)
AND attribute_values.attribute_id = 17
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 5 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (4367,4368,13123,13701,16135,17260,17434,17437,17784,17795,17796,17798,17800,17841,18890,18892,18893,21220,21425,24642,25403,25704,25706,26279,26577,26750,26752,26767,26769,27192,27193,27194,27198,27199,27200,29499,30058,30060,30061,30065,30091,30110,30128,30149,30170,30683,32175,34647,34648,34767,35013,35259,35260,23510,34030,34031,36276,36873,38019,38020,12249,15390,17301,17819,21675,23354,24925,25426,25429,25433,25442,25568,26282,26350,27180,27181,27186,29009,29010,29011,29400,29470,29488,30098,30100,30102,30104,32524,37352,37734,15296,16123,17287,22822,22823,23534,23546,23820,24003,24047,24049,24054,24055,24057,24061,24062,24073,24271,24363,29501,29502,30088,30090,30107,31700,31702,31709,31713,31714,31715,31716,31717,31723,31729,31740,31743,31744,31745,31746,31747,31757,31760,31762,31764,31765,31766,31767,31769,31772,31773,31774,31779,31780,31781,31783,31788,31795,31796,31797,31798,31805,31806,31807,31815,31817,31818,31823,31829,31833,31835,31840,31841,31843,31846,31848,31851,31872,31876,31881,31883,31884,31897,31904,31908,31915,31923,31936,34494,34495,34496,34498,34499,34501,34503,34505,34508,34509,34510,34511,36166,36174,36175,36179,36180,36181,36183,36648,36682,36686,36867,37464,37465,37466,38016,38017,38021,38022,38595,989,4503,9043,10352,11437,12745,12750,12778,12793,13252,14964,16040,17230,17298,17807,21948,24038,24039,24078,24080,25708,26191,26731,26735,26737,26766,26768,26798,26979,26980,27179,27182,27185,27187,27188,27189,27190,27207,27208,27209,27210,27211,27212,29468,29471,29473,29475,29476,30056,30079,30106,30123,30131,30168,33029,34613,34666,34705,34714,34987,34989,34990,35027,37467,38048,38049,38082,10149,10314,11572,12286,12287,12807,13231,13260,15170,17211,18982,18988,26803,27184,27203,28929,29442,29486,30099,30172,32665,33036,33056,34600,34618,34619,34621,34629,34636,34695,34696,38079,38080,8065,10329,15008,15224,15273,17254,17270,17279,17280,17848,27183,27201,27202,28861,29477,29478,29479,29483,29484,29485,34516,34517,34615,13230,15212,16072,17257,17864,17962,21949,23557,23558,23575,23579,26733,30052,30053,30054,38075,38081,3547,26785,29004,29005,29393,32173,37803,7984,13238,13256,19044,22838,23498,23590,23608,24034,24045,25461,26974,34477,36168,36169,36171,36172,36178,37468,37801,37802,38015,38018,38050,38317,38649,38650,38651,38652,38653,38654,38655,38656,38657,38709,2262,2263,2264,33066,35438,35439,35441,35442,35443,35444,35697,35704,35706,35707,35708,35709,35711,35712,35713,35714,35715,35716,35720,35722,35723,35728,35730,35731,35981,35982,35983,4435,17214,18966,18967,18968,26286,26287,27219,35100,35101,36422,38710)
AND attribute_values.attribute_id = 20
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 5 | 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 (4367,4368,13123,13701,16135,17260,17434,17437,17784,17795,17796,17798,17800,17841,18890,18892,18893,21220,21425,24642,25403,25704,25706,26279,26577,26750,26752,26767,26769,27192,27193,27194,27198,27199,27200,29499,30058,30060,30061,30065,30091,30110,30128,30149,30170,30683,32175,34647,34648,34767,35013,35259,35260,23510,34030,34031,36276,36873,38019,38020,12249,15390,17301,17819,21675,23354,24925,25426,25429,25433,25442,25568,26282,26350,27180,27181,27186,29009,29010,29011,29400,29470,29488,30098,30100,30102,30104,32524,37352,37734,15296,16123,17287,22822,22823,23534,23546,23820,24003,24047,24049,24054,24055,24057,24061,24062,24073,24271,24363,29501,29502,30088,30090,30107,31700,31702,31709,31713,31714,31715,31716,31717,31723,31729,31740,31743,31744,31745,31746,31747,31757,31760,31762,31764,31765,31766,31767,31769,31772,31773,31774,31779,31780,31781,31783,31788,31795,31796,31797,31798,31805,31806,31807,31815,31817,31818,31823,31829,31833,31835,31840,31841,31843,31846,31848,31851,31872,31876,31881,31883,31884,31897,31904,31908,31915,31923,31936,34494,34495,34496,34498,34499,34501,34503,34505,34508,34509,34510,34511,36166,36174,36175,36179,36180,36181,36183,36648,36682,36686,36867,37464,37465,37466,38016,38017,38021,38022,38595,989,4503,9043,10352,11437,12745,12750,12778,12793,13252,14964,16040,17230,17298,17807,21948,24038,24039,24078,24080,25708,26191,26731,26735,26737,26766,26768,26798,26979,26980,27179,27182,27185,27187,27188,27189,27190,27207,27208,27209,27210,27211,27212,29468,29471,29473,29475,29476,30056,30079,30106,30123,30131,30168,33029,34613,34666,34705,34714,34987,34989,34990,35027,37467,38048,38049,38082,10149,10314,11572,12286,12287,12807,13231,13260,15170,17211,18982,18988,26803,27184,27203,28929,29442,29486,30099,30172,32665,33036,33056,34600,34618,34619,34621,34629,34636,34695,34696,38079,38080,8065,10329,15008,15224,15273,17254,17270,17279,17280,17848,27183,27201,27202,28861,29477,29478,29479,29483,29484,29485,34516,34517,34615,13230,15212,16072,17257,17864,17962,21949,23557,23558,23575,23579,26733,30052,30053,30054,38075,38081,3547,26785,29004,29005,29393,32173,37803,7984,13238,13256,19044,22838,23498,23590,23608,24034,24045,25461,26974,34477,36168,36169,36171,36172,36178,37468,37801,37802,38015,38018,38050,38317,38649,38650,38651,38652,38653,38654,38655,38656,38657,38709,2262,2263,2264,33066,35438,35439,35441,35442,35443,35444,35697,35704,35706,35707,35708,35709,35711,35712,35713,35714,35715,35716,35720,35722,35723,35728,35730,35731,35981,35982,35983,4435,17214,18966,18967,18968,26286,26287,27219,35100,35101,36422,38710)
AND products.status = 1
| 1 | 1 | 5 | 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 (4367, 4368, 13123, 13701, 16135, 17260, 17434, 17437, 17784, 17795, 17796, 17798, 17800, 17841, 18890, 18892, 18893, 21220, 21425, 24642, 25403, 25704, 25706, 26279, 26577, 26750, 26752, 26767, 26769, 27192, 27193, 27194, 27198, 27199, 27200, 29499, 30058, 30060, 30061, 30065, 30091, 30110, 30128, 30149, 30170, 30683, 32175, 34647, 34648, 34767, 35013, 35259, 35260, 23510, 34030, 34031, 36276, 36873, 38019, 38020, 12249, 15390, 17301, 17819, 21675, 23354, 24925, 25426, 25429, 25433, 25442, 25568, 26282, 26350, 27180, 27181, 27186, 29009, 29010, 29011, 29400, 29470, 29488, 30098, 30100, 30102, 30104, 32524, 37352, 37734, 15296, 16123, 17287, 22822, 22823, 23534, 23546, 23820, 24003, 24047, 24049, 24054, 24055, 24057, 24061, 24062, 24073, 24271, 24363, 29501, 29502, 30088, 30090, 30107, 31700, 31702, 31709, 31713, 31714, 31715, 31716, 31717, 31723, 31729, 31740, 31743, 31744, 31745, 31746, 31747, 31757, 31760, 31762, 31764, 31765, 31766, 31767, 31769, 31772, 31773, 31774, 31779, 31780, 31781, 31783, 31788, 31795, 31796, 31797, 31798, 31805, 31806, 31807, 31815, 31817, 31818, 31823, 31829, 31833, 31835, 31840, 31841, 31843, 31846, 31848, 31851, 31872, 31876, 31881, 31883, 31884, 31897, 31904, 31908, 31915, 31923, 31936, 34494, 34495, 34496, 34498, 34499, 34501, 34503, 34505, 34508, 34509, 34510, 34511, 36166, 36174, 36175, 36179, 36180, 36181, 36183, 36648, 36682, 36686, 36867, 37464, 37465, 37466, 38016, 38017, 38021, 38022, 38595, 989, 4503, 9043, 10352, 11437, 12745, 12750, 12778, 12793, 13252, 14964, 16040, 17230, 17298, 17807, 21948, 24038, 24039, 24078, 24080, 25708, 26191, 26731, 26735, 26737, 26766, 26768, 26798, 26979, 26980, 27179, 27182, 27185, 27187, 27188, 27189, 27190, 27207, 27208, 27209, 27210, 27211, 27212, 29468, 29471, 29473, 29475, 29476, 30056, 30079, 30106, 30123, 30131, 30168, 33029, 34613, 34666, 34705, 34714, 34987, 34989, 34990, 35027, 37467, 38048, 38049, 38082, 10149, 10314, 11572, 12286, 12287, 12807, 13231, 13260, 15170, 17211, 18982, 18988, 26803, 27184, 27203, 28929, 29442, 29486, 30099, 30172, 32665, 33036, 33056, 34600, 34618, 34619, 34621, 34629, 34636, 34695, 34696, 38079, 38080, 8065, 10329, 15008, 15224, 15273, 17254, 17270, 17279, 17280, 17848, 27183, 27201, 27202, 28861, 29477, 29478, 29479, 29483, 29484, 29485, 34516, 34517, 34615, 13230, 15212, 16072, 17257, 17864, 17962, 21949, 23557, 23558, 23575, 23579, 26733, 30052, 30053, 30054, 38075, 38081, 3547, 26785, 29004, 29005, 29393, 32173, 37803, 7984, 13238, 13256, 19044, 22838, 23498, 23590, 23608, 24034, 24045, 25461, 26974, 34477, 36168, 36169, 36171, 36172, 36178, 37468, 37801, 37802, 38015, 38018, 38050, 38317, 38649, 38650, 38651, 38652, 38653, 38654, 38655, 38656, 38657, 38709, 2262, 2263, 2264, 33066, 35438, 35439, 35441, 35442, 35443, 35444, 35697, 35704, 35706, 35707, 35708, 35709, 35711, 35712, 35713, 35714, 35715, 35716, 35720, 35722, 35723, 35728, 35730, 35731, 35981, 35982, 35983, 4435, 17214, 18966, 18967, 18968, 26286, 26287, 27219, 35100, 35101, 36422, 38710) 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` = (27202) 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` = (26191) 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` = (35731) 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` = (29488) 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` = (17437) 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` = (28929) 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` = (27201) 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` = (27198) 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` = (29009) 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` = (18893) 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` = (29471) 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` = (23498) 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` = (32524) 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` = (29011) 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` = (34516) 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` = (24055) 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` = (22838) 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` = (17280) 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` = (13231) 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` = (25442) 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` = (27199) 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` = (27192) 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` = (18892) 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` = (17800) 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` = (17798) 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` = (17796) 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` = (17260) 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` = (16135) 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` = (17279) 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` = (34990) 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` = (34989) 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` = (34987) 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` = (30079) 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` = (25461) 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` = (24073) 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` = (24062) 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` = (24061) 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` = (24057) 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` = (24054) 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` = (24049) 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` = (24047) 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` = (24045) 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` = (24039) 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` = (24038) 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` = (24034) 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` = (24003) 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` = (23820) 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` = (23608) 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` = (23590) 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` = (23579) 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` = (23575) 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` = (23558) 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` = (23557) 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` = (23546) 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` = (23534) 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` = (23510) 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` = (35013) 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` = (33029) 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` = (29473) 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` = (29393) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` IN (4367, 4368, 13123, 13701, 16135, 17260, 17434, 17437, 17784, 17795, 17796, 17798, 17800, 17841, 18890, 18892, 18893, 21220, 21425, 24642, 25403, 25704, 25706, 26279, 26577, 26750, 26752, 26767, 26769, 27192, 27193, 27194, 27198, 27199, 27200, 29499, 30058, 30060, 30061, 30065, 30091, 30110, 30128, 30149, 30170, 30683, 32175, 34647, 34648, 34767, 35013, 35259, 35260, 23510, 34030, 34031, 36276, 36873, 38019, 38020, 12249, 15390, 17301, 17819, 21675, 23354, 24925, 25426, 25429, 25433, 25442, 25568, 26282, 26350, 27180, 27181, 27186, 29009, 29010, 29011, 29400, 29470, 29488, 30098, 30100, 30102, 30104, 32524, 37352, 37734, 15296, 16123, 17287, 22822, 22823, 23534, 23546, 23820, 24003, 24047, 24049, 24054, 24055, 24057, 24061, 24062, 24073, 24271, 24363, 29501, 29502, 30088, 30090, 30107, 31700, 31702, 31709, 31713, 31714, 31715, 31716, 31717, 31723, 31729, 31740, 31743, 31744, 31745, 31746, 31747, 31757, 31760, 31762, 31764, 31765, 31766, 31767, 31769, 31772, 31773, 31774, 31779, 31780, 31781, 31783, 31788, 31795, 31796, 31797, 31798, 31805, 31806, 31807, 31815, 31817, 31818, 31823, 31829, 31833, 31835, 31840, 31841, 31843, 31846, 31848, 31851, 31872, 31876, 31881, 31883, 31884, 31897, 31904, 31908, 31915, 31923, 31936, 34494, 34495, 34496, 34498, 34499, 34501, 34503, 34505, 34508, 34509, 34510, 34511, 36166, 36174, 36175, 36179, 36180, 36181, 36183, 36648, 36682, 36686, 36867, 37464, 37465, 37466, 38016, 38017, 38021, 38022, 38595, 989, 4503, 9043, 10352, 11437, 12745, 12750, 12778, 12793, 13252, 14964, 16040, 17230, 17298, 17807, 21948, 24038, 24039, 24078, 24080, 25708, 26191, 26731, 26735, 26737, 26766, 26768, 26798, 26979, 26980, 27179, 27182, 27185, 27187, 27188, 27189, 27190, 27207, 27208, 27209, 27210, 27211, 27212, 29468, 29471, 29473, 29475, 29476, 30056, 30079, 30106, 30123, 30131, 30168, 33029, 34613, 34666, 34705, 34714, 34987, 34989, 34990, 35027, 37467, 38048, 38049, 38082, 10149, 10314, 11572, 12286, 12287, 12807, 13231, 13260, 15170, 17211, 18982, 18988, 26803, 27184, 27203, 28929, 29442, 29486, 30099, 30172, 32665, 33036, 33056, 34600, 34618, 34619, 34621, 34629, 34636, 34695, 34696, 38079, 38080, 8065, 10329, 15008, 15224, 15273, 17254, 17270, 17279, 17280, 17848, 27183, 27201, 27202, 28861, 29477, 29478, 29479, 29483, 29484, 29485, 34516, 34517, 34615, 13230, 15212, 16072, 17257, 17864, 17962, 21949, 23557, 23558, 23575, 23579, 26733, 30052, 30053, 30054, 38075, 38081, 3547, 26785, 29004, 29005, 29393, 32173, 37803, 7984, 13238, 13256, 19044, 22838, 23498, 23590, 23608, 24034, 24045, 25461, 26974, 34477, 36168, 36169, 36171, 36172, 36178, 37468, 37801, 37802, 38015, 38018, 38050, 38317, 38649, 38650, 38651, 38652, 38653, 38654, 38655, 38656, 38657, 38709, 2262, 2263, 2264, 33066, 35438, 35439, 35441, 35442, 35443, 35444, 35697, 35704, 35706, 35707, 35708, 35709, 35711, 35712, 35713, 35714, 35715, 35716, 35720, 35722, 35723, 35728, 35730, 35731, 35981, 35982, 35983, 4435, 17214, 18966, 18967, 18968, 26286, 26287, 27219, 35100, 35101, 36422, 38710) | 1 | 1 | 1 | |
| UPDATE `4love_ro`.`categories` AS `Category` SET `Category`.`views` = `Category`.`views` + 1 WHERE `Category`.`id` = 17 | 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 | 1 | |
| 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 | |
