#6
⏱️ 75.55 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?)
Bindings:
[149670,135652,135651,135634,135622,135615,135596,135582,135564,135384,135364,135363,135279,135278,135271,135204,135019,135003,134802,134684,134567,134481,134463,134426,134261,134161,134159,134156,134109,134067,134064,134054,134045,133996,133922,133898,133886,133870,133798,133797,133791,133737,133729,133614,133578,133573,133572,133569,133565,133564,133563,133556,133554,133550,133548,133545,133539,133535,133533,133532,133531,133530,133529,133528,133518,133517,133516,133515,133513,133508,133504,133502,133501,133500,133499,133496,133495,133493,133492,133491,133489,133486,133484,133482,133481,133480,133479,133478,133477,133475,133474,133473,133472,133471,133470,133467,99982,150748,190885,1431275,1453410,109844,109471,95621,150772,190930,3225948,95635,150763,109102,1993337,199256,2922879,150773,95620,109467,190929,4324769,162165,110740,110100,1431171,170225,1907901,190786,2903796,194993,1959667,154945,109696,193908,199442,109658,150744,95624,199296,1460659,150747,199422,1431176,109789,864780,95644,1913921,1431161,199249,109106,150766,2927777,1909820,7477797,1431369,190767,109562,150724,4963163,1453320,96348,109578,150741,150775,109329,364555,95608,364560,98008,98608,101020,107882,4172615,1907879,199419,109305,150738,1907955,4524191,109566,190782,150757,96280,102973,190785,109532,1907953,190891,96276,189812,1453357,96458,7454739,2712622,1432304,1987013,598075,111462,190925,95619,109079,96299,500438,95607,97555,100594,98007,164586,3068182,199450,150745,109653,96274,199451,1907931,1431173,109470,1452770,2561083,170077,1431162,96252,190905,109105,96300,150752,109601,191005,1431175,1907926,150780,150753,109477,190931,1907954,96273,150769,96284,190979,109314,5130723,1907930,150734,1457159,150751,1452766,1879659,2637097,95638,190892,109070,150776,150739,109469,1453432,199385,1907943,150728,96297,9416568,1452775,109654,109659,150759,true,742,24,479,273]
#8
⏱️ 107.31 мс
select min(sp.id) as best_sp_id from "store_prices" as "sp" where "sp"."master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "sp"."price" > ? and "sp"."store_id" in (?, ?, ?, ?) group by sp.store_id, CASE WHEN sp.master_product_id = 99982 THEN 135363 WHEN sp.master_product_id = 135363 THEN 135363 WHEN sp.master_product_id = 150748 THEN 133556 WHEN sp.master_product_id = 133556 THEN 133556 WHEN sp.master_product_id = 190885 THEN 133556 WHEN sp.master_product_id = 1431275 THEN 133556 WHEN sp.master_product_id = 1453410 THEN 133556 WHEN sp.master_product_id = 109844 THEN 133556 WHEN sp.master_product_id = 109471 THEN 133471 WHEN sp.master_product_id = 133471 THEN 133471 WHEN sp.master_product_id = 95621 THEN 133471 WHEN sp.master_product_id = 150772 THEN 133471 WHEN sp.master_product_id = 190930 THEN 133471 WHEN sp.master_product_id = 3225948 THEN 133482 WHEN sp.master_product_id = 95635 THEN 133482 WHEN sp.master_product_id = 150763 THEN 133482 WHEN sp.master_product_id = 109102 THEN 133482 WHEN sp.master_product_id = 1993337 THEN 133482 WHEN sp.master_product_id = 133482 THEN 133482 WHEN sp.master_product_id = 199256 THEN 133482 WHEN sp.master_product_id = 2922879 THEN 133470 WHEN sp.master_product_id = 150773 THEN 133470 WHEN sp.master_product_id = 95620 THEN 133470 WHEN sp.master_product_id = 109467 THEN 133470 WHEN sp.master_product_id = 133470 THEN 133470 WHEN sp.master_product_id = 190929 THEN 133470 WHEN sp.master_product_id = 133515 THEN 133515 WHEN sp.master_product_id = 4324769 THEN 133515 WHEN sp.master_product_id = 162165 THEN 133515 WHEN sp.master_product_id = 110740 THEN 133515 WHEN sp.master_product_id = 110100 THEN 135652 WHEN sp.master_product_id = 1431171 THEN 135652 WHEN sp.master_product_id = 170225 THEN 135652 WHEN sp.master_product_id = 1907901 THEN 135652 WHEN sp.master_product_id = 190786 THEN 135652 WHEN sp.master_product_id = 135652 THEN 135652 WHEN sp.master_product_id = 133500 THEN 133500 WHEN sp.master_product_id = 2903796 THEN 133500 WHEN sp.master_product_id = 194993 THEN 133500 WHEN sp.master_product_id = 1959667 THEN 133500 WHEN sp.master_product_id = 154945 THEN 133500 WHEN sp.master_product_id = 109696 THEN 133500 WHEN sp.master_product_id = 193908 THEN 133500 WHEN sp.master_product_id = 133501 THEN 133501 WHEN sp.master_product_id = 199442 THEN 133501 WHEN sp.master_product_id = 109658 THEN 133501 WHEN sp.master_product_id = 150744 THEN 133501 WHEN sp.master_product_id = 133516 THEN 133516 WHEN sp.master_product_id = 95624 THEN 133516 WHEN sp.master_product_id = 199296 THEN 133516 WHEN sp.master_product_id = 1460659 THEN 133531 WHEN sp.master_product_id = 150747 THEN 133531 WHEN sp.master_product_id = 199422 THEN 133531 WHEN sp.master_product_id = 1431176 THEN 133531 WHEN sp.master_product_id = 109789 THEN 133531 WHEN sp.master_product_id = 133531 THEN 133531 WHEN sp.master_product_id = 864780 THEN 133517 WHEN sp.master_product_id = 95644 THEN 133517 WHEN sp.master_product_id = 1913921 THEN 133517 WHEN sp.master_product_id = 1431161 THEN 133517 WHEN sp.master_product_id = 199249 THEN 133517 WHEN sp.master_product_id = 133517 THEN 133517 WHEN sp.master_product_id = 109106 THEN 133517 WHEN sp.master_product_id = 150766 THEN 133517 WHEN sp.master_product_id = 2927777 THEN 134045 WHEN sp.master_product_id = 1909820 THEN 134045 WHEN sp.master_product_id = 7477797 THEN 134045 WHEN sp.master_product_id = 134045 THEN 134045 WHEN sp.master_product_id = 1431369 THEN 133569 WHEN sp.master_product_id = 190767 THEN 133569 WHEN sp.master_product_id = 133569 THEN 133569 WHEN sp.master_product_id = 109562 THEN 133569 WHEN sp.master_product_id = 150724 THEN 133569 WHEN sp.master_product_id = 4963163 THEN 133479 WHEN sp.master_product_id = 1453320 THEN 133479 WHEN sp.master_product_id = 96348 THEN 133479 WHEN sp.master_product_id = 109578 THEN 133479 WHEN sp.master_product_id = 133479 THEN 133479 WHEN sp.master_product_id = 150741 THEN 133479 WHEN sp.master_product_id = 133518 THEN 133518 WHEN sp.master_product_id = 150775 THEN 133518 WHEN sp.master_product_id = 109329 THEN 133518 WHEN sp.master_product_id = 364555 THEN 133535 WHEN sp.master_product_id = 95608 THEN 133535 WHEN sp.master_product_id = 364560 THEN 133535 WHEN sp.master_product_id = 98008 THEN 133535 WHEN sp.master_product_id = 98608 THEN 133535 WHEN sp.master_product_id = 101020 THEN 133535 WHEN sp.master_product_id = 107882 THEN 133535 WHEN sp.master_product_id = 133535 THEN 133535 WHEN sp.master_product_id = 4172615 THEN 133491 WHEN sp.master_product_id = 1907879 THEN 133491 WHEN sp.master_product_id = 133491 THEN 133491 WHEN sp.master_product_id = 199419 THEN 133491 WHEN sp.master_product_id = 109305 THEN 133491 WHEN sp.master_product_id = 150738 THEN 133491 WHEN sp.master_product_id = 1907955 THEN 133473 WHEN sp.master_product_id = 4524191 THEN 133473 WHEN sp.master_product_id = 133473 THEN 133473 WHEN sp.master_product_id = 109566 THEN 133473 WHEN sp.master_product_id = 190782 THEN 133473 WHEN sp.master_product_id = 150757 THEN 133486 WHEN sp.master_product_id = 96280 THEN 133486 WHEN sp.master_product_id = 133486 THEN 133486 WHEN sp.master_product_id = 102973 THEN 133486 WHEN sp.master_product_id = 190785 THEN 133486 WHEN sp.master_product_id = 109532 THEN 133486 WHEN sp.master_product_id = 1907953 THEN 133484 WHEN sp.master_product_id = 190891 THEN 133484 WHEN sp.master_product_id = 96276 THEN 133484 WHEN sp.master_product_id = 133484 THEN 133484 WHEN sp.master_product_id = 189812 THEN 133554 WHEN sp.master_product_id = 133554 THEN 133554 WHEN sp.master_product_id = 1453357 THEN 133554 WHEN sp.master_product_id = 96458 THEN 133472 WHEN sp.master_product_id = 7454739 THEN 133472 WHEN sp.master_product_id = 2712622 THEN 133472 WHEN sp.master_product_id = 133472 THEN 133472 WHEN sp.master_product_id = 1432304 THEN 133504 WHEN sp.master_product_id = 1987013 THEN 133504 WHEN sp.master_product_id = 598075 THEN 133504 WHEN sp.master_product_id = 133504 THEN 133504 WHEN sp.master_product_id = 111462 THEN 133504 WHEN sp.master_product_id = 190925 THEN 133467 WHEN sp.master_product_id = 95619 THEN 133467 WHEN sp.master_product_id = 133467 THEN 133467 WHEN sp.master_product_id = 109079 THEN 133467 WHEN sp.master_product_id = 96299 THEN 133529 WHEN sp.master_product_id = 500438 THEN 133529 WHEN sp.master_product_id = 95607 THEN 133529 WHEN sp.master_product_id = 97555 THEN 133529 WHEN sp.master_product_id = 133529 THEN 133529 WHEN sp.master_product_id = 100594 THEN 133529 WHEN sp.master_product_id = 98007 THEN 133529 WHEN sp.master_product_id = 164586 THEN 133529 WHEN sp.master_product_id = 3068182 THEN 133502 WHEN sp.master_product_id = 133502 THEN 133502 WHEN sp.master_product_id = 199450 THEN 133474 WHEN sp.master_product_id = 150745 THEN 133474 WHEN sp.master_product_id = 133474 THEN 133474 WHEN sp.master_product_id = 109653 THEN 133474 WHEN sp.master_product_id = 96274 THEN 133481 WHEN sp.master_product_id = 199451 THEN 133481 WHEN sp.master_product_id = 1907931 THEN 133481 WHEN sp.master_product_id = 1431173 THEN 133481 WHEN sp.master_product_id = 109470 THEN 133481 WHEN sp.master_product_id = 133481 THEN 133481 WHEN sp.master_product_id = 1452770 THEN 133532 WHEN sp.master_product_id = 133532 THEN 133532 WHEN sp.master_product_id = 2561083 THEN 133564 WHEN sp.master_product_id = 133564 THEN 133564 WHEN sp.master_product_id = 170077 THEN 133564 WHEN sp.master_product_id = 1431162 THEN 133564 WHEN sp.master_product_id = 96252 THEN 133564 WHEN sp.master_product_id = 190905 THEN 133564 WHEN sp.master_product_id = 109105 THEN 133564 WHEN sp.master_product_id = 96300 THEN 133478 WHEN sp.master_product_id = 133478 THEN 133478 WHEN sp.master_product_id = 150752 THEN 133478 WHEN sp.master_product_id = 109601 THEN 133478 WHEN sp.master_product_id = 191005 THEN 133478 WHEN sp.master_product_id = 1431175 THEN 133478 WHEN sp.master_product_id = 1907926 THEN 133478 WHEN sp.master_product_id = 133539 THEN 133539 WHEN sp.master_product_id = 150780 THEN 133539 WHEN sp.master_product_id = 150753 THEN 133477 WHEN sp.master_product_id = 109477 THEN 133477 WHEN sp.master_product_id = 135651 THEN 133477 WHEN sp.master_product_id = 133477 THEN 133477 WHEN sp.master_product_id = 190931 THEN 133477 WHEN sp.master_product_id = 1907954 THEN 133477 WHEN sp.master_product_id = 96273 THEN 133477 WHEN sp.master_product_id = 150769 THEN 133492 WHEN sp.master_product_id = 96284 THEN 133492 WHEN sp.master_product_id = 190979 THEN 133492 WHEN sp.master_product_id = 109314 THEN 133492 WHEN sp.master_product_id = 133492 THEN 133492 WHEN sp.master_product_id = 5130723 THEN 133480 WHEN sp.master_product_id = 1907930 THEN 133480 WHEN sp.master_product_id = 150734 THEN 133480 WHEN sp.master_product_id = 133480 THEN 133480 WHEN sp.master_product_id = 1457159 THEN 133898 WHEN sp.master_product_id = 133898 THEN 133898 WHEN sp.master_product_id = 150751 THEN 133528 WHEN sp.master_product_id = 1452766 THEN 133528 WHEN sp.master_product_id = 133528 THEN 133528 WHEN sp.master_product_id = 1879659 THEN 133528 WHEN sp.master_product_id = 2637097 THEN 133528 WHEN sp.master_product_id = 95638 THEN 133493 WHEN sp.master_product_id = 190892 THEN 133493 WHEN sp.master_product_id = 109070 THEN 133493 WHEN sp.master_product_id = 133493 THEN 133493 WHEN sp.master_product_id = 150776 THEN 133493 WHEN sp.master_product_id = 150739 THEN 133548 WHEN sp.master_product_id = 133548 THEN 133548 WHEN sp.master_product_id = 109469 THEN 133548 WHEN sp.master_product_id = 1453432 THEN 133495 WHEN sp.master_product_id = 199385 THEN 133495 WHEN sp.master_product_id = 1907943 THEN 133495 WHEN sp.master_product_id = 133495 THEN 133495 WHEN sp.master_product_id = 150728 THEN 133495 WHEN sp.master_product_id = 133565 THEN 133565 WHEN sp.master_product_id = 96297 THEN 133565 WHEN sp.master_product_id = 9416568 THEN 133565 WHEN sp.master_product_id = 1452775 THEN 133565 WHEN sp.master_product_id = 133530 THEN 133530 WHEN sp.master_product_id = 109654 THEN 133530 WHEN sp.master_product_id = 109659 THEN 133545 WHEN sp.master_product_id = 133545 THEN 133545 WHEN sp.master_product_id = 150759 THEN 133489 WHEN sp.master_product_id = 133489 THEN 133489 ELSE sp.master_product_id END limit 500
Bindings:
[149670,135652,135651,135634,135622,135615,135596,135582,135564,135384,135364,135363,135279,135278,135271,135204,135019,135003,134802,134684,134567,134481,134463,134426,134261,134161,134159,134156,134109,134067,134064,134054,134045,133996,133922,133898,133886,133870,133798,133797,133791,133737,133729,133614,133578,133573,133572,133569,133565,133564,133563,133556,133554,133550,133548,133545,133539,133535,133533,133532,133531,133530,133529,133528,133518,133517,133516,133515,133513,133508,133504,133502,133501,133500,133499,133496,133495,133493,133492,133491,133489,133486,133484,133482,133481,133480,133479,133478,133477,133475,133474,133473,133472,133471,133470,133467,99982,150748,190885,1431275,1453410,109844,109471,95621,150772,190930,3225948,95635,150763,109102,1993337,199256,2922879,150773,95620,109467,190929,4324769,162165,110740,110100,1431171,170225,1907901,190786,2903796,194993,1959667,154945,109696,193908,199442,109658,150744,95624,199296,1460659,150747,199422,1431176,109789,864780,95644,1913921,1431161,199249,109106,150766,2927777,1909820,7477797,1431369,190767,109562,150724,4963163,1453320,96348,109578,150741,150775,109329,364555,95608,364560,98008,98608,101020,107882,4172615,1907879,199419,109305,150738,1907955,4524191,109566,190782,150757,96280,102973,190785,109532,1907953,190891,96276,189812,1453357,96458,7454739,2712622,1432304,1987013,598075,111462,190925,95619,109079,96299,500438,95607,97555,100594,98007,164586,3068182,199450,150745,109653,96274,199451,1907931,1431173,109470,1452770,2561083,170077,1431162,96252,190905,109105,96300,150752,109601,191005,1431175,1907926,150780,150753,109477,190931,1907954,96273,150769,96284,190979,109314,5130723,1907930,150734,1457159,150751,1452766,1879659,2637097,95638,190892,109070,150776,150739,109469,1453432,199385,1907943,150728,96297,9416568,1452775,109654,109659,150759,0,742,24,479,273]
#9
⏱️ 32.18 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[5874586,5874587,5874588,5877156,5877047,5877066,5877092,5877048,5874601,5877050,5877054,5877058,5874603,5874591,5874609,5874576,5874577,5877029,5877064,5884032,5884168,5874231,5893612,5888885,5874212,5748556,5748557,5748558,5751078,5751077,5751052,5751053,5751056,5751057,5748569,5751076,5751009,5751033,5748570,5748561,5748571,5751034,5751025,5767830,5761509,5761212,5758950,5758245,5761621,5756195,5756153,5765650,5764057,5748231,5758720,5758793,5758795,5772961,5758729,5751030,5748228,2520206,2520209,2520210,2520211,2520212,2520213,2520214,2520215,2520216,2520217,2520218,2520219,2520220,2520222,2520223,2520225,2520227,2520228,2520229,2520230,2520231,2520232,2520233,2520234,2520235,2520236,2520237,2520239,2520731,2520240,2520241,2520242,2520248,2520249,2520250,2520251,2520252,2520253,2520255,2520257,2520263,2520266,2520267,2520268,2520269,2520270,2520271,2520273,2520275,2520277,2520283,2520284,2519482,2520473,2520760,2521036,2521037,2520609,2520341,2520297,2521035,2517549,2517883,2521395,2518969,2520859,2518586,2521380,2519846,2519844,2517051,2517053,2520764,2520386,2521033,2519879,2518765,2521412,2519675,2519870,2522043,2520289,3873524,3882855,3882984,3835899,3885478,3887112,3883199,3886338,3885650,4024927,3882941,3874040,3884790,3879372,3879716,3873352,3888058,3887198,3926500,4098844,3874169,3880017,3887155,3890036,3887241,3891025,3874126,3885392,3897604]