Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

53 Database Queries

32 Different statements

141.40 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
51.19 ms (36.20%)	1	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, 41619, 41693, 41692, 41691, 41611, 41610, 41687, 41609, 41684, 41778, 41694, 41608, 41696, 41669, 41705, 41703, 41701, 41613, 37868, 41612, 37573, 26360, 41680, 41776, 41645, 41733, 41330, 41668, 41600, 41599, 41655, 41597, 32799, 41732, 41734, 37570, 32177, 41730, 41773, 41731, 41596, 41618, 41605, 41617, 41648, 41616, 41606, 41615, 41598, 41614, 37871, 41601, 41602, 41603, 41604, 41620, 41639, 41640, 41641, 41642, 41643, 41644, 41646, 41647, 41649, 41650, 41651, 41652, 41653, 41654, 41656, 41638, 41636, 41621, 41622, 41623, 41624, 41629, 41625, 41626, 41627, 41628, 41630, 41631, 41632, 41633, 41634, 41635, 41657, 41595, 37651, 37706, 37704, 37702, 37701, 37698, 37697, 37695, 37694, 37707, 37708, 37736, 37735, 37734, 37733, 37732, 37730, 37729, 37709, 37693, 37690, 37663, 37662, 37660, 37659, 37658, 37657, 37654, 37652, 37664, 37671, 37689, 37688, 37687, 37683, 37677, 37676, 37673, 37672, 37737, 37738, 37739, 38590, 38589, 38588, 38283, 38075, 38069, 38066, 38063, 41584, 41585, 41593, 41592, 41591, 41590, 41589, 41588, 41587, 41586, 37872, 37870, 37843, 37842, 37841, 37840, 37839, 37744, 37743, 37742, 37844, 37845, 37869, 37866, 37865, 37864, 37863, 37861, 37850, 37849, 41594, 41658, 41774, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41804, 41803, 41775, 41777, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41853, 41854, 41855, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41873, 41872, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41890, 41772, 41659, 41679, 41681, 41682, 41683, 41685, 41686, 41688, 41689, 41690, 41695, 41697, 41698, 41699, 41700, 41702, 41704, 41678, 41677, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41707, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41706, 41708, 41709, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41738, 41737, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41735, 41736, 41755, 37650, 21420, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26294, 26293, 25875, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26714, 26767, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 31800, 31799, 31647, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 32681, 21419, 940, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10742, 10741, 10740, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 8781, 9143, 9152, 10726, 10731, 10732, 10734, 10809, 11031, 19505, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 17970, 17591, 17574, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 21415, 37282, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37571, 37572, 37574, 37538, 37537, 37534, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37414, 37527, 37532, 37575, 37576, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37618, 37612, 37610, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37647, 37281, 32685, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33283, 33475, 33500, 33536, 33584, 33596, 33597, 32928, 32926, 32925, 32686, 32688, 32690, 32694, 32695, 32698, 32699, 32723, 32744, 32867, 32868, 32907, 32919, 32920, 32921, 32923, 32924, 33598, 33600, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 36880, 36877, 36876, 33601, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 33942, 36128, 36859, 36860, 36863, 36864, 37280) Parameters: [] View formatted query View runnable query Explain query 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, 41619, 41693, 41692, 41691, 41611, 41610, 41687, 41609, 41684, 41778, 41694, 41608, 41696, 41669, 41705, 41703, 41701, 41613, 37868, 41612, 37573, 26360, 41680, 41776, 41645, 41733, 41330, 41668, 41600, 41599, 41655, 41597, 32799, 41732, 41734, 37570, 32177, 41730, 41773, 41731, 41596, 41618, 41605, 41617, 41648, 41616, 41606, 41615, 41598, 41614, 37871, 41601, 41602, 41603, 41604, 41620, 41639, 41640, 41641, 41642, 41643, 41644, 41646, 41647, 41649, 41650, 41651, 41652, 41653, 41654, 41656, 41638, 41636, 41621, 41622, 41623, 41624, 41629, 41625, 41626, 41627, 41628, 41630, 41631, 41632, 41633, 41634, 41635, 41657, 41595, 37651, 37706, 37704, 37702, 37701, 37698, 37697, 37695, 37694, 37707, 37708, 37736, 37735, 37734, 37733, 37732, 37730, 37729, 37709, 37693, 37690, 37663, 37662, 37660, 37659, 37658, 37657, 37654, 37652, 37664, 37671, 37689, 37688, 37687, 37683, 37677, 37676, 37673, 37672, 37737, 37738, 37739, 38590, 38589, 38588, 38283, 38075, 38069, 38066, 38063, 41584, 41585, 41593, 41592, 41591, 41590, 41589, 41588, 41587, 41586, 37872, 37870, 37843, 37842, 37841, 37840, 37839, 37744, 37743, 37742, 37844, 37845, 37869, 37866, 37865, 37864, 37863, 37861, 37850, 37849, 41594, 41658, 41774, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41804, 41803, 41775, 41777, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41853, 41854, 41855, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41873, 41872, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41890, 41772, 41659, 41679, 41681, 41682, 41683, 41685, 41686, 41688, 41689, 41690, 41695, 41697, 41698, 41699, 41700, 41702, 41704, 41678, 41677, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41707, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41706, 41708, 41709, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41738, 41737, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41735, 41736, 41755, 37650, 21420, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26294, 26293, 25875, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26714, 26767, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 31800, 31799, 31647, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 32681, 21419, 940, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10742, 10741, 10740, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 8781, 9143, 9152, 10726, 10731, 10732, 10734, 10809, 11031, 19505, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 17970, 17591, 17574, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 21415, 37282, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37571, 37572, 37574, 37538, 37537, 37534, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37414, 37527, 37532, 37575, 37576, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37618, 37612, 37610, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37647, 37281, 32685, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33283, 33475, 33500, 33536, 33584, 33596, 33597, 32928, 32926, 32925, 32686, 32688, 32690, 32694, 32695, 32698, 32699, 32723, 32744, 32867, 32868, 32907, 32919, 32920, 32921, 32923, 32924, 33598, 33600, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 36880, 36877, 36876, 33601, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 33942, 36128, 36859, 36860, 36863, 36864, 37280 ) 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, 41619, 41693, 41692, 41691, 41611, 41610, 41687, 41609, 41684, 41778, 41694, 41608, 41696, 41669, 41705, 41703, 41701, 41613, 37868, 41612, 37573, 26360, 41680, 41776, 41645, 41733, 41330, 41668, 41600, 41599, 41655, 41597, 32799, 41732, 41734, 37570, 32177, 41730, 41773, 41731, 41596, 41618, 41605, 41617, 41648, 41616, 41606, 41615, 41598, 41614, 37871, 41601, 41602, 41603, 41604, 41620, 41639, 41640, 41641, 41642, 41643, 41644, 41646, 41647, 41649, 41650, 41651, 41652, 41653, 41654, 41656, 41638, 41636, 41621, 41622, 41623, 41624, 41629, 41625, 41626, 41627, 41628, 41630, 41631, 41632, 41633, 41634, 41635, 41657, 41595, 37651, 37706, 37704, 37702, 37701, 37698, 37697, 37695, 37694, 37707, 37708, 37736, 37735, 37734, 37733, 37732, 37730, 37729, 37709, 37693, 37690, 37663, 37662, 37660, 37659, 37658, 37657, 37654, 37652, 37664, 37671, 37689, 37688, 37687, 37683, 37677, 37676, 37673, 37672, 37737, 37738, 37739, 38590, 38589, 38588, 38283, 38075, 38069, 38066, 38063, 41584, 41585, 41593, 41592, 41591, 41590, 41589, 41588, 41587, 41586, 37872, 37870, 37843, 37842, 37841, 37840, 37839, 37744, 37743, 37742, 37844, 37845, 37869, 37866, 37865, 37864, 37863, 37861, 37850, 37849, 41594, 41658, 41774, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41804, 41803, 41775, 41777, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41853, 41854, 41855, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41873, 41872, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41890, 41772, 41659, 41679, 41681, 41682, 41683, 41685, 41686, 41688, 41689, 41690, 41695, 41697, 41698, 41699, 41700, 41702, 41704, 41678, 41677, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41707, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41706, 41708, 41709, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41738, 41737, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41735, 41736, 41755, 37650, 21420, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26294, 26293, 25875, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26714, 26767, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 31800, 31799, 31647, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 32681, 21419, 940, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10742, 10741, 10740, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 8781, 9143, 9152, 10726, 10731, 10732, 10734, 10809, 11031, 19505, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 17970, 17591, 17574, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 21415, 37282, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37571, 37572, 37574, 37538, 37537, 37534, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37414, 37527, 37532, 37575, 37576, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37618, 37612, 37610, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37647, 37281, 32685, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33283, 33475, 33500, 33536, 33584, 33596, 33597, 32928, 32926, 32925, 32686, 32688, 32690, 32694, 32695, 32698, 32699, 32723, 32744, 32867, 32868, 32907, 32919, 32920, 32921, 32923, 32924, 33598, 33600, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 36880, 36877, 36876, 33601, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 33942, 36128, 36859, 36860, 36863, 36864, 37280);
30.54 ms (21.60%)	1	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, 41619, 41693, 41692, 41691, 41611, 41610, 41687, 41609, 41684, 41778, 41694, 41608, 41696, 41669, 41705, 41703, 41701, 41613, 37868, 41612, 37573, 26360, 41680, 41776, 41645, 41733, 41330, 41668, 41600, 41599, 41655, 41597, 32799, 41732, 41734, 37570, 32177, 41730, 41773, 41731, 41596, 41618, 41605, 41617, 41648, 41616, 41606, 41615, 41598, 41614, 37871, 41601, 41602, 41603, 41604, 41620, 41639, 41640, 41641, 41642, 41643, 41644, 41646, 41647, 41649, 41650, 41651, 41652, 41653, 41654, 41656, 41638, 41636, 41621, 41622, 41623, 41624, 41629, 41625, 41626, 41627, 41628, 41630, 41631, 41632, 41633, 41634, 41635, 41657, 41595, 37651, 37706, 37704, 37702, 37701, 37698, 37697, 37695, 37694, 37707, 37708, 37736, 37735, 37734, 37733, 37732, 37730, 37729, 37709, 37693, 37690, 37663, 37662, 37660, 37659, 37658, 37657, 37654, 37652, 37664, 37671, 37689, 37688, 37687, 37683, 37677, 37676, 37673, 37672, 37737, 37738, 37739, 38590, 38589, 38588, 38283, 38075, 38069, 38066, 38063, 41584, 41585, 41593, 41592, 41591, 41590, 41589, 41588, 41587, 41586, 37872, 37870, 37843, 37842, 37841, 37840, 37839, 37744, 37743, 37742, 37844, 37845, 37869, 37866, 37865, 37864, 37863, 37861, 37850, 37849, 41594, 41658, 41774, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41804, 41803, 41775, 41777, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41853, 41854, 41855, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41873, 41872, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41890, 41772, 41659, 41679, 41681, 41682, 41683, 41685, 41686, 41688, 41689, 41690, 41695, 41697, 41698, 41699, 41700, 41702, 41704, 41678, 41677, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41707, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41706, 41708, 41709, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41738, 41737, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41735, 41736, 41755, 37650, 21420, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26294, 26293, 25875, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26714, 26767, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 31800, 31799, 31647, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 32681, 21419, 940, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10742, 10741, 10740, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 8781, 9143, 9152, 10726, 10731, 10732, 10734, 10809, 11031, 19505, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 17970, 17591, 17574, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 21415, 37282, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37571, 37572, 37574, 37538, 37537, 37534, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37414, 37527, 37532, 37575, 37576, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37618, 37612, 37610, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37647, 37281, 32685, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33283, 33475, 33500, 33536, 33584, 33596, 33597, 32928, 32926, 32925, 32686, 32688, 32690, 32694, 32695, 32698, 32699, 32723, 32744, 32867, 32868, 32907, 32919, 32920, 32921, 32923, 32924, 33598, 33600, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 36880, 36877, 36876, 33601, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 33942, 36128, 36859, 36860, 36863, 36864, 37280) Parameters: [] View formatted query View runnable query Explain query 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, 41619, 41693, 41692, 41691, 41611, 41610, 41687, 41609, 41684, 41778, 41694, 41608, 41696, 41669, 41705, 41703, 41701, 41613, 37868, 41612, 37573, 26360, 41680, 41776, 41645, 41733, 41330, 41668, 41600, 41599, 41655, 41597, 32799, 41732, 41734, 37570, 32177, 41730, 41773, 41731, 41596, 41618, 41605, 41617, 41648, 41616, 41606, 41615, 41598, 41614, 37871, 41601, 41602, 41603, 41604, 41620, 41639, 41640, 41641, 41642, 41643, 41644, 41646, 41647, 41649, 41650, 41651, 41652, 41653, 41654, 41656, 41638, 41636, 41621, 41622, 41623, 41624, 41629, 41625, 41626, 41627, 41628, 41630, 41631, 41632, 41633, 41634, 41635, 41657, 41595, 37651, 37706, 37704, 37702, 37701, 37698, 37697, 37695, 37694, 37707, 37708, 37736, 37735, 37734, 37733, 37732, 37730, 37729, 37709, 37693, 37690, 37663, 37662, 37660, 37659, 37658, 37657, 37654, 37652, 37664, 37671, 37689, 37688, 37687, 37683, 37677, 37676, 37673, 37672, 37737, 37738, 37739, 38590, 38589, 38588, 38283, 38075, 38069, 38066, 38063, 41584, 41585, 41593, 41592, 41591, 41590, 41589, 41588, 41587, 41586, 37872, 37870, 37843, 37842, 37841, 37840, 37839, 37744, 37743, 37742, 37844, 37845, 37869, 37866, 37865, 37864, 37863, 37861, 37850, 37849, 41594, 41658, 41774, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41804, 41803, 41775, 41777, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41853, 41854, 41855, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41873, 41872, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41890, 41772, 41659, 41679, 41681, 41682, 41683, 41685, 41686, 41688, 41689, 41690, 41695, 41697, 41698, 41699, 41700, 41702, 41704, 41678, 41677, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41707, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41706, 41708, 41709, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41738, 41737, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41735, 41736, 41755, 37650, 21420, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26294, 26293, 25875, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26714, 26767, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 31800, 31799, 31647, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 32681, 21419, 940, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10742, 10741, 10740, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 8781, 9143, 9152, 10726, 10731, 10732, 10734, 10809, 11031, 19505, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 17970, 17591, 17574, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 21415, 37282, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37571, 37572, 37574, 37538, 37537, 37534, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37414, 37527, 37532, 37575, 37576, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37618, 37612, 37610, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37647, 37281, 32685, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33283, 33475, 33500, 33536, 33584, 33596, 33597, 32928, 32926, 32925, 32686, 32688, 32690, 32694, 32695, 32698, 32699, 32723, 32744, 32867, 32868, 32907, 32919, 32920, 32921, 32923, 32924, 33598, 33600, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 36880, 36877, 36876, 33601, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 33942, 36128, 36859, 36860, 36863, 36864, 37280 ) 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, 41619, 41693, 41692, 41691, 41611, 41610, 41687, 41609, 41684, 41778, 41694, 41608, 41696, 41669, 41705, 41703, 41701, 41613, 37868, 41612, 37573, 26360, 41680, 41776, 41645, 41733, 41330, 41668, 41600, 41599, 41655, 41597, 32799, 41732, 41734, 37570, 32177, 41730, 41773, 41731, 41596, 41618, 41605, 41617, 41648, 41616, 41606, 41615, 41598, 41614, 37871, 41601, 41602, 41603, 41604, 41620, 41639, 41640, 41641, 41642, 41643, 41644, 41646, 41647, 41649, 41650, 41651, 41652, 41653, 41654, 41656, 41638, 41636, 41621, 41622, 41623, 41624, 41629, 41625, 41626, 41627, 41628, 41630, 41631, 41632, 41633, 41634, 41635, 41657, 41595, 37651, 37706, 37704, 37702, 37701, 37698, 37697, 37695, 37694, 37707, 37708, 37736, 37735, 37734, 37733, 37732, 37730, 37729, 37709, 37693, 37690, 37663, 37662, 37660, 37659, 37658, 37657, 37654, 37652, 37664, 37671, 37689, 37688, 37687, 37683, 37677, 37676, 37673, 37672, 37737, 37738, 37739, 38590, 38589, 38588, 38283, 38075, 38069, 38066, 38063, 41584, 41585, 41593, 41592, 41591, 41590, 41589, 41588, 41587, 41586, 37872, 37870, 37843, 37842, 37841, 37840, 37839, 37744, 37743, 37742, 37844, 37845, 37869, 37866, 37865, 37864, 37863, 37861, 37850, 37849, 41594, 41658, 41774, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41804, 41803, 41775, 41777, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41853, 41854, 41855, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41873, 41872, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41890, 41772, 41659, 41679, 41681, 41682, 41683, 41685, 41686, 41688, 41689, 41690, 41695, 41697, 41698, 41699, 41700, 41702, 41704, 41678, 41677, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41707, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41706, 41708, 41709, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41738, 41737, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41735, 41736, 41755, 37650, 21420, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26294, 26293, 25875, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26714, 26767, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 31800, 31799, 31647, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 32681, 21419, 940, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10742, 10741, 10740, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 8781, 9143, 9152, 10726, 10731, 10732, 10734, 10809, 11031, 19505, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 17970, 17591, 17574, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 21415, 37282, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37571, 37572, 37574, 37538, 37537, 37534, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37414, 37527, 37532, 37575, 37576, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37618, 37612, 37610, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37647, 37281, 32685, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33283, 33475, 33500, 33536, 33584, 33596, 33597, 32928, 32926, 32925, 32686, 32688, 32690, 32694, 32695, 32698, 32699, 32723, 32744, 32867, 32868, 32907, 32919, 32920, 32921, 32923, 32924, 33598, 33600, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 36880, 36877, 36876, 33601, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 33942, 36128, 36859, 36860, 36863, 36864, 37280);
25.47 ms (18.01%)	1	SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND (p0_.id IN ('37416', '37421', '37418', '37420', '37417', '33538', '33536', '37422', '37415', '37414', '33233', '33210', '32920', '32922', '33546', '33545', '33544', '33543', '33583', '33581', '33582', '33580', '33561', '33599', '33601', '33600', '33597', '33598', '33596', '33280', '33500', '33506', '33505', '33501', '33447', '33491', '33492', '33493', '33503', '33502', '33504', '33508', '33507', '33510', '33509', '33475', '33474', '33448', '33449', '33450', '33451', '33524', '33523', '33522', '33521', '33211', '33215', '33234', '33217', '33216', '33215', '33214', '33213', '25874', '25875', '25873', '25872', '32930', '32929', '32928', '32927', '32926', '32925', '32924', '32047', '32046', '32047', '32046', '32695', '32686', '32685', '32681', '32696', '32698', '32699', '32821', '32820', '32819', '32818', '32817', '32816', '32815', '32814', '32813', '32812', '32869', '26369', '31289', '32870', '32868', '32867', '32866', '31297', '26368', '26367', '31294', '31293', '31292', '31291', '31290', '32761', '32760', '32759', '32758', '32757', '32756', '32755', '32754', '32753', '32752', '32751', '32750', '32749', '32748', '32747', '32746', '32745', '32726', '32725', '32724', '32723', '32722', '32721', '32720', '32719', '32718', '32717', '32744', '32743', '32742', '32716', '32715', '32714', '32713', '32571', '32570', '32569', '32568', '32567', '32566', '26415', '26414', '25608', '25633', '25607', '25634', '33942', '33367', '29180', '36128', '33246', '32709', '19505', '8781', '8759', '8756', '33940', '33365', '32799', '33362') OR p0_.category1c_id IN ('395', '48834', '51975', '681', '40', '52765', '133', '88', '44190', '1604892', '750119', '212', '222751', '65', '57', '222743', '161671', '776773', '1174859', '776774', '1210218', '706656', '706657', '60687', '1201058', '1201060', '809140', '770581', '753170', '63081', '63080', '46', '1615056', '1615057', '1615054', '1615055', '117', '87', '224', '222', '781958', '742018', '777809', '786123', '786121', '786122', '1174851', '190', '88911', '63079', '137', '802837', '809139', '809138', '464446', '697603', '1174864', '1174852', '542', '111028', '677', '186', '41', '42', '43', '58305', '52763', '1180542', '1180543', '770582', '414628', '425202', '1607055', '1174854', '1174853', '1174857', '1174855', '1174856', '1607057', '1607056', '425200', '425201', '72666', '239', '1174860', '1174861', '1174862', '1174863', '772643', '811249', '73473', '73470', '811248', '73475', '830318', '811250', '772641', '772642', '128006', '242', '109', '244', '243', '245', '69', '47279', '595', '48057', '48055', '1607053', '1607054', '63078', '676', '1607058', '543', '544', '70', '63082', '85', '118', '464', '426968', '426969', '426970', '390975', '49616', '603', '602', '240', '664', '501', '672', '63876', '673', '125', '63084', '72667', '1180541', '442051', '465345', '442050', '523', '267', '1174858', '801791', '61482', '111026', '111027', '115', '678', '61483', '228', '2099', '395333', '693', '61484', '72665', '199', '121', '461', '1201059')) Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND ( p0_.id IN ( '37416', '37421', '37418', '37420', '37417', '33538', '33536', '37422', '37415', '37414', '33233', '33210', '32920', '32922', '33546', '33545', '33544', '33543', '33583', '33581', '33582', '33580', '33561', '33599', '33601', '33600', '33597', '33598', '33596', '33280', '33500', '33506', '33505', '33501', '33447', '33491', '33492', '33493', '33503', '33502', '33504', '33508', '33507', '33510', '33509', '33475', '33474', '33448', '33449', '33450', '33451', '33524', '33523', '33522', '33521', '33211', '33215', '33234', '33217', '33216', '33215', '33214', '33213', '25874', '25875', '25873', '25872', '32930', '32929', '32928', '32927', '32926', '32925', '32924', '32047', '32046', '32047', '32046', '32695', '32686', '32685', '32681', '32696', '32698', '32699', '32821', '32820', '32819', '32818', '32817', '32816', '32815', '32814', '32813', '32812', '32869', '26369', '31289', '32870', '32868', '32867', '32866', '31297', '26368', '26367', '31294', '31293', '31292', '31291', '31290', '32761', '32760', '32759', '32758', '32757', '32756', '32755', '32754', '32753', '32752', '32751', '32750', '32749', '32748', '32747', '32746', '32745', '32726', '32725', '32724', '32723', '32722', '32721', '32720', '32719', '32718', '32717', '32744', '32743', '32742', '32716', '32715', '32714', '32713', '32571', '32570', '32569', '32568', '32567', '32566', '26415', '26414', '25608', '25633', '25607', '25634', '33942', '33367', '29180', '36128', '33246', '32709', '19505', '8781', '8759', '8756', '33940', '33365', '32799', '33362' ) OR p0_.category1c_id IN ( '395', '48834', '51975', '681', '40', '52765', '133', '88', '44190', '1604892', '750119', '212', '222751', '65', '57', '222743', '161671', '776773', '1174859', '776774', '1210218', '706656', '706657', '60687', '1201058', '1201060', '809140', '770581', '753170', '63081', '63080', '46', '1615056', '1615057', '1615054', '1615055', '117', '87', '224', '222', '781958', '742018', '777809', '786123', '786121', '786122', '1174851', '190', '88911', '63079', '137', '802837', '809139', '809138', '464446', '697603', '1174864', '1174852', '542', '111028', '677', '186', '41', '42', '43', '58305', '52763', '1180542', '1180543', '770582', '414628', '425202', '1607055', '1174854', '1174853', '1174857', '1174855', '1174856', '1607057', '1607056', '425200', '425201', '72666', '239', '1174860', '1174861', '1174862', '1174863', '772643', '811249', '73473', '73470', '811248', '73475', '830318', '811250', '772641', '772642', '128006', '242', '109', '244', '243', '245', '69', '47279', '595', '48057', '48055', '1607053', '1607054', '63078', '676', '1607058', '543', '544', '70', '63082', '85', '118', '464', '426968', '426969', '426970', '390975', '49616', '603', '602', '240', '664', '501', '672', '63876', '673', '125', '63084', '72667', '1180541', '442051', '465345', '442050', '523', '267', '1174858', '801791', '61482', '111026', '111027', '115', '678', '61483', '228', '2099', '395333', '693', '61484', '72665', '199', '121', '461', '1201059' ) ) SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND (p0_.id IN ('37416', '37421', '37418', '37420', '37417', '33538', '33536', '37422', '37415', '37414', '33233', '33210', '32920', '32922', '33546', '33545', '33544', '33543', '33583', '33581', '33582', '33580', '33561', '33599', '33601', '33600', '33597', '33598', '33596', '33280', '33500', '33506', '33505', '33501', '33447', '33491', '33492', '33493', '33503', '33502', '33504', '33508', '33507', '33510', '33509', '33475', '33474', '33448', '33449', '33450', '33451', '33524', '33523', '33522', '33521', '33211', '33215', '33234', '33217', '33216', '33215', '33214', '33213', '25874', '25875', '25873', '25872', '32930', '32929', '32928', '32927', '32926', '32925', '32924', '32047', '32046', '32047', '32046', '32695', '32686', '32685', '32681', '32696', '32698', '32699', '32821', '32820', '32819', '32818', '32817', '32816', '32815', '32814', '32813', '32812', '32869', '26369', '31289', '32870', '32868', '32867', '32866', '31297', '26368', '26367', '31294', '31293', '31292', '31291', '31290', '32761', '32760', '32759', '32758', '32757', '32756', '32755', '32754', '32753', '32752', '32751', '32750', '32749', '32748', '32747', '32746', '32745', '32726', '32725', '32724', '32723', '32722', '32721', '32720', '32719', '32718', '32717', '32744', '32743', '32742', '32716', '32715', '32714', '32713', '32571', '32570', '32569', '32568', '32567', '32566', '26415', '26414', '25608', '25633', '25607', '25634', '33942', '33367', '29180', '36128', '33246', '32709', '19505', '8781', '8759', '8756', '33940', '33365', '32799', '33362') OR p0_.category1c_id IN ('395', '48834', '51975', '681', '40', '52765', '133', '88', '44190', '1604892', '750119', '212', '222751', '65', '57', '222743', '161671', '776773', '1174859', '776774', '1210218', '706656', '706657', '60687', '1201058', '1201060', '809140', '770581', '753170', '63081', '63080', '46', '1615056', '1615057', '1615054', '1615055', '117', '87', '224', '222', '781958', '742018', '777809', '786123', '786121', '786122', '1174851', '190', '88911', '63079', '137', '802837', '809139', '809138', '464446', '697603', '1174864', '1174852', '542', '111028', '677', '186', '41', '42', '43', '58305', '52763', '1180542', '1180543', '770582', '414628', '425202', '1607055', '1174854', '1174853', '1174857', '1174855', '1174856', '1607057', '1607056', '425200', '425201', '72666', '239', '1174860', '1174861', '1174862', '1174863', '772643', '811249', '73473', '73470', '811248', '73475', '830318', '811250', '772641', '772642', '128006', '242', '109', '244', '243', '245', '69', '47279', '595', '48057', '48055', '1607053', '1607054', '63078', '676', '1607058', '543', '544', '70', '63082', '85', '118', '464', '426968', '426969', '426970', '390975', '49616', '603', '602', '240', '664', '501', '672', '63876', '673', '125', '63084', '72667', '1180541', '442051', '465345', '442050', '523', '267', '1174858', '801791', '61482', '111026', '111027', '115', '678', '61483', '228', '2099', '395333', '693', '61484', '72665', '199', '121', '461', '1201059'));
7.20 ms (5.09%)	1	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 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 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 = 'test' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION;
4.61 ms (3.26%)	1	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, 41619, 41693, 41692, 41691, 41611, 41610, 41687, 41609, 41684, 41778, 41694, 41608, 41696, 41669, 41705, 41703, 41701, 41613, 37868, 41612, 37573, 26360, 41680, 41776, 41645, 41733, 41330, 41668, 41600, 41599, 41655, 41597, 32799, 41732, 41734, 37570, 32177, 41730, 41773, 41731, 41596, 41618, 41605, 41617, 41648, 41616, 41606, 41615, 41598, 41614, 37871, 41601, 41602, 41603, 41604, 41620, 41639, 41640, 41641, 41642, 41643, 41644, 41646, 41647, 41649, 41650, 41651, 41652, 41653, 41654, 41656, 41638, 41636, 41621, 41622, 41623, 41624, 41629, 41625, 41626, 41627, 41628, 41630, 41631, 41632, 41633, 41634, 41635, 41657, 41595, 37651, 37706, 37704, 37702, 37701, 37698, 37697, 37695, 37694, 37707, 37708, 37736, 37735, 37734, 37733, 37732, 37730, 37729, 37709, 37693, 37690, 37663, 37662, 37660, 37659, 37658, 37657, 37654, 37652, 37664, 37671, 37689, 37688, 37687, 37683, 37677, 37676, 37673, 37672, 37737, 37738, 37739, 38590, 38589, 38588, 38283, 38075, 38069, 38066, 38063, 41584, 41585, 41593, 41592, 41591, 41590, 41589, 41588, 41587, 41586, 37872, 37870, 37843, 37842, 37841, 37840, 37839, 37744, 37743, 37742, 37844, 37845, 37869, 37866, 37865, 37864, 37863, 37861, 37850, 37849, 41594, 41658, 41774, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41804, 41803, 41775, 41777, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41853, 41854, 41855, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41873, 41872, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41890, 41772, 41659, 41679, 41681, 41682, 41683, 41685, 41686, 41688, 41689, 41690, 41695, 41697, 41698, 41699, 41700, 41702, 41704, 41678, 41677, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41707, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41706, 41708, 41709, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41738, 41737, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41735, 41736, 41755, 37650, 21420, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26294, 26293, 25875, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26714, 26767, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 31800, 31799, 31647, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 32681, 21419, 940, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10742, 10741, 10740, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 8781, 9143, 9152, 10726, 10731, 10732, 10734, 10809, 11031, 19505, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 17970, 17591, 17574, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 21415, 37282, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37571, 37572, 37574, 37538, 37537, 37534, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37414, 37527, 37532, 37575, 37576, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37618, 37612, 37610, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37647, 37281, 32685, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33283, 33475, 33500, 33536, 33584, 33596, 33597, 32928, 32926, 32925, 32686, 32688, 32690, 32694, 32695, 32698, 32699, 32723, 32744, 32867, 32868, 32907, 32919, 32920, 32921, 32923, 32924, 33598, 33600, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 36880, 36877, 36876, 33601, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 33942, 36128, 36859, 36860, 36863, 36864, 37280) Parameters: [] View formatted query View runnable query Explain query 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, 41619, 41693, 41692, 41691, 41611, 41610, 41687, 41609, 41684, 41778, 41694, 41608, 41696, 41669, 41705, 41703, 41701, 41613, 37868, 41612, 37573, 26360, 41680, 41776, 41645, 41733, 41330, 41668, 41600, 41599, 41655, 41597, 32799, 41732, 41734, 37570, 32177, 41730, 41773, 41731, 41596, 41618, 41605, 41617, 41648, 41616, 41606, 41615, 41598, 41614, 37871, 41601, 41602, 41603, 41604, 41620, 41639, 41640, 41641, 41642, 41643, 41644, 41646, 41647, 41649, 41650, 41651, 41652, 41653, 41654, 41656, 41638, 41636, 41621, 41622, 41623, 41624, 41629, 41625, 41626, 41627, 41628, 41630, 41631, 41632, 41633, 41634, 41635, 41657, 41595, 37651, 37706, 37704, 37702, 37701, 37698, 37697, 37695, 37694, 37707, 37708, 37736, 37735, 37734, 37733, 37732, 37730, 37729, 37709, 37693, 37690, 37663, 37662, 37660, 37659, 37658, 37657, 37654, 37652, 37664, 37671, 37689, 37688, 37687, 37683, 37677, 37676, 37673, 37672, 37737, 37738, 37739, 38590, 38589, 38588, 38283, 38075, 38069, 38066, 38063, 41584, 41585, 41593, 41592, 41591, 41590, 41589, 41588, 41587, 41586, 37872, 37870, 37843, 37842, 37841, 37840, 37839, 37744, 37743, 37742, 37844, 37845, 37869, 37866, 37865, 37864, 37863, 37861, 37850, 37849, 41594, 41658, 41774, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41804, 41803, 41775, 41777, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41853, 41854, 41855, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41873, 41872, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41890, 41772, 41659, 41679, 41681, 41682, 41683, 41685, 41686, 41688, 41689, 41690, 41695, 41697, 41698, 41699, 41700, 41702, 41704, 41678, 41677, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41707, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41706, 41708, 41709, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41738, 41737, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41735, 41736, 41755, 37650, 21420, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26294, 26293, 25875, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26714, 26767, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 31800, 31799, 31647, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 32681, 21419, 940, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10742, 10741, 10740, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 8781, 9143, 9152, 10726, 10731, 10732, 10734, 10809, 11031, 19505, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 17970, 17591, 17574, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 21415, 37282, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37571, 37572, 37574, 37538, 37537, 37534, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37414, 37527, 37532, 37575, 37576, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37618, 37612, 37610, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37647, 37281, 32685, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33283, 33475, 33500, 33536, 33584, 33596, 33597, 32928, 32926, 32925, 32686, 32688, 32690, 32694, 32695, 32698, 32699, 32723, 32744, 32867, 32868, 32907, 32919, 32920, 32921, 32923, 32924, 33598, 33600, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 36880, 36877, 36876, 33601, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 33942, 36128, 36859, 36860, 36863, 36864, 37280 ) 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, 41619, 41693, 41692, 41691, 41611, 41610, 41687, 41609, 41684, 41778, 41694, 41608, 41696, 41669, 41705, 41703, 41701, 41613, 37868, 41612, 37573, 26360, 41680, 41776, 41645, 41733, 41330, 41668, 41600, 41599, 41655, 41597, 32799, 41732, 41734, 37570, 32177, 41730, 41773, 41731, 41596, 41618, 41605, 41617, 41648, 41616, 41606, 41615, 41598, 41614, 37871, 41601, 41602, 41603, 41604, 41620, 41639, 41640, 41641, 41642, 41643, 41644, 41646, 41647, 41649, 41650, 41651, 41652, 41653, 41654, 41656, 41638, 41636, 41621, 41622, 41623, 41624, 41629, 41625, 41626, 41627, 41628, 41630, 41631, 41632, 41633, 41634, 41635, 41657, 41595, 37651, 37706, 37704, 37702, 37701, 37698, 37697, 37695, 37694, 37707, 37708, 37736, 37735, 37734, 37733, 37732, 37730, 37729, 37709, 37693, 37690, 37663, 37662, 37660, 37659, 37658, 37657, 37654, 37652, 37664, 37671, 37689, 37688, 37687, 37683, 37677, 37676, 37673, 37672, 37737, 37738, 37739, 38590, 38589, 38588, 38283, 38075, 38069, 38066, 38063, 41584, 41585, 41593, 41592, 41591, 41590, 41589, 41588, 41587, 41586, 37872, 37870, 37843, 37842, 37841, 37840, 37839, 37744, 37743, 37742, 37844, 37845, 37869, 37866, 37865, 37864, 37863, 37861, 37850, 37849, 41594, 41658, 41774, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41804, 41803, 41775, 41777, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41853, 41854, 41855, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41873, 41872, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41890, 41772, 41659, 41679, 41681, 41682, 41683, 41685, 41686, 41688, 41689, 41690, 41695, 41697, 41698, 41699, 41700, 41702, 41704, 41678, 41677, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41707, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41706, 41708, 41709, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41738, 41737, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41735, 41736, 41755, 37650, 21420, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26294, 26293, 25875, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26714, 26767, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 31800, 31799, 31647, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 32681, 21419, 940, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10742, 10741, 10740, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 8781, 9143, 9152, 10726, 10731, 10732, 10734, 10809, 11031, 19505, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 17970, 17591, 17574, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 21415, 37282, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37571, 37572, 37574, 37538, 37537, 37534, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37414, 37527, 37532, 37575, 37576, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37618, 37612, 37610, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37647, 37281, 32685, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33283, 33475, 33500, 33536, 33584, 33596, 33597, 32928, 32926, 32925, 32686, 32688, 32690, 32694, 32695, 32698, 32699, 32723, 32744, 32867, 32868, 32907, 32919, 32920, 32921, 32923, 32924, 33598, 33600, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 36880, 36877, 36876, 33601, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 33942, 36128, 36859, 36860, 36863, 36864, 37280);
3.50 ms (2.48%)	1	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 (940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414) ORDER BY p0_.is_hit DESC) dctrn_result) dctrn_table Parameters: [] View formatted query View runnable query Explain query 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 ( 940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414 ) ORDER BY p0_.is_hit DESC ) dctrn_result ) dctrn_table 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 (940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414) ORDER BY p0_.is_hit DESC) dctrn_result) dctrn_table;
3.44 ms (2.43%)	1	SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (7, 1848, 1854, 931, 5426, 157, 24764, 3841373, 808783, 3837980, 2566, 3840957, 3840196, 3839899, 1815050, 3840960, 3840260, 3840475, 475, 516, 3838827, 4895, 3847112, 3847115, 5669, 3837927, 4140, 8, 926, 465, 808764, 1214, 137, 1182, 3839569, 3839574, 3839560, 3839561, 3839668, 3839586, 3839611, 3839662, 3839617, 3839595, 3839570, 3839661, 3839634, 3839604, 3839573, 3839616, 3839578, 3839636, 3839606, 3839702, 3840976, 3840317, 3839715, 3841090, 3841096, 3839637, 3840200, 3841396, 3839568, 3843980, 3843986, 3839703, 3844166, 3844221, 3844252, 3847012, 3839610, 3839672, 3839629, 3847122, 3839701, 3839678, 3839576, 833, 1845, 1852, 3011, 3012, 3841170, 3844304, 3844308, 5424, 5436, 5507, 3844312, 3847044, 3838030, 3838671, 7719, 7722, 7912, 3847062, 7931, 7939, 8028, 3841122, 3838693, 547741, 3844137, 547755, 547758, 6300, 547781, 7733, 3838031, 547797, 3026, 643404, 643405, 808779, 1099889, 3844299, 1350284, 1405786, 3838514, 3837716, 3837717, 3837718, 3838590, 3838591, 3838592, 3838593, 4422, 2920189, 3838529, 3837963, 3838597, 3838569, 3847226, 3847227, 3838512, 3837992, 3837994, 3838531, 3847228, 3838344, 3837740, 3837996, 3838538, 3838539, 3838543, 3847170, 3838675, 3838676, 3838682, 3840336, 3840338, 3837713, 3840345, 3840346, 3840349, 3840350, 3840351, 3840360, 3840491, 3840492, 3840496, 3840497, 3840498, 3840499, 3840502, 3840505, 3840506, 3840507, 3840508, 3840667, 3840671, 3840674, 3840729, 3840732, 808765, 3840955, 3844322, 3847249, 3841747, 3841054, 3839184, 3841168, 3841093, 3841095, 3841119, 3847251, 3841295, 3841341, 3840850, 3842123, 3842124, 3841395, 3841401, 3841405, 3841415, 547782, 3841467, 7927, 3841477, 3841480, 3842368, 3843322, 3842051, 3843790, 3843791, 3843792, 3843793, 3843794, 3843795, 3843797, 3843798, 3843864, 3843865, 3842644, 3847287, 3847288, 3847293, 3847294, 3844088, 3840925, 3841476, 3842052, 3844151, 3844153, 3844154, 3844155, 3844158, 2215221, 3844165, 3844168, 3844261, 3844170, 3844172, 3844176, 3844177, 3847261, 3847262, 3844008, 3844184, 3844185, 3844186, 3844187, 3844190, 3844191, 3844192, 3844194, 3844195, 3844196, 3844197, 3844201, 3844202, 3844205, 3844206, 3844207, 3844210, 3844213, 3844214, 3844212, 3844217, 7929, 3844218, 3844219, 3844220, 3844223, 3844224, 3844226, 3844227, 3844251, 3844255, 3844256, 3844335, 3844336, 3844337, 3844449, 3844452, 3844455, 3844550, 3844685, 3844686, 3844683, 3847011, 3847047, 3847048, 3847049, 3847050, 3847051, 3847052, 3847053, 3847055, 3847320, 3847161, 3847057, 3847058, 3847059, 3847060, 7932, 3847061, 3847063, 3847064, 3847065, 3847066, 3847067, 3847068, 3847069, 3847071, 3847072, 3847073, 3847074, 3847075, 3847076, 3847077, 3847078, 3847079, 3847080, 3847081, 3847082, 3847083, 3847084, 3847085, 5508, 5509, 3847086, 547749, 3847087, 3847088, 3847089, 3847090, 3847091, 3847092, 3847093, 3847094, 3847095, 3847096, 3847097, 3847098, 3847099, 3847100, 3847101, 3847102, 3847103, 3847104, 3847105, 3847106, 3847107, 3847108, 3847109, 3847214, 3847110, 3847113, 3847119, 3847278, 3847123, 3847124, 3847125, 3847221, 3844300, 3847129, 3847130, 3847131, 3847132, 3847133, 3844301, 3847279, 7732, 3847135, 3847136, 3847137, 3847138, 3847139, 3847140, 3847141, 3847142, 3844145, 3847269, 3847270, 3847271, 3847273, 3847275, 3847277, 3847321, 3847322, 3847323, 3847324, 1457, 3847326, 3847327, 3847330, 3844538, 3847333, 855, 229, 193, 2429151, 2061, 3837924, 638, 416, 4991, 834, 1846, 317, 1853, 1921, 1923, 491, 1169, 4065, 2335, 2086, 5425, 1159, 5428, 5429, 5430, 1026, 5431, 639, 1267, 817, 910, 6772, 1571, 6773, 3822, 1936, 7571, 687, 7784, 7785, 1384, 2954, 1697, 1483, 242, 2363, 1360, 124842, 2075, 7252, 1810, 4874, 3837743, 1316, 1890287, 934, 368, 4247, 3837747, 1644, 2598, 3837965, 3837969, 2234576, 4601, 1485, 1276, 429112, 3838405, 3838409, 3838431, 3865, 530, 1277445, 3840669, 4884, 1206207, 3841048, 3841050, 3841051, 1675248, 3092, 1493, 989, 836, 7194, 1458, 2594, 2471, 1675233, 3841094, 7888, 3841098, 3837748, 3918, 220, 246, 1277447, 3841387, 6636, 1490, 3310325, 1514, 3838408, 2361341, 3843799, 3837968, 685, 3838407, 1396518, 82868, 3840650, 3225, 1259582, 132871, 3843994, 3844014, 6771, 3840224, 3844152, 3840221, 785, 3068, 3152, 678331, 1814, 4138, 3844171, 7605, 929, 2590, 3820, 1899750, 1206189, 4983, 3847, 2948, 3838435, 1591845, 6719, 3838365, 2721, 3844362, 1433, 3841539, 3841675, 3844687, 3837704, 777, 1335, 3846391, 863, 3839185, 963, 5, 5145, 2153, 1084, 1302, 812, 830, 8081, 3841198, 34, 1136, 3845801, 1055593, 1507, 1368, 832, 1115, 6175, 4420, 3841388, 6965, 5793, 846, 1811, 2250, 6440, 811, 2632, 3840873, 6597, 6526, 1510, 269, 604, 130, 51, 173, 163, 519, 522, 290, 208, 504, 278, 347, 617, 818, 54, 807, 152, 307, 997, 231, 503, 258, 32, 1153, 778, 412374, 573735, 174, 271, 262, 547731, 40, 5335, 2127, 470, 495, 164, 1206200, 256, 53, 678335, 3841496, 3173946, 185, 261, 33, 1137, 75, 175, 471, 4243, 330, 108, 4634, 165, 3515, 875, 121, 131, 17, 5969, 82, 2576, 257, 2117, 2313, 3251, 2646, 1752, 492, 331, 768, 232, 7253, 4143, 779, 2481, 1819, 813, 819, 840, 3420, 1328, 1181, 1157, 1109, 1776, 429109, 302, 2493, 1299, 878, 4487, 1827, 3840215, 3840668, 3840730, 3840731, 3840733, 3840603, 3841047, 3841049, 3840995, 3840993, 3840323, 3841056, 3839402, 3839376, 3841091, 3841092, 3839850, 3840382, 3841097, 3839855, 3840994, 3839270, 3841058, 3840851, 3841386, 3841394, 3840003, 3840104, 6932, 2051, 3843800, 3839733, 3840657, 3841261, 3840768, 3840271, 3844013, 3839981, 3840223, 3840214, 3841398, 3840220, 3840318, 3844164, 3844167, 3839249, 3841306, 3839872, 3842030, 3840991, 3844178, 3843987, 3844225, 3839380, 3839857, 3840702, 3840721, 3844253, 3839461, 3844361, 3839387, 3843915, 3840153, 3841674, 1286411, 3842294, 3840536, 2860, 3839466, 3839469, 3842021, 3842163, 3847126, 3842230, 3845627, 3840640, 3842152, 3847134, 5736, 3844988, 3839493, 3841381, 3839776, 3842043, 3842430, 3847325, 3842231, 3842034, 3844134, 3847331, 3847342, 3842298, 3840895, 3841349, 19, 154, 473, 808766, 140, 1185, 510, 1847, 930, 493, 857, 474, 156, 56, 142, 6140, 695, 1013, 591, 300, 743, 248, 3637, 1017, 5142, 3599, 2048, 994, 2552, 7491, 438, 3293, 1726, 749, 1001, 716, 177, 681, 31, 2545, 526, 660, 1104, 703, 3541, 3796, 1400, 647, 119, 573, 1613, 359, 383, 722, 763, 114, 83, 3168, 2076, 178, 960, 3116, 365, 97, 898, 2109462, 24756, 1450, 4549, 903, 173378, 1682, 348, 999, 527, 1555, 479, 881, 871, 1380, 619, 624, 5400, 1573, 1423, 421, 117, 1722, 2540, 3230, 4729, 969, 3576, 89, 27, 147, 1703023, 60, 499, 922, 159, 4, 336, 249, 318, 538, 3215, 169, 511, 1056, 146, 1357, 1844, 1849, 1920, 1922, 1924, 3628597, 4064, 7901, 5423, 5773, 5435, 2448, 3866, 7095, 7398, 7317, 8027, 1139, 1294, 4023, 3854, 547792, 4425, 814, 488, 3091, 3574301, 808785, 2591, 7727, 1927, 3088, 3094, 3838993, 2339, 3837981, 1310, 6290, 3025, 1911, 7404, 3844298, 148, 2715, 808773, 3840956, 3840958, 3840959, 3840962, 4985, 241, 227, 244, 2244279, 3841551, 6757, 4699, 547704, 2622, 3844514, 3844513, 4232, 3844163, 6187, 864, 480, 2852, 287, 120, 3841485, 3847054, 3844229, 808800, 1339, 5414, 3837985, 7601, 3837708, 808797, 3847111, 3847114, 3847117, 3847118, 5112, 115, 3847121, 1306, 3844318, 3847268, 3841358, 3844139, 3847272, 3847274, 3847276, 340, 382, 372, 366, 3837694, 3847282, 3837867, 57, 1851, 876, 5422, 1176, 597, 764, 2862, 3304, 1191, 750, 95, 561, 7966, 1468, 464, 3844222, 528, 5893, 2856, 2195, 859, 186, 1060, 144, 402, 134, 296, 1161846, 1061, 872, 293, 1471, 1675, 925, 2600, 808747, 2661, 487, 2847591, 2847590, 1843, 1205, 1213, 2774, 3628600, 7357, 3847116, 354, 461, 294, 297, 239, 238, 552, 2587, 279, 364, 4042, 343, 337, 596, 447, 3628598, 4984, 2816, 2827, 123, 3583344, 3583343, 3583346, 3583349, 389, 444, 179, 189, 2571, 1041, 1212, 1120, 911, 7257, 2476, 513530, 166, 1407, 216, 13, 234, 369, 4970, 235, 357, 3841055, 236, 1409, 4971, 243, 358, 3791939, 3791925, 3791937, 3791938, 3791928, 3791926, 1686, 1651, 1394, 2777, 669, 180, 3973, 190, 386, 1068, 2182, 387, 3842326, 3749, 388, 1040, 390, 432, 429, 422, 426, 587, 556, 558, 433, 430, 423, 427, 588, 557, 559, 1434, 544, 1395, 1653, 1396, 413, 1397, 361, 2515, 0) Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN ( 7, 1848, 1854, 931, 5426, 157, 24764, 3841373, 808783, 3837980, 2566, 3840957, 3840196, 3839899, 1815050, 3840960, 3840260, 3840475, 475, 516, 3838827, 4895, 3847112, 3847115, 5669, 3837927, 4140, 8, 926, 465, 808764, 1214, 137, 1182, 3839569, 3839574, 3839560, 3839561, 3839668, 3839586, 3839611, 3839662, 3839617, 3839595, 3839570, 3839661, 3839634, 3839604, 3839573, 3839616, 3839578, 3839636, 3839606, 3839702, 3840976, 3840317, 3839715, 3841090, 3841096, 3839637, 3840200, 3841396, 3839568, 3843980, 3843986, 3839703, 3844166, 3844221, 3844252, 3847012, 3839610, 3839672, 3839629, 3847122, 3839701, 3839678, 3839576, 833, 1845, 1852, 3011, 3012, 3841170, 3844304, 3844308, 5424, 5436, 5507, 3844312, 3847044, 3838030, 3838671, 7719, 7722, 7912, 3847062, 7931, 7939, 8028, 3841122, 3838693, 547741, 3844137, 547755, 547758, 6300, 547781, 7733, 3838031, 547797, 3026, 643404, 643405, 808779, 1099889, 3844299, 1350284, 1405786, 3838514, 3837716, 3837717, 3837718, 3838590, 3838591, 3838592, 3838593, 4422, 2920189, 3838529, 3837963, 3838597, 3838569, 3847226, 3847227, 3838512, 3837992, 3837994, 3838531, 3847228, 3838344, 3837740, 3837996, 3838538, 3838539, 3838543, 3847170, 3838675, 3838676, 3838682, 3840336, 3840338, 3837713, 3840345, 3840346, 3840349, 3840350, 3840351, 3840360, 3840491, 3840492, 3840496, 3840497, 3840498, 3840499, 3840502, 3840505, 3840506, 3840507, 3840508, 3840667, 3840671, 3840674, 3840729, 3840732, 808765, 3840955, 3844322, 3847249, 3841747, 3841054, 3839184, 3841168, 3841093, 3841095, 3841119, 3847251, 3841295, 3841341, 3840850, 3842123, 3842124, 3841395, 3841401, 3841405, 3841415, 547782, 3841467, 7927, 3841477, 3841480, 3842368, 3843322, 3842051, 3843790, 3843791, 3843792, 3843793, 3843794, 3843795, 3843797, 3843798, 3843864, 3843865, 3842644, 3847287, 3847288, 3847293, 3847294, 3844088, 3840925, 3841476, 3842052, 3844151, 3844153, 3844154, 3844155, 3844158, 2215221, 3844165, 3844168, 3844261, 3844170, 3844172, 3844176, 3844177, 3847261, 3847262, 3844008, 3844184, 3844185, 3844186, 3844187, 3844190, 3844191, 3844192, 3844194, 3844195, 3844196, 3844197, 3844201, 3844202, 3844205, 3844206, 3844207, 3844210, 3844213, 3844214, 3844212, 3844217, 7929, 3844218, 3844219, 3844220, 3844223, 3844224, 3844226, 3844227, 3844251, 3844255, 3844256, 3844335, 3844336, 3844337, 3844449, 3844452, 3844455, 3844550, 3844685, 3844686, 3844683, 3847011, 3847047, 3847048, 3847049, 3847050, 3847051, 3847052, 3847053, 3847055, 3847320, 3847161, 3847057, 3847058, 3847059, 3847060, 7932, 3847061, 3847063, 3847064, 3847065, 3847066, 3847067, 3847068, 3847069, 3847071, 3847072, 3847073, 3847074, 3847075, 3847076, 3847077, 3847078, 3847079, 3847080, 3847081, 3847082, 3847083, 3847084, 3847085, 5508, 5509, 3847086, 547749, 3847087, 3847088, 3847089, 3847090, 3847091, 3847092, 3847093, 3847094, 3847095, 3847096, 3847097, 3847098, 3847099, 3847100, 3847101, 3847102, 3847103, 3847104, 3847105, 3847106, 3847107, 3847108, 3847109, 3847214, 3847110, 3847113, 3847119, 3847278, 3847123, 3847124, 3847125, 3847221, 3844300, 3847129, 3847130, 3847131, 3847132, 3847133, 3844301, 3847279, 7732, 3847135, 3847136, 3847137, 3847138, 3847139, 3847140, 3847141, 3847142, 3844145, 3847269, 3847270, 3847271, 3847273, 3847275, 3847277, 3847321, 3847322, 3847323, 3847324, 1457, 3847326, 3847327, 3847330, 3844538, 3847333, 855, 229, 193, 2429151, 2061, 3837924, 638, 416, 4991, 834, 1846, 317, 1853, 1921, 1923, 491, 1169, 4065, 2335, 2086, 5425, 1159, 5428, 5429, 5430, 1026, 5431, 639, 1267, 817, 910, 6772, 1571, 6773, 3822, 1936, 7571, 687, 7784, 7785, 1384, 2954, 1697, 1483, 242, 2363, 1360, 124842, 2075, 7252, 1810, 4874, 3837743, 1316, 1890287, 934, 368, 4247, 3837747, 1644, 2598, 3837965, 3837969, 2234576, 4601, 1485, 1276, 429112, 3838405, 3838409, 3838431, 3865, 530, 1277445, 3840669, 4884, 1206207, 3841048, 3841050, 3841051, 1675248, 3092, 1493, 989, 836, 7194, 1458, 2594, 2471, 1675233, 3841094, 7888, 3841098, 3837748, 3918, 220, 246, 1277447, 3841387, 6636, 1490, 3310325, 1514, 3838408, 2361341, 3843799, 3837968, 685, 3838407, 1396518, 82868, 3840650, 3225, 1259582, 132871, 3843994, 3844014, 6771, 3840224, 3844152, 3840221, 785, 3068, 3152, 678331, 1814, 4138, 3844171, 7605, 929, 2590, 3820, 1899750, 1206189, 4983, 3847, 2948, 3838435, 1591845, 6719, 3838365, 2721, 3844362, 1433, 3841539, 3841675, 3844687, 3837704, 777, 1335, 3846391, 863, 3839185, 963, 5, 5145, 2153, 1084, 1302, 812, 830, 8081, 3841198, 34, 1136, 3845801, 1055593, 1507, 1368, 832, 1115, 6175, 4420, 3841388, 6965, 5793, 846, 1811, 2250, 6440, 811, 2632, 3840873, 6597, 6526, 1510, 269, 604, 130, 51, 173, 163, 519, 522, 290, 208, 504, 278, 347, 617, 818, 54, 807, 152, 307, 997, 231, 503, 258, 32, 1153, 778, 412374, 573735, 174, 271, 262, 547731, 40, 5335, 2127, 470, 495, 164, 1206200, 256, 53, 678335, 3841496, 3173946, 185, 261, 33, 1137, 75, 175, 471, 4243, 330, 108, 4634, 165, 3515, 875, 121, 131, 17, 5969, 82, 2576, 257, 2117, 2313, 3251, 2646, 1752, 492, 331, 768, 232, 7253, 4143, 779, 2481, 1819, 813, 819, 840, 3420, 1328, 1181, 1157, 1109, 1776, 429109, 302, 2493, 1299, 878, 4487, 1827, 3840215, 3840668, 3840730, 3840731, 3840733, 3840603, 3841047, 3841049, 3840995, 3840993, 3840323, 3841056, 3839402, 3839376, 3841091, 3841092, 3839850, 3840382, 3841097, 3839855, 3840994, 3839270, 3841058, 3840851, 3841386, 3841394, 3840003, 3840104, 6932, 2051, 3843800, 3839733, 3840657, 3841261, 3840768, 3840271, 3844013, 3839981, 3840223, 3840214, 3841398, 3840220, 3840318, 3844164, 3844167, 3839249, 3841306, 3839872, 3842030, 3840991, 3844178, 3843987, 3844225, 3839380, 3839857, 3840702, 3840721, 3844253, 3839461, 3844361, 3839387, 3843915, 3840153, 3841674, 1286411, 3842294, 3840536, 2860, 3839466, 3839469, 3842021, 3842163, 3847126, 3842230, 3845627, 3840640, 3842152, 3847134, 5736, 3844988, 3839493, 3841381, 3839776, 3842043, 3842430, 3847325, 3842231, 3842034, 3844134, 3847331, 3847342, 3842298, 3840895, 3841349, 19, 154, 473, 808766, 140, 1185, 510, 1847, 930, 493, 857, 474, 156, 56, 142, 6140, 695, 1013, 591, 300, 743, 248, 3637, 1017, 5142, 3599, 2048, 994, 2552, 7491, 438, 3293, 1726, 749, 1001, 716, 177, 681, 31, 2545, 526, 660, 1104, 703, 3541, 3796, 1400, 647, 119, 573, 1613, 359, 383, 722, 763, 114, 83, 3168, 2076, 178, 960, 3116, 365, 97, 898, 2109462, 24756, 1450, 4549, 903, 173378, 1682, 348, 999, 527, 1555, 479, 881, 871, 1380, 619, 624, 5400, 1573, 1423, 421, 117, 1722, 2540, 3230, 4729, 969, 3576, 89, 27, 147, 1703023, 60, 499, 922, 159, 4, 336, 249, 318, 538, 3215, 169, 511, 1056, 146, 1357, 1844, 1849, 1920, 1922, 1924, 3628597, 4064, 7901, 5423, 5773, 5435, 2448, 3866, 7095, 7398, 7317, 8027, 1139, 1294, 4023, 3854, 547792, 4425, 814, 488, 3091, 3574301, 808785, 2591, 7727, 1927, 3088, 3094, 3838993, 2339, 3837981, 1310, 6290, 3025, 1911, 7404, 3844298, 148, 2715, 808773, 3840956, 3840958, 3840959, 3840962, 4985, 241, 227, 244, 2244279, 3841551, 6757, 4699, 547704, 2622, 3844514, 3844513, 4232, 3844163, 6187, 864, 480, 2852, 287, 120, 3841485, 3847054, 3844229, 808800, 1339, 5414, 3837985, 7601, 3837708, 808797, 3847111, 3847114, 3847117, 3847118, 5112, 115, 3847121, 1306, 3844318, 3847268, 3841358, 3844139, 3847272, 3847274, 3847276, 340, 382, 372, 366, 3837694, 3847282, 3837867, 57, 1851, 876, 5422, 1176, 597, 764, 2862, 3304, 1191, 750, 95, 561, 7966, 1468, 464, 3844222, 528, 5893, 2856, 2195, 859, 186, 1060, 144, 402, 134, 296, 1161846, 1061, 872, 293, 1471, 1675, 925, 2600, 808747, 2661, 487, 2847591, 2847590, 1843, 1205, 1213, 2774, 3628600, 7357, 3847116, 354, 461, 294, 297, 239, 238, 552, 2587, 279, 364, 4042, 343, 337, 596, 447, 3628598, 4984, 2816, 2827, 123, 3583344, 3583343, 3583346, 3583349, 389, 444, 179, 189, 2571, 1041, 1212, 1120, 911, 7257, 2476, 513530, 166, 1407, 216, 13, 234, 369, 4970, 235, 357, 3841055, 236, 1409, 4971, 243, 358, 3791939, 3791925, 3791937, 3791938, 3791928, 3791926, 1686, 1651, 1394, 2777, 669, 180, 3973, 190, 386, 1068, 2182, 387, 3842326, 3749, 388, 1040, 390, 432, 429, 422, 426, 587, 556, 558, 433, 430, 423, 427, 588, 557, 559, 1434, 544, 1395, 1653, 1396, 413, 1397, 361, 2515, 0 ) SELECT p0_.id AS id_0, p0_.title AS title_1 FROM property_value p0_ WHERE p0_.id IN (7, 1848, 1854, 931, 5426, 157, 24764, 3841373, 808783, 3837980, 2566, 3840957, 3840196, 3839899, 1815050, 3840960, 3840260, 3840475, 475, 516, 3838827, 4895, 3847112, 3847115, 5669, 3837927, 4140, 8, 926, 465, 808764, 1214, 137, 1182, 3839569, 3839574, 3839560, 3839561, 3839668, 3839586, 3839611, 3839662, 3839617, 3839595, 3839570, 3839661, 3839634, 3839604, 3839573, 3839616, 3839578, 3839636, 3839606, 3839702, 3840976, 3840317, 3839715, 3841090, 3841096, 3839637, 3840200, 3841396, 3839568, 3843980, 3843986, 3839703, 3844166, 3844221, 3844252, 3847012, 3839610, 3839672, 3839629, 3847122, 3839701, 3839678, 3839576, 833, 1845, 1852, 3011, 3012, 3841170, 3844304, 3844308, 5424, 5436, 5507, 3844312, 3847044, 3838030, 3838671, 7719, 7722, 7912, 3847062, 7931, 7939, 8028, 3841122, 3838693, 547741, 3844137, 547755, 547758, 6300, 547781, 7733, 3838031, 547797, 3026, 643404, 643405, 808779, 1099889, 3844299, 1350284, 1405786, 3838514, 3837716, 3837717, 3837718, 3838590, 3838591, 3838592, 3838593, 4422, 2920189, 3838529, 3837963, 3838597, 3838569, 3847226, 3847227, 3838512, 3837992, 3837994, 3838531, 3847228, 3838344, 3837740, 3837996, 3838538, 3838539, 3838543, 3847170, 3838675, 3838676, 3838682, 3840336, 3840338, 3837713, 3840345, 3840346, 3840349, 3840350, 3840351, 3840360, 3840491, 3840492, 3840496, 3840497, 3840498, 3840499, 3840502, 3840505, 3840506, 3840507, 3840508, 3840667, 3840671, 3840674, 3840729, 3840732, 808765, 3840955, 3844322, 3847249, 3841747, 3841054, 3839184, 3841168, 3841093, 3841095, 3841119, 3847251, 3841295, 3841341, 3840850, 3842123, 3842124, 3841395, 3841401, 3841405, 3841415, 547782, 3841467, 7927, 3841477, 3841480, 3842368, 3843322, 3842051, 3843790, 3843791, 3843792, 3843793, 3843794, 3843795, 3843797, 3843798, 3843864, 3843865, 3842644, 3847287, 3847288, 3847293, 3847294, 3844088, 3840925, 3841476, 3842052, 3844151, 3844153, 3844154, 3844155, 3844158, 2215221, 3844165, 3844168, 3844261, 3844170, 3844172, 3844176, 3844177, 3847261, 3847262, 3844008, 3844184, 3844185, 3844186, 3844187, 3844190, 3844191, 3844192, 3844194, 3844195, 3844196, 3844197, 3844201, 3844202, 3844205, 3844206, 3844207, 3844210, 3844213, 3844214, 3844212, 3844217, 7929, 3844218, 3844219, 3844220, 3844223, 3844224, 3844226, 3844227, 3844251, 3844255, 3844256, 3844335, 3844336, 3844337, 3844449, 3844452, 3844455, 3844550, 3844685, 3844686, 3844683, 3847011, 3847047, 3847048, 3847049, 3847050, 3847051, 3847052, 3847053, 3847055, 3847320, 3847161, 3847057, 3847058, 3847059, 3847060, 7932, 3847061, 3847063, 3847064, 3847065, 3847066, 3847067, 3847068, 3847069, 3847071, 3847072, 3847073, 3847074, 3847075, 3847076, 3847077, 3847078, 3847079, 3847080, 3847081, 3847082, 3847083, 3847084, 3847085, 5508, 5509, 3847086, 547749, 3847087, 3847088, 3847089, 3847090, 3847091, 3847092, 3847093, 3847094, 3847095, 3847096, 3847097, 3847098, 3847099, 3847100, 3847101, 3847102, 3847103, 3847104, 3847105, 3847106, 3847107, 3847108, 3847109, 3847214, 3847110, 3847113, 3847119, 3847278, 3847123, 3847124, 3847125, 3847221, 3844300, 3847129, 3847130, 3847131, 3847132, 3847133, 3844301, 3847279, 7732, 3847135, 3847136, 3847137, 3847138, 3847139, 3847140, 3847141, 3847142, 3844145, 3847269, 3847270, 3847271, 3847273, 3847275, 3847277, 3847321, 3847322, 3847323, 3847324, 1457, 3847326, 3847327, 3847330, 3844538, 3847333, 855, 229, 193, 2429151, 2061, 3837924, 638, 416, 4991, 834, 1846, 317, 1853, 1921, 1923, 491, 1169, 4065, 2335, 2086, 5425, 1159, 5428, 5429, 5430, 1026, 5431, 639, 1267, 817, 910, 6772, 1571, 6773, 3822, 1936, 7571, 687, 7784, 7785, 1384, 2954, 1697, 1483, 242, 2363, 1360, 124842, 2075, 7252, 1810, 4874, 3837743, 1316, 1890287, 934, 368, 4247, 3837747, 1644, 2598, 3837965, 3837969, 2234576, 4601, 1485, 1276, 429112, 3838405, 3838409, 3838431, 3865, 530, 1277445, 3840669, 4884, 1206207, 3841048, 3841050, 3841051, 1675248, 3092, 1493, 989, 836, 7194, 1458, 2594, 2471, 1675233, 3841094, 7888, 3841098, 3837748, 3918, 220, 246, 1277447, 3841387, 6636, 1490, 3310325, 1514, 3838408, 2361341, 3843799, 3837968, 685, 3838407, 1396518, 82868, 3840650, 3225, 1259582, 132871, 3843994, 3844014, 6771, 3840224, 3844152, 3840221, 785, 3068, 3152, 678331, 1814, 4138, 3844171, 7605, 929, 2590, 3820, 1899750, 1206189, 4983, 3847, 2948, 3838435, 1591845, 6719, 3838365, 2721, 3844362, 1433, 3841539, 3841675, 3844687, 3837704, 777, 1335, 3846391, 863, 3839185, 963, 5, 5145, 2153, 1084, 1302, 812, 830, 8081, 3841198, 34, 1136, 3845801, 1055593, 1507, 1368, 832, 1115, 6175, 4420, 3841388, 6965, 5793, 846, 1811, 2250, 6440, 811, 2632, 3840873, 6597, 6526, 1510, 269, 604, 130, 51, 173, 163, 519, 522, 290, 208, 504, 278, 347, 617, 818, 54, 807, 152, 307, 997, 231, 503, 258, 32, 1153, 778, 412374, 573735, 174, 271, 262, 547731, 40, 5335, 2127, 470, 495, 164, 1206200, 256, 53, 678335, 3841496, 3173946, 185, 261, 33, 1137, 75, 175, 471, 4243, 330, 108, 4634, 165, 3515, 875, 121, 131, 17, 5969, 82, 2576, 257, 2117, 2313, 3251, 2646, 1752, 492, 331, 768, 232, 7253, 4143, 779, 2481, 1819, 813, 819, 840, 3420, 1328, 1181, 1157, 1109, 1776, 429109, 302, 2493, 1299, 878, 4487, 1827, 3840215, 3840668, 3840730, 3840731, 3840733, 3840603, 3841047, 3841049, 3840995, 3840993, 3840323, 3841056, 3839402, 3839376, 3841091, 3841092, 3839850, 3840382, 3841097, 3839855, 3840994, 3839270, 3841058, 3840851, 3841386, 3841394, 3840003, 3840104, 6932, 2051, 3843800, 3839733, 3840657, 3841261, 3840768, 3840271, 3844013, 3839981, 3840223, 3840214, 3841398, 3840220, 3840318, 3844164, 3844167, 3839249, 3841306, 3839872, 3842030, 3840991, 3844178, 3843987, 3844225, 3839380, 3839857, 3840702, 3840721, 3844253, 3839461, 3844361, 3839387, 3843915, 3840153, 3841674, 1286411, 3842294, 3840536, 2860, 3839466, 3839469, 3842021, 3842163, 3847126, 3842230, 3845627, 3840640, 3842152, 3847134, 5736, 3844988, 3839493, 3841381, 3839776, 3842043, 3842430, 3847325, 3842231, 3842034, 3844134, 3847331, 3847342, 3842298, 3840895, 3841349, 19, 154, 473, 808766, 140, 1185, 510, 1847, 930, 493, 857, 474, 156, 56, 142, 6140, 695, 1013, 591, 300, 743, 248, 3637, 1017, 5142, 3599, 2048, 994, 2552, 7491, 438, 3293, 1726, 749, 1001, 716, 177, 681, 31, 2545, 526, 660, 1104, 703, 3541, 3796, 1400, 647, 119, 573, 1613, 359, 383, 722, 763, 114, 83, 3168, 2076, 178, 960, 3116, 365, 97, 898, 2109462, 24756, 1450, 4549, 903, 173378, 1682, 348, 999, 527, 1555, 479, 881, 871, 1380, 619, 624, 5400, 1573, 1423, 421, 117, 1722, 2540, 3230, 4729, 969, 3576, 89, 27, 147, 1703023, 60, 499, 922, 159, 4, 336, 249, 318, 538, 3215, 169, 511, 1056, 146, 1357, 1844, 1849, 1920, 1922, 1924, 3628597, 4064, 7901, 5423, 5773, 5435, 2448, 3866, 7095, 7398, 7317, 8027, 1139, 1294, 4023, 3854, 547792, 4425, 814, 488, 3091, 3574301, 808785, 2591, 7727, 1927, 3088, 3094, 3838993, 2339, 3837981, 1310, 6290, 3025, 1911, 7404, 3844298, 148, 2715, 808773, 3840956, 3840958, 3840959, 3840962, 4985, 241, 227, 244, 2244279, 3841551, 6757, 4699, 547704, 2622, 3844514, 3844513, 4232, 3844163, 6187, 864, 480, 2852, 287, 120, 3841485, 3847054, 3844229, 808800, 1339, 5414, 3837985, 7601, 3837708, 808797, 3847111, 3847114, 3847117, 3847118, 5112, 115, 3847121, 1306, 3844318, 3847268, 3841358, 3844139, 3847272, 3847274, 3847276, 340, 382, 372, 366, 3837694, 3847282, 3837867, 57, 1851, 876, 5422, 1176, 597, 764, 2862, 3304, 1191, 750, 95, 561, 7966, 1468, 464, 3844222, 528, 5893, 2856, 2195, 859, 186, 1060, 144, 402, 134, 296, 1161846, 1061, 872, 293, 1471, 1675, 925, 2600, 808747, 2661, 487, 2847591, 2847590, 1843, 1205, 1213, 2774, 3628600, 7357, 3847116, 354, 461, 294, 297, 239, 238, 552, 2587, 279, 364, 4042, 343, 337, 596, 447, 3628598, 4984, 2816, 2827, 123, 3583344, 3583343, 3583346, 3583349, 389, 444, 179, 189, 2571, 1041, 1212, 1120, 911, 7257, 2476, 513530, 166, 1407, 216, 13, 234, 369, 4970, 235, 357, 3841055, 236, 1409, 4971, 243, 358, 3791939, 3791925, 3791937, 3791938, 3791928, 3791926, 1686, 1651, 1394, 2777, 669, 180, 3973, 190, 386, 1068, 2182, 387, 3842326, 3749, 388, 1040, 390, 432, 429, 422, 426, 587, 556, 558, 433, 430, 423, 427, 588, 557, 559, 1434, 544, 1395, 1653, 1396, 413, 1397, 361, 2515, 0);
2.94 ms (2.08%)	1	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 (940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414) ORDER BY p0_.is_hit DESC LIMIT 64 Parameters: [] View formatted query View runnable query Explain query 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 ( 940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414 ) ORDER BY p0_.is_hit DESC LIMIT 64 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 (940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414) ORDER BY p0_.is_hit DESC LIMIT 64;
2.09 ms (1.48%)	1	SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414) ORDER BY p0_.is_hit DESC Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN ( 940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414 ) ORDER BY p0_.is_hit DESC SELECT p0_.id AS id_0 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414) ORDER BY p0_.is_hit DESC;
1.84 ms (1.30%)	2	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 SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'test' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
1.82 ms (1.29%)	1	SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414) ORDER BY p0_.is_hit DESC Parameters: [] View formatted query View runnable query Explain query SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN ( 940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414 ) ORDER BY p0_.is_hit DESC SELECT MIN(p0_.price) AS sclr_0, MAX(p0_.price) AS sclr_1 FROM product p0_ WHERE p0_.visible = 1 AND p0_.id IN (940, 2003, 2007, 2008, 2045, 2047, 2048, 2050, 2051, 3879, 3880, 9143, 9152, 10726, 10731, 10732, 10734, 10740, 10741, 10742, 10744, 10747, 10748, 10749, 10750, 10758, 10759, 10760, 10766, 10768, 10775, 10777, 10781, 10783, 10784, 10800, 10808, 10809, 11031, 11811, 12274, 12275, 13943, 13945, 13946, 13947, 13949, 14836, 16595, 16786, 16790, 17012, 17016, 17021, 17495, 17502, 17574, 17591, 17970, 20459, 20460, 20606, 20607, 20623, 20626, 20633, 20650, 20658, 20669, 20675, 20679, 20828, 20829, 21069, 21070, 21415, 21419, 21420, 21836, 22224, 22348, 22415, 25512, 25513, 25515, 25547, 25548, 25838, 25839, 25840, 25855, 25856, 25857, 25858, 25869, 26293, 26294, 26295, 26301, 26306, 26308, 26313, 26314, 26322, 26332, 26334, 26340, 26360, 26361, 26455, 26683, 26685, 26698, 26699, 26701, 26714, 26767, 26768, 26769, 26850, 26851, 27449, 29243, 31226, 31248, 31250, 31254, 31258, 31259, 31263, 31264, 31265, 31267, 31277, 31647, 31799, 31800, 31805, 31806, 31807, 31808, 31811, 31814, 31815, 31816, 31817, 32157, 32177, 32245, 32253, 32260, 32341, 32342, 32344, 32345, 32688, 32690, 32694, 32907, 32919, 32921, 32923, 33283, 33584, 33652, 33657, 33672, 33673, 33823, 33824, 33827, 33832, 33841, 33843, 36859, 36860, 36863, 36864, 36876, 36877, 36880, 36881, 36882, 36883, 36884, 36885, 36886, 36887, 36888, 36889, 36890, 36893, 36894, 36896, 36984, 36985, 36987, 37279, 37280, 37281, 37282, 37283, 37284, 37285, 37286, 37287, 37288, 37289, 37290, 37291, 37292, 37294, 37295, 37296, 37297, 37527, 37532, 37534, 37537, 37538, 37547, 37549, 37550, 37551, 37553, 37554, 37555, 37558, 37564, 37565, 37566, 37567, 37568, 37569, 37570, 37571, 37572, 37573, 37574, 37575, 37576, 37577, 37578, 37579, 37580, 37581, 37582, 37583, 37584, 37585, 37586, 37588, 37590, 37591, 37593, 37602, 37604, 37606, 37610, 37612, 37618, 37619, 37620, 37621, 37624, 37625, 37626, 37628, 37629, 37630, 37631, 37635, 37636, 37639, 37640, 37641, 37642, 37645, 37647, 37650, 37651, 37652, 37654, 37657, 37658, 37659, 37660, 37662, 37663, 37664, 37671, 37672, 37673, 37676, 37677, 37683, 37687, 37688, 37689, 37690, 37693, 37694, 37695, 37697, 37698, 37701, 37702, 37704, 37706, 37707, 37708, 37709, 37729, 37730, 37732, 37733, 37734, 37735, 37736, 37737, 37738, 37739, 37742, 37743, 37744, 37839, 37840, 37841, 37842, 37843, 37844, 37845, 37849, 37850, 37861, 37863, 37864, 37865, 37866, 37868, 37869, 37870, 37871, 37872, 38063, 38066, 38069, 38075, 38283, 38588, 38589, 38590, 41330, 41584, 41585, 41586, 41587, 41588, 41589, 41590, 41591, 41592, 41593, 41594, 41595, 41596, 41597, 41598, 41599, 41600, 41601, 41602, 41603, 41604, 41605, 41606, 41608, 41609, 41610, 41611, 41612, 41613, 41614, 41615, 41616, 41617, 41618, 41619, 41620, 41621, 41622, 41623, 41624, 41625, 41626, 41627, 41628, 41629, 41630, 41631, 41632, 41633, 41634, 41635, 41636, 41638, 41639, 41640, 41641, 41642, 41643, 41644, 41645, 41646, 41647, 41648, 41649, 41650, 41651, 41652, 41653, 41654, 41655, 41656, 41657, 41658, 41659, 41660, 41661, 41662, 41663, 41664, 41665, 41666, 41667, 41668, 41669, 41670, 41671, 41672, 41673, 41674, 41675, 41676, 41677, 41678, 41679, 41680, 41681, 41682, 41683, 41684, 41685, 41686, 41687, 41688, 41689, 41690, 41691, 41692, 41693, 41694, 41695, 41696, 41697, 41698, 41699, 41700, 41701, 41702, 41703, 41704, 41705, 41706, 41707, 41708, 41709, 41710, 41711, 41712, 41713, 41714, 41715, 41716, 41717, 41718, 41719, 41720, 41727, 41728, 41729, 41730, 41731, 41732, 41733, 41734, 41735, 41736, 41737, 41738, 41739, 41740, 41741, 41742, 41743, 41744, 41745, 41746, 41747, 41748, 41749, 41750, 41751, 41752, 41753, 41754, 41755, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41801, 41802, 41803, 41804, 41805, 41806, 41807, 41808, 41809, 41810, 41811, 41815, 41816, 41817, 41818, 41819, 41820, 41821, 41826, 41852, 41853, 41854, 41855, 41856, 41857, 41858, 41859, 41860, 41861, 41862, 41863, 41864, 41865, 41866, 41867, 41868, 41869, 41870, 41871, 41872, 41873, 41874, 41875, 41876, 41877, 41878, 41879, 41880, 41881, 41882, 41883, 41884, 41885, 41886, 41887, 41888, 41889, 41890, 8781, 19505, 25875, 32681, 32685, 32686, 32695, 32698, 32699, 32723, 32744, 32799, 32867, 32868, 32920, 32924, 32925, 32926, 32928, 32929, 33210, 33213, 33214, 33215, 33216, 33217, 33234, 33246, 33280, 33475, 33500, 33536, 33596, 33597, 33598, 33600, 33601, 33942, 36128, 37414) ORDER BY p0_.is_hit DESC;
1.01 ms (0.72%)	1	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 (3839560, 3847012, 3839574, 3839617, 3839604, 3839576, 3844166, 3844221, 3843980, 3847122, 3839668, 3839570, 3839573, 3841090, 3844252, 3839672, 3839636, 3840317, 3840976, 3839678, 3839634, 3841396, 3839701, 3839561, 3839702, 3839569, 3839611, 3839578, 3839606, 3839715, 3841096, 3843986, 3839610, 3839595, 3839661, 3839637, 3839703, 3839629, 3839586, 3839662, 3839616, 3840200, 3839568) Parameters: [] View formatted query View runnable query Explain query 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 ( 3839560, 3847012, 3839574, 3839617, 3839604, 3839576, 3844166, 3844221, 3843980, 3847122, 3839668, 3839570, 3839573, 3841090, 3844252, 3839672, 3839636, 3840317, 3840976, 3839678, 3839634, 3841396, 3839701, 3839561, 3839702, 3839569, 3839611, 3839578, 3839606, 3839715, 3841096, 3843986, 3839610, 3839595, 3839661, 3839637, 3839703, 3839629, 3839586, 3839662, 3839616, 3840200, 3839568 ) 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 (3839560, 3847012, 3839574, 3839617, 3839604, 3839576, 3844166, 3844221, 3843980, 3847122, 3839668, 3839570, 3839573, 3841090, 3844252, 3839672, 3839636, 3840317, 3840976, 3839678, 3839634, 3841396, 3839701, 3839561, 3839702, 3839569, 3839611, 3839578, 3839606, 3839715, 3841096, 3843986, 3839610, 3839595, 3839661, 3839637, 3839703, 3839629, 3839586, 3839662, 3839616, 3840200, 3839568);
0.65 ms (0.46%)	6	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
0.65 ms (0.46%)	1	SELECT plp.product_id,pl.text,pl.color,pl.priority,pl.type FROM product_label_product plp join product_label pl on pl.id = plp.product_label_id WHERE plp.product_id IN (41730,41731,41732,41733,41734,32799,41773,41776,41778,41330,41597,41599,41600,41608,41609,41610,41611,41612,41613,41619,41645,32177,41655,37570,41668,37573,41669,41680,41684,41687,41691,41692,41693,41694,41696,41701,41703,41705,37868,26360,2048,25856,33280,33536,36864,41728,25857,41729,2050,25858,2051,33283,37635,32260,37636,10758,10759,37639,41735,10760,37640,41736,37641,41737) AND pl.visible=1 ORDER BY plp.product_id,pl.priority DESC Parameters: [] View formatted query View runnable query Explain query SELECT plp.product_id, pl.text, pl.color, pl.priority, pl.type FROM product_label_product plp join product_label pl on pl.id = plp.product_label_id WHERE plp.product_id IN ( 41730, 41731, 41732, 41733, 41734, 32799, 41773, 41776, 41778, 41330, 41597, 41599, 41600, 41608, 41609, 41610, 41611, 41612, 41613, 41619, 41645, 32177, 41655, 37570, 41668, 37573, 41669, 41680, 41684, 41687, 41691, 41692, 41693, 41694, 41696, 41701, 41703, 41705, 37868, 26360, 2048, 25856, 33280, 33536, 36864, 41728, 25857, 41729, 2050, 25858, 2051, 33283, 37635, 32260, 37636, 10758, 10759, 37639, 41735, 10760, 37640, 41736, 37641, 41737 ) AND pl.visible = 1 ORDER BY plp.product_id, pl.priority DESC SELECT plp.product_id,pl.text,pl.color,pl.priority,pl.type FROM product_label_product plp join product_label pl on pl.id = plp.product_label_id WHERE plp.product_id IN (41730,41731,41732,41733,41734,32799,41773,41776,41778,41330,41597,41599,41600,41608,41609,41610,41611,41612,41613,41619,41645,32177,41655,37570,41668,37573,41669,41680,41684,41687,41691,41692,41693,41694,41696,41701,41703,41705,37868,26360,2048,25856,33280,33536,36864,41728,25857,41729,2050,25858,2051,33283,37635,32260,37636,10758,10759,37639,41735,10760,37640,41736,37641,41737) AND pl.visible=1 ORDER BY plp.product_id,pl.priority DESC;
0.65 ms (0.46%)	8	SELECT t0.id AS id_1, t0.info_block AS info_block_2, t0.url AS url_3, t0.anchor AS anchor_4, t0.position AS position_5, t0.visible AS visible_6 FROM info_block_link t0 WHERE t0.info_block = ? AND t0.visible = ? ORDER BY t0.position ASC Parameters: [`"catalog" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.info_block AS info_block_2, t0.url AS url_3, t0.anchor AS anchor_4, t0.position AS position_5, t0.visible AS visible_6 FROM info_block_link t0 WHERE t0.info_block = ? AND t0.visible = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.info_block AS info_block_2, t0.url AS url_3, t0.anchor AS anchor_4, t0.position AS position_5, t0.visible AS visible_6 FROM info_block_link t0 WHERE t0.info_block = 'catalog' AND t0.visible = 1 ORDER BY t0.position ASC;
0.58 ms (0.41%)	7	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 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 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 = 'registration_bonus' LIMIT 1;
0.57 ms (0.40%)	1	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 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' 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 = 'test' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
0.48 ms (0.34%)	1	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 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 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 = 'test' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
0.33 ms (0.23%)	1	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.slug = ? LIMIT 1 Parameters: [`"new-year"`] View formatted query View runnable query Explain query 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.slug = ? LIMIT 1 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.slug = 'new-year' LIMIT 1;
0.25 ms (0.18%)	1	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: [`280`] View formatted query View runnable query Explain query 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 = ? 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 = 280;
0.20 ms (0.14%)	2	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 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 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;
0.19 ms (0.13%)	1	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 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 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 = 'test' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
0.18 ms (0.12%)	2	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 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 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 = 'topCatalog' LIMIT 1;
0.16 ms (0.12%)	1	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 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 = ? 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 = 1;
0.14 ms (0.10%)	1	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 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 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;
0.12 ms (0.08%)	1	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_.in_filter = 1 Parameters: [] View formatted query View runnable query Explain query 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_.in_filter = 1 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_.in_filter = 1;
0.12 ms (0.08%)	1	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:35" "2026-02-04 06:45:35"`] View formatted query View runnable query Explain query 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' ) 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 >= '2026-02-04 06:45:35' AND p0_.date_from <= '2026-02-04 06:45:35') AND p0_.type IN ('profit_set', 'registered_customer', 'even_less_price', 'discount_on_products');
0.11 ms (0.08%)	1	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 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 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 <> 'custom' AND p0_.visible = 1;
0.11 ms (0.07%)	1	SELECT t0.id AS id_1, t0.object AS object_2, t0.title AS title_3, t0.description AS description_4, t0.h1 AS h1_5, t0.keywords AS keywords_6, t0.title_pagination AS title_pagination_7, t0.description_pagination AS description_pagination_8, t0.h1_pagination AS h1_pagination_9, t0.keywords_pagination AS keywords_pagination_10 FROM seo_template t0 WHERE t0.object = ? LIMIT 1 Parameters: [`App\Component\Seo\SeoObjectType {#3112 __toString(): "virtual_category" }`] View formatted query View runnable query SELECT t0.id AS id_1, t0.object AS object_2, t0.title AS title_3, t0.description AS description_4, t0.h1 AS h1_5, t0.keywords AS keywords_6, t0.title_pagination AS title_pagination_7, t0.description_pagination AS description_pagination_8, t0.h1_pagination AS h1_pagination_9, t0.keywords_pagination AS keywords_pagination_10 FROM seo_template t0 WHERE t0.object = ? LIMIT 1 SELECT t0.id AS id_1, t0.object AS object_2, t0.title AS title_3, t0.description AS description_4, t0.h1 AS h1_5, t0.keywords AS keywords_6, t0.title_pagination AS title_pagination_7, t0.description_pagination AS description_pagination_8, t0.h1_pagination AS h1_pagination_9, t0.keywords_pagination AS keywords_pagination_10 FROM seo_template t0 WHERE t0.object = 'virtual_category' LIMIT 1;
0.09 ms (0.07%)	1	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 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 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;
0.09 ms (0.06%)	1	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 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 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 = 0 AND t0.type IN ('category', 'virtual_category') ORDER BY t0.position ASC;
0.09 ms (0.06%)	1	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;

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\SeoTemplate	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.
App\Entity\AdminUser	No errors.
App\Entity\MessageThrottle	No errors.
App\Entity\NotifyTemplate	No errors.

Symfony Profiler

https://test.perina-peroni.ru/vcategory/new-year

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping