| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Shop`.`id`, `Shop`.`seller_id`, `Shop`.`name`, `Shop`.`slug`, `Shop`.`description`, `Seller`.`id`, `Seller`.`member_id` FROM `4love_ro`.`shops` AS `Shop` LEFT JOIN `4love_ro`.`sellers` AS `Seller` ON (`Shop`.`seller_id` = `Seller`.`id`) WHERE `slug` = '4love' LIMIT 1 | 0 | 0 | 0 | |
| SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`slug`, `Category`.`name` FROM `4love_ro`.`categories` AS `Category` WHERE `slug` IN ('sex-shop', 'vibratoare-1') ORDER BY `lft` asc | 2 | 2 | 0 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`banner`, `Category`.`banner_url`, `Category`.`description`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`image`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`top`, `Category`.`column`, `Category`.`sort_order`, `Category`.`status`, `Category`.`date_added`, `Category`.`date_modified`, `Category`.`views`, `Category`.`special` FROM `4love_ro`.`categories` AS `Category` WHERE `slug` = 'vibratoare-1' 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` = 54 ORDER BY `Category`.`lft` asc | 14 | 14 | 0 | |
| SELECT `Category`.`id` FROM `4love_ro`.`categories` AS `Category` WHERE `id` IN (54, 55, 56, 57, 58, 60, 61, 62, 63, 120, 132, 147, 148, 161, 143) | 15 | 15 | 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 (54, 55, 56, 57, 58, 60, 61, 62, 63, 120, 132, 143, 147, 148, 161) AND `CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `Product`.`status` = '1' | 1188 | 1188 | 7 | |
| SELECT `AttributeValue`.`attribute_id` FROM `4love_ro`.`attribute_values` AS `AttributeValue` WHERE `AttributeValue`.`entity_id` IN (7579, 13540, 25587, 26351, 26352, 29046, 29427, 32183, 34584, 9040, 9975, 10342, 13249, 13251, 13261, 15209, 15880, 16029, 16066, 17162, 17267, 20482, 21435, 21498, 24241, 25086, 25565, 25584, 26895, 27031, 27041, 27071, 27336, 27349, 27357, 27394, 27576, 27660, 27663, 27842, 27844, 27846, 27847, 28608, 28639, 28644, 28833, 29419, 29445, 30012, 31470, 31478, 31499, 31515, 31669, 31675, 32073, 32076, 32550, 32561, 32564, 33024, 33025, 34902, 35114, 35263, 35265, 35266, 35267, 35268, 35276, 35277, 35278, 35279, 35477, 35867, 35869, 35890, 35898, 36040, 36044, 36081, 36815, 36877, 36986, 36995, 37131, 37142, 37144, 37163, 37273, 37274, 37367, 37368, 37382, 37384, 37386, 37388, 37390, 37392, 37429, 37794, 37795, 37796, 37797, 37836, 37873, 37891, 37911, 37956, 37979, 37980, 37981, 37982, 37992, 38204, 38211, 38216, 38244, 38257, 38686, 38688, 38699, 38702, 38704, 38705, 38706, 38708, 7534, 7535, 7985, 8000, 8008, 8024, 8026, 8030, 8035, 8036, 8037, 8047, 8048, 8049, 8051, 8235, 9059, 11601, 11602, 11681, 13266, 13542, 13555, 13562, 13571, 13574, 13575, 15225, 15858, 15864, 15865, 15868, 15869, 15871, 15892, 15895, 15897, 15913, 15915, 15947, 15955, 15956, 15965, 17126, 17134, 17136, 17856, 18070, 18071, 18073, 18669, 18680, 18681, 18683, 18719, 18720, 18739, 18831, 18833, 19012, 19014, 19055, 19056, 19057, 20100, 20431, 20439, 20441, 20825, 20842, 21145, 21146, 21149, 21150, 21815, 21835, 21837, 21838, 21843, 21844, 21845, 21846, 21850, 21867, 21868, 21870, 21882, 21884, 21886, 22530, 22544, 22545, 22551, 22555, 22557, 22591, 22642, 22927, 24955, 24956, 24957, 24958, 25682, 25685, 26310, 26311, 26420, 27082, 27141, 27143, 27144, 27155, 27156, 27157, 27158, 27159, 27160, 27161, 27164, 27165, 27166, 27345, 27404, 27411, 27413, 28400, 28623, 28646, 28672, 29019, 29027, 29028, 29029, 29036, 29038, 29039, 29041, 29042, 29043, 29093, 29094, 29116, 29117, 29119, 29160, 29161, 29162, 29163, 29166, 29216, 29217, 29219, 29220, 29221, 29421, 29422, 30687, 30689, 30691, 30693, 32180, 32181, 32540, 34951, 34958, 35020, 35032, 35062, 35063, 35064, 35065, 35068, 35069, 35070, 35071, 35072, 35074, 35080, 35082, 35084, 35086, 35089, 35090, 35092, 35094, 35105, 35285, 35287, 35290, 35291, 35293, 35295, 35297, 35299, 35301, 35303, 35307, 35309, 35311, 35313, 35319, 35323, 35325, 35327, 35328, 35329, 35330, 35332, 35334, 35335, 35338, 35340, 35346, 35347, 35350, 35351, 35352, 35353, 35354, 35355, 35370, 35371, 35373, 35375, 35379, 35381, 35383, 35384, 35386, 35390, 35396, 35399, 35401, 35403, 35404, 35405, 35407, 35409, 35410, 35784, 35785, 35853, 35862, 35863, 35866, 35868, 35870, 35871, 35873, 35875, 35877, 35985, 36443, 37164, 37175, 37176, 37177, 37178, 37189, 37191, 37192, 37197, 37198, 37216, 37217, 37218, 37219, 37233, 37234, 37235, 37238, 37239, 37242, 37245, 37246, 37247, 37248, 37249, 37250, 37253, 37254, 37255, 37256, 37257, 37259, 37261, 37262, 37263, 37264, 37265, 37266, 37333, 37334, 37335, 37336, 37337, 37338, 37339, 37364, 37431, 37432, 37442, 37455, 37456, 37457, 37458, 37459, 37750, 37751, 37755, 37860, 37862, 37898, 37900, 37927, 37929, 38233, 38692, 10384, 11631, 11677, 19911, 20581, 20614, 21549, 21578, 22048, 22049, 22050, 24219, 24221, 25094, 25639, 26511, 26512, 26866, 27056, 27083, 27086, 27090, 27100, 27101, 27108, 27115, 27579, 28589, 28590, 28859, 28893, 28923, 28984, 29236, 29522, 30003, 31448, 31456, 31459, 31476, 31496, 31500, 31508, 32620, 32679, 33017, 33018, 33019, 33020, 34899, 34907, 35238, 35243, 35474, 35485, 35880, 35917, 35922, 35923, 35931, 36018, 36031, 36035, 36036, 36039, 36045, 36064, 36068, 36071, 36074, 36088, 36090, 36129, 36141, 36840, 36972, 36982, 36983, 36984, 36985, 37182, 37777, 37778, 37780, 37793, 37837, 37952, 37994, 37997, 38218, 38282, 38283, 38285, 38631, 38634, 38689, 38693, 38694, 7576, 9947, 10375, 12776, 12908, 13021, 13600, 18883, 18886, 18936, 22047, 22085, 22520, 22589, 22641, 24217, 24223, 24260, 24940, 25078, 25099, 25446, 25459, 25501, 25524, 25655, 25660, 25661, 26104, 26127, 26128, 26129, 26887, 27088, 27119, 27121, 27124, 27125, 27127, 27134, 27321, 27720, 28405, 28572, 28599, 28617, 28630, 28662, 28874, 28885, 28892, 28904, 28905, 29254, 29255, 29290, 29292, 29432, 29518, 30010, 31426, 31433, 31455, 31460, 31534, 31632, 31633, 31634, 32579, 32583, 32604, 32625, 32649, 34890, 34891, 34944, 34954, 35882, 35885, 35888, 35889, 35891, 35895, 35901, 35902, 35984, 36060, 36066, 36128, 36130, 36137, 36909, 36974, 36998, 37428, 37434, 37440, 37779, 37781, 37782, 37783, 37784, 37786, 37787, 37838, 37841, 37842, 37844, 37855, 37868, 37871, 37879, 37887, 37914, 37915, 37918, 37933, 37935, 37938, 37943, 37946, 37947, 37960, 37966, 37967, 37973, 37995, 38220, 38222, 38224, 38315, 38679, 38680, 38681, 38690, 38691, 20421, 20604, 21928, 22067, 22076, 25081, 25096, 25101, 25103, 25117, 25476, 25590, 25619, 26322, 26891, 27034, 27069, 27081, 27110, 27343, 27564, 27565, 27571, 27718, 28438, 28588, 28656, 28855, 28889, 28900, 28901, 28903, 28924, 28931, 28938, 29347, 29389, 29420, 30007, 30008, 30030, 30033, 30698, 31436, 31440, 31453, 31458, 31485, 31494, 31497, 31501, 31504, 31509, 31512, 31514, 31519, 31527, 31533, 31537, 32052, 32184, 32191, 32542, 34888, 34889, 34901, 34903, 34905, 34908, 34909, 34922, 34977, 35616, 35619, 35620, 35623, 35625, 35886, 35892, 35896, 35913, 35921, 35925, 35926, 35998, 36028, 36061, 36073, 36076, 36079, 36083, 36089, 36094, 36101, 36102, 36106, 36108, 36110, 36121, 36127, 36138, 36142, 36143, 36152, 36157, 36159, 36832, 36843, 36907, 36908, 36966, 36969, 36978, 36989, 36997, 37358, 37771, 37789, 37790, 37843, 37854, 37931, 37948, 38227, 38265, 38286, 38287, 38677, 38682, 38684, 38696, 38697, 38698, 38701, 11066, 11592, 13247, 13297, 13530, 15914, 16025, 16051, 16289, 17446, 20602, 20608, 20611, 20612, 21436, 21542, 21553, 21926, 22070, 22528, 23457, 24364, 24365, 26700, 27562, 27563, 28606, 28667, 28875, 28884, 28891, 28894, 29256, 29519, 29520, 30015, 31425, 31441, 31630, 31631, 32034, 32045, 32603, 32628, 33015, 33016, 34892, 34980, 35795, 35796, 36037, 36069, 36910, 37441, 37776, 37866, 37989, 37990, 37991, 37993, 38231, 38240, 38700, 8224, 9050, 10320, 10330, 11674, 12797, 13245, 13253, 13255, 15589, 15893, 16026, 16033, 16034, 16968, 17783, 18069, 18711, 18712, 18713, 18937, 20583, 20594, 20618, 20841, 21151, 21541, 21543, 21841, 22577, 24819, 24823, 25479, 25696, 26718, 26719, 26991, 26992, 26995, 27061, 27063, 27122, 28733, 28848, 28866, 28878, 28887, 28897, 28919, 28986, 29045, 29521, 31443, 32057, 32176, 32177, 32627, 34805, 34885, 34886, 34893, 34897, 34955, 34976, 34978, 35883, 35884, 35887, 35999, 36115, 36911, 36970, 37179, 37180, 37181, 37359, 37375, 37433, 37788, 37940, 37964, 37965, 38217, 38678, 38683, 38685, 38687, 11103, 21209, 25721, 25823, 27461, 28679, 32590, 35048, 35899, 36158, 38616, 14106, 17731, 18298, 20493, 21656, 22491, 23373, 24105, 24186, 24396, 25045, 25803, 26079, 26098, 26298, 26300, 27708, 28698, 28812, 29235, 29238, 29239, 29251, 29333, 29390, 29392, 30004, 30006, 32043, 32044, 33013, 33014, 33070, 33109, 33110, 33114, 33115, 34768, 34883, 35142, 35197, 35200, 35201, 35202, 35203, 35204, 35205, 35206, 35241, 35245, 35246, 35250, 35251, 36802, 36960, 36962, 37772, 37773, 38091, 38310, 38313, 38314, 38626, 38627, 38628, 7413, 11666, 16293, 16301, 16302, 20621, 20832, 21434, 21640, 22040, 22041, 22953, 25075, 25085, 25087, 25561, 27072, 27091, 27095, 27342, 28638, 28652, 29418, 29452, 30011, 31526, 32075, 32551, 32552, 32789, 33021, 33022, 33023, 33073, 33075, 33076, 35115, 35280, 35300, 35302, 35304, 35306, 35308, 35310, 35312, 35315, 35316, 35317, 35318, 35320, 35322, 35324, 35333, 35336, 35337, 36057, 36078, 36080, 36085, 36097, 36098, 36103, 36113, 36117, 36120, 36126, 36134, 36140, 36151, 37143, 37361, 37363, 37365, 37366, 37819, 37905, 37942, 38209, 38252, 38253, 38254, 38255, 38256, 38258, 38311, 38312, 25077, 25640, 28850, 32530, 32600, 32601, 36123, 36967, 15270, 15908, 21153, 22042, 22043, 22045, 25699, 25700, 26155, 27534, 28631, 28841, 28879, 28911, 31489, 36025, 36043, 36976, 37438, 37892, 37916, 38237, 38309, 38600, 38602, 38707, 28447, 28694, 28699, 29915, 29919, 29931, 35429, 35481, 35484, 35617, 35646, 35650, 35657, 35662, 36768, 36769) AND `AttributeValue`.`model` = 'Product' GROUP BY `AttributeValue`.`attribute_id` | 12 | 12 | 23 | maybe slow |
| SELECT `Attribute`.`id` FROM `4love_ro`.`attributes` AS `Attribute` WHERE `Attribute`.`name` IN ('Baterii', 'Functii') | 2 | 2 | 0 | |
| SELECT `Attribute`.`id`, `Attribute`.`name` FROM `4love_ro`.`attributes` AS `Attribute` WHERE `Attribute`.`id` IN (1, 2, 3, 4, 6, 13, 14, 17, 18, 20) ORDER BY `Attribute`.`name` asc | 10 | 10 | 0 | |
| SELECT `Attribute`.`id` FROM `4love_ro`.`attributes` AS `Attribute` WHERE `Attribute`.`name` IN ('Baterii', 'Functii') | 2 | 2 | 0 | |
| SELECT `Attribute`.`id`, `Attribute`.`name` FROM `4love_ro`.`attributes` AS `Attribute` WHERE `Attribute`.`id` IN (1, 2, 3, 4, 6, 13, 14, 17, 18, 20) ORDER BY `Attribute`.`name` asc | 10 | 10 | 0 | |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND attribute_values.attribute_id = 1
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 27 | 27 | 23 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND attribute_values.attribute_id = 2
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 64 | 64 | 22 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND attribute_values.attribute_id = 3
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 13 | 13 | 22 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND attribute_values.attribute_id = 4
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 21 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND attribute_values.attribute_id = 6
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 47 | 47 | 22 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND attribute_values.attribute_id = 13
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 21 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND attribute_values.attribute_id = 14
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 7 | 7 | 21 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND attribute_values.attribute_id = 17
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 21 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND attribute_values.attribute_id = 18
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 21 | maybe slow |
|
SELECT
attribute_values.value,
COUNT(DISTINCT attribute_values.entity_id) as count
FROM attribute_values
WHERE attribute_values.entity_id IN (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND attribute_values.attribute_id = 20
AND attribute_values.model = 'Product'
GROUP BY attribute_values.value
ORDER BY attribute_values.value ASC
| 1 | 1 | 21 | 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 (7579,13540,25587,26351,26352,29046,29427,32183,34584,9040,9975,10342,13249,13251,13261,15209,15880,16029,16066,17162,17267,20482,21435,21498,24241,25086,25565,25584,26895,27031,27041,27071,27336,27349,27357,27394,27576,27660,27663,27842,27844,27846,27847,28608,28639,28644,28833,29419,29445,30012,31470,31478,31499,31515,31669,31675,32073,32076,32550,32561,32564,33024,33025,34902,35114,35263,35265,35266,35267,35268,35276,35277,35278,35279,35477,35867,35869,35890,35898,36040,36044,36081,36815,36877,36986,36995,37131,37142,37144,37163,37273,37274,37367,37368,37382,37384,37386,37388,37390,37392,37429,37794,37795,37796,37797,37836,37873,37891,37911,37956,37979,37980,37981,37982,37992,38204,38211,38216,38244,38257,38686,38688,38699,38702,38704,38705,38706,38708,7534,7535,7985,8000,8008,8024,8026,8030,8035,8036,8037,8047,8048,8049,8051,8235,9059,11601,11602,11681,13266,13542,13555,13562,13571,13574,13575,15225,15858,15864,15865,15868,15869,15871,15892,15895,15897,15913,15915,15947,15955,15956,15965,17126,17134,17136,17856,18070,18071,18073,18669,18680,18681,18683,18719,18720,18739,18831,18833,19012,19014,19055,19056,19057,20100,20431,20439,20441,20825,20842,21145,21146,21149,21150,21815,21835,21837,21838,21843,21844,21845,21846,21850,21867,21868,21870,21882,21884,21886,22530,22544,22545,22551,22555,22557,22591,22642,22927,24955,24956,24957,24958,25682,25685,26310,26311,26420,27082,27141,27143,27144,27155,27156,27157,27158,27159,27160,27161,27164,27165,27166,27345,27404,27411,27413,28400,28623,28646,28672,29019,29027,29028,29029,29036,29038,29039,29041,29042,29043,29093,29094,29116,29117,29119,29160,29161,29162,29163,29166,29216,29217,29219,29220,29221,29421,29422,30687,30689,30691,30693,32180,32181,32540,34951,34958,35020,35032,35062,35063,35064,35065,35068,35069,35070,35071,35072,35074,35080,35082,35084,35086,35089,35090,35092,35094,35105,35285,35287,35290,35291,35293,35295,35297,35299,35301,35303,35307,35309,35311,35313,35319,35323,35325,35327,35328,35329,35330,35332,35334,35335,35338,35340,35346,35347,35350,35351,35352,35353,35354,35355,35370,35371,35373,35375,35379,35381,35383,35384,35386,35390,35396,35399,35401,35403,35404,35405,35407,35409,35410,35784,35785,35853,35862,35863,35866,35868,35870,35871,35873,35875,35877,35985,36443,37164,37175,37176,37177,37178,37189,37191,37192,37197,37198,37216,37217,37218,37219,37233,37234,37235,37238,37239,37242,37245,37246,37247,37248,37249,37250,37253,37254,37255,37256,37257,37259,37261,37262,37263,37264,37265,37266,37333,37334,37335,37336,37337,37338,37339,37364,37431,37432,37442,37455,37456,37457,37458,37459,37750,37751,37755,37860,37862,37898,37900,37927,37929,38233,38692,10384,11631,11677,19911,20581,20614,21549,21578,22048,22049,22050,24219,24221,25094,25639,26511,26512,26866,27056,27083,27086,27090,27100,27101,27108,27115,27579,28589,28590,28859,28893,28923,28984,29236,29522,30003,31448,31456,31459,31476,31496,31500,31508,32620,32679,33017,33018,33019,33020,34899,34907,35238,35243,35474,35485,35880,35917,35922,35923,35931,36018,36031,36035,36036,36039,36045,36064,36068,36071,36074,36088,36090,36129,36141,36840,36972,36982,36983,36984,36985,37182,37777,37778,37780,37793,37837,37952,37994,37997,38218,38282,38283,38285,38631,38634,38689,38693,38694,7576,9947,10375,12776,12908,13021,13600,18883,18886,18936,22047,22085,22520,22589,22641,24217,24223,24260,24940,25078,25099,25446,25459,25501,25524,25655,25660,25661,26104,26127,26128,26129,26887,27088,27119,27121,27124,27125,27127,27134,27321,27720,28405,28572,28599,28617,28630,28662,28874,28885,28892,28904,28905,29254,29255,29290,29292,29432,29518,30010,31426,31433,31455,31460,31534,31632,31633,31634,32579,32583,32604,32625,32649,34890,34891,34944,34954,35882,35885,35888,35889,35891,35895,35901,35902,35984,36060,36066,36128,36130,36137,36909,36974,36998,37428,37434,37440,37779,37781,37782,37783,37784,37786,37787,37838,37841,37842,37844,37855,37868,37871,37879,37887,37914,37915,37918,37933,37935,37938,37943,37946,37947,37960,37966,37967,37973,37995,38220,38222,38224,38315,38679,38680,38681,38690,38691,20421,20604,21928,22067,22076,25081,25096,25101,25103,25117,25476,25590,25619,26322,26891,27034,27069,27081,27110,27343,27564,27565,27571,27718,28438,28588,28656,28855,28889,28900,28901,28903,28924,28931,28938,29347,29389,29420,30007,30008,30030,30033,30698,31436,31440,31453,31458,31485,31494,31497,31501,31504,31509,31512,31514,31519,31527,31533,31537,32052,32184,32191,32542,34888,34889,34901,34903,34905,34908,34909,34922,34977,35616,35619,35620,35623,35625,35886,35892,35896,35913,35921,35925,35926,35998,36028,36061,36073,36076,36079,36083,36089,36094,36101,36102,36106,36108,36110,36121,36127,36138,36142,36143,36152,36157,36159,36832,36843,36907,36908,36966,36969,36978,36989,36997,37358,37771,37789,37790,37843,37854,37931,37948,38227,38265,38286,38287,38677,38682,38684,38696,38697,38698,38701,11066,11592,13247,13297,13530,15914,16025,16051,16289,17446,20602,20608,20611,20612,21436,21542,21553,21926,22070,22528,23457,24364,24365,26700,27562,27563,28606,28667,28875,28884,28891,28894,29256,29519,29520,30015,31425,31441,31630,31631,32034,32045,32603,32628,33015,33016,34892,34980,35795,35796,36037,36069,36910,37441,37776,37866,37989,37990,37991,37993,38231,38240,38700,8224,9050,10320,10330,11674,12797,13245,13253,13255,15589,15893,16026,16033,16034,16968,17783,18069,18711,18712,18713,18937,20583,20594,20618,20841,21151,21541,21543,21841,22577,24819,24823,25479,25696,26718,26719,26991,26992,26995,27061,27063,27122,28733,28848,28866,28878,28887,28897,28919,28986,29045,29521,31443,32057,32176,32177,32627,34805,34885,34886,34893,34897,34955,34976,34978,35883,35884,35887,35999,36115,36911,36970,37179,37180,37181,37359,37375,37433,37788,37940,37964,37965,38217,38678,38683,38685,38687,11103,21209,25721,25823,27461,28679,32590,35048,35899,36158,38616,14106,17731,18298,20493,21656,22491,23373,24105,24186,24396,25045,25803,26079,26098,26298,26300,27708,28698,28812,29235,29238,29239,29251,29333,29390,29392,30004,30006,32043,32044,33013,33014,33070,33109,33110,33114,33115,34768,34883,35142,35197,35200,35201,35202,35203,35204,35205,35206,35241,35245,35246,35250,35251,36802,36960,36962,37772,37773,38091,38310,38313,38314,38626,38627,38628,7413,11666,16293,16301,16302,20621,20832,21434,21640,22040,22041,22953,25075,25085,25087,25561,27072,27091,27095,27342,28638,28652,29418,29452,30011,31526,32075,32551,32552,32789,33021,33022,33023,33073,33075,33076,35115,35280,35300,35302,35304,35306,35308,35310,35312,35315,35316,35317,35318,35320,35322,35324,35333,35336,35337,36057,36078,36080,36085,36097,36098,36103,36113,36117,36120,36126,36134,36140,36151,37143,37361,37363,37365,37366,37819,37905,37942,38209,38252,38253,38254,38255,38256,38258,38311,38312,25077,25640,28850,32530,32600,32601,36123,36967,15270,15908,21153,22042,22043,22045,25699,25700,26155,27534,28631,28841,28879,28911,31489,36025,36043,36976,37438,37892,37916,38237,38309,38600,38602,38707,28447,28694,28699,29915,29919,29931,35429,35481,35484,35617,35646,35650,35657,35662,36768,36769)
AND products.status = 1
| 1 | 1 | 13 | 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 (7579, 13540, 25587, 26351, 26352, 29046, 29427, 32183, 34584, 9040, 9975, 10342, 13249, 13251, 13261, 15209, 15880, 16029, 16066, 17162, 17267, 20482, 21435, 21498, 24241, 25086, 25565, 25584, 26895, 27031, 27041, 27071, 27336, 27349, 27357, 27394, 27576, 27660, 27663, 27842, 27844, 27846, 27847, 28608, 28639, 28644, 28833, 29419, 29445, 30012, 31470, 31478, 31499, 31515, 31669, 31675, 32073, 32076, 32550, 32561, 32564, 33024, 33025, 34902, 35114, 35263, 35265, 35266, 35267, 35268, 35276, 35277, 35278, 35279, 35477, 35867, 35869, 35890, 35898, 36040, 36044, 36081, 36815, 36877, 36986, 36995, 37131, 37142, 37144, 37163, 37273, 37274, 37367, 37368, 37382, 37384, 37386, 37388, 37390, 37392, 37429, 37794, 37795, 37796, 37797, 37836, 37873, 37891, 37911, 37956, 37979, 37980, 37981, 37982, 37992, 38204, 38211, 38216, 38244, 38257, 38686, 38688, 38699, 38702, 38704, 38705, 38706, 38708, 7534, 7535, 7985, 8000, 8008, 8024, 8026, 8030, 8035, 8036, 8037, 8047, 8048, 8049, 8051, 8235, 9059, 11601, 11602, 11681, 13266, 13542, 13555, 13562, 13571, 13574, 13575, 15225, 15858, 15864, 15865, 15868, 15869, 15871, 15892, 15895, 15897, 15913, 15915, 15947, 15955, 15956, 15965, 17126, 17134, 17136, 17856, 18070, 18071, 18073, 18669, 18680, 18681, 18683, 18719, 18720, 18739, 18831, 18833, 19012, 19014, 19055, 19056, 19057, 20100, 20431, 20439, 20441, 20825, 20842, 21145, 21146, 21149, 21150, 21815, 21835, 21837, 21838, 21843, 21844, 21845, 21846, 21850, 21867, 21868, 21870, 21882, 21884, 21886, 22530, 22544, 22545, 22551, 22555, 22557, 22591, 22642, 22927, 24955, 24956, 24957, 24958, 25682, 25685, 26310, 26311, 26420, 27082, 27141, 27143, 27144, 27155, 27156, 27157, 27158, 27159, 27160, 27161, 27164, 27165, 27166, 27345, 27404, 27411, 27413, 28400, 28623, 28646, 28672, 29019, 29027, 29028, 29029, 29036, 29038, 29039, 29041, 29042, 29043, 29093, 29094, 29116, 29117, 29119, 29160, 29161, 29162, 29163, 29166, 29216, 29217, 29219, 29220, 29221, 29421, 29422, 30687, 30689, 30691, 30693, 32180, 32181, 32540, 34951, 34958, 35020, 35032, 35062, 35063, 35064, 35065, 35068, 35069, 35070, 35071, 35072, 35074, 35080, 35082, 35084, 35086, 35089, 35090, 35092, 35094, 35105, 35285, 35287, 35290, 35291, 35293, 35295, 35297, 35299, 35301, 35303, 35307, 35309, 35311, 35313, 35319, 35323, 35325, 35327, 35328, 35329, 35330, 35332, 35334, 35335, 35338, 35340, 35346, 35347, 35350, 35351, 35352, 35353, 35354, 35355, 35370, 35371, 35373, 35375, 35379, 35381, 35383, 35384, 35386, 35390, 35396, 35399, 35401, 35403, 35404, 35405, 35407, 35409, 35410, 35784, 35785, 35853, 35862, 35863, 35866, 35868, 35870, 35871, 35873, 35875, 35877, 35985, 36443, 37164, 37175, 37176, 37177, 37178, 37189, 37191, 37192, 37197, 37198, 37216, 37217, 37218, 37219, 37233, 37234, 37235, 37238, 37239, 37242, 37245, 37246, 37247, 37248, 37249, 37250, 37253, 37254, 37255, 37256, 37257, 37259, 37261, 37262, 37263, 37264, 37265, 37266, 37333, 37334, 37335, 37336, 37337, 37338, 37339, 37364, 37431, 37432, 37442, 37455, 37456, 37457, 37458, 37459, 37750, 37751, 37755, 37860, 37862, 37898, 37900, 37927, 37929, 38233, 38692, 10384, 11631, 11677, 19911, 20581, 20614, 21549, 21578, 22048, 22049, 22050, 24219, 24221, 25094, 25639, 26511, 26512, 26866, 27056, 27083, 27086, 27090, 27100, 27101, 27108, 27115, 27579, 28589, 28590, 28859, 28893, 28923, 28984, 29236, 29522, 30003, 31448, 31456, 31459, 31476, 31496, 31500, 31508, 32620, 32679, 33017, 33018, 33019, 33020, 34899, 34907, 35238, 35243, 35474, 35485, 35880, 35917, 35922, 35923, 35931, 36018, 36031, 36035, 36036, 36039, 36045, 36064, 36068, 36071, 36074, 36088, 36090, 36129, 36141, 36840, 36972, 36982, 36983, 36984, 36985, 37182, 37777, 37778, 37780, 37793, 37837, 37952, 37994, 37997, 38218, 38282, 38283, 38285, 38631, 38634, 38689, 38693, 38694, 7576, 9947, 10375, 12776, 12908, 13021, 13600, 18883, 18886, 18936, 22047, 22085, 22520, 22589, 22641, 24217, 24223, 24260, 24940, 25078, 25099, 25446, 25459, 25501, 25524, 25655, 25660, 25661, 26104, 26127, 26128, 26129, 26887, 27088, 27119, 27121, 27124, 27125, 27127, 27134, 27321, 27720, 28405, 28572, 28599, 28617, 28630, 28662, 28874, 28885, 28892, 28904, 28905, 29254, 29255, 29290, 29292, 29432, 29518, 30010, 31426, 31433, 31455, 31460, 31534, 31632, 31633, 31634, 32579, 32583, 32604, 32625, 32649, 34890, 34891, 34944, 34954, 35882, 35885, 35888, 35889, 35891, 35895, 35901, 35902, 35984, 36060, 36066, 36128, 36130, 36137, 36909, 36974, 36998, 37428, 37434, 37440, 37779, 37781, 37782, 37783, 37784, 37786, 37787, 37838, 37841, 37842, 37844, 37855, 37868, 37871, 37879, 37887, 37914, 37915, 37918, 37933, 37935, 37938, 37943, 37946, 37947, 37960, 37966, 37967, 37973, 37995, 38220, 38222, 38224, 38315, 38679, 38680, 38681, 38690, 38691, 20421, 20604, 21928, 22067, 22076, 25081, 25096, 25101, 25103, 25117, 25476, 25590, 25619, 26322, 26891, 27034, 27069, 27081, 27110, 27343, 27564, 27565, 27571, 27718, 28438, 28588, 28656, 28855, 28889, 28900, 28901, 28903, 28924, 28931, 28938, 29347, 29389, 29420, 30007, 30008, 30030, 30033, 30698, 31436, 31440, 31453, 31458, 31485, 31494, 31497, 31501, 31504, 31509, 31512, 31514, 31519, 31527, 31533, 31537, 32052, 32184, 32191, 32542, 34888, 34889, 34901, 34903, 34905, 34908, 34909, 34922, 34977, 35616, 35619, 35620, 35623, 35625, 35886, 35892, 35896, 35913, 35921, 35925, 35926, 35998, 36028, 36061, 36073, 36076, 36079, 36083, 36089, 36094, 36101, 36102, 36106, 36108, 36110, 36121, 36127, 36138, 36142, 36143, 36152, 36157, 36159, 36832, 36843, 36907, 36908, 36966, 36969, 36978, 36989, 36997, 37358, 37771, 37789, 37790, 37843, 37854, 37931, 37948, 38227, 38265, 38286, 38287, 38677, 38682, 38684, 38696, 38697, 38698, 38701, 11066, 11592, 13247, 13297, 13530, 15914, 16025, 16051, 16289, 17446, 20602, 20608, 20611, 20612, 21436, 21542, 21553, 21926, 22070, 22528, 23457, 24364, 24365, 26700, 27562, 27563, 28606, 28667, 28875, 28884, 28891, 28894, 29256, 29519, 29520, 30015, 31425, 31441, 31630, 31631, 32034, 32045, 32603, 32628, 33015, 33016, 34892, 34980, 35795, 35796, 36037, 36069, 36910, 37441, 37776, 37866, 37989, 37990, 37991, 37993, 38231, 38240, 38700, 8224, 9050, 10320, 10330, 11674, 12797, 13245, 13253, 13255, 15589, 15893, 16026, 16033, 16034, 16968, 17783, 18069, 18711, 18712, 18713, 18937, 20583, 20594, 20618, 20841, 21151, 21541, 21543, 21841, 22577, 24819, 24823, 25479, 25696, 26718, 26719, 26991, 26992, 26995, 27061, 27063, 27122, 28733, 28848, 28866, 28878, 28887, 28897, 28919, 28986, 29045, 29521, 31443, 32057, 32176, 32177, 32627, 34805, 34885, 34886, 34893, 34897, 34955, 34976, 34978, 35883, 35884, 35887, 35999, 36115, 36911, 36970, 37179, 37180, 37181, 37359, 37375, 37433, 37788, 37940, 37964, 37965, 38217, 38678, 38683, 38685, 38687, 11103, 21209, 25721, 25823, 27461, 28679, 32590, 35048, 35899, 36158, 38616, 14106, 17731, 18298, 20493, 21656, 22491, 23373, 24105, 24186, 24396, 25045, 25803, 26079, 26098, 26298, 26300, 27708, 28698, 28812, 29235, 29238, 29239, 29251, 29333, 29390, 29392, 30004, 30006, 32043, 32044, 33013, 33014, 33070, 33109, 33110, 33114, 33115, 34768, 34883, 35142, 35197, 35200, 35201, 35202, 35203, 35204, 35205, 35206, 35241, 35245, 35246, 35250, 35251, 36802, 36960, 36962, 37772, 37773, 38091, 38310, 38313, 38314, 38626, 38627, 38628, 7413, 11666, 16293, 16301, 16302, 20621, 20832, 21434, 21640, 22040, 22041, 22953, 25075, 25085, 25087, 25561, 27072, 27091, 27095, 27342, 28638, 28652, 29418, 29452, 30011, 31526, 32075, 32551, 32552, 32789, 33021, 33022, 33023, 33073, 33075, 33076, 35115, 35280, 35300, 35302, 35304, 35306, 35308, 35310, 35312, 35315, 35316, 35317, 35318, 35320, 35322, 35324, 35333, 35336, 35337, 36057, 36078, 36080, 36085, 36097, 36098, 36103, 36113, 36117, 36120, 36126, 36134, 36140, 36151, 37143, 37361, 37363, 37365, 37366, 37819, 37905, 37942, 38209, 38252, 38253, 38254, 38255, 38256, 38258, 38311, 38312, 25077, 25640, 28850, 32530, 32600, 32601, 36123, 36967, 15270, 15908, 21153, 22042, 22043, 22045, 25699, 25700, 26155, 27534, 28631, 28841, 28879, 28911, 31489, 36025, 36043, 36976, 37438, 37892, 37916, 38237, 38309, 38600, 38602, 38707, 28447, 28694, 28699, 29915, 29919, 29931, 35429, 35481, 35484, 35617, 35646, 35650, 35657, 35662, 36768, 36769) ORDER BY `Product`.`priority` desc, `Product`.`id` desc LIMIT 60 | 60 | 60 | 6 | 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` = (38091) 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` = (37432) 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` = (37429) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (37428) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (27534) 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` = (25479) 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` = (21153) 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` = (34584) 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` = (36962) 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` = (35293) 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` = (32649) 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` = (32601) 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` = (28667) 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` = (21640) 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` = (20614) 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` = (20493) 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` = (37793) 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` = (36123) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (33013) 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` = (28850) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (28656) 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` = (27847) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (27563) 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` = (27321) 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` = (27141) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (18680) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (11631) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (11666) 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` = (30003) 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` = (31519) 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` = (31512) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (29045) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (28931) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (28638) 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` = (28599) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (27576) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (27571) 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` = (26300) 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` = (26128) 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` = (25661) 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` = (25660) 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` = (25081) 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` = (25077) 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` = (24217) 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` = (22076) 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` = (22067) 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` = (20608) 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` = (18669) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (16293) 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` = (15908) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (22577) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (16029) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (10384) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (29420) 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` = (25590) 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` = (32603) 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` = (27081) 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` = (25700) 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` = (8035) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 0 | 0 | 0 | |
| SELECT `ProductDiscount`.`price`, `ProductDiscount`.`product_id` FROM `4love_ro`.`product_discounts` AS `ProductDiscount` WHERE ((((`ProductDiscount`.`end_date` >= NOW()) OR (`ProductDiscount`.`end_date` = '0000-00-00'))) AND (((`ProductDiscount`.`start_date` <= NOW()) OR (`ProductDiscount`.`start_date` = '0000-00-00')))) AND `ProductDiscount`.`product_id` = (25101) ORDER BY `ProductDiscount`.`priority` asc LIMIT 1 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`id` IN (7579, 13540, 25587, 26351, 26352, 29046, 29427, 32183, 34584, 9040, 9975, 10342, 13249, 13251, 13261, 15209, 15880, 16029, 16066, 17162, 17267, 20482, 21435, 21498, 24241, 25086, 25565, 25584, 26895, 27031, 27041, 27071, 27336, 27349, 27357, 27394, 27576, 27660, 27663, 27842, 27844, 27846, 27847, 28608, 28639, 28644, 28833, 29419, 29445, 30012, 31470, 31478, 31499, 31515, 31669, 31675, 32073, 32076, 32550, 32561, 32564, 33024, 33025, 34902, 35114, 35263, 35265, 35266, 35267, 35268, 35276, 35277, 35278, 35279, 35477, 35867, 35869, 35890, 35898, 36040, 36044, 36081, 36815, 36877, 36986, 36995, 37131, 37142, 37144, 37163, 37273, 37274, 37367, 37368, 37382, 37384, 37386, 37388, 37390, 37392, 37429, 37794, 37795, 37796, 37797, 37836, 37873, 37891, 37911, 37956, 37979, 37980, 37981, 37982, 37992, 38204, 38211, 38216, 38244, 38257, 38686, 38688, 38699, 38702, 38704, 38705, 38706, 38708, 7534, 7535, 7985, 8000, 8008, 8024, 8026, 8030, 8035, 8036, 8037, 8047, 8048, 8049, 8051, 8235, 9059, 11601, 11602, 11681, 13266, 13542, 13555, 13562, 13571, 13574, 13575, 15225, 15858, 15864, 15865, 15868, 15869, 15871, 15892, 15895, 15897, 15913, 15915, 15947, 15955, 15956, 15965, 17126, 17134, 17136, 17856, 18070, 18071, 18073, 18669, 18680, 18681, 18683, 18719, 18720, 18739, 18831, 18833, 19012, 19014, 19055, 19056, 19057, 20100, 20431, 20439, 20441, 20825, 20842, 21145, 21146, 21149, 21150, 21815, 21835, 21837, 21838, 21843, 21844, 21845, 21846, 21850, 21867, 21868, 21870, 21882, 21884, 21886, 22530, 22544, 22545, 22551, 22555, 22557, 22591, 22642, 22927, 24955, 24956, 24957, 24958, 25682, 25685, 26310, 26311, 26420, 27082, 27141, 27143, 27144, 27155, 27156, 27157, 27158, 27159, 27160, 27161, 27164, 27165, 27166, 27345, 27404, 27411, 27413, 28400, 28623, 28646, 28672, 29019, 29027, 29028, 29029, 29036, 29038, 29039, 29041, 29042, 29043, 29093, 29094, 29116, 29117, 29119, 29160, 29161, 29162, 29163, 29166, 29216, 29217, 29219, 29220, 29221, 29421, 29422, 30687, 30689, 30691, 30693, 32180, 32181, 32540, 34951, 34958, 35020, 35032, 35062, 35063, 35064, 35065, 35068, 35069, 35070, 35071, 35072, 35074, 35080, 35082, 35084, 35086, 35089, 35090, 35092, 35094, 35105, 35285, 35287, 35290, 35291, 35293, 35295, 35297, 35299, 35301, 35303, 35307, 35309, 35311, 35313, 35319, 35323, 35325, 35327, 35328, 35329, 35330, 35332, 35334, 35335, 35338, 35340, 35346, 35347, 35350, 35351, 35352, 35353, 35354, 35355, 35370, 35371, 35373, 35375, 35379, 35381, 35383, 35384, 35386, 35390, 35396, 35399, 35401, 35403, 35404, 35405, 35407, 35409, 35410, 35784, 35785, 35853, 35862, 35863, 35866, 35868, 35870, 35871, 35873, 35875, 35877, 35985, 36443, 37164, 37175, 37176, 37177, 37178, 37189, 37191, 37192, 37197, 37198, 37216, 37217, 37218, 37219, 37233, 37234, 37235, 37238, 37239, 37242, 37245, 37246, 37247, 37248, 37249, 37250, 37253, 37254, 37255, 37256, 37257, 37259, 37261, 37262, 37263, 37264, 37265, 37266, 37333, 37334, 37335, 37336, 37337, 37338, 37339, 37364, 37431, 37432, 37442, 37455, 37456, 37457, 37458, 37459, 37750, 37751, 37755, 37860, 37862, 37898, 37900, 37927, 37929, 38233, 38692, 10384, 11631, 11677, 19911, 20581, 20614, 21549, 21578, 22048, 22049, 22050, 24219, 24221, 25094, 25639, 26511, 26512, 26866, 27056, 27083, 27086, 27090, 27100, 27101, 27108, 27115, 27579, 28589, 28590, 28859, 28893, 28923, 28984, 29236, 29522, 30003, 31448, 31456, 31459, 31476, 31496, 31500, 31508, 32620, 32679, 33017, 33018, 33019, 33020, 34899, 34907, 35238, 35243, 35474, 35485, 35880, 35917, 35922, 35923, 35931, 36018, 36031, 36035, 36036, 36039, 36045, 36064, 36068, 36071, 36074, 36088, 36090, 36129, 36141, 36840, 36972, 36982, 36983, 36984, 36985, 37182, 37777, 37778, 37780, 37793, 37837, 37952, 37994, 37997, 38218, 38282, 38283, 38285, 38631, 38634, 38689, 38693, 38694, 7576, 9947, 10375, 12776, 12908, 13021, 13600, 18883, 18886, 18936, 22047, 22085, 22520, 22589, 22641, 24217, 24223, 24260, 24940, 25078, 25099, 25446, 25459, 25501, 25524, 25655, 25660, 25661, 26104, 26127, 26128, 26129, 26887, 27088, 27119, 27121, 27124, 27125, 27127, 27134, 27321, 27720, 28405, 28572, 28599, 28617, 28630, 28662, 28874, 28885, 28892, 28904, 28905, 29254, 29255, 29290, 29292, 29432, 29518, 30010, 31426, 31433, 31455, 31460, 31534, 31632, 31633, 31634, 32579, 32583, 32604, 32625, 32649, 34890, 34891, 34944, 34954, 35882, 35885, 35888, 35889, 35891, 35895, 35901, 35902, 35984, 36060, 36066, 36128, 36130, 36137, 36909, 36974, 36998, 37428, 37434, 37440, 37779, 37781, 37782, 37783, 37784, 37786, 37787, 37838, 37841, 37842, 37844, 37855, 37868, 37871, 37879, 37887, 37914, 37915, 37918, 37933, 37935, 37938, 37943, 37946, 37947, 37960, 37966, 37967, 37973, 37995, 38220, 38222, 38224, 38315, 38679, 38680, 38681, 38690, 38691, 20421, 20604, 21928, 22067, 22076, 25081, 25096, 25101, 25103, 25117, 25476, 25590, 25619, 26322, 26891, 27034, 27069, 27081, 27110, 27343, 27564, 27565, 27571, 27718, 28438, 28588, 28656, 28855, 28889, 28900, 28901, 28903, 28924, 28931, 28938, 29347, 29389, 29420, 30007, 30008, 30030, 30033, 30698, 31436, 31440, 31453, 31458, 31485, 31494, 31497, 31501, 31504, 31509, 31512, 31514, 31519, 31527, 31533, 31537, 32052, 32184, 32191, 32542, 34888, 34889, 34901, 34903, 34905, 34908, 34909, 34922, 34977, 35616, 35619, 35620, 35623, 35625, 35886, 35892, 35896, 35913, 35921, 35925, 35926, 35998, 36028, 36061, 36073, 36076, 36079, 36083, 36089, 36094, 36101, 36102, 36106, 36108, 36110, 36121, 36127, 36138, 36142, 36143, 36152, 36157, 36159, 36832, 36843, 36907, 36908, 36966, 36969, 36978, 36989, 36997, 37358, 37771, 37789, 37790, 37843, 37854, 37931, 37948, 38227, 38265, 38286, 38287, 38677, 38682, 38684, 38696, 38697, 38698, 38701, 11066, 11592, 13247, 13297, 13530, 15914, 16025, 16051, 16289, 17446, 20602, 20608, 20611, 20612, 21436, 21542, 21553, 21926, 22070, 22528, 23457, 24364, 24365, 26700, 27562, 27563, 28606, 28667, 28875, 28884, 28891, 28894, 29256, 29519, 29520, 30015, 31425, 31441, 31630, 31631, 32034, 32045, 32603, 32628, 33015, 33016, 34892, 34980, 35795, 35796, 36037, 36069, 36910, 37441, 37776, 37866, 37989, 37990, 37991, 37993, 38231, 38240, 38700, 8224, 9050, 10320, 10330, 11674, 12797, 13245, 13253, 13255, 15589, 15893, 16026, 16033, 16034, 16968, 17783, 18069, 18711, 18712, 18713, 18937, 20583, 20594, 20618, 20841, 21151, 21541, 21543, 21841, 22577, 24819, 24823, 25479, 25696, 26718, 26719, 26991, 26992, 26995, 27061, 27063, 27122, 28733, 28848, 28866, 28878, 28887, 28897, 28919, 28986, 29045, 29521, 31443, 32057, 32176, 32177, 32627, 34805, 34885, 34886, 34893, 34897, 34955, 34976, 34978, 35883, 35884, 35887, 35999, 36115, 36911, 36970, 37179, 37180, 37181, 37359, 37375, 37433, 37788, 37940, 37964, 37965, 38217, 38678, 38683, 38685, 38687, 11103, 21209, 25721, 25823, 27461, 28679, 32590, 35048, 35899, 36158, 38616, 14106, 17731, 18298, 20493, 21656, 22491, 23373, 24105, 24186, 24396, 25045, 25803, 26079, 26098, 26298, 26300, 27708, 28698, 28812, 29235, 29238, 29239, 29251, 29333, 29390, 29392, 30004, 30006, 32043, 32044, 33013, 33014, 33070, 33109, 33110, 33114, 33115, 34768, 34883, 35142, 35197, 35200, 35201, 35202, 35203, 35204, 35205, 35206, 35241, 35245, 35246, 35250, 35251, 36802, 36960, 36962, 37772, 37773, 38091, 38310, 38313, 38314, 38626, 38627, 38628, 7413, 11666, 16293, 16301, 16302, 20621, 20832, 21434, 21640, 22040, 22041, 22953, 25075, 25085, 25087, 25561, 27072, 27091, 27095, 27342, 28638, 28652, 29418, 29452, 30011, 31526, 32075, 32551, 32552, 32789, 33021, 33022, 33023, 33073, 33075, 33076, 35115, 35280, 35300, 35302, 35304, 35306, 35308, 35310, 35312, 35315, 35316, 35317, 35318, 35320, 35322, 35324, 35333, 35336, 35337, 36057, 36078, 36080, 36085, 36097, 36098, 36103, 36113, 36117, 36120, 36126, 36134, 36140, 36151, 37143, 37361, 37363, 37365, 37366, 37819, 37905, 37942, 38209, 38252, 38253, 38254, 38255, 38256, 38258, 38311, 38312, 25077, 25640, 28850, 32530, 32600, 32601, 36123, 36967, 15270, 15908, 21153, 22042, 22043, 22045, 25699, 25700, 26155, 27534, 28631, 28841, 28879, 28911, 31489, 36025, 36043, 36976, 37438, 37892, 37916, 38237, 38309, 38600, 38602, 38707, 28447, 28694, 28699, 29915, 29919, 29931, 35429, 35481, 35484, 35617, 35646, 35650, 35657, 35662, 36768, 36769) | 1 | 1 | 3 | maybe slow |
| UPDATE `4love_ro`.`categories` AS `Category` SET `Category`.`views` = `Category`.`views` + 1 WHERE `Category`.`id` = 54 | 1 | 1 | 0 | |
| SELECT `Manufacturer`.`id`, `Manufacturer`.`name`, `Manufacturer`.`slug`, `Manufacturer`.`image`, `Manufacturer`.`sort_order`, `Manufacturer`.`status` FROM `4love_ro`.`manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`status` = 1 ORDER BY `name` ASC | 47 | 47 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 106 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 110 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 35 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 36 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 37 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 38 AND `Product`.`status` = '1' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 126 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 75 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 70 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 98 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 108 AND `Product`.`status` = '1' | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 107 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 64 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 31 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 42 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 128 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 123 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 125 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 122 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 89 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 32 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 104 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 102 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 83 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 96 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 127 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 116 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 95 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 129 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 124 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 47 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 90 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 49 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 112 AND `Product`.`status` = '1' | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 130 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 50 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 51 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 109 AND `Product`.`status` = '1' | 1 | 1 | 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 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 118 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 97 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `4love_ro`.`products` AS `Product` WHERE `Product`.`manufacturer_id` = 63 AND `Product`.`status` = '1' | 1 | 1 | 1 | |
