| 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 ('reduceri', 'black-friday') ORDER BY `lft` asc | 2 | 2 | 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` = 'black-friday' 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` = 156 ORDER BY `Category`.`lft` asc | 4 | 4 | 0 | |
| SELECT `Category`.`id` FROM `4love_ro`.`categories` AS `Category` WHERE `id` IN (156, 157, 158, 160, 138) | 5 | 5 | 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 (138, 156, 157, 158, 160) AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' | 477 | 477 | 4 | |
| SELECT `AttributeValue`.`attribute_id` FROM `4love_ro`.`attribute_values` AS `AttributeValue` WHERE `AttributeValue`.`entity_id` IN (27201, 12286, 36939, 15390, 36924, 25273, 17437, 32175, 32208, 25271, 30053, 36155, 27202, 25251, 25426, 25823, 27183, 34517, 27179, 27211, 18966, 34618, 29005, 29454, 29460, 29461, 29462, 29463, 30060, 30061, 30091, 30099, 30123, 30131, 30149, 30168, 30170, 28861, 28929, 30172, 34577, 34652, 34651, 37864, 12287, 30052, 36933, 36937, 13252, 6840, 15523, 37435, 6747, 21448, 23372, 35779, 25603, 26436, 27534, 27576, 38308, 35744, 29234, 29255, 29700, 29996, 29998, 29999, 35755, 37781, 26191, 38309, 33663, 37436, 33664, 21617, 35826, 38637, 13607, 37176, 32176, 28901, 9975, 37441, 26866, 37793, 15088, 15868, 15914, 18681, 18683, 32177, 32180, 32181, 31632, 32603, 20482, 21553, 10330, 22070, 23457, 32076, 31489, 24823, 24955, 37191, 25101, 25103, 25476, 25479, 25619, 25685, 37873, 32600, 34901, 26700, 26995, 37432, 27041, 37431, 27158, 27164, 27165, 27166, 34977, 27321, 27336, 27345, 27349, 27394, 27404, 27413, 27718, 27846, 27847, 27866, 28572, 37433, 28623, 28887, 28905, 37177, 29019, 29027, 29028, 29029, 29036, 29038, 29039, 29041, 29042, 29043, 29093, 29094, 29116, 29117, 29119, 29161, 29162, 29163, 29216, 29219, 29220, 29421, 29427, 29432, 29445, 30015, 31426, 31436, 31440, 31453, 31501, 31509, 31514, 20421, 32649, 29389, 27571, 29217, 35062, 35063, 35064, 35068, 35069, 35070, 35071, 21556, 35784, 37178, 36910, 28667, 21498, 35313, 35353, 35278, 35373, 37866, 35985, 35885, 35887, 35899, 37842, 37189, 35999, 35290, 35340, 35347, 35868, 24819, 35401, 35403, 35409, 36035, 36071, 36083, 37264, 37248, 37216, 37235, 37337, 37359, 37891, 37911, 37915, 37927, 37929, 37940, 29059, 16060, 29066, 19172, 27401, 29055, 35055, 35387, 25690, 24820, 24928, 35058, 25139, 25161, 25418, 25427, 25431, 25600, 25677, 25689, 26284, 27318, 35056, 29047, 27150, 27228, 27229, 27304, 27313, 27316, 27319, 27334, 27348, 27391, 27418, 32736, 35054, 27648, 27761, 27764, 28876, 27782, 27793, 27819, 27861, 37452, 28990, 29018, 29022, 29053, 29054, 29061, 29062, 29063, 29068, 29073, 29080, 29081, 29113, 29146, 29206, 29207, 29208, 31664, 37279, 31430, 31666, 31693, 29049, 25420, 27315, 35057, 35059, 35061, 35083, 29050, 35060, 29051, 37184, 29057, 27388, 35264, 35273, 35281, 35282, 35283, 35397, 37173, 35954, 35952, 35937, 35936, 35933, 35932, 35414, 37187, 35286, 35289, 35968, 35966, 35420, 35418, 35348, 35394, 35360, 35385, 35376, 35365, 36049, 27799, 29060, 37237, 37881, 29770, 27936, 27937, 27939, 27940, 27941, 27942, 27943, 27945, 27948, 27949, 27950, 27959, 27960, 27962, 27965, 27968, 27969, 27970, 27972, 27973, 27974, 27979, 27980, 27981, 27982, 27983, 27988, 27989, 27990, 27993, 27994, 27995, 27996, 27997, 28000, 28001, 28004, 28006, 28017, 28023, 28024, 28036, 28046, 28049, 28067, 28069, 28072, 28078, 28079, 28083, 28084, 28089, 28099, 28102, 28103, 28207, 28212, 28217, 28219, 28220, 28221, 28233, 28234, 28235, 28237, 28238, 28242, 28250, 28251, 28255, 28256, 28258, 28272, 28276, 28280, 28298, 28301, 28304, 28310, 28317, 28358, 28387, 28438, 28454, 28457, 28461, 28463, 28466, 28490, 28503, 28512, 28513, 28514, 28524, 28527, 28537, 28538, 28539, 28540, 28543, 28544, 28545, 28547, 28548, 28549, 28552, 28554, 28555, 28564, 28567, 28582, 29725, 29726, 29780, 29785, 29788, 29791, 29799, 29800, 29801, 29803, 29804, 29805, 29806, 29812, 29852, 29862, 29876, 29878, 29883, 28558, 29931, 29915, 29813) AND `AttributeValue`.`model` = 'Product' GROUP BY `AttributeValue`.`attribute_id` | 17 | 17 | 8 | 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, 5, 6, 8, 9, 13, 14, 15, 16, 17, 18, 20) ORDER BY `Attribute`.`name` asc | 15 | 15 | 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, 5, 6, 8, 9, 13, 14, 15, 16, 17, 18, 20) ORDER BY `Attribute`.`name` asc | 15 | 15 | 0 | |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 1
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 24 | 24 | 9 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 2
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 72 | 72 | 9 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 3
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 17 | 17 | 9 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 4
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 7 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 5
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 7 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 6
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 52 | 52 | 9 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 8
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 11 | 11 | 8 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 9
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 3 | 3 | 7 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 13
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 8 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 14
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 11 | 11 | 8 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 15
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 7 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 16
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 8 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 17
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 8 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 18
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 7 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND attribute_values.attribute_id = 20
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 7 | 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 (27201,12286,36939,15390,36924,25273,17437,32175,32208,25271,30053,36155,27202,25251,25426,25823,27183,34517,27179,27211,18966,34618,29005,29454,29460,29461,29462,29463,30060,30061,30091,30099,30123,30131,30149,30168,30170,28861,28929,30172,34577,34652,34651,37864,12287,30052,36933,36937,13252,6840,15523,37435,6747,21448,23372,35779,25603,26436,27534,27576,38308,35744,29234,29255,29700,29996,29998,29999,35755,37781,26191,38309,33663,37436,33664,21617,35826,38637,13607,37176,32176,28901,9975,37441,26866,37793,15088,15868,15914,18681,18683,32177,32180,32181,31632,32603,20482,21553,10330,22070,23457,32076,31489,24823,24955,37191,25101,25103,25476,25479,25619,25685,37873,32600,34901,26700,26995,37432,27041,37431,27158,27164,27165,27166,34977,27321,27336,27345,27349,27394,27404,27413,27718,27846,27847,27866,28572,37433,28623,28887,28905,37177,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29161,29162,29163,29216,29219,29220,29421,29427,29432,29445,30015,31426,31436,31440,31453,31501,31509,31514,20421,32649,29389,27571,29217,35062,35063,35064,35068,35069,35070,35071,21556,35784,37178,36910,28667,21498,35313,35353,35278,35373,37866,35985,35885,35887,35899,37842,37189,35999,35290,35340,35347,35868,24819,35401,35403,35409,36035,36071,36083,37264,37248,37216,37235,37337,37359,37891,37911,37915,37927,37929,37940,29059,16060,29066,19172,27401,29055,35055,35387,25690,24820,24928,35058,25139,25161,25418,25427,25431,25600,25677,25689,26284,27318,35056,29047,27150,27228,27229,27304,27313,27316,27319,27334,27348,27391,27418,32736,35054,27648,27761,27764,28876,27782,27793,27819,27861,37452,28990,29018,29022,29053,29054,29061,29062,29063,29068,29073,29080,29081,29113,29146,29206,29207,29208,31664,37279,31430,31666,31693,29049,25420,27315,35057,35059,35061,35083,29050,35060,29051,37184,29057,27388,35264,35273,35281,35282,35283,35397,37173,35954,35952,35937,35936,35933,35932,35414,37187,35286,35289,35968,35966,35420,35418,35348,35394,35360,35385,35376,35365,36049,27799,29060,37237,37881,29770,27936,27937,27939,27940,27941,27942,27943,27945,27948,27949,27950,27959,27960,27962,27965,27968,27969,27970,27972,27973,27974,27979,27980,27981,27982,27983,27988,27989,27990,27993,27994,27995,27996,27997,28000,28001,28004,28006,28017,28023,28024,28036,28046,28049,28067,28069,28072,28078,28079,28083,28084,28089,28099,28102,28103,28207,28212,28217,28219,28220,28221,28233,28234,28235,28237,28238,28242,28250,28251,28255,28256,28258,28272,28276,28280,28298,28301,28304,28310,28317,28358,28387,28438,28454,28457,28461,28463,28466,28490,28503,28512,28513,28514,28524,28527,28537,28538,28539,28540,28543,28544,28545,28547,28548,28549,28552,28554,28555,28564,28567,28582,29725,29726,29780,29785,29788,29791,29799,29800,29801,29803,29804,29805,29806,29812,29852,29862,29876,29878,29883,28558,29931,29915,29813)
AND products.status = 1
| 1 | 1 | 7 | 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 (27201, 12286, 36939, 15390, 36924, 25273, 17437, 32175, 32208, 25271, 30053, 36155, 27202, 25251, 25426, 25823, 27183, 34517, 27179, 27211, 18966, 34618, 29005, 29454, 29460, 29461, 29462, 29463, 30060, 30061, 30091, 30099, 30123, 30131, 30149, 30168, 30170, 28861, 28929, 30172, 34577, 34652, 34651, 37864, 12287, 30052, 36933, 36937, 13252, 6840, 15523, 37435, 6747, 21448, 23372, 35779, 25603, 26436, 27534, 27576, 38308, 35744, 29234, 29255, 29700, 29996, 29998, 29999, 35755, 37781, 26191, 38309, 33663, 37436, 33664, 21617, 35826, 38637, 13607, 37176, 32176, 28901, 9975, 37441, 26866, 37793, 15088, 15868, 15914, 18681, 18683, 32177, 32180, 32181, 31632, 32603, 20482, 21553, 10330, 22070, 23457, 32076, 31489, 24823, 24955, 37191, 25101, 25103, 25476, 25479, 25619, 25685, 37873, 32600, 34901, 26700, 26995, 37432, 27041, 37431, 27158, 27164, 27165, 27166, 34977, 27321, 27336, 27345, 27349, 27394, 27404, 27413, 27718, 27846, 27847, 27866, 28572, 37433, 28623, 28887, 28905, 37177, 29019, 29027, 29028, 29029, 29036, 29038, 29039, 29041, 29042, 29043, 29093, 29094, 29116, 29117, 29119, 29161, 29162, 29163, 29216, 29219, 29220, 29421, 29427, 29432, 29445, 30015, 31426, 31436, 31440, 31453, 31501, 31509, 31514, 20421, 32649, 29389, 27571, 29217, 35062, 35063, 35064, 35068, 35069, 35070, 35071, 21556, 35784, 37178, 36910, 28667, 21498, 35313, 35353, 35278, 35373, 37866, 35985, 35885, 35887, 35899, 37842, 37189, 35999, 35290, 35340, 35347, 35868, 24819, 35401, 35403, 35409, 36035, 36071, 36083, 37264, 37248, 37216, 37235, 37337, 37359, 37891, 37911, 37915, 37927, 37929, 37940, 29059, 16060, 29066, 19172, 27401, 29055, 35055, 35387, 25690, 24820, 24928, 35058, 25139, 25161, 25418, 25427, 25431, 25600, 25677, 25689, 26284, 27318, 35056, 29047, 27150, 27228, 27229, 27304, 27313, 27316, 27319, 27334, 27348, 27391, 27418, 32736, 35054, 27648, 27761, 27764, 28876, 27782, 27793, 27819, 27861, 37452, 28990, 29018, 29022, 29053, 29054, 29061, 29062, 29063, 29068, 29073, 29080, 29081, 29113, 29146, 29206, 29207, 29208, 31664, 37279, 31430, 31666, 31693, 29049, 25420, 27315, 35057, 35059, 35061, 35083, 29050, 35060, 29051, 37184, 29057, 27388, 35264, 35273, 35281, 35282, 35283, 35397, 37173, 35954, 35952, 35937, 35936, 35933, 35932, 35414, 37187, 35286, 35289, 35968, 35966, 35420, 35418, 35348, 35394, 35360, 35385, 35376, 35365, 36049, 27799, 29060, 37237, 37881, 29770, 27936, 27937, 27939, 27940, 27941, 27942, 27943, 27945, 27948, 27949, 27950, 27959, 27960, 27962, 27965, 27968, 27969, 27970, 27972, 27973, 27974, 27979, 27980, 27981, 27982, 27983, 27988, 27989, 27990, 27993, 27994, 27995, 27996, 27997, 28000, 28001, 28004, 28006, 28017, 28023, 28024, 28036, 28046, 28049, 28067, 28069, 28072, 28078, 28079, 28083, 28084, 28089, 28099, 28102, 28103, 28207, 28212, 28217, 28219, 28220, 28221, 28233, 28234, 28235, 28237, 28238, 28242, 28250, 28251, 28255, 28256, 28258, 28272, 28276, 28280, 28298, 28301, 28304, 28310, 28317, 28358, 28387, 28438, 28454, 28457, 28461, 28463, 28466, 28490, 28503, 28512, 28513, 28514, 28524, 28527, 28537, 28538, 28539, 28540, 28543, 28544, 28545, 28547, 28548, 28549, 28552, 28554, 28555, 28564, 28567, 28582, 29725, 29726, 29780, 29785, 29788, 29791, 29799, 29800, 29801, 29803, 29804, 29805, 29806, 29812, 29852, 29862, 29876, 29878, 29883, 28558, 29931, 29915, 29813) ORDER BY `Product`.`priority` desc, `Product`.`id` desc LIMIT 60, 60 | 60 | 60 | 3 | maybe slow |
| 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` = (28558) 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` = (28099) 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` = (27391) 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` = (27183) 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` = (26436) 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` = (26284) 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` = (25689) 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` = (25103) 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` = (24928) 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` = (38637) 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` = (38309) 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` = (38308) 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` = (37940) 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` = (37929) 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` = (37927) 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` = (37915) 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` = (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` = (37881) 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` = (37866) 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` = (37864) 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` = (37842) 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` = (37781) 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` = (37452) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37441) 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` = (37436) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37435) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37433) 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` = (37431) 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` = (37359) 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` = (37337) 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` = (37279) 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` = (37264) 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` = (37248) 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` = (37237) 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` = (37235) 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` = (37216) 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` = (37191) 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` = (37189) 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` = (37187) 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` = (37184) 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` = (37178) 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` = (37177) 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` = (37176) 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` = (37173) 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` = (36939) 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` = (36937) 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` = (36933) 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` = (36924) 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` = (36910) 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` = (36155) 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` = (36083) 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` = (36071) 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` = (36049) 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` = (36035) 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` = (35999) 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` = (35985) 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` = (35968) 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` = (35966) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` IN (27201, 12286, 36939, 15390, 36924, 25273, 17437, 32175, 32208, 25271, 30053, 36155, 27202, 25251, 25426, 25823, 27183, 34517, 27179, 27211, 18966, 34618, 29005, 29454, 29460, 29461, 29462, 29463, 30060, 30061, 30091, 30099, 30123, 30131, 30149, 30168, 30170, 28861, 28929, 30172, 34577, 34652, 34651, 37864, 12287, 30052, 36933, 36937, 13252, 6840, 15523, 37435, 6747, 21448, 23372, 35779, 25603, 26436, 27534, 27576, 38308, 35744, 29234, 29255, 29700, 29996, 29998, 29999, 35755, 37781, 26191, 38309, 33663, 37436, 33664, 21617, 35826, 38637, 13607, 37176, 32176, 28901, 9975, 37441, 26866, 37793, 15088, 15868, 15914, 18681, 18683, 32177, 32180, 32181, 31632, 32603, 20482, 21553, 10330, 22070, 23457, 32076, 31489, 24823, 24955, 37191, 25101, 25103, 25476, 25479, 25619, 25685, 37873, 32600, 34901, 26700, 26995, 37432, 27041, 37431, 27158, 27164, 27165, 27166, 34977, 27321, 27336, 27345, 27349, 27394, 27404, 27413, 27718, 27846, 27847, 27866, 28572, 37433, 28623, 28887, 28905, 37177, 29019, 29027, 29028, 29029, 29036, 29038, 29039, 29041, 29042, 29043, 29093, 29094, 29116, 29117, 29119, 29161, 29162, 29163, 29216, 29219, 29220, 29421, 29427, 29432, 29445, 30015, 31426, 31436, 31440, 31453, 31501, 31509, 31514, 20421, 32649, 29389, 27571, 29217, 35062, 35063, 35064, 35068, 35069, 35070, 35071, 21556, 35784, 37178, 36910, 28667, 21498, 35313, 35353, 35278, 35373, 37866, 35985, 35885, 35887, 35899, 37842, 37189, 35999, 35290, 35340, 35347, 35868, 24819, 35401, 35403, 35409, 36035, 36071, 36083, 37264, 37248, 37216, 37235, 37337, 37359, 37891, 37911, 37915, 37927, 37929, 37940, 29059, 16060, 29066, 19172, 27401, 29055, 35055, 35387, 25690, 24820, 24928, 35058, 25139, 25161, 25418, 25427, 25431, 25600, 25677, 25689, 26284, 27318, 35056, 29047, 27150, 27228, 27229, 27304, 27313, 27316, 27319, 27334, 27348, 27391, 27418, 32736, 35054, 27648, 27761, 27764, 28876, 27782, 27793, 27819, 27861, 37452, 28990, 29018, 29022, 29053, 29054, 29061, 29062, 29063, 29068, 29073, 29080, 29081, 29113, 29146, 29206, 29207, 29208, 31664, 37279, 31430, 31666, 31693, 29049, 25420, 27315, 35057, 35059, 35061, 35083, 29050, 35060, 29051, 37184, 29057, 27388, 35264, 35273, 35281, 35282, 35283, 35397, 37173, 35954, 35952, 35937, 35936, 35933, 35932, 35414, 37187, 35286, 35289, 35968, 35966, 35420, 35418, 35348, 35394, 35360, 35385, 35376, 35365, 36049, 27799, 29060, 37237, 37881, 29770, 27936, 27937, 27939, 27940, 27941, 27942, 27943, 27945, 27948, 27949, 27950, 27959, 27960, 27962, 27965, 27968, 27969, 27970, 27972, 27973, 27974, 27979, 27980, 27981, 27982, 27983, 27988, 27989, 27990, 27993, 27994, 27995, 27996, 27997, 28000, 28001, 28004, 28006, 28017, 28023, 28024, 28036, 28046, 28049, 28067, 28069, 28072, 28078, 28079, 28083, 28084, 28089, 28099, 28102, 28103, 28207, 28212, 28217, 28219, 28220, 28221, 28233, 28234, 28235, 28237, 28238, 28242, 28250, 28251, 28255, 28256, 28258, 28272, 28276, 28280, 28298, 28301, 28304, 28310, 28317, 28358, 28387, 28438, 28454, 28457, 28461, 28463, 28466, 28490, 28503, 28512, 28513, 28514, 28524, 28527, 28537, 28538, 28539, 28540, 28543, 28544, 28545, 28547, 28548, 28549, 28552, 28554, 28555, 28564, 28567, 28582, 29725, 29726, 29780, 29785, 29788, 29791, 29799, 29800, 29801, 29803, 29804, 29805, 29806, 29812, 29852, 29862, 29876, 29878, 29883, 28558, 29931, 29915, 29813) | 1 | 1 | 1 | |
| UPDATE `4love_ro`.`categories` AS `Category` SET `Category`.`views` = `Category`.`views` + 1 WHERE `Category`.`id` = 156 | 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 | 2 | maybe slow |
| 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 | 2 | maybe slow |
| 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 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 127 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| 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 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 124 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 47 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| 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 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 130 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 50 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 51 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 109 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| 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 | 2 | maybe slow |
| 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 | |