https://test.perina-peroni.ru/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CPartsController%253A%253ArenderTopCatalog

Method
GET
HTTP Status
200
IP
216.73.216.33
Profiled on
Token
d3b805

Query Metrics

37 Database Queries
29 Different statements
503.24 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.13 ms 
SELECT (c0_.id) AS sclr_0, (c0_.name) AS sclr_1, (c0_.parent_id) AS sclr_2, (c0_.products_number) AS sclr_3, (c0_.slug) AS sclr_4, (c0_.sort) AS sclr_5, (c0_.icon) AS sclr_6, (c0_.image) AS sclr_7 FROM category c0_ WHERE c0_.visible = 1 ORDER BY c0_.sort ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.10 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.kladr AS kladr_4, t0.fias AS fias_5, t0.oktmo AS oktmo_6, t0.time_zone AS time_zone_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.population AS population_10, t0.full_address AS full_address_11, t0.okato AS okato_12, t0.country AS country_13, t0.region_id AS region_id_14, t0.delivery_zone_id AS delivery_zone_id_15 FROM city t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3 0.48 ms 
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.date_from AS date_from_2, p0_.date_to AS date_to_3, p0_.name AS name_4, p0_.config AS config_5, p0_.type AS type_6, p0_.product_label_id AS product_label_id_7 FROM promotion p0_ WHERE (p0_.is_active = 1 AND p0_.date_to >= ? AND p0_.date_from <= ?) AND p0_.type IN ('profit_set', 'registered_customer', 'even_less_price', 'discount_on_products')
Parameters: 
[
  "2026-02-04 06:45:34"
  "2026-02-04 06:45:34"
]
View formatted query    View runnable query    Explain query
4 0.23 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.conditions AS conditions_6, t0.visible AS visible_7, t0.short_name AS short_name_8, t0.image AS image_9, t0.filter_properties AS filter_properties_10, t0.products_count AS products_count_11, t0.content_id AS content_id_12 FROM virtual_category t0 WHERE t0.id = ?
Parameters: 
[
  500
]
View formatted query    View runnable query    Explain query
5 77.14 ms 
SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND p0_.old_price > 0 AND p0_.name NOT LIKE ? LIMIT 9000
Parameters: 
[
  "%Уценка%"
]
View formatted query    View runnable query    Explain query
6 15.29 ms 
SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (950, 1000, 1027, 1060, 1594, 1598, 1901, 1963, 1964, 1965, 1968, 1969, 1970, 1974, 1975, 1977, 1978, 1979, 1980, 2600, 2605, 2850, 2851, 2855, 3221, 3235, 3474, 3475, 3476, 4525, 4662, 4663, 4675, 4693, 4698, 4709, 4726, 5349, 5355, 5386, 5408, 5672, 5673, 5704, 6162, 6166, 6169, 6193, 6195, 6229, 6237, 6310, 6342, 6384, 6388, 6393, 6408, 6410, 6422, 6424, 6471, 6488, 6497, 6512, 6521, 6525, 6526, 6527, 6533, 6618, 6620, 6633, 6635, 6640, 6642, 6654, 6666, 6669, 6678, 6683, 6684, 6709, 7206, 7218, 8369, 8372, 9026, 9143, 9152, 9353, 9459, 9594, 10487, 10699, 10781, 10794, 11340, 11529, 11530, 11531, 11549, 11550, 11552, 11690, 11972, 12678, 13194, 13205, 13211, 13214, 13215, 13222, 13234, 13238, 13256, 13259, 13263, 13281, 13282, 13294, 13299, 13302, 13303, 13322, 13348, 13355, 13360, 13378, 13389, 13445, 13449, 13450, 13463, 13480, 13482, 13483, 13484, 13491, 13497, 13512, 13608, 13615, 13667, 13668, 13670, 13672, 13900, 13901, 13902, 13967, 14117, 14118, 14227, 14228, 14231, 14346, 14803, 15206, 15483, 15486, 15487, 15488, 15489, 15496, 16068, 16069, 16741, 16811, 17461, 17462, 17463, 17464, 17465, 17467, 17468, 17469, 17470, 17471, 17472, 17473, 17729, 17794, 17796, 17797, 17800, 17801, 17803, 17804, 17805, 17834, 17835, 18094, 18101, 18196, 18197, 18206, 18209, 18218, 18231, 18233, 18237, 18239, 18241, 18246, 18251, 18259, 18292, 18294, 18304, 18332, 18386, 18496, 18550, 18553, 18566, 18567, 18568, 18569, 18572, 18574, 18578, 18579, 18586, 18587, 18588, 18589, 18590, 18591, 18592, 18593, 18594, 18595, 18596, 18597, 18598, 18599, 18600, 18601, 18603, 18604, 18605, 18609, 18610, 18611, 18613, 18614, 18616, 18617, 18618, 18620, 18621, 18623, 18624, 18626, 18627, 18630, 18631, 18633, 18634, 18635, 18638, 18640, 18642, 18643, 19047, 19181, 19233, 19273, 19274, 19278, 19280, 19282, 19342, 19343, 19399, 19425, 19489, 19808, 19847, 19848, 19852, 19853, 19854, 19856, 19857, 19858, 19860, 19864, 19867, 19868, 19869, 20000, 20161, 20254, 20257, 20310, 20398, 20415, 20474, 20570, 20776, 20778, 20780, 20781, 20787, 20788, 20789, 20790, 20954, 21337, 21353, 21358, 21362, 21367, 21368, 21369, 21532, 21698, 21701, 21702, 21703, 21714, 21719, 21720, 21721, 21722, 21723, 21725, 21727, 21728, 21729, 21731, 21732, 21733, 21734, 21736, 21737, 21740, 21741, 21742, 21747, 21761, 21765, 21767, 21768, 21769, 21770, 21771, 21772, 21773, 21774, 21775, 21776, 21778, 21779, 21781, 21784, 21839, 21960, 21964, 21973, 21974, 21975, 21976, 21979, 21980, 22074, 22138, 22141, 22150, 22151, 22253, 22256, 22525, 22542, 22545, 22594, 22596, 22599, 22600, 22601, 22602, 22603, 22605, 22606, 22607, 22608, 22614, 22615, 22616, 22617, 22618, 22628, 22639, 22681, 22682, 22685, 22687, 22688, 22689, 22690, 22693, 22795, 22798, 22800, 22802, 22811, 22813, 22816, 22819, 22877, 22925, 22932, 23186, 23187, 23190, 23191, 23192, 23193, 23312, 23348, 23351, 23353, 23354, 23355, 23357, 23359, 23361, 23363, 23374, 23380, 23385, 23386, 23393, 23441, 23468, 23480, 23482, 23503, 23535, 23536, 23586, 23587, 23594, 23876, 23893, 23932, 23933, 24265, 24314, 24357, 24358, 24359, 24360, 24361, 24364, 24367, 24368, 24370, 24374, 24382, 24392, 24396, 24447, 24448, 24450, 24452, 24453, 24682, 24694, 24878, 24909, 24935, 24971, 24980, 24981, 24982, 24983, 24985, 25018, 25023, 25125, 25130, 25157, 25159, 25161, 25242, 25291, 25307, 25319, 25331, 25336, 25343, 25344, 25404, 25501, 25592, 25683, 25688, 25693, 25773, 25774, 25775, 25777, 25784, 25786, 25790, 25791, 25792, 25932, 25940, 25941, 25950, 25951, 26097, 26109, 26119, 26124, 26126, 26164, 26173, 26174, 26175, 26176, 26177, 26178, 26179, 26180, 26183, 26190, 26191, 26192, 26194, 26195, 26196, 26285, 26310, 26642, 26647, 26740, 26797, 26801, 26804, 26808, 26810, 26828, 26900, 26903, 26904, 26906, 26954, 26956, 27027, 27075, 27098, 27202, 27204, 27205, 27206, 27207, 27209, 27210, 27215, 27216, 27218, 27235, 27245, 27250, 27253, 27254, 27255, 27256, 27257, 27299, 27302, 27311, 27373, 27375, 27376, 27472, 27548, 27551, 27564, 27569, 27570, 27571, 27598, 27600, 27682, 27834, 27835, 27837, 27839, 27840, 27842, 28217, 28222, 28965, 28968, 28970, 28971, 28972, 28973, 28974, 28996, 29048, 29063, 29064, 29077, 29079, 29105, 29107, 29110, 29113, 29114, 29115, 29137, 29152, 29153, 29174, 29176, 29178, 29181, 29188, 29189, 29191, 29210, 29211, 29212, 29213, 29214, 29387, 29389, 29399, 29404, 29405, 29407, 30079, 30086, 30087, 30088, 30165, 30169, 30170, 30234, 30235, 30236, 30237, 30238, 30252, 30253, 30254, 30255, 30256, 30269, 30270, 30271, 30272, 30273, 30274, 30503, 30516, 30518, 30553, 30554, 30555, 30556, 30557, 30559, 30561, 30564, 30565, 30566, 30569, 30573, 30582, 30583, 30584, 30587, 30589, 30592, 30594, 30596, 30600, 30666, 30673, 30674, 30675, 30678, 30680, 30735, 30737, 30745, 30746, 30747, 30750, 30751, 30753, 30757, 30768, 30770, 30773, 30774, 30775, 30776, 30779, 30785, 30812, 30813, 30814, 30815, 30816, 30817, 30818, 30819, 30821, 31192, 31194, 31196, 31197, 31199, 31214, 31217, 31219, 31338, 31341, 31342, 31343, 31510, 31511, 31513, 31514, 31515, 31516, 31517, 31522, 31524, 31530, 31535, 31536, 31537, 31569, 31570, 31573, 31575, 31577, 31578, 31580, 31581, 31583, 31584, 31585, 31586, 31588, 31590, 31591, 31594, 31596, 31597, 31600, 31601, 31602, 31603, 31606, 31607, 31609, 31611, 31612, 31613, 31614, 31615, 31616, 31617, 31618, 31619, 31620, 31621, 31638, 31640, 31642, 31645, 31646, 31649, 31660, 31662, 31663, 31664, 31700, 31707, 31756, 31769, 31776, 31827, 31828, 31829, 31830, 31832, 31833, 31834, 31835, 31837, 31841, 31846, 31847, 31848, 31849, 31857, 31859, 31861, 31862, 31863, 31864, 31865, 31866, 31867, 31868, 31870, 31881, 31886, 31897, 31898, 31899, 31900, 31911, 31913, 31915, 31918, 31974, 32004, 32009, 32065, 32292, 32293, 32295, 32298, 32299, 32300, 32301, 32303, 32305, 32306, 32308, 32310, 32311, 32330, 32358, 32359, 32360, 32371, 32388, 32399, 32453, 32460, 32563, 32581, 32587, 32592, 32602, 32604, 32606, 32622, 32623, 32624, 32626, 32627, 32650, 32652, 32658, 32659, 32668, 32669, 32670, 32676, 32677, 32679, 32824, 32828, 32829, 32833, 32842, 32843, 32904, 32905, 32906, 32909, 32910, 32916, 32917, 33036, 33038, 33055, 33221, 33223, 33224, 33225, 33227, 33228, 33247, 33249, 33250, 33251, 33256, 33257, 33258, 33259, 33260, 33261, 33262, 33263, 33264, 33265, 33266, 33267, 33268, 33269, 33270, 33271, 33272, 33273, 33292, 33293, 33294, 33316, 33317, 33318, 33320, 33327, 33329, 33335, 33379, 33382, 33384, 33387, 33388, 33389, 33398, 33411, 33412, 33430, 33431, 33432, 33436, 33439, 33442, 33472, 33490, 33558, 33690, 33691, 33692, 33693, 33694, 33695, 33697, 33698, 33701, 33702, 33703, 33704, 33705, 33706, 33707, 33708, 33709, 33710, 33712, 33713, 33722, 33728, 33870, 33871, 33872, 33873, 33874, 33875, 33876, 33879, 33883, 33884, 33898, 33901, 33902, 33903, 33905, 33923, 33951, 33954, 34027, 34028, 34031, 34033, 34034, 34069, 34112, 34113, 34114, 34237, 34248, 34257, 34258, 34259, 34260, 34261, 34262, 34263, 34264, 34266, 34267, 34268, 34269, 34274, 34275, 34283, 34284, 34285, 34286, 34287, 34288, 34289, 34293, 34294, 34295, 34296, 34297, 34298, 34299, 34300, 34302, 34303, 34304, 34305, 34306, 34308, 34309, 34310, 34311, 34312, 34313, 34314, 34315, 34316, 34317, 34320, 34346, 34417, 34421, 34427, 34437, 34439, 34464, 34561, 34617, 34620, 34621, 34629, 34660, 34740, 34795, 34988, 34997, 34998, 35008, 35009, 35010, 35011, 35015, 35039, 35040, 35050, 35051, 35053, 35055, 35061, 35063, 35066, 35101, 35106, 35121, 35152, 35174, 35180, 35181, 35183, 35184, 35222, 35224, 35225, 35226, 35227, 35228, 35312, 35313, 35314, 35315, 35316, 35317, 35455, 35458, 35462, 35466, 35468, 35469, 35471, 35473, 35487, 35494, 35500, 35502, 35503, 35504, 35506, 35508, 35510, 35511, 35512, 35513, 35514, 35516, 35523, 35524, 35525, 35527, 35528, 35529, 35530, 35531, 35534, 35535, 35536, 35538, 35542, 35543, 35545, 35546, 35549, 35552, 35555, 35557, 35578, 35605, 35606, 35608, 35609, 35611, 35612, 35613, 35614, 35615, 35616, 35617, 35620, 35621, 35622, 35623, 35624, 35626, 35627, 35628, 35629, 35630, 35631, 35632, 35633, 35634, 35635, 35637, 35638, 35639, 35640, 35641, 35642, 35643, 35644, 35645, 35646, 35647, 35655, 35740, 35742, 35749, 35750, 35754, 35755, 35760, 35800, 35801, 35872, 35876, 35920, 35923, 35999, 36000, 36010, 36052, 36053, 36057, 36064, 36127, 36128, 36130, 36146, 36147, 36148, 36149, 36152, 36153, 36159, 36160, 36163, 36165, 36166, 36168, 36172, 36173, 36176, 36177, 36178, 36224, 36228, 36238, 36242, 36243, 36245, 36247, 36249, 36250, 36251, 36252, 36254, 36256, 36259, 36270, 36294, 36295, 36355, 36390, 36391, 36419, 36420, 36425, 36431, 36433, 36473, 36479, 36485, 36489, 36492, 36493, 36494, 36535, 36546, 36548, 36622, 36631, 36633, 36641, 36643, 36644, 36645, 36711, 36756, 36757, 36806, 36810, 36812, 36814, 36820, 36853, 36862, 36901, 36908, 36912, 36915, 36920, 36923, 36963, 36978, 37109, 37111, 37115, 37189, 37209, 37210, 37211, 37227, 37273, 37309, 37310, 37311, 37312, 37313, 37315, 37316, 37317, 37318, 37322, 37323, 37324, 37326, 37327, 37398, 37439, 37505, 37506, 37507, 37508, 37509, 37510, 37511, 37512, 37513, 37514, 37515, 37516, 37517, 37518, 37519, 37520, 37718, 37719, 37720, 37740, 37750, 37752, 37937, 37998, 37999, 38000, 38019, 38020, 38021, 38026, 38027, 38076, 38077, 38078, 38079, 38087, 38107, 38108, 38122, 38124, 38125, 38126, 38127, 38132, 38266, 38310, 38323, 38324, 38326, 38327, 38328, 38329, 38331, 38332, 38350, 38383, 38384, 38385, 38386, 38387, 38388, 38389, 38390, 38391, 38392, 38393, 38394, 38413, 38513, 38516, 38531, 38532, 38533, 38534, 38535, 38536, 38860, 38866, 38868, 38869, 38892, 38893, 38910, 38927, 38964, 38975, 39050, 39055, 39059, 39061, 39063, 39064, 39066, 39068, 39073, 39161, 39209, 39212, 39217, 39218, 39429, 39431, 39432, 39434, 39435, 39436, 39437, 39438, 39508, 39511, 39554, 39621, 39625, 39627, 39640, 39641, 39760, 39761, 39762, 39763, 39764, 39765, 39766, 39767, 39776, 39777, 39778, 39948, 39949, 39950, 39951, 39952, 39953, 39960, 39961, 39962, 39964, 39965, 39969, 39976, 40480, 40481, 40835, 40836, 40837, 40841, 40842, 40843, 40844, 40845, 40846, 40847, 40848, 40900, 41132, 41178, 41243, 41400, 41401, 41402, 41403, 41404, 41405, 41406, 41407, 41408, 41409, 41410, 41411, 41412, 41413, 41414, 41415, 41416, 41417, 41418, 41419, 41420, 41421, 41422, 41423, 41424, 41426, 41427, 41428, 41429, 41431, 41432, 41433, 41434, 41435, 41436, 41437, 41438, 41439, 41440, 41441, 41442, 41443, 41444, 41445, 41446, 41447, 41448, 41449, 41450, 41451, 41452, 41453, 41455, 41471, 41472, 41473, 41474, 41475, 41476, 41477, 41478, 41479, 41481, 41482, 41483, 41484, 41485, 41486, 41487, 41488, 41489, 41490, 41491, 41492, 41493, 41494, 41495, 41496, 41497, 41498, 41499, 41500, 41501, 41502, 41503, 41504, 41505, 41507, 41508, 41509, 41510, 41511, 41512, 41513, 41514, 41515, 41516, 41517, 41518, 41519, 41520, 41521, 41522, 41523, 41524, 41525, 41526, 41527, 41528, 41529, 41530, 41531, 41532, 41533, 41534, 41535, 41536, 41537, 41538, 41539, 41540, 41541, 41542, 41543, 41544, 41545, 41546, 41547, 41548, 41549, 41550, 41551, 41552, 41553, 41554, 41555, 41556, 41557, 41558, 41559, 41560, 41561, 41562, 41563, 41564, 41565, 41566, 41567, 41568, 41569, 41570, 41571, 41572, 41573, 41574, 41575, 41576, 41577, 41578, 41579, 41580, 41581, 41582, 41583, 41827, 41828, 41829, 41830, 41831, 41832, 41833, 41834, 41835) ORDER BY p0_.discount_percent DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 4.10 ms 
SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (950, 1000, 1027, 1060, 1594, 1598, 1901, 1963, 1964, 1965, 1968, 1969, 1970, 1974, 1975, 1977, 1978, 1979, 1980, 2600, 2605, 2850, 2851, 2855, 3221, 3235, 3474, 3475, 3476, 4525, 4662, 4663, 4675, 4693, 4698, 4709, 4726, 5349, 5355, 5386, 5408, 5672, 5673, 5704, 6162, 6166, 6169, 6193, 6195, 6229, 6237, 6310, 6342, 6384, 6388, 6393, 6408, 6410, 6422, 6424, 6471, 6488, 6497, 6512, 6521, 6525, 6526, 6527, 6533, 6618, 6620, 6633, 6635, 6640, 6642, 6654, 6666, 6669, 6678, 6683, 6684, 6709, 7206, 7218, 8369, 8372, 9026, 9143, 9152, 9353, 9459, 9594, 10487, 10699, 10781, 10794, 11340, 11529, 11530, 11531, 11549, 11550, 11552, 11690, 11972, 12678, 13194, 13205, 13211, 13214, 13215, 13222, 13234, 13238, 13256, 13259, 13263, 13281, 13282, 13294, 13299, 13302, 13303, 13322, 13348, 13355, 13360, 13378, 13389, 13445, 13449, 13450, 13463, 13480, 13482, 13483, 13484, 13491, 13497, 13512, 13608, 13615, 13667, 13668, 13670, 13672, 13900, 13901, 13902, 13967, 14117, 14118, 14227, 14228, 14231, 14346, 14803, 15206, 15483, 15486, 15487, 15488, 15489, 15496, 16068, 16069, 16741, 16811, 17461, 17462, 17463, 17464, 17465, 17467, 17468, 17469, 17470, 17471, 17472, 17473, 17729, 17794, 17796, 17797, 17800, 17801, 17803, 17804, 17805, 17834, 17835, 18094, 18101, 18196, 18197, 18206, 18209, 18218, 18231, 18233, 18237, 18239, 18241, 18246, 18251, 18259, 18292, 18294, 18304, 18332, 18386, 18496, 18550, 18553, 18566, 18567, 18568, 18569, 18572, 18574, 18578, 18579, 18586, 18587, 18588, 18589, 18590, 18591, 18592, 18593, 18594, 18595, 18596, 18597, 18598, 18599, 18600, 18601, 18603, 18604, 18605, 18609, 18610, 18611, 18613, 18614, 18616, 18617, 18618, 18620, 18621, 18623, 18624, 18626, 18627, 18630, 18631, 18633, 18634, 18635, 18638, 18640, 18642, 18643, 19047, 19181, 19233, 19273, 19274, 19278, 19280, 19282, 19342, 19343, 19399, 19425, 19489, 19808, 19847, 19848, 19852, 19853, 19854, 19856, 19857, 19858, 19860, 19864, 19867, 19868, 19869, 20000, 20161, 20254, 20257, 20310, 20398, 20415, 20474, 20570, 20776, 20778, 20780, 20781, 20787, 20788, 20789, 20790, 20954, 21337, 21353, 21358, 21362, 21367, 21368, 21369, 21532, 21698, 21701, 21702, 21703, 21714, 21719, 21720, 21721, 21722, 21723, 21725, 21727, 21728, 21729, 21731, 21732, 21733, 21734, 21736, 21737, 21740, 21741, 21742, 21747, 21761, 21765, 21767, 21768, 21769, 21770, 21771, 21772, 21773, 21774, 21775, 21776, 21778, 21779, 21781, 21784, 21839, 21960, 21964, 21973, 21974, 21975, 21976, 21979, 21980, 22074, 22138, 22141, 22150, 22151, 22253, 22256, 22525, 22542, 22545, 22594, 22596, 22599, 22600, 22601, 22602, 22603, 22605, 22606, 22607, 22608, 22614, 22615, 22616, 22617, 22618, 22628, 22639, 22681, 22682, 22685, 22687, 22688, 22689, 22690, 22693, 22795, 22798, 22800, 22802, 22811, 22813, 22816, 22819, 22877, 22925, 22932, 23186, 23187, 23190, 23191, 23192, 23193, 23312, 23348, 23351, 23353, 23354, 23355, 23357, 23359, 23361, 23363, 23374, 23380, 23385, 23386, 23393, 23441, 23468, 23480, 23482, 23503, 23535, 23536, 23586, 23587, 23594, 23876, 23893, 23932, 23933, 24265, 24314, 24357, 24358, 24359, 24360, 24361, 24364, 24367, 24368, 24370, 24374, 24382, 24392, 24396, 24447, 24448, 24450, 24452, 24453, 24682, 24694, 24878, 24909, 24935, 24971, 24980, 24981, 24982, 24983, 24985, 25018, 25023, 25125, 25130, 25157, 25159, 25161, 25242, 25291, 25307, 25319, 25331, 25336, 25343, 25344, 25404, 25501, 25592, 25683, 25688, 25693, 25773, 25774, 25775, 25777, 25784, 25786, 25790, 25791, 25792, 25932, 25940, 25941, 25950, 25951, 26097, 26109, 26119, 26124, 26126, 26164, 26173, 26174, 26175, 26176, 26177, 26178, 26179, 26180, 26183, 26190, 26191, 26192, 26194, 26195, 26196, 26285, 26310, 26642, 26647, 26740, 26797, 26801, 26804, 26808, 26810, 26828, 26900, 26903, 26904, 26906, 26954, 26956, 27027, 27075, 27098, 27202, 27204, 27205, 27206, 27207, 27209, 27210, 27215, 27216, 27218, 27235, 27245, 27250, 27253, 27254, 27255, 27256, 27257, 27299, 27302, 27311, 27373, 27375, 27376, 27472, 27548, 27551, 27564, 27569, 27570, 27571, 27598, 27600, 27682, 27834, 27835, 27837, 27839, 27840, 27842, 28217, 28222, 28965, 28968, 28970, 28971, 28972, 28973, 28974, 28996, 29048, 29063, 29064, 29077, 29079, 29105, 29107, 29110, 29113, 29114, 29115, 29137, 29152, 29153, 29174, 29176, 29178, 29181, 29188, 29189, 29191, 29210, 29211, 29212, 29213, 29214, 29387, 29389, 29399, 29404, 29405, 29407, 30079, 30086, 30087, 30088, 30165, 30169, 30170, 30234, 30235, 30236, 30237, 30238, 30252, 30253, 30254, 30255, 30256, 30269, 30270, 30271, 30272, 30273, 30274, 30503, 30516, 30518, 30553, 30554, 30555, 30556, 30557, 30559, 30561, 30564, 30565, 30566, 30569, 30573, 30582, 30583, 30584, 30587, 30589, 30592, 30594, 30596, 30600, 30666, 30673, 30674, 30675, 30678, 30680, 30735, 30737, 30745, 30746, 30747, 30750, 30751, 30753, 30757, 30768, 30770, 30773, 30774, 30775, 30776, 30779, 30785, 30812, 30813, 30814, 30815, 30816, 30817, 30818, 30819, 30821, 31192, 31194, 31196, 31197, 31199, 31214, 31217, 31219, 31338, 31341, 31342, 31343, 31510, 31511, 31513, 31514, 31515, 31516, 31517, 31522, 31524, 31530, 31535, 31536, 31537, 31569, 31570, 31573, 31575, 31577, 31578, 31580, 31581, 31583, 31584, 31585, 31586, 31588, 31590, 31591, 31594, 31596, 31597, 31600, 31601, 31602, 31603, 31606, 31607, 31609, 31611, 31612, 31613, 31614, 31615, 31616, 31617, 31618, 31619, 31620, 31621, 31638, 31640, 31642, 31645, 31646, 31649, 31660, 31662, 31663, 31664, 31700, 31707, 31756, 31769, 31776, 31827, 31828, 31829, 31830, 31832, 31833, 31834, 31835, 31837, 31841, 31846, 31847, 31848, 31849, 31857, 31859, 31861, 31862, 31863, 31864, 31865, 31866, 31867, 31868, 31870, 31881, 31886, 31897, 31898, 31899, 31900, 31911, 31913, 31915, 31918, 31974, 32004, 32009, 32065, 32292, 32293, 32295, 32298, 32299, 32300, 32301, 32303, 32305, 32306, 32308, 32310, 32311, 32330, 32358, 32359, 32360, 32371, 32388, 32399, 32453, 32460, 32563, 32581, 32587, 32592, 32602, 32604, 32606, 32622, 32623, 32624, 32626, 32627, 32650, 32652, 32658, 32659, 32668, 32669, 32670, 32676, 32677, 32679, 32824, 32828, 32829, 32833, 32842, 32843, 32904, 32905, 32906, 32909, 32910, 32916, 32917, 33036, 33038, 33055, 33221, 33223, 33224, 33225, 33227, 33228, 33247, 33249, 33250, 33251, 33256, 33257, 33258, 33259, 33260, 33261, 33262, 33263, 33264, 33265, 33266, 33267, 33268, 33269, 33270, 33271, 33272, 33273, 33292, 33293, 33294, 33316, 33317, 33318, 33320, 33327, 33329, 33335, 33379, 33382, 33384, 33387, 33388, 33389, 33398, 33411, 33412, 33430, 33431, 33432, 33436, 33439, 33442, 33472, 33490, 33558, 33690, 33691, 33692, 33693, 33694, 33695, 33697, 33698, 33701, 33702, 33703, 33704, 33705, 33706, 33707, 33708, 33709, 33710, 33712, 33713, 33722, 33728, 33870, 33871, 33872, 33873, 33874, 33875, 33876, 33879, 33883, 33884, 33898, 33901, 33902, 33903, 33905, 33923, 33951, 33954, 34027, 34028, 34031, 34033, 34034, 34069, 34112, 34113, 34114, 34237, 34248, 34257, 34258, 34259, 34260, 34261, 34262, 34263, 34264, 34266, 34267, 34268, 34269, 34274, 34275, 34283, 34284, 34285, 34286, 34287, 34288, 34289, 34293, 34294, 34295, 34296, 34297, 34298, 34299, 34300, 34302, 34303, 34304, 34305, 34306, 34308, 34309, 34310, 34311, 34312, 34313, 34314, 34315, 34316, 34317, 34320, 34346, 34417, 34421, 34427, 34437, 34439, 34464, 34561, 34617, 34620, 34621, 34629, 34660, 34740, 34795, 34988, 34997, 34998, 35008, 35009, 35010, 35011, 35015, 35039, 35040, 35050, 35051, 35053, 35055, 35061, 35063, 35066, 35101, 35106, 35121, 35152, 35174, 35180, 35181, 35183, 35184, 35222, 35224, 35225, 35226, 35227, 35228, 35312, 35313, 35314, 35315, 35316, 35317, 35455, 35458, 35462, 35466, 35468, 35469, 35471, 35473, 35487, 35494, 35500, 35502, 35503, 35504, 35506, 35508, 35510, 35511, 35512, 35513, 35514, 35516, 35523, 35524, 35525, 35527, 35528, 35529, 35530, 35531, 35534, 35535, 35536, 35538, 35542, 35543, 35545, 35546, 35549, 35552, 35555, 35557, 35578, 35605, 35606, 35608, 35609, 35611, 35612, 35613, 35614, 35615, 35616, 35617, 35620, 35621, 35622, 35623, 35624, 35626, 35627, 35628, 35629, 35630, 35631, 35632, 35633, 35634, 35635, 35637, 35638, 35639, 35640, 35641, 35642, 35643, 35644, 35645, 35646, 35647, 35655, 35740, 35742, 35749, 35750, 35754, 35755, 35760, 35800, 35801, 35872, 35876, 35920, 35923, 35999, 36000, 36010, 36052, 36053, 36057, 36064, 36127, 36128, 36130, 36146, 36147, 36148, 36149, 36152, 36153, 36159, 36160, 36163, 36165, 36166, 36168, 36172, 36173, 36176, 36177, 36178, 36224, 36228, 36238, 36242, 36243, 36245, 36247, 36249, 36250, 36251, 36252, 36254, 36256, 36259, 36270, 36294, 36295, 36355, 36390, 36391, 36419, 36420, 36425, 36431, 36433, 36473, 36479, 36485, 36489, 36492, 36493, 36494, 36535, 36546, 36548, 36622, 36631, 36633, 36641, 36643, 36644, 36645, 36711, 36756, 36757, 36806, 36810, 36812, 36814, 36820, 36853, 36862, 36901, 36908, 36912, 36915, 36920, 36923, 36963, 36978, 37109, 37111, 37115, 37189, 37209, 37210, 37211, 37227, 37273, 37309, 37310, 37311, 37312, 37313, 37315, 37316, 37317, 37318, 37322, 37323, 37324, 37326, 37327, 37398, 37439, 37505, 37506, 37507, 37508, 37509, 37510, 37511, 37512, 37513, 37514, 37515, 37516, 37517, 37518, 37519, 37520, 37718, 37719, 37720, 37740, 37750, 37752, 37937, 37998, 37999, 38000, 38019, 38020, 38021, 38026, 38027, 38076, 38077, 38078, 38079, 38087, 38107, 38108, 38122, 38124, 38125, 38126, 38127, 38132, 38266, 38310, 38323, 38324, 38326, 38327, 38328, 38329, 38331, 38332, 38350, 38383, 38384, 38385, 38386, 38387, 38388, 38389, 38390, 38391, 38392, 38393, 38394, 38413, 38513, 38516, 38531, 38532, 38533, 38534, 38535, 38536, 38860, 38866, 38868, 38869, 38892, 38893, 38910, 38927, 38964, 38975, 39050, 39055, 39059, 39061, 39063, 39064, 39066, 39068, 39073, 39161, 39209, 39212, 39217, 39218, 39429, 39431, 39432, 39434, 39435, 39436, 39437, 39438, 39508, 39511, 39554, 39621, 39625, 39627, 39640, 39641, 39760, 39761, 39762, 39763, 39764, 39765, 39766, 39767, 39776, 39777, 39778, 39948, 39949, 39950, 39951, 39952, 39953, 39960, 39961, 39962, 39964, 39965, 39969, 39976, 40480, 40481, 40835, 40836, 40837, 40841, 40842, 40843, 40844, 40845, 40846, 40847, 40848, 40900, 41132, 41178, 41243, 41400, 41401, 41402, 41403, 41404, 41405, 41406, 41407, 41408, 41409, 41410, 41411, 41412, 41413, 41414, 41415, 41416, 41417, 41418, 41419, 41420, 41421, 41422, 41423, 41424, 41426, 41427, 41428, 41429, 41431, 41432, 41433, 41434, 41435, 41436, 41437, 41438, 41439, 41440, 41441, 41442, 41443, 41444, 41445, 41446, 41447, 41448, 41449, 41450, 41451, 41452, 41453, 41455, 41471, 41472, 41473, 41474, 41475, 41476, 41477, 41478, 41479, 41481, 41482, 41483, 41484, 41485, 41486, 41487, 41488, 41489, 41490, 41491, 41492, 41493, 41494, 41495, 41496, 41497, 41498, 41499, 41500, 41501, 41502, 41503, 41504, 41505, 41507, 41508, 41509, 41510, 41511, 41512, 41513, 41514, 41515, 41516, 41517, 41518, 41519, 41520, 41521, 41522, 41523, 41524, 41525, 41526, 41527, 41528, 41529, 41530, 41531, 41532, 41533, 41534, 41535, 41536, 41537, 41538, 41539, 41540, 41541, 41542, 41543, 41544, 41545, 41546, 41547, 41548, 41549, 41550, 41551, 41552, 41553, 41554, 41555, 41556, 41557, 41558, 41559, 41560, 41561, 41562, 41563, 41564, 41565, 41566, 41567, 41568, 41569, 41570, 41571, 41572, 41573, 41574, 41575, 41576, 41577, 41578, 41579, 41580, 41581, 41582, 41583, 41827, 41828, 41829, 41830, 41831, 41832, 41833, 41834, 41835) ORDER BY p0_.discount_percent DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
8 173.75 ms 
SELECT p0_.property_id AS sclr_0, p0_.value_id AS sclr_1, p1_.id AS id_2 FROM product p1_ INNER JOIN product_property p0_ ON p1_.id = p0_.product_id WHERE p1_.id IN (0, 21767, 21768, 21769, 21770, 21771, 21772, 21761, 21765, 33954, 32388, 34417, 34421, 34427, 31214, 31217, 34237, 20790, 23359, 23361, 31830, 23363, 31832, 20787, 20788, 20789, 30737, 23351, 32563, 23353, 23354, 26164, 30553, 23355, 30554, 31827, 23357, 31828, 31829, 20776, 20778, 20780, 20781, 30735, 21736, 21737, 21740, 18635, 21742, 24358, 26192, 29107, 18638, 24359, 26194, 31848, 18640, 24360, 26195, 31849, 18566, 18642, 19847, 24361, 26196, 18567, 18643, 19848, 18568, 18569, 22819, 30753, 18572, 30757, 18574, 26176, 30768, 34617, 24382, 26177, 26797, 30770, 18626, 21698, 21773, 26178, 29178, 30561, 18627, 21701, 21774, 26179, 30564, 30774, 18630, 19864, 21702, 21775, 23385, 26180, 30565, 30775, 18631, 19867, 21703, 21776, 23386, 26810, 30566, 30776, 18633, 19868, 21778, 23393, 26190, 30569, 31841, 18634, 19869, 21741, 24357, 26191, 29105, 18591, 21720, 21781, 22798, 31847, 18592, 21721, 21747, 21784, 22800, 30745, 38323, 18593, 21722, 21839, 22802, 29113, 30746, 38324, 39621, 18594, 18616, 21723, 22811, 29114, 39625, 18595, 18617, 21725, 22813, 24364, 26956, 29115, 30750, 39627, 41827, 18596, 18618, 19852, 21727, 22628, 22816, 24367, 26173, 30751, 41828, 18597, 18620, 19853, 21728, 24368, 26174, 30555, 41829, 18598, 18621, 19854, 21729, 24370, 24980, 26175, 30556, 33430, 41830, 18599, 18623, 19856, 21731, 24981, 33431, 41831, 18578, 18600, 18624, 19857, 21732, 24982, 30559, 33432, 41832, 18579, 18601, 21733, 23374, 24983, 26801, 30773, 31833, 31866, 41833, 18586, 18603, 21734, 23380, 26804, 31834, 31867, 41834, 18587, 18604, 26808, 31835, 31868, 41835, 18588, 18605, 26183, 31837, 18589, 21714, 34795, 18590, 21719, 21779, 22795, 30785, 31846, 18550, 29110, 18553, 30779, 18611, 18613, 18614, 30747, 24374, 30557, 19858, 19860, 18609, 18610, 26954, 31857, 31859, 31861, 31862, 31863, 31864, 29176, 31865, 29181, 25125, 25130, 30573, 22614, 27472, 22615, 35106, 22616, 22617, 22618, 36489, 11531, 11972, 24985, 31870, 11529, 11530, 25157, 25159, 25161, 31192, 31194, 31196, 31197, 31199, 34305, 35009, 34311, 40846, 34315, 19425, 34302, 39068, 18209, 34303, 39073, 18218, 34284, 34285, 35011, 34260, 39429, 34293, 39431, 28996, 34312, 34264, 34314, 34298, 34269, 34299, 39064, 34274, 34300, 22594, 22596, 13259, 13263, 34437, 34439, 14346, 13450, 18206, 13463, 22256, 13480, 31645, 11340, 18196, 13449, 18197, 20415, 36923, 39050, 39055, 39059, 39061, 39063, 39066, 13482, 13483, 13484, 13491, 35015, 13497, 13512, 31646, 35101, 36242, 5349, 36243, 5355, 38326, 38327, 38328, 20474, 22681, 22682, 29174, 22685, 22687, 15483, 22688, 15486, 22689, 24447, 36270, 15487, 22690, 24448, 6229, 15488, 22693, 6237, 15489, 30518, 39432, 39964, 33227, 39965, 35061, 35063, 35066, 23480, 27564, 36249, 38087, 19273, 19274, 27299, 33224, 39434, 24396, 27302, 39435, 27311, 39436, 13389, 32843, 39437, 13445, 39438, 18386, 18496, 20954, 19808, 21337, 24878, 1963, 26285, 1964, 27253, 1965, 27075, 35740, 19233, 35742, 33221, 39960, 14803, 33223, 39961, 1974, 24392, 39962, 1975, 10781, 33225, 10794, 34660, 36177, 37115, 24265, 34740, 32905, 38266, 30813, 36862, 13281, 36901, 13282, 13294, 22545, 22639, 27600, 34262, 33472, 32906, 31338, 31617, 31341, 31618, 35121, 31342, 31619, 39209, 31343, 31620, 31621, 22599, 26647, 22600, 36057, 22601, 35050, 22602, 34031, 35051, 22074, 22603, 35053, 25501, 35055, 22141, 34268, 33490, 7206, 25688, 4709, 6527, 31219, 4726, 6533, 26904, 2850, 6618, 20254, 26906, 32668, 37273, 2851, 6620, 20257, 22542, 32669, 36908, 38892, 2855, 6633, 32670, 38893, 3221, 6635, 19047, 25784, 30817, 33728, 3235, 5672, 6640, 9353, 23586, 25786, 26642, 5673, 6642, 23587, 25790, 33055, 5704, 6654, 23594, 25791, 34027, 6162, 6471, 6666, 10487, 21532, 25792, 32622, 34028, 6166, 6488, 6669, 32623, 4662, 6169, 6497, 6678, 23932, 30086, 32624, 4663, 6193, 6512, 6683, 23933, 30087, 32626, 34267, 4675, 6195, 6521, 6684, 32627, 33228, 35800, 4693, 6525, 6709, 4698, 6526, 34283, 37398, 33388, 34304, 38076, 14117, 30587, 33389, 38077, 14118, 30589, 31600, 34286, 34306, 36247, 38078, 31601, 34308, 38079, 38910, 30818, 31602, 36250, 1968, 22877, 27598, 31603, 34261, 1969, 31606, 1970, 31607, 31609, 36256, 31611, 31612, 34988, 6310, 20000, 23312, 23468, 24453, 25693, 26903, 30170, 30274, 30582, 31536, 31591, 32658, 33690, 33709, 34275, 36238, 39777, 6342, 16068, 23348, 24682, 25773, 26119, 30583, 31537, 31594, 32659, 32909, 33691, 33710, 37227, 39778, 6384, 16069, 25774, 28965, 30516, 30584, 31596, 32910, 33692, 33712, 34248, 35008, 37439, 6388, 21960, 25775, 28968, 30815, 31597, 32916, 33693, 33713, 34257, 36245, 5386, 6393, 9143, 21964, 25777, 28970, 30816, 31573, 31911, 32917, 33694, 34258, 35010, 5408, 6408, 9152, 14227, 21973, 24935, 25307, 26310, 27027, 28971, 30592, 31575, 31913, 32676, 33036, 33411, 33695, 33923, 34259, 34287, 39640, 6410, 14228, 21974, 25319, 28972, 29152, 30594, 31577, 31638, 31915, 32677, 33038, 33412, 33697, 33951, 34288, 34309, 36052, 38329, 39641, 6422, 9459, 13194, 14231, 21975, 25331, 28973, 29153, 30596, 30819, 31578, 31918, 32679, 33698, 34289, 34310, 36053, 36251, 37750, 38331, 40844, 6424, 13205, 21976, 25336, 28974, 30821, 31580, 33701, 36252, 36711, 37510, 37752, 38332, 40845, 13211, 13608, 21979, 25343, 27682, 31581, 33702, 34263, 34294, 35222, 37511, 37937, 38350, 38531, 13214, 13615, 15206, 21980, 25344, 25932, 31583, 33703, 34295, 34313, 35224, 37109, 37512, 38532, 40847, 13215, 25940, 30269, 31584, 32833, 33704, 34266, 34296, 35225, 36492, 37111, 38533, 40848, 13222, 22138, 25941, 30270, 31585, 33705, 34297, 35226, 36493, 37322, 38126, 38534, 40900, 13234, 19342, 25950, 30271, 31586, 33706, 34069, 34316, 35227, 36146, 36494, 37323, 38019, 38127, 38535, 39969, 13238, 19343, 22150, 24450, 25683, 30272, 31588, 31881, 33707, 34317, 35228, 35801, 36147, 37324, 38020, 38132, 38536, 41178, 13256, 22151, 24452, 26900, 30169, 30273, 31535, 31590, 31886, 33558, 33708, 38021, 39776, 2600, 2605, 22525, 23482, 33902, 39950, 17461, 21362, 39951, 17462, 24971, 17463, 38964, 17464, 17465, 32828, 36254, 17467, 32829, 17468, 36259, 1000, 32650, 32652, 31756, 20570, 19278, 19280, 36806, 18094, 19282, 31660, 18101, 31662, 31663, 31664, 13901, 35313, 13902, 17729, 35314, 35315, 35316, 37505, 27569, 35317, 37506, 27570, 37507, 27571, 37508, 37509, 32824, 36756, 36757, 29188, 29189, 41132, 29191, 1027, 13900, 35312, 15496, 22253, 28217, 29211, 34114, 35876, 36548, 37211, 38026, 40481, 8369, 29212, 30503, 35920, 36622, 38027, 8372, 24694, 29213, 35923, 36631, 29214, 35152, 36633, 23535, 30237, 33292, 33398, 33722, 20398, 23536, 31510, 32592, 33293, 35655, 40842, 12678, 13302, 31511, 32602, 33870, 37740, 38413, 3474, 13303, 27098, 32604, 33871, 34561, 3475, 13322, 29405, 30600, 31642, 32606, 33872, 35040, 36963, 3476, 13348, 23876, 29407, 33873, 13355, 23186, 33874, 37998, 13360, 13667, 23187, 25404, 29063, 32065, 33875, 34629, 37999, 13378, 13668, 22605, 33876, 38000, 13670, 22606, 30088, 33879, 36178, 37189, 13672, 22607, 30165, 33883, 34112, 36535, 36814, 37209, 22608, 29210, 33884, 34113, 35872, 36228, 36355, 36546, 37210, 40480, 1060, 7218, 17473, 26109, 27216, 30812, 31616, 31700, 31897, 32299, 32453, 33250, 33384, 33898, 34997, 35502, 35529, 35605, 35626, 35643, 36149, 36853, 37327, 37518, 38310, 38389, 38866, 39511, 41400, 41416, 41434, 41450, 41483, 41499, 41516, 41532, 41548, 41564, 41580, 19489, 20161, 27218, 27548, 28222, 30234, 31707, 31898, 32300, 32460, 33251, 33901, 34998, 35503, 35530, 35606, 35627, 35644, 36152, 37519, 38390, 38868, 39554, 40835, 41401, 41417, 41435, 41451, 41484, 41500, 41517, 41533, 41549, 41565, 41581, 17794, 26124, 27235, 27551, 30235, 30814, 31569, 31899, 32301, 35504, 35531, 35608, 35628, 35645, 36153, 36419, 37520, 38391, 38869, 39161, 39948, 40836, 41402, 41418, 41436, 41452, 41485, 41501, 41518, 41534, 41550, 41566, 41582, 1901, 9026, 16741, 17796, 18231, 21353, 23503, 25242, 26126, 27245, 30236, 31570, 31769, 31900, 32303, 32581, 33903, 35506, 35534, 35609, 35629, 35646, 35999, 36159, 36420, 37309, 37718, 38392, 39949, 40837, 41403, 41419, 41437, 41453, 41486, 41502, 41519, 41535, 41551, 41567, 41583, 11690, 16811, 17797, 18233, 20310, 21358, 24909, 25291, 27250, 29387, 31776, 32305, 32587, 33905, 35174, 35508, 35535, 35611, 35630, 35647, 36000, 36160, 36425, 36641, 36912, 37310, 37719, 38393, 39212, 40841, 41404, 41420, 41438, 41455, 41487, 41503, 41520, 41536, 41552, 41568, 17800, 18237, 29137, 29389, 30238, 32306, 35180, 35455, 35510, 35536, 35612, 35631, 36010, 36163, 36431, 36643, 36915, 37311, 37720, 38394, 39217, 41405, 41421, 41439, 41471, 41488, 41504, 41521, 41537, 41553, 41569, 17801, 18239, 19181, 21367, 27254, 29399, 30252, 32308, 33294, 35181, 35458, 35511, 35538, 35613, 35632, 36165, 36433, 36644, 36920, 37312, 38927, 39218, 39952, 40843, 41406, 41422, 41440, 41472, 41489, 41505, 41522, 41538, 41554, 41570, 17803, 18241, 21368, 27255, 29404, 30253, 31513, 32310, 33316, 35039, 35183, 35462, 35512, 35542, 35614, 35633, 36166, 36473, 36645, 37313, 38107, 38513, 39760, 39953, 41407, 41423, 41441, 41473, 41490, 41507, 41523, 41539, 41555, 41571, 9594, 17804, 18246, 21369, 22925, 26740, 27202, 27256, 30254, 31514, 31974, 32311, 33317, 35184, 35466, 35513, 35543, 35615, 35634, 35749, 36168, 36479, 37315, 38108, 38516, 39761, 41408, 41424, 41442, 41474, 41491, 41508, 41524, 41540, 41556, 41572, 17805, 18251, 22932, 27204, 27257, 30255, 30666, 31515, 32004, 32330, 33318, 34620, 35468, 35514, 35545, 35616, 35635, 35750, 36064, 36172, 36485, 36978, 37316, 38122, 39762, 41409, 41426, 41443, 41475, 41492, 41509, 41525, 41541, 41557, 41573, 10699, 17834, 18259, 23893, 27205, 27834, 29048, 30079, 30256, 30673, 31516, 32009, 32358, 33320, 33436, 34621, 35469, 35516, 35546, 35617, 35637, 35754, 36127, 36173, 37317, 38124, 38383, 39763, 41410, 41427, 41444, 41476, 41493, 41510, 41526, 41542, 41558, 41574, 17835, 18292, 27206, 27835, 30674, 31517, 31649, 32359, 33327, 33439, 34033, 35471, 35523, 35549, 35620, 35638, 35755, 36128, 36176, 37318, 37513, 38125, 38384, 39764, 41411, 41428, 41445, 41477, 41494, 41511, 41527, 41543, 41559, 41575, 1977, 17469, 18294, 23190, 25018, 27207, 27837, 29064, 30675, 31522, 32292, 32360, 32842, 33329, 33442, 34034, 35473, 35524, 35552, 35621, 35639, 35760, 36130, 36810, 37514, 38385, 39765, 41412, 41429, 41446, 41478, 41495, 41512, 41528, 41544, 41560, 41576, 950, 1978, 17470, 18304, 23191, 25023, 25592, 27209, 27373, 27839, 29077, 30678, 31524, 31613, 32293, 32371, 33335, 35487, 35525, 35555, 35622, 35640, 36294, 37515, 38386, 39766, 41413, 41431, 41447, 41479, 41496, 41513, 41529, 41545, 41561, 41577, 1979, 17471, 18332, 23192, 24314, 25951, 26828, 27210, 27375, 27840, 29079, 30680, 31530, 31614, 32295, 32904, 33247, 33379, 35494, 35527, 35557, 35623, 35641, 36224, 36295, 37516, 38387, 39767, 39976, 41414, 41432, 41448, 41481, 41497, 41514, 41530, 41546, 41562, 41578, 1980, 17472, 19399, 23193, 23441, 27215, 27376, 27842, 31615, 32298, 32399, 33249, 33382, 35500, 35528, 35578, 35624, 35642, 36148, 36820, 37326, 37517, 38388, 38860, 39508, 41243, 41415, 41433, 41449, 41482, 41498, 41515, 41531, 41547, 41563, 41579, 33387, 13967, 33270, 33271, 36391, 33272, 33273, 33265, 33266, 33267, 36812, 33268, 33269, 4525, 34464, 34346, 1594, 1598, 38975, 26097, 34320, 36390, 33256, 33257, 33258, 33259, 33260, 33261, 33262, 33263, 33264, 11549, 11550, 11552, 13299, 31640)
Parameters: 
[]
View formatted query    View runnable query    Explain query
9 29.77 ms 
SELECT p0_.id AS id_0, c1_.id AS id_1 FROM product p0_ INNER JOIN category_1c c2_ ON p0_.category1c_id = c2_.id INNER JOIN category_category1c c3_ ON c2_.id = c3_.category1c_id INNER JOIN category c1_ ON c1_.id = c3_.category_id WHERE p0_.id IN (0, 21767, 21768, 21769, 21770, 21771, 21772, 21761, 21765, 33954, 32388, 34417, 34421, 34427, 31214, 31217, 34237, 20790, 23359, 23361, 31830, 23363, 31832, 20787, 20788, 20789, 30737, 23351, 32563, 23353, 23354, 26164, 30553, 23355, 30554, 31827, 23357, 31828, 31829, 20776, 20778, 20780, 20781, 30735, 21736, 21737, 21740, 18635, 21742, 24358, 26192, 29107, 18638, 24359, 26194, 31848, 18640, 24360, 26195, 31849, 18566, 18642, 19847, 24361, 26196, 18567, 18643, 19848, 18568, 18569, 22819, 30753, 18572, 30757, 18574, 26176, 30768, 34617, 24382, 26177, 26797, 30770, 18626, 21698, 21773, 26178, 29178, 30561, 18627, 21701, 21774, 26179, 30564, 30774, 18630, 19864, 21702, 21775, 23385, 26180, 30565, 30775, 18631, 19867, 21703, 21776, 23386, 26810, 30566, 30776, 18633, 19868, 21778, 23393, 26190, 30569, 31841, 18634, 19869, 21741, 24357, 26191, 29105, 18591, 21720, 21781, 22798, 31847, 18592, 21721, 21747, 21784, 22800, 30745, 38323, 18593, 21722, 21839, 22802, 29113, 30746, 38324, 39621, 18594, 18616, 21723, 22811, 29114, 39625, 18595, 18617, 21725, 22813, 24364, 26956, 29115, 30750, 39627, 41827, 18596, 18618, 19852, 21727, 22628, 22816, 24367, 26173, 30751, 41828, 18597, 18620, 19853, 21728, 24368, 26174, 30555, 41829, 18598, 18621, 19854, 21729, 24370, 24980, 26175, 30556, 33430, 41830, 18599, 18623, 19856, 21731, 24981, 33431, 41831, 18578, 18600, 18624, 19857, 21732, 24982, 30559, 33432, 41832, 18579, 18601, 21733, 23374, 24983, 26801, 30773, 31833, 31866, 41833, 18586, 18603, 21734, 23380, 26804, 31834, 31867, 41834, 18587, 18604, 26808, 31835, 31868, 41835, 18588, 18605, 26183, 31837, 18589, 21714, 34795, 18590, 21719, 21779, 22795, 30785, 31846, 18550, 29110, 18553, 30779, 18611, 18613, 18614, 30747, 24374, 30557, 19858, 19860, 18609, 18610, 26954, 31857, 31859, 31861, 31862, 31863, 31864, 29176, 31865, 29181, 25125, 25130, 30573, 22614, 27472, 22615, 35106, 22616, 22617, 22618, 36489, 11531, 11972, 24985, 31870, 11529, 11530, 25157, 25159, 25161, 31192, 31194, 31196, 31197, 31199, 34305, 35009, 34311, 40846, 34315, 19425, 34302, 39068, 18209, 34303, 39073, 18218, 34284, 34285, 35011, 34260, 39429, 34293, 39431, 28996, 34312, 34264, 34314, 34298, 34269, 34299, 39064, 34274, 34300, 22594, 22596, 13259, 13263, 34437, 34439, 14346, 13450, 18206, 13463, 22256, 13480, 31645, 11340, 18196, 13449, 18197, 20415, 36923, 39050, 39055, 39059, 39061, 39063, 39066, 13482, 13483, 13484, 13491, 35015, 13497, 13512, 31646, 35101, 36242, 5349, 36243, 5355, 38326, 38327, 38328, 20474, 22681, 22682, 29174, 22685, 22687, 15483, 22688, 15486, 22689, 24447, 36270, 15487, 22690, 24448, 6229, 15488, 22693, 6237, 15489, 30518, 39432, 39964, 33227, 39965, 35061, 35063, 35066, 23480, 27564, 36249, 38087, 19273, 19274, 27299, 33224, 39434, 24396, 27302, 39435, 27311, 39436, 13389, 32843, 39437, 13445, 39438, 18386, 18496, 20954, 19808, 21337, 24878, 1963, 26285, 1964, 27253, 1965, 27075, 35740, 19233, 35742, 33221, 39960, 14803, 33223, 39961, 1974, 24392, 39962, 1975, 10781, 33225, 10794, 34660, 36177, 37115, 24265, 34740, 32905, 38266, 30813, 36862, 13281, 36901, 13282, 13294, 22545, 22639, 27600, 34262, 33472, 32906, 31338, 31617, 31341, 31618, 35121, 31342, 31619, 39209, 31343, 31620, 31621, 22599, 26647, 22600, 36057, 22601, 35050, 22602, 34031, 35051, 22074, 22603, 35053, 25501, 35055, 22141, 34268, 33490, 7206, 25688, 4709, 6527, 31219, 4726, 6533, 26904, 2850, 6618, 20254, 26906, 32668, 37273, 2851, 6620, 20257, 22542, 32669, 36908, 38892, 2855, 6633, 32670, 38893, 3221, 6635, 19047, 25784, 30817, 33728, 3235, 5672, 6640, 9353, 23586, 25786, 26642, 5673, 6642, 23587, 25790, 33055, 5704, 6654, 23594, 25791, 34027, 6162, 6471, 6666, 10487, 21532, 25792, 32622, 34028, 6166, 6488, 6669, 32623, 4662, 6169, 6497, 6678, 23932, 30086, 32624, 4663, 6193, 6512, 6683, 23933, 30087, 32626, 34267, 4675, 6195, 6521, 6684, 32627, 33228, 35800, 4693, 6525, 6709, 4698, 6526, 34283, 37398, 33388, 34304, 38076, 14117, 30587, 33389, 38077, 14118, 30589, 31600, 34286, 34306, 36247, 38078, 31601, 34308, 38079, 38910, 30818, 31602, 36250, 1968, 22877, 27598, 31603, 34261, 1969, 31606, 1970, 31607, 31609, 36256, 31611, 31612, 34988, 6310, 20000, 23312, 23468, 24453, 25693, 26903, 30170, 30274, 30582, 31536, 31591, 32658, 33690, 33709, 34275, 36238, 39777, 6342, 16068, 23348, 24682, 25773, 26119, 30583, 31537, 31594, 32659, 32909, 33691, 33710, 37227, 39778, 6384, 16069, 25774, 28965, 30516, 30584, 31596, 32910, 33692, 33712, 34248, 35008, 37439, 6388, 21960, 25775, 28968, 30815, 31597, 32916, 33693, 33713, 34257, 36245, 5386, 6393, 9143, 21964, 25777, 28970, 30816, 31573, 31911, 32917, 33694, 34258, 35010, 5408, 6408, 9152, 14227, 21973, 24935, 25307, 26310, 27027, 28971, 30592, 31575, 31913, 32676, 33036, 33411, 33695, 33923, 34259, 34287, 39640, 6410, 14228, 21974, 25319, 28972, 29152, 30594, 31577, 31638, 31915, 32677, 33038, 33412, 33697, 33951, 34288, 34309, 36052, 38329, 39641, 6422, 9459, 13194, 14231, 21975, 25331, 28973, 29153, 30596, 30819, 31578, 31918, 32679, 33698, 34289, 34310, 36053, 36251, 37750, 38331, 40844, 6424, 13205, 21976, 25336, 28974, 30821, 31580, 33701, 36252, 36711, 37510, 37752, 38332, 40845, 13211, 13608, 21979, 25343, 27682, 31581, 33702, 34263, 34294, 35222, 37511, 37937, 38350, 38531, 13214, 13615, 15206, 21980, 25344, 25932, 31583, 33703, 34295, 34313, 35224, 37109, 37512, 38532, 40847, 13215, 25940, 30269, 31584, 32833, 33704, 34266, 34296, 35225, 36492, 37111, 38533, 40848, 13222, 22138, 25941, 30270, 31585, 33705, 34297, 35226, 36493, 37322, 38126, 38534, 40900, 13234, 19342, 25950, 30271, 31586, 33706, 34069, 34316, 35227, 36146, 36494, 37323, 38019, 38127, 38535, 39969, 13238, 19343, 22150, 24450, 25683, 30272, 31588, 31881, 33707, 34317, 35228, 35801, 36147, 37324, 38020, 38132, 38536, 41178, 13256, 22151, 24452, 26900, 30169, 30273, 31535, 31590, 31886, 33558, 33708, 38021, 39776, 2600, 2605, 22525, 23482, 33902, 39950, 17461, 21362, 39951, 17462, 24971, 17463, 38964, 17464, 17465, 32828, 36254, 17467, 32829, 17468, 36259, 1000, 32650, 32652, 31756, 20570, 19278, 19280, 36806, 18094, 19282, 31660, 18101, 31662, 31663, 31664, 13901, 35313, 13902, 17729, 35314, 35315, 35316, 37505, 27569, 35317, 37506, 27570, 37507, 27571, 37508, 37509, 32824, 36756, 36757, 29188, 29189, 41132, 29191, 1027, 13900, 35312, 15496, 22253, 28217, 29211, 34114, 35876, 36548, 37211, 38026, 40481, 8369, 29212, 30503, 35920, 36622, 38027, 8372, 24694, 29213, 35923, 36631, 29214, 35152, 36633, 23535, 30237, 33292, 33398, 33722, 20398, 23536, 31510, 32592, 33293, 35655, 40842, 12678, 13302, 31511, 32602, 33870, 37740, 38413, 3474, 13303, 27098, 32604, 33871, 34561, 3475, 13322, 29405, 30600, 31642, 32606, 33872, 35040, 36963, 3476, 13348, 23876, 29407, 33873, 13355, 23186, 33874, 37998, 13360, 13667, 23187, 25404, 29063, 32065, 33875, 34629, 37999, 13378, 13668, 22605, 33876, 38000, 13670, 22606, 30088, 33879, 36178, 37189, 13672, 22607, 30165, 33883, 34112, 36535, 36814, 37209, 22608, 29210, 33884, 34113, 35872, 36228, 36355, 36546, 37210, 40480, 1060, 7218, 17473, 26109, 27216, 30812, 31616, 31700, 31897, 32299, 32453, 33250, 33384, 33898, 34997, 35502, 35529, 35605, 35626, 35643, 36149, 36853, 37327, 37518, 38310, 38389, 38866, 39511, 41400, 41416, 41434, 41450, 41483, 41499, 41516, 41532, 41548, 41564, 41580, 19489, 20161, 27218, 27548, 28222, 30234, 31707, 31898, 32300, 32460, 33251, 33901, 34998, 35503, 35530, 35606, 35627, 35644, 36152, 37519, 38390, 38868, 39554, 40835, 41401, 41417, 41435, 41451, 41484, 41500, 41517, 41533, 41549, 41565, 41581, 17794, 26124, 27235, 27551, 30235, 30814, 31569, 31899, 32301, 35504, 35531, 35608, 35628, 35645, 36153, 36419, 37520, 38391, 38869, 39161, 39948, 40836, 41402, 41418, 41436, 41452, 41485, 41501, 41518, 41534, 41550, 41566, 41582, 1901, 9026, 16741, 17796, 18231, 21353, 23503, 25242, 26126, 27245, 30236, 31570, 31769, 31900, 32303, 32581, 33903, 35506, 35534, 35609, 35629, 35646, 35999, 36159, 36420, 37309, 37718, 38392, 39949, 40837, 41403, 41419, 41437, 41453, 41486, 41502, 41519, 41535, 41551, 41567, 41583, 11690, 16811, 17797, 18233, 20310, 21358, 24909, 25291, 27250, 29387, 31776, 32305, 32587, 33905, 35174, 35508, 35535, 35611, 35630, 35647, 36000, 36160, 36425, 36641, 36912, 37310, 37719, 38393, 39212, 40841, 41404, 41420, 41438, 41455, 41487, 41503, 41520, 41536, 41552, 41568, 17800, 18237, 29137, 29389, 30238, 32306, 35180, 35455, 35510, 35536, 35612, 35631, 36010, 36163, 36431, 36643, 36915, 37311, 37720, 38394, 39217, 41405, 41421, 41439, 41471, 41488, 41504, 41521, 41537, 41553, 41569, 17801, 18239, 19181, 21367, 27254, 29399, 30252, 32308, 33294, 35181, 35458, 35511, 35538, 35613, 35632, 36165, 36433, 36644, 36920, 37312, 38927, 39218, 39952, 40843, 41406, 41422, 41440, 41472, 41489, 41505, 41522, 41538, 41554, 41570, 17803, 18241, 21368, 27255, 29404, 30253, 31513, 32310, 33316, 35039, 35183, 35462, 35512, 35542, 35614, 35633, 36166, 36473, 36645, 37313, 38107, 38513, 39760, 39953, 41407, 41423, 41441, 41473, 41490, 41507, 41523, 41539, 41555, 41571, 9594, 17804, 18246, 21369, 22925, 26740, 27202, 27256, 30254, 31514, 31974, 32311, 33317, 35184, 35466, 35513, 35543, 35615, 35634, 35749, 36168, 36479, 37315, 38108, 38516, 39761, 41408, 41424, 41442, 41474, 41491, 41508, 41524, 41540, 41556, 41572, 17805, 18251, 22932, 27204, 27257, 30255, 30666, 31515, 32004, 32330, 33318, 34620, 35468, 35514, 35545, 35616, 35635, 35750, 36064, 36172, 36485, 36978, 37316, 38122, 39762, 41409, 41426, 41443, 41475, 41492, 41509, 41525, 41541, 41557, 41573, 10699, 17834, 18259, 23893, 27205, 27834, 29048, 30079, 30256, 30673, 31516, 32009, 32358, 33320, 33436, 34621, 35469, 35516, 35546, 35617, 35637, 35754, 36127, 36173, 37317, 38124, 38383, 39763, 41410, 41427, 41444, 41476, 41493, 41510, 41526, 41542, 41558, 41574, 17835, 18292, 27206, 27835, 30674, 31517, 31649, 32359, 33327, 33439, 34033, 35471, 35523, 35549, 35620, 35638, 35755, 36128, 36176, 37318, 37513, 38125, 38384, 39764, 41411, 41428, 41445, 41477, 41494, 41511, 41527, 41543, 41559, 41575, 1977, 17469, 18294, 23190, 25018, 27207, 27837, 29064, 30675, 31522, 32292, 32360, 32842, 33329, 33442, 34034, 35473, 35524, 35552, 35621, 35639, 35760, 36130, 36810, 37514, 38385, 39765, 41412, 41429, 41446, 41478, 41495, 41512, 41528, 41544, 41560, 41576, 950, 1978, 17470, 18304, 23191, 25023, 25592, 27209, 27373, 27839, 29077, 30678, 31524, 31613, 32293, 32371, 33335, 35487, 35525, 35555, 35622, 35640, 36294, 37515, 38386, 39766, 41413, 41431, 41447, 41479, 41496, 41513, 41529, 41545, 41561, 41577, 1979, 17471, 18332, 23192, 24314, 25951, 26828, 27210, 27375, 27840, 29079, 30680, 31530, 31614, 32295, 32904, 33247, 33379, 35494, 35527, 35557, 35623, 35641, 36224, 36295, 37516, 38387, 39767, 39976, 41414, 41432, 41448, 41481, 41497, 41514, 41530, 41546, 41562, 41578, 1980, 17472, 19399, 23193, 23441, 27215, 27376, 27842, 31615, 32298, 32399, 33249, 33382, 35500, 35528, 35578, 35624, 35642, 36148, 36820, 37326, 37517, 38388, 38860, 39508, 41243, 41415, 41433, 41449, 41482, 41498, 41515, 41531, 41547, 41563, 41579, 33387, 13967, 33270, 33271, 36391, 33272, 33273, 33265, 33266, 33267, 36812, 33268, 33269, 4525, 34464, 34346, 1594, 1598, 38975, 26097, 34320, 36390, 33256, 33257, 33258, 33259, 33260, 33261, 33262, 33263, 33264, 11549, 11550, 11552, 13299, 31640)
Parameters: 
[]
View formatted query    View runnable query    Explain query
10 0.33 ms 
SELECT p0_.id AS id_0, p0_.alias AS alias_1, p0_.title AS title_2, p0_.values_sort AS values_sort_3 FROM property p0_ WHERE p0_.id IN ('10', '41', '9', '43', '44', '35', '32', '4', '6', '29', '49', '21614', '1', '42', '46', '54', '30', '55', '31', '40', '39', '20', '25', '37', '45', '36', '7', '21', '27', '26', '3', '8', '2', '12')
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 6.74 ms 
SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (169, 499, 318, 146, 89, 147, 4, 27, 60, 538, 249, 511, 565, 336, 973, 1357, 922, 1703023, 1056, 7, 157, 453, 3844585, 334, 663, 2723, 160, 1480, 7797, 182, 6506, 1680, 1405, 3490, 2493382, 5426, 2929, 4297, 4895, 547666, 634, 5073, 3709, 3183031, 1424364, 3454, 165183, 3840709, 1740096, 3843496, 24764, 3841250, 6194, 3844684, 7496, 3837950, 222, 475, 870, 1528, 3841677, 931, 808750, 3838832, 6251, 2841, 808783, 7606, 4941, 3839930, 3837927, 3837980, 3839557, 3841228, 549, 8, 465, 4288, 137, 4433, 1182, 773, 1192, 324, 3669, 926, 808764, 7673, 3680, 4859, 1643, 3949, 3841927, 2697, 3529015, 3845168, 3845167, 480, 99649, 2367, 4776, 806, 171, 24547, 3880, 191, 2828, 2426, 3844298, 99648, 2434, 864, 3646700, 7921, 24518, 889, 3840490, 4719, 73, 3646703, 1849, 897, 61, 3088, 3838244, 3838825, 3529014, 2040, 5442, 6348, 3839151, 199, 1265, 8076, 3842272, 6888, 3478, 120, 6644, 7540, 913, 345, 349, 3845231, 1924, 125, 366, 4505, 3710, 287, 7901, 148, 4023, 325, 3840442, 340, 115, 342, 7546, 1424359, 3727, 3844318, 3840899, 2537, 4740, 3842342, 1424356, 3844447, 1105, 1825, 2052, 1158, 3693, 2130, 3450, 6757, 4098, 3839453, 244, 227, 3536, 3842351, 1424358, 2207, 3845232, 3628597, 1218, 3839135, 3842239, 2591, 3839142, 1172, 3839144, 2925, 3839843, 3840691, 1139, 3723, 4985, 3842121, 7973, 3716, 3574301, 3915, 3845244, 4494, 814, 7782, 2615, 241, 3839525, 3839898, 5417, 3840249, 382, 5784, 3839133, 3841990, 3843297, 3839146, 2339, 4699, 1830, 3837981, 2351533, 3091, 4064, 3725, 4746, 3839671, 3840927, 3839702, 3841919, 3839634, 3839579, 3839566, 3839648, 3839720, 3839591, 3839728, 3839637, 3840976, 3839638, 3839623, 3839689, 3839691, 3839697, 3839598, 3839558, 3840162, 3839595, 3839574, 3839693, 3839578, 3839587, 3839561, 3839608, 3843806, 3839562, 3841568, 3840075, 3839581, 3839681, 3839636, 3839567, 3841989, 3839573, 3839666, 3839674, 3839610, 3844543, 3839570, 3839629, 3839642, 3839725, 3843986, 3839571, 3839656, 3839692, 3839683, 3839659, 3839668, 3839619, 3840444, 3839568, 3844022, 3840990, 3840084, 3839594, 3839606, 3839560, 3839698, 3840317, 3839617, 3845625, 3839682, 3840200, 3839724, 3839616, 3839580, 3847034, 3844524, 3847192, 3841923, 3841926, 3841925, 3847018, 3843957, 3846943, 3840877, 3845155, 3842786, 24519, 3846977, 3846955, 3847033, 3847029, 3847030, 3846959, 3839499, 3847032, 3844584, 3838708, 3846800, 3845611, 3842785, 3847031, 3847259, 3843186, 3846954, 3839497, 3839502, 3840922, 3842712, 3846983, 3845380, 3844095, 3845520, 3847177, 3846991, 3847017, 3845980, 3845982, 3846036, 3846045, 3845984, 1099889, 3846035, 3846189, 8052, 3846033, 3845981, 3845977, 3838824, 3846003, 3839357, 3845979, 3845978, 3846029, 3846186, 3846032, 3846965, 3846936, 3841933, 3841935, 6861, 3846969, 1997, 3843047, 3846427, 3843820, 3846815, 3842148, 3843498, 3846410, 3844586, 3842875, 3839495, 3840091, 3845692, 3846804, 3846125, 3842113, 3842114, 3845600, 3847178, 3845796, 3847005, 3846124, 3845701, 2493388, 3838849, 3847020, 3841041, 3162, 3172, 3839296, 3842617, 3845485, 3843263, 3841995, 3846461, 3846122, 3846803, 3846135, 3846123, 3845486, 2493385, 5424, 3838705, 3841992, 1286418, 3843904, 3846142, 3841996, 3845830, 3844542, 3846989, 3838554, 3846938, 3838555, 3847244, 3846027, 3847257, 3837601, 547665, 3842109, 3843154, 3842110, 3846000, 3846028, 3706, 3846302, 3844317, 3846313, 3842591, 3846411, 3840898, 3846952, 3843801, 3846781, 3628601, 3843153, 3847174, 3846789, 3842823, 3846829, 3847296, 3845525, 3846868, 3846361, 3845986, 3843502, 3842546, 3846782, 3843504, 1740108, 3847243, 3843509, 3846308, 3845595, 3846979, 3842899, 3845998, 3846312, 3845516, 3846986, 3846867, 3846376, 3846994, 3845542, 3845544, 3843495, 1740109, 6921, 6910, 3845999, 3843883, 3840086, 3846065, 3845536, 3846990, 3846068, 3846026, 3843501, 3844304, 3846311, 3846375, 3845539, 3844308, 3846814, 3845517, 3842784, 3791943, 3845812, 3846869, 3845540, 3841504, 3846022, 3846777, 3842369, 3844587, 3846961, 3845518, 3846014, 3839452, 3846783, 3845543, 3846002, 3846998, 3843506, 3837865, 3846044, 3846015, 3846785, 3844128, 3846055, 3839018, 3846136, 3845818, 3846034, 3846039, 3846967, 3841038, 3846791, 3845820, 3846001, 3844021, 3847264, 3846318, 3846968, 3845985, 3846371, 3842900, 3846790, 3842664, 3845605, 3841500, 3845243, 3845604, 3846825, 3839278, 3841037, 3843507, 3843511, 3847165, 3846992, 3840466, 3842725, 3843770, 3846927, 3847224, 3846999, 3847225, 3845535, 3847185, 3841036, 3842805, 3842806, 3842808, 3847167, 3847223, 3847026, 3846851, 3846857, 3845545, 3842406, 3843625, 3844397, 3845588, 4014, 3839760, 3843132, 3846887, 3843659, 4017, 3846666, 3846889, 3843668, 2010, 3843670, 2109499, 3846865, 3846861, 3842816, 3840888, 488106, 3841955, 3846724, 3843206, 3846043, 3843060, 3843542, 3846912, 3844663, 3845493, 1994, 3842002, 3840129, 3846997, 3846793, 3845078, 3845596, 3846854, 3845823, 3842519, 3846875, 3845077, 3844319, 3843362, 3843009, 3843543, 3839083, 3843772, 3843653, 3843468, 3843624, 3845587, 3846933, 5047, 3846740, 3846296, 3841116, 3840694, 3846817, 3841220, 3842683, 3841498, 3842815, 3846859, 3846831, 3845550, 3845551, 3845552, 3846892, 3845120, 3845283, 3844133, 3846980, 3844641, 3846344, 3842120, 3846818, 3847043, 3847231, 3846741, 3846853, 3846862, 3846708, 3841130, 3840695, 3846860, 3841221, 3846893, 3844642, 3838514, 3845925, 3845606, 3837879, 3846752, 3846863, 3841117, 3844643, 3841236, 3529018, 3843020, 3846087, 3846425, 3838656, 3846464, 3843010, 3846864, 3840476, 3841131, 3846895, 3845555, 3840378, 3844644, 3838622, 3847035, 3846090, 3846813, 3843232, 3846858, 3842186, 3846896, 3845171, 3843809, 3844243, 3844645, 3845045, 3846765, 3846866, 3846882, 3846717, 3846899, 3843563, 3843812, 3844646, 3844941, 3846974, 976034, 3846737, 3839999, 3846883, 3846901, 3843817, 3844764, 3842117, 3846725, 3846792, 3846885, 3846902, 3845561, 2020, 3846729, 3846716, 3841988, 3846904, 3843583, 3846823, 4922, 3846730, 3840719, 3846872, 3846780, 3846908, 3843585, 3847263, 3846731, 3841115, 3839391, 3846726, 3845070, 3839219, 3846739, 3846909, 3844635, 3846732, 3846754, 3844326, 3843322, 3846910, 3844132, 3844636, 3845591, 3846733, 3846755, 3846855, 3840690, 3841040, 3843323, 3845119, 3844637, 3838492, 3846735, 3838881, 3846756, 3837982, 3843143, 3843151, 3844638, 3842937, 3846736, 3838882, 3846757, 3839474, 3845829, 3841217, 3843466, 3844639, 3845281, 3846758, 3841219, 3845834, 3844640, 3842673, 3846134, 3845541, 3846301, 3845722, 3845546, 1560, 3839282, 3845521, 855, 638, 3837924, 229, 2061, 2463, 193, 2092, 3839345, 801, 2418, 4834, 3840455, 7976, 1198, 2471, 3837657, 3608, 608524, 1206194, 7216, 24544, 6771, 24523, 1304550, 2539, 1384, 7581, 3361, 573740, 246, 5999, 1206196, 1206207, 351, 1757, 429130, 1565, 1749427, 5804, 2911, 428, 1206198, 1206202, 24527, 1809, 1206199, 361, 6013, 3842257, 3842055, 6875, 24538, 3838758, 1971, 5, 3838932, 1646, 1331925, 1239, 3839025, 3766, 3840575, 6964, 3733, 3842081, 3841870, 3845943, 3845933, 116413, 3841861, 2735, 80, 24776, 3841848, 3841849, 3840786, 7237, 5369, 3838826, 3841871, 3838921, 3841872, 2278, 3841839, 469, 3841846, 3841859, 2433, 1353, 3840093, 6646, 8053, 346, 791, 91, 1740122, 7271, 1444, 3843500, 2576, 1429, 7166, 3436, 3845032, 3565246, 2030, 3358, 3842115, 934, 6539, 3843505, 3844458, 574, 8078, 2493389, 7813, 866, 1903, 6645, 3108, 121, 491, 910, 870098, 947, 4485, 976, 4846, 988, 2381029, 1267, 5431, 3841187, 242, 1128, 5608, 3843969, 7808, 3842040, 576, 3844544, 3840166, 3360, 916, 1861, 3841833, 3838962, 838, 1335, 1391, 6247, 3841549, 355, 1675238, 3841837, 3841312, 3728, 220, 3839871, 3355, 2332, 3449, 704522, 904, 230, 3840176, 4766, 735, 3842349, 3841798, 4962, 5502, 3841864, 2467, 515, 3840123, 728, 739184, 3843517, 5061, 3840180, 3843518, 1826, 3837969, 3843526, 3292, 1233, 2048729, 5351, 5702, 547684, 1778, 2515, 6038, 3840938, 1607, 3841847, 3843497, 6922, 6913, 3841073, 1495, 2349, 7605, 3838406, 3841074, 1675248, 1489, 4468, 3841085, 700, 3843515, 2335, 3225, 3840172, 82920, 3841086, 3841419, 3841830, 82883, 2086, 2650, 1028, 28, 894, 1571, 3840125, 6791, 2147, 1569, 655, 3841850, 3061, 4359, 3600, 3840537, 3310325, 2780, 3841869, 3843281, 812, 481, 3839455, 3840182, 3841851, 2371181, 3843519, 2371192, 3845941, 3828425, 162, 3843521, 3844131, 3841877, 1277461, 4464, 3840868, 2493387, 3841853, 5595, 6631, 3841803, 717, 3845945, 3837773, 3841835, 3837676, 5388, 3845947, 1675236, 1675245, 3841855, 151, 3966, 3841875, 6437, 2881, 3842352, 2930, 3646694, 1591845, 6178, 5014, 667, 1807, 2280, 1554, 7576, 3843524, 3837622, 777, 3840929, 1514, 3780, 2285, 3840443, 4601, 1483, 3844129, 2250, 979, 7174, 454318, 194, 6031, 1174, 582, 3838431, 1169, 785, 3840032, 4706, 3837743, 3839990, 1904, 3839818, 3838405, 1593, 3842240, 3845938, 3629, 3840891, 3828437, 3844422, 2632, 1805667, 7262, 3840592, 3844423, 4814, 3837643, 3843363, 3838451, 639, 3745, 5347, 2807, 573739, 1951, 1724, 4375, 3841499, 3840706, 3839813, 748, 3842228, 1786, 1905, 6495, 788, 1055591, 3838028, 989, 5821, 6440, 3743, 2562, 3839261, 3839094, 3839819, 1719, 3839313, 6707, 14, 714, 3838819, 3840168, 3841238, 3841391, 4497, 1742, 2598, 4490, 4160, 46, 6737, 1749420, 5003, 3841281, 3841082, 3839527, 3839992, 1493, 2296, 5775, 3838734, 593, 2859, 3839816, 863, 3838738, 1431, 3828429, 1740119, 4158, 3838815, 6768, 3843584, 6537, 1136, 1558, 4540, 6726, 7543, 3839460, 738, 3842286, 3841183, 3841550, 6829, 4973, 3839462, 3840692, 4611, 1902, 2752, 3845233, 3838818, 817506, 1298, 3840759, 1635, 5810, 6146, 3838883, 3839476, 3841071, 3918, 3845284, 3838377, 1277449, 452, 1561, 3841229, 830, 290, 1206200, 278, 262, 4987, 163, 805, 269, 152, 347, 164, 5335, 997, 208, 54, 32, 519, 504, 130, 1153, 15, 503, 703, 248, 31, 383, 5969, 307, 173, 53, 1137, 807, 604, 51, 2690, 470, 231, 471, 522, 306, 1405784, 778, 495, 617, 256, 261, 6673, 174, 1104, 654, 1327, 2315, 1117, 99, 271, 107, 2422, 818, 108, 75, 3839311, 573735, 412374, 70, 6669, 114, 165, 258, 4636, 2305, 40, 3173946, 4634, 4476, 330, 185, 33, 257, 17, 3251, 875, 131, 2646, 4243, 82, 175, 2313, 3422, 1827, 3841471, 3840783, 3841920, 3840246, 3841928, 331, 3841812, 1109, 779, 3840878, 4204, 7276, 1157, 1776, 24531, 921, 99666, 2481, 2393, 3839493, 3886, 3840633, 2860, 232, 3839466, 1181, 5736, 3646702, 3562, 214335, 492, 8032, 3840846, 3839981, 819, 3839026, 3840170, 768, 3081, 3842080, 176, 2613, 3841823, 1277418, 2048740, 3841862, 4675, 740, 3842082, 3841831, 247223, 24644, 3839358, 3841834, 3841176, 792, 3841838, 3841857, 82880, 3841858, 308, 3840859, 3840652, 5712, 302, 3840275, 4487, 3843499, 7167, 3840092, 3841052, 3845271, 3840272, 3839905, 3019, 3841182, 1819, 3840876, 272, 2051, 3565247, 1328, 109, 3841717, 3842284, 547679, 3845270, 3841177, 612, 3841186, 3841066, 3840025, 3841384, 3839129, 3840642, 34, 3840742, 3840165, 3528, 263, 3840734, 7238, 4461, 4459, 3839870, 686, 3840900, 3840175, 3841547, 3841836, 3844071, 55, 3841863, 3839553, 3840121, 132, 3841866, 3843516, 3841841, 3840179, 547685, 3841832, 3843525, 1299, 2048730, 682, 3173958, 3840003, 3840934, 2054, 5703, 3839853, 813, 3840087, 304890, 3841822, 530585, 3839374, 3843514, 3840171, 3840100, 3839459, 82878, 4207, 24754, 513543, 3840954, 6932, 3841813, 3912, 3839375, 3840291, 3840104, 1734, 3839447, 1537, 3839454, 513540, 3845940, 3840188, 3843520, 3844130, 4856, 3845942, 3828432, 3840015, 3841824, 3828433, 209, 3843964, 3845944, 3839092, 3843967, 3845946, 3841854, 3844023, 3840991, 2808, 3841874, 3843360, 3841876, 2361340, 24777, 3840305, 3845265, 5679, 3843523, 3843529, 3840928, 3840467, 7233, 1286411, 1138, 3842092, 3839380, 3839270, 3840994, 3841067, 5622, 3840031, 3842554, 949, 3839815, 3841279, 3840889, 116422, 3845937, 3840890, 3842103, 3844419, 3839461, 221, 3839872, 116424, 5658, 513548, 3840164, 3839865, 3840528, 900, 3840569, 3840705, 3839811, 3842227, 3842231, 3839442, 3844134, 3423, 3840323, 291, 82839, 1821, 3840167, 3841237, 3845264, 4498, 7055, 3840482, 7742, 3841280, 3839526, 3840861, 3840214, 605, 3840000, 3809, 3845266, 3845939, 887747, 3843574, 4143, 3840607, 3840024, 3840829, 3843298, 3840993, 3840745, 3839252, 3842285, 3841287, 140939, 3842230, 3844921, 3840758, 3841369, 71, 3839475, 3841394, 3843737, 5732, 3839769, 24768, 19, 473, 4290, 140, 2038, 154, 780, 1185, 808766, 82851, 3246670, 1464, 3838285, 4293, 3838278, 24512, 911, 3840194, 3840163, 3065, 65, 5659, 789, 3125, 20, 3840821, 3926, 3838908, 7168, 5721, 82921, 166, 7957, 6462, 1754, 404084, 3840818, 3839464, 5996, 214331, 1743, 7257, 857, 493, 550, 1037875, 56, 510, 22, 1037876, 1046731, 142, 474, 156, 2095, 1414, 930, 2865, 1017, 1582, 16, 1277467, 631, 1001, 6434, 3443, 960, 5204, 1013, 1160, 2333, 624, 1573, 800, 97, 479, 1722, 1517, 709, 3272, 579, 619, 4340, 1497, 42, 3109, 5142, 1161856, 1277466, 2076, 173378, 695, 3459, 6070, 7953, 6814, 3841567, 3429, 6196, 1909, 526, 2584461, 1669, 3596, 1277436, 404, 1044, 3498, 1112, 3943, 1850, 3842464, 72, 188, 3845072, 681, 2812, 6891, 2967, 1170716, 3837872, 3837890, 3110509, 1295446, 438, 3842944, 3087, 346155, 3838, 702, 3845299, 3845073, 2456834, 2302, 5920, 5872, 2726, 6833, 2915, 404050, 990, 24658, 116423, 1621, 4584, 2792, 1091032, 1079, 6496, 3844496, 3281, 104, 4837, 3847334, 482, 647, 722, 1636, 3847152, 2090428, 2174, 3842502, 3655753, 607, 2044, 3847318, 346152, 476, 3847319, 24885, 365, 6116, 669591, 3842144, 1295455, 3277, 2048, 3592, 3462, 1380, 210, 24870, 6114, 462758, 1682, 3844567, 1833830, 3841083, 165170, 5752, 881, 313134, 24305, 2176684, 24756, 300, 2099, 2837, 2584460, 1350292, 1259571, 2289, 1359501, 3841191, 567, 119, 3841879, 5716, 3110516, 3847316, 3214, 621, 1091052, 3847335, 3492, 1486, 1259591, 1740093, 2456843, 381, 634676, 429107, 117, 527, 2499, 24579, 3844274, 353, 2292926, 82914, 551, 2478, 3977, 3580, 1099888, 2371168, 999, 2090420, 4680, 4500, 204, 2099911, 24814, 2048738, 6954, 2302697, 3837903, 3930, 2176683, 2540, 3847332, 4536, 2983678, 660, 2109444, 3058, 3072, 4373, 606, 1091038, 739, 1101, 4549, 969, 2282, 2302696, 1423, 7744, 1559, 1613, 2971, 1840, 3116, 24841, 3294, 917, 2809, 5648, 732, 3847317, 196, 1045, 716, 3460, 688, 1583, 1379, 280, 3837837, 2761, 5682, 2205, 876, 3223, 95, 764, 6111, 750, 57, 3996, 2856, 1672, 528, 699, 771, 1468, 464, 450, 6952, 569, 5422, 1191, 859, 541, 1628, 961, 952, 3840581, 2771, 1277456, 3841418, 486, 2195, 3840088, 3839363, 1277458, 2370, 3843329, 802, 1525, 918, 3304, 1037, 84, 6695, 4367, 1030, 3840693, 3101454, 2198, 7966, 3844680, 3773718, 6863, 3845626, 1176, 273, 5893, 3839933, 3843682, 286, 2897, 561, 2862, 6782, 6487, 335, 3228, 392, 354, 2425, 2802, 885, 2774, 2600, 2847591, 4735, 882, 1563, 1675, 487, 2661, 6127, 1389, 1213, 827, 3488, 1512, 925, 214328, 3465303, 808747, 2847590, 1623, 216, 13, 6617, 2, 696, 644, 44, 3155, 3730, 2138, 3705, 2325, 2103, 86, 3628607, 893, 1376, 1385, 1651, 3171, 2254, 1394, 2795, 852, 1686, 3457, 410, 391, 6068, 113, 2816, 3664812, 2827, 6257, 3837922, 3841865, 4838, 3847199, 4371, 3841829, 2272, 2283, 3841856, 6960, 3628598, 650, 123, 3844459, 1531, 6577, 3841784, 462748, 1170711, 1470838, 3840177, 3455, 3847197, 3842340, 3841868, 7172, 3183036, 3840930, 547676, 6908, 1129, 3529021, 3845286, 1268489, 3840183, 3840189, 2066, 3074, 3845918, 3729, 4984, 274, 3583343, 3583345, 3583349, 3583344, 3583342, 3583346, 3839076, 3, 78, 658, 26, 45, 641, 537, 39, 3139, 1418, 255, 2286, 314, 530, 375, 2378, 3945, 628, 547, 678, 2281, 502, 518, 693, 3942, 1159, 981, 30, 1130, 984, 116, 1108, 422, 429, 432, 556, 426, 558, 587, 7229, 542, 553, 1602, 423, 430, 433, 557, 427, 559, 588, 1943, 543, 554, 1603, 1434, 544, 1395, 411, 1653, 1396, 580, 412, 3845105, 413, 1614, 1397, 179, 1041, 189, 1212, 444, 389, 1070, 390, 21, 134, 1471, 186, 403, 144, 1161846, 872, 736, 1050, 296, 1059, 477, 1314, 402, 293, 1057, 1309, 2388, 400, 1170714, 4387, 190, 669, 2777, 180, 2788, 7408, 386, 3424, 1739, 1068, 1203, 3840427, 3840412, 3165, 4342, 870107, 3173947, 1038, 387, 3842307, 3842302, 3845250, 3845248, 3842310, 3842312, 3842306, 2892, 3749, 2785, 388, 443, 1040, 2170, 87, 711, 3841947, 59, 297, 2587, 364, 239, 198, 294, 343, 1477, 337, 238, 461, 279, 447, 344, 377, 6, 1171, 234, 369, 376, 363, 4970, 4892, 1996, 1975, 1409, 4795, 3842279, 1470839, 4971, 4893, 4910, 3839152, 3791939, 3791941, 3791925, 3791936, 3791940, 3791938, 3791921, 3844073, 3839162, 3791930, 3791932, 3844076, 3844075, 3791928, 3839132, 3837947, 3839145, 3844445, 0)
Parameters: 
[]
View formatted query    View runnable query    Explain query
12 83.98 ms 
SELECT p0_.property_id AS sclr_0, p0_.value_id AS sclr_1, p0_.product_id AS sclr_2 FROM product_property p0_ WHERE p0_.product_id IN (0, 21767, 21768, 21769, 21770, 21771, 21772, 21761, 21765, 33954, 32388, 34417, 34421, 34427, 31214, 31217, 34237, 20790, 23359, 23361, 31830, 23363, 31832, 20787, 20788, 20789, 30737, 23351, 32563, 23353, 23354, 26164, 30553, 23355, 30554, 31827, 23357, 31828, 31829, 20776, 20778, 20780, 20781, 30735, 21736, 21737, 21740, 18635, 21742, 24358, 26192, 29107, 18638, 24359, 26194, 31848, 18640, 24360, 26195, 31849, 18566, 18642, 19847, 24361, 26196, 18567, 18643, 19848, 18568, 18569, 22819, 30753, 18572, 30757, 18574, 26176, 30768, 34617, 24382, 26177, 26797, 30770, 18626, 21698, 21773, 26178, 29178, 30561, 18627, 21701, 21774, 26179, 30564, 30774, 18630, 19864, 21702, 21775, 23385, 26180, 30565, 30775, 18631, 19867, 21703, 21776, 23386, 26810, 30566, 30776, 18633, 19868, 21778, 23393, 26190, 30569, 31841, 18634, 19869, 21741, 24357, 26191, 29105, 18591, 21720, 21781, 22798, 31847, 18592, 21721, 21747, 21784, 22800, 30745, 38323, 18593, 21722, 21839, 22802, 29113, 30746, 38324, 39621, 18594, 18616, 21723, 22811, 29114, 39625, 18595, 18617, 21725, 22813, 24364, 26956, 29115, 30750, 39627, 41827, 18596, 18618, 19852, 21727, 22628, 22816, 24367, 26173, 30751, 41828, 18597, 18620, 19853, 21728, 24368, 26174, 30555, 41829, 18598, 18621, 19854, 21729, 24370, 24980, 26175, 30556, 33430, 41830, 18599, 18623, 19856, 21731, 24981, 33431, 41831, 18578, 18600, 18624, 19857, 21732, 24982, 30559, 33432, 41832, 18579, 18601, 21733, 23374, 24983, 26801, 30773, 31833, 31866, 41833, 18586, 18603, 21734, 23380, 26804, 31834, 31867, 41834, 18587, 18604, 26808, 31835, 31868, 41835, 18588, 18605, 26183, 31837, 18589, 21714, 34795, 18590, 21719, 21779, 22795, 30785, 31846, 18550, 29110, 18553, 30779, 18611, 18613, 18614, 30747, 24374, 30557, 19858, 19860, 18609, 18610, 26954, 31857, 31859, 31861, 31862, 31863, 31864, 29176, 31865, 29181, 25125, 25130, 30573, 22614, 27472, 22615, 35106, 22616, 22617, 22618, 36489, 11531, 11972, 24985, 31870, 11529, 11530, 25157, 25159, 25161, 31192, 31194, 31196, 31197, 31199, 34305, 35009, 34311, 40846, 34315, 19425, 34302, 39068, 18209, 34303, 39073, 18218, 34284, 34285, 35011, 34260, 39429, 34293, 39431, 28996, 34312, 34264, 34314, 34298, 34269, 34299, 39064, 34274, 34300, 22594, 22596, 13259, 13263, 34437, 34439, 14346, 13450, 18206, 13463, 22256, 13480, 31645, 11340, 18196, 13449, 18197, 20415, 36923, 39050, 39055, 39059, 39061, 39063, 39066, 13482, 13483, 13484, 13491, 35015, 13497, 13512, 31646, 35101, 36242, 5349, 36243, 5355, 38326, 38327, 38328, 20474, 22681, 22682, 29174, 22685, 22687, 15483, 22688, 15486, 22689, 24447, 36270, 15487, 22690, 24448, 6229, 15488, 22693, 6237, 15489, 30518, 39432, 39964, 33227, 39965, 35061, 35063, 35066, 23480, 27564, 36249, 38087, 19273, 19274, 27299, 33224, 39434, 24396, 27302, 39435, 27311, 39436, 13389, 32843, 39437, 13445, 39438, 18386, 18496, 20954, 19808, 21337, 24878, 1963, 26285, 1964, 27253, 1965, 27075, 35740, 19233, 35742, 33221, 39960, 14803, 33223, 39961, 1974, 24392, 39962, 1975, 10781, 33225, 10794, 34660, 36177, 37115, 24265, 34740, 32905, 38266, 30813, 36862, 13281, 36901, 13282, 13294, 22545, 22639, 27600, 34262, 33472, 32906, 31338, 31617, 31341, 31618, 35121, 31342, 31619, 39209, 31343, 31620, 31621, 22599, 26647, 22600, 36057, 22601, 35050, 22602, 34031, 35051, 22074, 22603, 35053, 25501, 35055, 22141, 34268, 33490, 7206, 25688, 4709, 6527, 31219, 4726, 6533, 26904, 2850, 6618, 20254, 26906, 32668, 37273, 2851, 6620, 20257, 22542, 32669, 36908, 38892, 2855, 6633, 32670, 38893, 3221, 6635, 19047, 25784, 30817, 33728, 3235, 5672, 6640, 9353, 23586, 25786, 26642, 5673, 6642, 23587, 25790, 33055, 5704, 6654, 23594, 25791, 34027, 6162, 6471, 6666, 10487, 21532, 25792, 32622, 34028, 6166, 6488, 6669, 32623, 4662, 6169, 6497, 6678, 23932, 30086, 32624, 4663, 6193, 6512, 6683, 23933, 30087, 32626, 34267, 4675, 6195, 6521, 6684, 32627, 33228, 35800, 4693, 6525, 6709, 4698, 6526, 34283, 37398, 33388, 34304, 38076, 14117, 30587, 33389, 38077, 14118, 30589, 31600, 34286, 34306, 36247, 38078, 31601, 34308, 38079, 38910, 30818, 31602, 36250, 1968, 22877, 27598, 31603, 34261, 1969, 31606, 1970, 31607, 31609, 36256, 31611, 31612, 34988, 6310, 20000, 23312, 23468, 24453, 25693, 26903, 30170, 30274, 30582, 31536, 31591, 32658, 33690, 33709, 34275, 36238, 39777, 6342, 16068, 23348, 24682, 25773, 26119, 30583, 31537, 31594, 32659, 32909, 33691, 33710, 37227, 39778, 6384, 16069, 25774, 28965, 30516, 30584, 31596, 32910, 33692, 33712, 34248, 35008, 37439, 6388, 21960, 25775, 28968, 30815, 31597, 32916, 33693, 33713, 34257, 36245, 5386, 6393, 9143, 21964, 25777, 28970, 30816, 31573, 31911, 32917, 33694, 34258, 35010, 5408, 6408, 9152, 14227, 21973, 24935, 25307, 26310, 27027, 28971, 30592, 31575, 31913, 32676, 33036, 33411, 33695, 33923, 34259, 34287, 39640, 6410, 14228, 21974, 25319, 28972, 29152, 30594, 31577, 31638, 31915, 32677, 33038, 33412, 33697, 33951, 34288, 34309, 36052, 38329, 39641, 6422, 9459, 13194, 14231, 21975, 25331, 28973, 29153, 30596, 30819, 31578, 31918, 32679, 33698, 34289, 34310, 36053, 36251, 37750, 38331, 40844, 6424, 13205, 21976, 25336, 28974, 30821, 31580, 33701, 36252, 36711, 37510, 37752, 38332, 40845, 13211, 13608, 21979, 25343, 27682, 31581, 33702, 34263, 34294, 35222, 37511, 37937, 38350, 38531, 13214, 13615, 15206, 21980, 25344, 25932, 31583, 33703, 34295, 34313, 35224, 37109, 37512, 38532, 40847, 13215, 25940, 30269, 31584, 32833, 33704, 34266, 34296, 35225, 36492, 37111, 38533, 40848, 13222, 22138, 25941, 30270, 31585, 33705, 34297, 35226, 36493, 37322, 38126, 38534, 40900, 13234, 19342, 25950, 30271, 31586, 33706, 34069, 34316, 35227, 36146, 36494, 37323, 38019, 38127, 38535, 39969, 13238, 19343, 22150, 24450, 25683, 30272, 31588, 31881, 33707, 34317, 35228, 35801, 36147, 37324, 38020, 38132, 38536, 41178, 13256, 22151, 24452, 26900, 30169, 30273, 31535, 31590, 31886, 33558, 33708, 38021, 39776, 2600, 2605, 22525, 23482, 33902, 39950, 17461, 21362, 39951, 17462, 24971, 17463, 38964, 17464, 17465, 32828, 36254, 17467, 32829, 17468, 36259, 1000, 32650, 32652, 31756, 20570, 19278, 19280, 36806, 18094, 19282, 31660, 18101, 31662, 31663, 31664, 13901, 35313, 13902, 17729, 35314, 35315, 35316, 37505, 27569, 35317, 37506, 27570, 37507, 27571, 37508, 37509, 32824, 36756, 36757, 29188, 29189, 41132, 29191, 1027, 13900, 35312, 15496, 22253, 28217, 29211, 34114, 35876, 36548, 37211, 38026, 40481, 8369, 29212, 30503, 35920, 36622, 38027, 8372, 24694, 29213, 35923, 36631, 29214, 35152, 36633, 23535, 30237, 33292, 33398, 33722, 20398, 23536, 31510, 32592, 33293, 35655, 40842, 12678, 13302, 31511, 32602, 33870, 37740, 38413, 3474, 13303, 27098, 32604, 33871, 34561, 3475, 13322, 29405, 30600, 31642, 32606, 33872, 35040, 36963, 3476, 13348, 23876, 29407, 33873, 13355, 23186, 33874, 37998, 13360, 13667, 23187, 25404, 29063, 32065, 33875, 34629, 37999, 13378, 13668, 22605, 33876, 38000, 13670, 22606, 30088, 33879, 36178, 37189, 13672, 22607, 30165, 33883, 34112, 36535, 36814, 37209, 22608, 29210, 33884, 34113, 35872, 36228, 36355, 36546, 37210, 40480, 1060, 7218, 17473, 26109, 27216, 30812, 31616, 31700, 31897, 32299, 32453, 33250, 33384, 33898, 34997, 35502, 35529, 35605, 35626, 35643, 36149, 36853, 37327, 37518, 38310, 38389, 38866, 39511, 41400, 41416, 41434, 41450, 41483, 41499, 41516, 41532, 41548, 41564, 41580, 19489, 20161, 27218, 27548, 28222, 30234, 31707, 31898, 32300, 32460, 33251, 33901, 34998, 35503, 35530, 35606, 35627, 35644, 36152, 37519, 38390, 38868, 39554, 40835, 41401, 41417, 41435, 41451, 41484, 41500, 41517, 41533, 41549, 41565, 41581, 17794, 26124, 27235, 27551, 30235, 30814, 31569, 31899, 32301, 35504, 35531, 35608, 35628, 35645, 36153, 36419, 37520, 38391, 38869, 39161, 39948, 40836, 41402, 41418, 41436, 41452, 41485, 41501, 41518, 41534, 41550, 41566, 41582, 1901, 9026, 16741, 17796, 18231, 21353, 23503, 25242, 26126, 27245, 30236, 31570, 31769, 31900, 32303, 32581, 33903, 35506, 35534, 35609, 35629, 35646, 35999, 36159, 36420, 37309, 37718, 38392, 39949, 40837, 41403, 41419, 41437, 41453, 41486, 41502, 41519, 41535, 41551, 41567, 41583, 11690, 16811, 17797, 18233, 20310, 21358, 24909, 25291, 27250, 29387, 31776, 32305, 32587, 33905, 35174, 35508, 35535, 35611, 35630, 35647, 36000, 36160, 36425, 36641, 36912, 37310, 37719, 38393, 39212, 40841, 41404, 41420, 41438, 41455, 41487, 41503, 41520, 41536, 41552, 41568, 17800, 18237, 29137, 29389, 30238, 32306, 35180, 35455, 35510, 35536, 35612, 35631, 36010, 36163, 36431, 36643, 36915, 37311, 37720, 38394, 39217, 41405, 41421, 41439, 41471, 41488, 41504, 41521, 41537, 41553, 41569, 17801, 18239, 19181, 21367, 27254, 29399, 30252, 32308, 33294, 35181, 35458, 35511, 35538, 35613, 35632, 36165, 36433, 36644, 36920, 37312, 38927, 39218, 39952, 40843, 41406, 41422, 41440, 41472, 41489, 41505, 41522, 41538, 41554, 41570, 17803, 18241, 21368, 27255, 29404, 30253, 31513, 32310, 33316, 35039, 35183, 35462, 35512, 35542, 35614, 35633, 36166, 36473, 36645, 37313, 38107, 38513, 39760, 39953, 41407, 41423, 41441, 41473, 41490, 41507, 41523, 41539, 41555, 41571, 9594, 17804, 18246, 21369, 22925, 26740, 27202, 27256, 30254, 31514, 31974, 32311, 33317, 35184, 35466, 35513, 35543, 35615, 35634, 35749, 36168, 36479, 37315, 38108, 38516, 39761, 41408, 41424, 41442, 41474, 41491, 41508, 41524, 41540, 41556, 41572, 17805, 18251, 22932, 27204, 27257, 30255, 30666, 31515, 32004, 32330, 33318, 34620, 35468, 35514, 35545, 35616, 35635, 35750, 36064, 36172, 36485, 36978, 37316, 38122, 39762, 41409, 41426, 41443, 41475, 41492, 41509, 41525, 41541, 41557, 41573, 10699, 17834, 18259, 23893, 27205, 27834, 29048, 30079, 30256, 30673, 31516, 32009, 32358, 33320, 33436, 34621, 35469, 35516, 35546, 35617, 35637, 35754, 36127, 36173, 37317, 38124, 38383, 39763, 41410, 41427, 41444, 41476, 41493, 41510, 41526, 41542, 41558, 41574, 17835, 18292, 27206, 27835, 30674, 31517, 31649, 32359, 33327, 33439, 34033, 35471, 35523, 35549, 35620, 35638, 35755, 36128, 36176, 37318, 37513, 38125, 38384, 39764, 41411, 41428, 41445, 41477, 41494, 41511, 41527, 41543, 41559, 41575, 1977, 17469, 18294, 23190, 25018, 27207, 27837, 29064, 30675, 31522, 32292, 32360, 32842, 33329, 33442, 34034, 35473, 35524, 35552, 35621, 35639, 35760, 36130, 36810, 37514, 38385, 39765, 41412, 41429, 41446, 41478, 41495, 41512, 41528, 41544, 41560, 41576, 950, 1978, 17470, 18304, 23191, 25023, 25592, 27209, 27373, 27839, 29077, 30678, 31524, 31613, 32293, 32371, 33335, 35487, 35525, 35555, 35622, 35640, 36294, 37515, 38386, 39766, 41413, 41431, 41447, 41479, 41496, 41513, 41529, 41545, 41561, 41577, 1979, 17471, 18332, 23192, 24314, 25951, 26828, 27210, 27375, 27840, 29079, 30680, 31530, 31614, 32295, 32904, 33247, 33379, 35494, 35527, 35557, 35623, 35641, 36224, 36295, 37516, 38387, 39767, 39976, 41414, 41432, 41448, 41481, 41497, 41514, 41530, 41546, 41562, 41578, 1980, 17472, 19399, 23193, 23441, 27215, 27376, 27842, 31615, 32298, 32399, 33249, 33382, 35500, 35528, 35578, 35624, 35642, 36148, 36820, 37326, 37517, 38388, 38860, 39508, 41243, 41415, 41433, 41449, 41482, 41498, 41515, 41531, 41547, 41563, 41579, 33387, 13967, 33270, 33271, 36391, 33272, 33273, 33265, 33266, 33267, 36812, 33268, 33269, 4525, 34464, 34346, 1594, 1598, 38975, 26097, 34320, 36390, 33256, 33257, 33258, 33259, 33260, 33261, 33262, 33263, 33264, 11549, 11550, 11552, 13299, 31640)
Parameters: 
[]
View formatted query    View runnable query    Explain query
13 1.28 ms 
SELECT p0_.id AS id_0, b1_.image AS image_1 FROM property_value p0_ INNER JOIN brand b1_ ON (b1_.uid = p0_.uid) WHERE p0_.id IN (3839574, 3839566, 3839561, 3841568, 3839579, 3839578, 3840990, 3839638, 3839683, 3839689, 3839562, 3839671, 3839571, 3840444, 3839608, 3839606, 3839573, 3839720, 3839642, 3839702, 3840976, 3839598, 3839610, 3839558, 3839567, 3839594, 3839560, 3839587, 3839636, 3840317, 3839634, 3839681, 3840162, 3839691, 3841989, 3839637, 3839656, 3844022, 3839648, 3839581, 3839570, 3840927, 3839674, 3839568, 3841919, 3839629, 3843986, 3839728, 3843806, 3839725, 3839591, 3839697, 3839666, 3839692, 3839698, 3845625, 3840075, 3844543, 3839659, 3839668, 3840084, 3839724, 3839616, 3839623, 3839595, 3839693, 3839619, 3839617, 3839682, 3840200, 3839580)
Parameters: 
[]
View formatted query    View runnable query    Explain query
14 77.13 ms 
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.description AS description_4, p0_.main_image AS main_image_5, p0_.uid AS uid_6, p0_.characteristic AS characteristic_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.created_at_in1_c AS created_at_in1_c_10, p0_.price AS price_11, p0_.old_price AS old_price_12, p0_.bonus AS bonus_13, p0_.slug AS slug_14, p0_.images AS images_15, p0_.number_of_orders AS number_of_orders_16, p0_.is_new AS is_new_17, p0_.is_hit AS is_hit_18, p0_.is_gift AS is_gift_19, p0_.is_new_year AS is_new_year_20, p0_.full_title AS full_title_21, p0_.discount_percent AS discount_percent_22, p0_.balance_store AS balance_store_23, p0_.balance_warehouse AS balance_warehouse_24, p0_.old_slug AS old_slug_25, p0_.viewed AS viewed_26, p0_.code1c AS code1c_27, p0_.data AS data_28, p0_.on_demand AS on_demand_29, p0_.hash AS hash_30, p0_.reviews_number AS reviews_number_31, p0_.reviews_avg_score AS reviews_avg_score_32, p0_.group_uid AS group_uid_33, p0_.is_little_remains AS is_little_remains_34, p0_.common_group_name AS common_group_name_35 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (950, 1000, 1027, 1060, 1594, 1598, 1901, 1963, 1964, 1965, 1968, 1969, 1970, 1974, 1975, 1977, 1978, 1979, 1980, 2600, 2605, 2850, 2851, 2855, 3221, 3235, 3474, 3475, 3476, 4525, 4662, 4663, 4675, 4693, 4698, 4709, 4726, 5349, 5355, 5386, 5408, 5672, 5673, 5704, 6162, 6166, 6169, 6193, 6195, 6229, 6237, 6310, 6342, 6384, 6388, 6393, 6408, 6410, 6422, 6424, 6471, 6488, 6497, 6512, 6521, 6525, 6526, 6527, 6533, 6618, 6620, 6633, 6635, 6640, 6642, 6654, 6666, 6669, 6678, 6683, 6684, 6709, 7206, 7218, 8369, 8372, 9026, 9143, 9152, 9353, 9459, 9594, 10487, 10699, 10781, 10794, 11340, 11529, 11530, 11531, 11549, 11550, 11552, 11690, 11972, 12678, 13194, 13205, 13211, 13214, 13215, 13222, 13234, 13238, 13256, 13259, 13263, 13281, 13282, 13294, 13299, 13302, 13303, 13322, 13348, 13355, 13360, 13378, 13389, 13445, 13449, 13450, 13463, 13480, 13482, 13483, 13484, 13491, 13497, 13512, 13608, 13615, 13667, 13668, 13670, 13672, 13900, 13901, 13902, 13967, 14117, 14118, 14227, 14228, 14231, 14346, 14803, 15206, 15483, 15486, 15487, 15488, 15489, 15496, 16068, 16069, 16741, 16811, 17461, 17462, 17463, 17464, 17465, 17467, 17468, 17469, 17470, 17471, 17472, 17473, 17729, 17794, 17796, 17797, 17800, 17801, 17803, 17804, 17805, 17834, 17835, 18094, 18101, 18196, 18197, 18206, 18209, 18218, 18231, 18233, 18237, 18239, 18241, 18246, 18251, 18259, 18292, 18294, 18304, 18332, 18386, 18496, 18550, 18553, 18566, 18567, 18568, 18569, 18572, 18574, 18578, 18579, 18586, 18587, 18588, 18589, 18590, 18591, 18592, 18593, 18594, 18595, 18596, 18597, 18598, 18599, 18600, 18601, 18603, 18604, 18605, 18609, 18610, 18611, 18613, 18614, 18616, 18617, 18618, 18620, 18621, 18623, 18624, 18626, 18627, 18630, 18631, 18633, 18634, 18635, 18638, 18640, 18642, 18643, 19047, 19181, 19233, 19273, 19274, 19278, 19280, 19282, 19342, 19343, 19399, 19425, 19489, 19808, 19847, 19848, 19852, 19853, 19854, 19856, 19857, 19858, 19860, 19864, 19867, 19868, 19869, 20000, 20161, 20254, 20257, 20310, 20398, 20415, 20474, 20570, 20776, 20778, 20780, 20781, 20787, 20788, 20789, 20790, 20954, 21337, 21353, 21358, 21362, 21367, 21368, 21369, 21532, 21698, 21701, 21702, 21703, 21714, 21719, 21720, 21721, 21722, 21723, 21725, 21727, 21728, 21729, 21731, 21732, 21733, 21734, 21736, 21737, 21740, 21741, 21742, 21747, 21761, 21765, 21767, 21768, 21769, 21770, 21771, 21772, 21773, 21774, 21775, 21776, 21778, 21779, 21781, 21784, 21839, 21960, 21964, 21973, 21974, 21975, 21976, 21979, 21980, 22074, 22138, 22141, 22150, 22151, 22253, 22256, 22525, 22542, 22545, 22594, 22596, 22599, 22600, 22601, 22602, 22603, 22605, 22606, 22607, 22608, 22614, 22615, 22616, 22617, 22618, 22628, 22639, 22681, 22682, 22685, 22687, 22688, 22689, 22690, 22693, 22795, 22798, 22800, 22802, 22811, 22813, 22816, 22819, 22877, 22925, 22932, 23186, 23187, 23190, 23191, 23192, 23193, 23312, 23348, 23351, 23353, 23354, 23355, 23357, 23359, 23361, 23363, 23374, 23380, 23385, 23386, 23393, 23441, 23468, 23480, 23482, 23503, 23535, 23536, 23586, 23587, 23594, 23876, 23893, 23932, 23933, 24265, 24314, 24357, 24358, 24359, 24360, 24361, 24364, 24367, 24368, 24370, 24374, 24382, 24392, 24396, 24447, 24448, 24450, 24452, 24453, 24682, 24694, 24878, 24909, 24935, 24971, 24980, 24981, 24982, 24983, 24985, 25018, 25023, 25125, 25130, 25157, 25159, 25161, 25242, 25291, 25307, 25319, 25331, 25336, 25343, 25344, 25404, 25501, 25592, 25683, 25688, 25693, 25773, 25774, 25775, 25777, 25784, 25786, 25790, 25791, 25792, 25932, 25940, 25941, 25950, 25951, 26097, 26109, 26119, 26124, 26126, 26164, 26173, 26174, 26175, 26176, 26177, 26178, 26179, 26180, 26183, 26190, 26191, 26192, 26194, 26195, 26196, 26285, 26310, 26642, 26647, 26740, 26797, 26801, 26804, 26808, 26810, 26828, 26900, 26903, 26904, 26906, 26954, 26956, 27027, 27075, 27098, 27202, 27204, 27205, 27206, 27207, 27209, 27210, 27215, 27216, 27218, 27235, 27245, 27250, 27253, 27254, 27255, 27256, 27257, 27299, 27302, 27311, 27373, 27375, 27376, 27472, 27548, 27551, 27564, 27569, 27570, 27571, 27598, 27600, 27682, 27834, 27835, 27837, 27839, 27840, 27842, 28217, 28222, 28965, 28968, 28970, 28971, 28972, 28973, 28974, 28996, 29048, 29063, 29064, 29077, 29079, 29105, 29107, 29110, 29113, 29114, 29115, 29137, 29152, 29153, 29174, 29176, 29178, 29181, 29188, 29189, 29191, 29210, 29211, 29212, 29213, 29214, 29387, 29389, 29399, 29404, 29405, 29407, 30079, 30086, 30087, 30088, 30165, 30169, 30170, 30234, 30235, 30236, 30237, 30238, 30252, 30253, 30254, 30255, 30256, 30269, 30270, 30271, 30272, 30273, 30274, 30503, 30516, 30518, 30553, 30554, 30555, 30556, 30557, 30559, 30561, 30564, 30565, 30566, 30569, 30573, 30582, 30583, 30584, 30587, 30589, 30592, 30594, 30596, 30600, 30666, 30673, 30674, 30675, 30678, 30680, 30735, 30737, 30745, 30746, 30747, 30750, 30751, 30753, 30757, 30768, 30770, 30773, 30774, 30775, 30776, 30779, 30785, 30812, 30813, 30814, 30815, 30816, 30817, 30818, 30819, 30821, 31192, 31194, 31196, 31197, 31199, 31214, 31217, 31219, 31338, 31341, 31342, 31343, 31510, 31511, 31513, 31514, 31515, 31516, 31517, 31522, 31524, 31530, 31535, 31536, 31537, 31569, 31570, 31573, 31575, 31577, 31578, 31580, 31581, 31583, 31584, 31585, 31586, 31588, 31590, 31591, 31594, 31596, 31597, 31600, 31601, 31602, 31603, 31606, 31607, 31609, 31611, 31612, 31613, 31614, 31615, 31616, 31617, 31618, 31619, 31620, 31621, 31638, 31640, 31642, 31645, 31646, 31649, 31660, 31662, 31663, 31664, 31700, 31707, 31756, 31769, 31776, 31827, 31828, 31829, 31830, 31832, 31833, 31834, 31835, 31837, 31841, 31846, 31847, 31848, 31849, 31857, 31859, 31861, 31862, 31863, 31864, 31865, 31866, 31867, 31868, 31870, 31881, 31886, 31897, 31898, 31899, 31900, 31911, 31913, 31915, 31918, 31974, 32004, 32009, 32065, 32292, 32293, 32295, 32298, 32299, 32300, 32301, 32303, 32305, 32306, 32308, 32310, 32311, 32330, 32358, 32359, 32360, 32371, 32388, 32399, 32453, 32460, 32563, 32581, 32587, 32592, 32602, 32604, 32606, 32622, 32623, 32624, 32626, 32627, 32650, 32652, 32658, 32659, 32668, 32669, 32670, 32676, 32677, 32679, 32824, 32828, 32829, 32833, 32842, 32843, 32904, 32905, 32906, 32909, 32910, 32916, 32917, 33036, 33038, 33055, 33221, 33223, 33224, 33225, 33227, 33228, 33247, 33249, 33250, 33251, 33256, 33257, 33258, 33259, 33260, 33261, 33262, 33263, 33264, 33265, 33266, 33267, 33268, 33269, 33270, 33271, 33272, 33273, 33292, 33293, 33294, 33316, 33317, 33318, 33320, 33327, 33329, 33335, 33379, 33382, 33384, 33387, 33388, 33389, 33398, 33411, 33412, 33430, 33431, 33432, 33436, 33439, 33442, 33472, 33490, 33558, 33690, 33691, 33692, 33693, 33694, 33695, 33697, 33698, 33701, 33702, 33703, 33704, 33705, 33706, 33707, 33708, 33709, 33710, 33712, 33713, 33722, 33728, 33870, 33871, 33872, 33873, 33874, 33875, 33876, 33879, 33883, 33884, 33898, 33901, 33902, 33903, 33905, 33923, 33951, 33954, 34027, 34028, 34031, 34033, 34034, 34069, 34112, 34113, 34114, 34237, 34248, 34257, 34258, 34259, 34260, 34261, 34262, 34263, 34264, 34266, 34267, 34268, 34269, 34274, 34275, 34283, 34284, 34285, 34286, 34287, 34288, 34289, 34293, 34294, 34295, 34296, 34297, 34298, 34299, 34300, 34302, 34303, 34304, 34305, 34306, 34308, 34309, 34310, 34311, 34312, 34313, 34314, 34315, 34316, 34317, 34320, 34346, 34417, 34421, 34427, 34437, 34439, 34464, 34561, 34617, 34620, 34621, 34629, 34660, 34740, 34795, 34988, 34997, 34998, 35008, 35009, 35010, 35011, 35015, 35039, 35040, 35050, 35051, 35053, 35055, 35061, 35063, 35066, 35101, 35106, 35121, 35152, 35174, 35180, 35181, 35183, 35184, 35222, 35224, 35225, 35226, 35227, 35228, 35312, 35313, 35314, 35315, 35316, 35317, 35455, 35458, 35462, 35466, 35468, 35469, 35471, 35473, 35487, 35494, 35500, 35502, 35503, 35504, 35506, 35508, 35510, 35511, 35512, 35513, 35514, 35516, 35523, 35524, 35525, 35527, 35528, 35529, 35530, 35531, 35534, 35535, 35536, 35538, 35542, 35543, 35545, 35546, 35549, 35552, 35555, 35557, 35578, 35605, 35606, 35608, 35609, 35611, 35612, 35613, 35614, 35615, 35616, 35617, 35620, 35621, 35622, 35623, 35624, 35626, 35627, 35628, 35629, 35630, 35631, 35632, 35633, 35634, 35635, 35637, 35638, 35639, 35640, 35641, 35642, 35643, 35644, 35645, 35646, 35647, 35655, 35740, 35742, 35749, 35750, 35754, 35755, 35760, 35800, 35801, 35872, 35876, 35920, 35923, 35999, 36000, 36010, 36052, 36053, 36057, 36064, 36127, 36128, 36130, 36146, 36147, 36148, 36149, 36152, 36153, 36159, 36160, 36163, 36165, 36166, 36168, 36172, 36173, 36176, 36177, 36178, 36224, 36228, 36238, 36242, 36243, 36245, 36247, 36249, 36250, 36251, 36252, 36254, 36256, 36259, 36270, 36294, 36295, 36355, 36390, 36391, 36419, 36420, 36425, 36431, 36433, 36473, 36479, 36485, 36489, 36492, 36493, 36494, 36535, 36546, 36548, 36622, 36631, 36633, 36641, 36643, 36644, 36645, 36711, 36756, 36757, 36806, 36810, 36812, 36814, 36820, 36853, 36862, 36901, 36908, 36912, 36915, 36920, 36923, 36963, 36978, 37109, 37111, 37115, 37189, 37209, 37210, 37211, 37227, 37273, 37309, 37310, 37311, 37312, 37313, 37315, 37316, 37317, 37318, 37322, 37323, 37324, 37326, 37327, 37398, 37439, 37505, 37506, 37507, 37508, 37509, 37510, 37511, 37512, 37513, 37514, 37515, 37516, 37517, 37518, 37519, 37520, 37718, 37719, 37720, 37740, 37750, 37752, 37937, 37998, 37999, 38000, 38019, 38020, 38021, 38026, 38027, 38076, 38077, 38078, 38079, 38087, 38107, 38108, 38122, 38124, 38125, 38126, 38127, 38132, 38266, 38310, 38323, 38324, 38326, 38327, 38328, 38329, 38331, 38332, 38350, 38383, 38384, 38385, 38386, 38387, 38388, 38389, 38390, 38391, 38392, 38393, 38394, 38413, 38513, 38516, 38531, 38532, 38533, 38534, 38535, 38536, 38860, 38866, 38868, 38869, 38892, 38893, 38910, 38927, 38964, 38975, 39050, 39055, 39059, 39061, 39063, 39064, 39066, 39068, 39073, 39161, 39209, 39212, 39217, 39218, 39429, 39431, 39432, 39434, 39435, 39436, 39437, 39438, 39508, 39511, 39554, 39621, 39625, 39627, 39640, 39641, 39760, 39761, 39762, 39763, 39764, 39765, 39766, 39767, 39776, 39777, 39778, 39948, 39949, 39950, 39951, 39952, 39953, 39960, 39961, 39962, 39964, 39965, 39969, 39976, 40480, 40481, 40835, 40836, 40837, 40841, 40842, 40843, 40844, 40845, 40846, 40847, 40848, 40900, 41132, 41178, 41243, 41400, 41401, 41402, 41403, 41404, 41405, 41406, 41407, 41408, 41409, 41410, 41411, 41412, 41413, 41414, 41415, 41416, 41417, 41418, 41419, 41420, 41421, 41422, 41423, 41424, 41426, 41427, 41428, 41429, 41431, 41432, 41433, 41434, 41435, 41436, 41437, 41438, 41439, 41440, 41441, 41442, 41443, 41444, 41445, 41446, 41447, 41448, 41449, 41450, 41451, 41452, 41453, 41455, 41471, 41472, 41473, 41474, 41475, 41476, 41477, 41478, 41479, 41481, 41482, 41483, 41484, 41485, 41486, 41487, 41488, 41489, 41490, 41491, 41492, 41493, 41494, 41495, 41496, 41497, 41498, 41499, 41500, 41501, 41502, 41503, 41504, 41505, 41507, 41508, 41509, 41510, 41511, 41512, 41513, 41514, 41515, 41516, 41517, 41518, 41519, 41520, 41521, 41522, 41523, 41524, 41525, 41526, 41527, 41528, 41529, 41530, 41531, 41532, 41533, 41534, 41535, 41536, 41537, 41538, 41539, 41540, 41541, 41542, 41543, 41544, 41545, 41546, 41547, 41548, 41549, 41550, 41551, 41552, 41553, 41554, 41555, 41556, 41557, 41558, 41559, 41560, 41561, 41562, 41563, 41564, 41565, 41566, 41567, 41568, 41569, 41570, 41571, 41572, 41573, 41574, 41575, 41576, 41577, 41578, 41579, 41580, 41581, 41582, 41583, 41827, 41828, 41829, 41830, 41831, 41832, 41833, 41834, 41835) ORDER BY p0_.discount_percent DESC) dctrn_result) dctrn_table
Parameters: 
[]
View formatted query    View runnable query    Explain query
15 20.52 ms 
SELECT p0_.id AS id_0, p0_.visible AS visible_1, p0_.name AS name_2, p0_.sku AS sku_3, p0_.description AS description_4, p0_.main_image AS main_image_5, p0_.uid AS uid_6, p0_.characteristic AS characteristic_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p0_.created_at_in1_c AS created_at_in1_c_10, p0_.price AS price_11, p0_.old_price AS old_price_12, p0_.bonus AS bonus_13, p0_.slug AS slug_14, p0_.images AS images_15, p0_.number_of_orders AS number_of_orders_16, p0_.is_new AS is_new_17, p0_.is_hit AS is_hit_18, p0_.is_gift AS is_gift_19, p0_.is_new_year AS is_new_year_20, p0_.full_title AS full_title_21, p0_.discount_percent AS discount_percent_22, p0_.balance_store AS balance_store_23, p0_.balance_warehouse AS balance_warehouse_24, p0_.old_slug AS old_slug_25, p0_.viewed AS viewed_26, p0_.code1c AS code1c_27, p0_.data AS data_28, p0_.on_demand AS on_demand_29, p0_.hash AS hash_30, p0_.reviews_number AS reviews_number_31, p0_.reviews_avg_score AS reviews_avg_score_32, p0_.group_uid AS group_uid_33, p0_.is_little_remains AS is_little_remains_34, p0_.common_group_name AS common_group_name_35, p0_.brand_id AS brand_id_36, p0_.size_id AS size_id_37, p0_.category1c_id AS category1c_id_38 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (950, 1000, 1027, 1060, 1594, 1598, 1901, 1963, 1964, 1965, 1968, 1969, 1970, 1974, 1975, 1977, 1978, 1979, 1980, 2600, 2605, 2850, 2851, 2855, 3221, 3235, 3474, 3475, 3476, 4525, 4662, 4663, 4675, 4693, 4698, 4709, 4726, 5349, 5355, 5386, 5408, 5672, 5673, 5704, 6162, 6166, 6169, 6193, 6195, 6229, 6237, 6310, 6342, 6384, 6388, 6393, 6408, 6410, 6422, 6424, 6471, 6488, 6497, 6512, 6521, 6525, 6526, 6527, 6533, 6618, 6620, 6633, 6635, 6640, 6642, 6654, 6666, 6669, 6678, 6683, 6684, 6709, 7206, 7218, 8369, 8372, 9026, 9143, 9152, 9353, 9459, 9594, 10487, 10699, 10781, 10794, 11340, 11529, 11530, 11531, 11549, 11550, 11552, 11690, 11972, 12678, 13194, 13205, 13211, 13214, 13215, 13222, 13234, 13238, 13256, 13259, 13263, 13281, 13282, 13294, 13299, 13302, 13303, 13322, 13348, 13355, 13360, 13378, 13389, 13445, 13449, 13450, 13463, 13480, 13482, 13483, 13484, 13491, 13497, 13512, 13608, 13615, 13667, 13668, 13670, 13672, 13900, 13901, 13902, 13967, 14117, 14118, 14227, 14228, 14231, 14346, 14803, 15206, 15483, 15486, 15487, 15488, 15489, 15496, 16068, 16069, 16741, 16811, 17461, 17462, 17463, 17464, 17465, 17467, 17468, 17469, 17470, 17471, 17472, 17473, 17729, 17794, 17796, 17797, 17800, 17801, 17803, 17804, 17805, 17834, 17835, 18094, 18101, 18196, 18197, 18206, 18209, 18218, 18231, 18233, 18237, 18239, 18241, 18246, 18251, 18259, 18292, 18294, 18304, 18332, 18386, 18496, 18550, 18553, 18566, 18567, 18568, 18569, 18572, 18574, 18578, 18579, 18586, 18587, 18588, 18589, 18590, 18591, 18592, 18593, 18594, 18595, 18596, 18597, 18598, 18599, 18600, 18601, 18603, 18604, 18605, 18609, 18610, 18611, 18613, 18614, 18616, 18617, 18618, 18620, 18621, 18623, 18624, 18626, 18627, 18630, 18631, 18633, 18634, 18635, 18638, 18640, 18642, 18643, 19047, 19181, 19233, 19273, 19274, 19278, 19280, 19282, 19342, 19343, 19399, 19425, 19489, 19808, 19847, 19848, 19852, 19853, 19854, 19856, 19857, 19858, 19860, 19864, 19867, 19868, 19869, 20000, 20161, 20254, 20257, 20310, 20398, 20415, 20474, 20570, 20776, 20778, 20780, 20781, 20787, 20788, 20789, 20790, 20954, 21337, 21353, 21358, 21362, 21367, 21368, 21369, 21532, 21698, 21701, 21702, 21703, 21714, 21719, 21720, 21721, 21722, 21723, 21725, 21727, 21728, 21729, 21731, 21732, 21733, 21734, 21736, 21737, 21740, 21741, 21742, 21747, 21761, 21765, 21767, 21768, 21769, 21770, 21771, 21772, 21773, 21774, 21775, 21776, 21778, 21779, 21781, 21784, 21839, 21960, 21964, 21973, 21974, 21975, 21976, 21979, 21980, 22074, 22138, 22141, 22150, 22151, 22253, 22256, 22525, 22542, 22545, 22594, 22596, 22599, 22600, 22601, 22602, 22603, 22605, 22606, 22607, 22608, 22614, 22615, 22616, 22617, 22618, 22628, 22639, 22681, 22682, 22685, 22687, 22688, 22689, 22690, 22693, 22795, 22798, 22800, 22802, 22811, 22813, 22816, 22819, 22877, 22925, 22932, 23186, 23187, 23190, 23191, 23192, 23193, 23312, 23348, 23351, 23353, 23354, 23355, 23357, 23359, 23361, 23363, 23374, 23380, 23385, 23386, 23393, 23441, 23468, 23480, 23482, 23503, 23535, 23536, 23586, 23587, 23594, 23876, 23893, 23932, 23933, 24265, 24314, 24357, 24358, 24359, 24360, 24361, 24364, 24367, 24368, 24370, 24374, 24382, 24392, 24396, 24447, 24448, 24450, 24452, 24453, 24682, 24694, 24878, 24909, 24935, 24971, 24980, 24981, 24982, 24983, 24985, 25018, 25023, 25125, 25130, 25157, 25159, 25161, 25242, 25291, 25307, 25319, 25331, 25336, 25343, 25344, 25404, 25501, 25592, 25683, 25688, 25693, 25773, 25774, 25775, 25777, 25784, 25786, 25790, 25791, 25792, 25932, 25940, 25941, 25950, 25951, 26097, 26109, 26119, 26124, 26126, 26164, 26173, 26174, 26175, 26176, 26177, 26178, 26179, 26180, 26183, 26190, 26191, 26192, 26194, 26195, 26196, 26285, 26310, 26642, 26647, 26740, 26797, 26801, 26804, 26808, 26810, 26828, 26900, 26903, 26904, 26906, 26954, 26956, 27027, 27075, 27098, 27202, 27204, 27205, 27206, 27207, 27209, 27210, 27215, 27216, 27218, 27235, 27245, 27250, 27253, 27254, 27255, 27256, 27257, 27299, 27302, 27311, 27373, 27375, 27376, 27472, 27548, 27551, 27564, 27569, 27570, 27571, 27598, 27600, 27682, 27834, 27835, 27837, 27839, 27840, 27842, 28217, 28222, 28965, 28968, 28970, 28971, 28972, 28973, 28974, 28996, 29048, 29063, 29064, 29077, 29079, 29105, 29107, 29110, 29113, 29114, 29115, 29137, 29152, 29153, 29174, 29176, 29178, 29181, 29188, 29189, 29191, 29210, 29211, 29212, 29213, 29214, 29387, 29389, 29399, 29404, 29405, 29407, 30079, 30086, 30087, 30088, 30165, 30169, 30170, 30234, 30235, 30236, 30237, 30238, 30252, 30253, 30254, 30255, 30256, 30269, 30270, 30271, 30272, 30273, 30274, 30503, 30516, 30518, 30553, 30554, 30555, 30556, 30557, 30559, 30561, 30564, 30565, 30566, 30569, 30573, 30582, 30583, 30584, 30587, 30589, 30592, 30594, 30596, 30600, 30666, 30673, 30674, 30675, 30678, 30680, 30735, 30737, 30745, 30746, 30747, 30750, 30751, 30753, 30757, 30768, 30770, 30773, 30774, 30775, 30776, 30779, 30785, 30812, 30813, 30814, 30815, 30816, 30817, 30818, 30819, 30821, 31192, 31194, 31196, 31197, 31199, 31214, 31217, 31219, 31338, 31341, 31342, 31343, 31510, 31511, 31513, 31514, 31515, 31516, 31517, 31522, 31524, 31530, 31535, 31536, 31537, 31569, 31570, 31573, 31575, 31577, 31578, 31580, 31581, 31583, 31584, 31585, 31586, 31588, 31590, 31591, 31594, 31596, 31597, 31600, 31601, 31602, 31603, 31606, 31607, 31609, 31611, 31612, 31613, 31614, 31615, 31616, 31617, 31618, 31619, 31620, 31621, 31638, 31640, 31642, 31645, 31646, 31649, 31660, 31662, 31663, 31664, 31700, 31707, 31756, 31769, 31776, 31827, 31828, 31829, 31830, 31832, 31833, 31834, 31835, 31837, 31841, 31846, 31847, 31848, 31849, 31857, 31859, 31861, 31862, 31863, 31864, 31865, 31866, 31867, 31868, 31870, 31881, 31886, 31897, 31898, 31899, 31900, 31911, 31913, 31915, 31918, 31974, 32004, 32009, 32065, 32292, 32293, 32295, 32298, 32299, 32300, 32301, 32303, 32305, 32306, 32308, 32310, 32311, 32330, 32358, 32359, 32360, 32371, 32388, 32399, 32453, 32460, 32563, 32581, 32587, 32592, 32602, 32604, 32606, 32622, 32623, 32624, 32626, 32627, 32650, 32652, 32658, 32659, 32668, 32669, 32670, 32676, 32677, 32679, 32824, 32828, 32829, 32833, 32842, 32843, 32904, 32905, 32906, 32909, 32910, 32916, 32917, 33036, 33038, 33055, 33221, 33223, 33224, 33225, 33227, 33228, 33247, 33249, 33250, 33251, 33256, 33257, 33258, 33259, 33260, 33261, 33262, 33263, 33264, 33265, 33266, 33267, 33268, 33269, 33270, 33271, 33272, 33273, 33292, 33293, 33294, 33316, 33317, 33318, 33320, 33327, 33329, 33335, 33379, 33382, 33384, 33387, 33388, 33389, 33398, 33411, 33412, 33430, 33431, 33432, 33436, 33439, 33442, 33472, 33490, 33558, 33690, 33691, 33692, 33693, 33694, 33695, 33697, 33698, 33701, 33702, 33703, 33704, 33705, 33706, 33707, 33708, 33709, 33710, 33712, 33713, 33722, 33728, 33870, 33871, 33872, 33873, 33874, 33875, 33876, 33879, 33883, 33884, 33898, 33901, 33902, 33903, 33905, 33923, 33951, 33954, 34027, 34028, 34031, 34033, 34034, 34069, 34112, 34113, 34114, 34237, 34248, 34257, 34258, 34259, 34260, 34261, 34262, 34263, 34264, 34266, 34267, 34268, 34269, 34274, 34275, 34283, 34284, 34285, 34286, 34287, 34288, 34289, 34293, 34294, 34295, 34296, 34297, 34298, 34299, 34300, 34302, 34303, 34304, 34305, 34306, 34308, 34309, 34310, 34311, 34312, 34313, 34314, 34315, 34316, 34317, 34320, 34346, 34417, 34421, 34427, 34437, 34439, 34464, 34561, 34617, 34620, 34621, 34629, 34660, 34740, 34795, 34988, 34997, 34998, 35008, 35009, 35010, 35011, 35015, 35039, 35040, 35050, 35051, 35053, 35055, 35061, 35063, 35066, 35101, 35106, 35121, 35152, 35174, 35180, 35181, 35183, 35184, 35222, 35224, 35225, 35226, 35227, 35228, 35312, 35313, 35314, 35315, 35316, 35317, 35455, 35458, 35462, 35466, 35468, 35469, 35471, 35473, 35487, 35494, 35500, 35502, 35503, 35504, 35506, 35508, 35510, 35511, 35512, 35513, 35514, 35516, 35523, 35524, 35525, 35527, 35528, 35529, 35530, 35531, 35534, 35535, 35536, 35538, 35542, 35543, 35545, 35546, 35549, 35552, 35555, 35557, 35578, 35605, 35606, 35608, 35609, 35611, 35612, 35613, 35614, 35615, 35616, 35617, 35620, 35621, 35622, 35623, 35624, 35626, 35627, 35628, 35629, 35630, 35631, 35632, 35633, 35634, 35635, 35637, 35638, 35639, 35640, 35641, 35642, 35643, 35644, 35645, 35646, 35647, 35655, 35740, 35742, 35749, 35750, 35754, 35755, 35760, 35800, 35801, 35872, 35876, 35920, 35923, 35999, 36000, 36010, 36052, 36053, 36057, 36064, 36127, 36128, 36130, 36146, 36147, 36148, 36149, 36152, 36153, 36159, 36160, 36163, 36165, 36166, 36168, 36172, 36173, 36176, 36177, 36178, 36224, 36228, 36238, 36242, 36243, 36245, 36247, 36249, 36250, 36251, 36252, 36254, 36256, 36259, 36270, 36294, 36295, 36355, 36390, 36391, 36419, 36420, 36425, 36431, 36433, 36473, 36479, 36485, 36489, 36492, 36493, 36494, 36535, 36546, 36548, 36622, 36631, 36633, 36641, 36643, 36644, 36645, 36711, 36756, 36757, 36806, 36810, 36812, 36814, 36820, 36853, 36862, 36901, 36908, 36912, 36915, 36920, 36923, 36963, 36978, 37109, 37111, 37115, 37189, 37209, 37210, 37211, 37227, 37273, 37309, 37310, 37311, 37312, 37313, 37315, 37316, 37317, 37318, 37322, 37323, 37324, 37326, 37327, 37398, 37439, 37505, 37506, 37507, 37508, 37509, 37510, 37511, 37512, 37513, 37514, 37515, 37516, 37517, 37518, 37519, 37520, 37718, 37719, 37720, 37740, 37750, 37752, 37937, 37998, 37999, 38000, 38019, 38020, 38021, 38026, 38027, 38076, 38077, 38078, 38079, 38087, 38107, 38108, 38122, 38124, 38125, 38126, 38127, 38132, 38266, 38310, 38323, 38324, 38326, 38327, 38328, 38329, 38331, 38332, 38350, 38383, 38384, 38385, 38386, 38387, 38388, 38389, 38390, 38391, 38392, 38393, 38394, 38413, 38513, 38516, 38531, 38532, 38533, 38534, 38535, 38536, 38860, 38866, 38868, 38869, 38892, 38893, 38910, 38927, 38964, 38975, 39050, 39055, 39059, 39061, 39063, 39064, 39066, 39068, 39073, 39161, 39209, 39212, 39217, 39218, 39429, 39431, 39432, 39434, 39435, 39436, 39437, 39438, 39508, 39511, 39554, 39621, 39625, 39627, 39640, 39641, 39760, 39761, 39762, 39763, 39764, 39765, 39766, 39767, 39776, 39777, 39778, 39948, 39949, 39950, 39951, 39952, 39953, 39960, 39961, 39962, 39964, 39965, 39969, 39976, 40480, 40481, 40835, 40836, 40837, 40841, 40842, 40843, 40844, 40845, 40846, 40847, 40848, 40900, 41132, 41178, 41243, 41400, 41401, 41402, 41403, 41404, 41405, 41406, 41407, 41408, 41409, 41410, 41411, 41412, 41413, 41414, 41415, 41416, 41417, 41418, 41419, 41420, 41421, 41422, 41423, 41424, 41426, 41427, 41428, 41429, 41431, 41432, 41433, 41434, 41435, 41436, 41437, 41438, 41439, 41440, 41441, 41442, 41443, 41444, 41445, 41446, 41447, 41448, 41449, 41450, 41451, 41452, 41453, 41455, 41471, 41472, 41473, 41474, 41475, 41476, 41477, 41478, 41479, 41481, 41482, 41483, 41484, 41485, 41486, 41487, 41488, 41489, 41490, 41491, 41492, 41493, 41494, 41495, 41496, 41497, 41498, 41499, 41500, 41501, 41502, 41503, 41504, 41505, 41507, 41508, 41509, 41510, 41511, 41512, 41513, 41514, 41515, 41516, 41517, 41518, 41519, 41520, 41521, 41522, 41523, 41524, 41525, 41526, 41527, 41528, 41529, 41530, 41531, 41532, 41533, 41534, 41535, 41536, 41537, 41538, 41539, 41540, 41541, 41542, 41543, 41544, 41545, 41546, 41547, 41548, 41549, 41550, 41551, 41552, 41553, 41554, 41555, 41556, 41557, 41558, 41559, 41560, 41561, 41562, 41563, 41564, 41565, 41566, 41567, 41568, 41569, 41570, 41571, 41572, 41573, 41574, 41575, 41576, 41577, 41578, 41579, 41580, 41581, 41582, 41583, 41827, 41828, 41829, 41830, 41831, 41832, 41833, 41834, 41835) ORDER BY p0_.discount_percent DESC LIMIT 64
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 0.13 ms 
SELECT p0_.id AS id_0, p0_.text AS text_1, p0_.color AS color_2, p0_.visible AS visible_3, p0_.priority AS priority_4, p0_.type AS type_5 FROM product_label p0_ WHERE p0_.type <> ? AND p0_.visible = 1
Parameters: 
[
  "custom"
]
View formatted query    View runnable query    Explain query
17 0.46 ms 
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.h1 AS h1_4, t0.top_banner_img AS top_banner_img_5, t0.seo_text_top AS seo_text_top_6, t0.seo_text_bottom AS seo_text_bottom_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.top_banner_img_mobile AS top_banner_img_mobile_10, t0.top_banner_url AS top_banner_url_11 FROM products_list_content t0 WHERE t0.id = ?
Parameters: 
[
  447
]
View formatted query    View runnable query    Explain query
18 0.10 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.content_head AS content_head_6 FROM ext_script t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
19 0.12 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
20 1.03 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "test"
]
View formatted query    View runnable query    Explain query
21 0.11 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
22 0.79 ms 
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters: 
[
  "test"
]
View formatted query    View runnable query    Explain query
23 0.11 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
24 0.59 ms 
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters: 
[
  "test"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
25 0.09 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
26 7.24 ms 
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME
AND c.CONSTRAINT_SCHEMA = k.TABLE_SCHEMA */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION
Parameters: 
[
  "test"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
27 0.47 ms 
SELECT       COLUMN_NAME        AS field,
       COLUMN_TYPE        AS type,
       IS_NULLABLE        AS `null`,
       COLUMN_KEY         AS `key`,
       COLUMN_DEFAULT     AS `default`,
       EXTRA,
       COLUMN_COMMENT     AS comment,
       CHARACTER_SET_NAME AS characterset,
       COLLATION_NAME     AS collation
FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters: 
[
  "test"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
28 0.11 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
29 0.19 ms 
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters: 
[
  "test"
  "doctrine_migration_versions"
]
View formatted query    View runnable query    Explain query
30 0.08 ms 
SELECT * FROM doctrine_migration_versions
Parameters: 
[]
View formatted query    View runnable query    Explain query
31 0.11 ms 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
32 0.09 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.code AS code_5, t0.sort AS sort_6, t0.help_text AS help_text_7, t0.visible AS visible_8 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "registration_bonus"
]
View formatted query    View runnable query    Explain query
33 0.08 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.code AS code_5, t0.sort AS sort_6, t0.help_text AS help_text_7, t0.visible AS visible_8 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "logo"
]
View formatted query    View runnable query    Explain query
34 0.09 ms 
SELECT c0_.id AS id_0, c0_.name AS name_1 FROM city c0_ INNER JOIN pickpoint p1_ ON c0_.id = p1_.city_id WHERE c0_.name NOT IN ('Москва', 'Санкт-Петербург', 'Екатеринбург') AND c0_.id NOT IN (1) GROUP BY c0_.id, c0_.name ORDER BY c0_.population DESC LIMIT 25
Parameters: 
[]
View formatted query    View runnable query    Explain query
35 0.10 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated_at AS updated_at_4, t0.code AS code_5, t0.sort AS sort_6, t0.help_text AS help_text_7, t0.visible AS visible_8 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "logo"
]
View formatted query    View runnable query    Explain query
36 0.10 ms 
SELECT t0.id AS id_1, t0.position AS position_2, t0.is_mobile AS is_mobile_3, t0.type, t0.object_id AS object_id_4, t0.object_id AS object_id_5 FROM catalog t0 WHERE t0.is_mobile = ? AND t0.type IN ('category', 'virtual_category') ORDER BY t0.position ASC
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
37 0.09 ms 
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.page_code AS page_code_4, t0.content AS content_5 FROM content t0 WHERE t0.page_code = ? LIMIT 1
Parameters: 
[
  "topCatalog"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Category No errors.
App\Entity\Product No errors.
App\Entity\Customer No errors.
App\Entity\City No errors.
App\Entity\Sms No errors.
App\Entity\PromoCode No errors.
App\Entity\Settings No errors.
App\Entity\Region No errors.
App\Entity\DeliveryZone No errors.
App\Entity\TransporterCode No errors.
App\Entity\PickPoint No errors.
App\Entity\Transporter No errors.
App\Entity\Promotions\AbstractPromotion No errors.
App\Entity\Promotions\ProfitSetPromotion No errors.
App\Entity\Promotions\DiscountRegisteredCustomerPromotion No errors.
App\Entity\Promotions\EvenLessPricePromotion No errors.
App\Entity\Promotions\DiscountOnProductsPromotion No errors.
App\Entity\ProductLabel No errors.
App\Entity\VirtualCategory No errors.
App\Entity\ProductsListContent No errors.
App\Entity\ProductProperty No errors.
App\Entity\Property No errors.
App\Entity\PropertyValue No errors.
App\Entity\Category1C No errors.
App\Entity\Brand No errors.
App\Entity\ProductSize No errors.
App\Entity\ProductIcon No errors.
App\Entity\ProductCertificate No errors.
App\Entity\ProductReview No errors.
App\Entity\ProductVideo No errors.
App\Entity\ProductQuestion No errors.
App\Entity\Content No errors.
App\Entity\InfoBlockLink No errors.
App\Entity\ExtScript No errors.
App\Entity\CustomerQuestion No errors.
App\Entity\Order No errors.
App\Entity\EmailLog No errors.
App\Entity\Store No errors.
App\Entity\CustomerLog No errors.
App\Entity\OrderItem No errors.
App\Entity\Address No errors.
App\Entity\OrderCalculation No errors.
App\Entity\GiftCardOrder No errors.
App\Entity\OrderTransaction No errors.
App\Entity\SiteLog No errors.
App\Entity\OrderPayment No errors.
App\Entity\GiftCard No errors.
App\Entity\GiftCardDebit No errors.
App\Entity\EmailLogEvent No errors.
App\Entity\Catalog\AbstractCatalogItem No errors.
App\Entity\Catalog\CategoryCatalogItem No errors.
App\Entity\Catalog\VirtualCategoryCatalogItem No errors.