#1
⏱️ 25.32 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"modiin"]
#2
⏱️ 189.32 мс
select count(*) as "aggregate" from "master_products" where "barcode" is not null and "master_products"."id" in ((select "master_product_id" from "store_prices" where "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) union (select "master_product_id" from "deals" where "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Bindings:
[713,763,147,345,1153,1201,1255,1273,348,40,111,305,426,439,549,406,true,713,763,147,345,1153,1201,1255,1273,348,40,111,305,426,439,549,406]
#3
⏱️ 187.73 мс
select * from "master_products" where "barcode" is not null and "master_products"."id" in ((select "master_product_id" from "store_prices" where "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) union (select "master_product_id" from "deals" where "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) order by CASE WHEN master_products.image_url IS NOT NULL AND master_products.image_url != '' THEN 0 ELSE 1 END, "master_products"."id" desc limit 96 offset 0
Bindings:
[713,763,147,345,1153,1201,1255,1273,348,40,111,305,426,439,549,406,true,713,763,147,345,1153,1201,1255,1273,348,40,111,305,426,439,549,406]
#4
⏱️ 1.7 мс
select * from "canonical_products" where "canonical_products"."id" in (3, 29, 49, 73, 75, 81, 87, 109, 117, 126, 140, 162, 174, 175, 180, 257, 269, 275, 276, 279, 281, 283, 286, 299, 308, 310, 313, 314, 320)
#5
⏱️ 1.23 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[29,281,140,87,257,279,276,109,75,126,81,117,283,286,162,320,174,175,73,275,3,313,299,269,314,310,49,180,308]
#6
⏱️ 26.51 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[4935924,4928790,4777564,4665520,4658871,4658870,4658869,4658868,4628744,4603578,4602029,4601010,4599809,4592992,4584074,4574784,4548104,4546420,4546409,4546386,4546379,4546368,4546366,4546355,4546345,4546334,4546323,4546313,4546301,4546295,4546279,4546274,4546265,4546263,4546262,4546253,4546244,4546240,4546223,4546198,4546136,4546116,4545656,4544898,4544894,4541685,4541684,4541335,4540379,4540340,4540339,4540337,4540288,4540285,4540232,4539975,4539841,4539718,4539502,4539501,4539493,4536369,4536333,4535017,4534950,4534927,4534846,4534774,4534738,4534639,4534637,4534609,4534608,4534601,4534184,4534183,4533815,4533508,4533498,4533490,4532830,4531886,4531885,4529854,4529792,4529153,4528085,4528009,4527799,4527798,4527796,4527795,4527794,4526816,4526787,4525248,8775857,8775862,8775826,8775829,8775830,8775837,8775838,8775841,8775842,8775845,8775843,8775844,8775847,8775846,8775848,8775850,8775851,8775859,8775861,8775867,8775868,2645047,7696015,8775839,8775856,8775858,8775860,8775863,8775864,199939,4869230,4619338,8775832,8775833,8775836,8775865,8775825,8775828,189745,8775840,8775849,8775853,8775855,8775866,2642425,2671007,8775827,8775831,8775834,8775835,8775852,8775854,8775869,190787,157207,1456451,154874,160600,162815,96257,149434,2661944,195132,2193998,793980,97984,1458062,194318,3053377,1452602,2670953,4033131,195121,207015,110668,100076,4679481,9960259,4016585,149368,2663583,192681,207016,195120,110465,2666480,198954,198955,3855719,1980207,4055598,162816,160964,207014,195119,97189,2663682,1059071,1467932,207013,195118,195115,2680729,149430,96243,97183,161469,4983721,97174,158802,97181,96295,192680,true,713,763,147,345,1153,1201,1255,1273,348,40,111,305,426,439,549,406]
#7
⏱️ 3.41 мс
select * from "stores" where "stores"."id" in (111, 147, 305, 345, 348, 406, 1153, 1201, 1255, 1273)
#8
⏱️ 31.65 мс
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 = 8775857 THEN 4533490 WHEN sp.master_product_id = 8775862 THEN 4533490 WHEN sp.master_product_id = 8775826 THEN 4533490 WHEN sp.master_product_id = 8775829 THEN 4533490 WHEN sp.master_product_id = 8775830 THEN 4533490 WHEN sp.master_product_id = 8775837 THEN 4533490 WHEN sp.master_product_id = 8775838 THEN 4533490 WHEN sp.master_product_id = 8775841 THEN 4533490 WHEN sp.master_product_id = 8775842 THEN 4533490 WHEN sp.master_product_id = 8775845 THEN 4533490 WHEN sp.master_product_id = 8775843 THEN 4533490 WHEN sp.master_product_id = 8775844 THEN 4533490 WHEN sp.master_product_id = 8775847 THEN 4533490 WHEN sp.master_product_id = 8775846 THEN 4533490 WHEN sp.master_product_id = 8775848 THEN 4533490 WHEN sp.master_product_id = 8775850 THEN 4533490 WHEN sp.master_product_id = 8775851 THEN 4533490 WHEN sp.master_product_id = 8775859 THEN 4533490 WHEN sp.master_product_id = 8775861 THEN 4533490 WHEN sp.master_product_id = 8775867 THEN 4533490 WHEN sp.master_product_id = 8775868 THEN 4533490 WHEN sp.master_product_id = 2645047 THEN 4533490 WHEN sp.master_product_id = 7696015 THEN 4533490 WHEN sp.master_product_id = 8775839 THEN 4533490 WHEN sp.master_product_id = 8775856 THEN 4533490 WHEN sp.master_product_id = 8775858 THEN 4533490 WHEN sp.master_product_id = 8775860 THEN 4533490 WHEN sp.master_product_id = 8775863 THEN 4533490 WHEN sp.master_product_id = 8775864 THEN 4533490 WHEN sp.master_product_id = 199939 THEN 4533490 WHEN sp.master_product_id = 4869230 THEN 4533490 WHEN sp.master_product_id = 4619338 THEN 4533490 WHEN sp.master_product_id = 8775832 THEN 4533490 WHEN sp.master_product_id = 8775833 THEN 4533490 WHEN sp.master_product_id = 8775836 THEN 4533490 WHEN sp.master_product_id = 8775865 THEN 4533490 WHEN sp.master_product_id = 8775825 THEN 4533490 WHEN sp.master_product_id = 8775828 THEN 4533490 WHEN sp.master_product_id = 4533490 THEN 4533490 WHEN sp.master_product_id = 189745 THEN 4533490 WHEN sp.master_product_id = 8775840 THEN 4533490 WHEN sp.master_product_id = 8775849 THEN 4533490 WHEN sp.master_product_id = 8775853 THEN 4533490 WHEN sp.master_product_id = 8775855 THEN 4533490 WHEN sp.master_product_id = 8775866 THEN 4533490 WHEN sp.master_product_id = 2642425 THEN 4533490 WHEN sp.master_product_id = 2671007 THEN 4533490 WHEN sp.master_product_id = 8775827 THEN 4533490 WHEN sp.master_product_id = 8775831 THEN 4533490 WHEN sp.master_product_id = 8775834 THEN 4533490 WHEN sp.master_product_id = 8775835 THEN 4533490 WHEN sp.master_product_id = 8775852 THEN 4533490 WHEN sp.master_product_id = 8775854 THEN 4533490 WHEN sp.master_product_id = 8775869 THEN 4533490 WHEN sp.master_product_id = 190787 THEN 4533490 WHEN sp.master_product_id = 4777564 THEN 4536369 WHEN sp.master_product_id = 4536369 THEN 4536369 WHEN sp.master_product_id = 157207 THEN 4526816 WHEN sp.master_product_id = 4526816 THEN 4526816 WHEN sp.master_product_id = 1456451 THEN 4526816 WHEN sp.master_product_id = 154874 THEN 4526816 WHEN sp.master_product_id = 160600 THEN 4526816 WHEN sp.master_product_id = 162815 THEN 4526816 WHEN sp.master_product_id = 96257 THEN 4526816 WHEN sp.master_product_id = 149434 THEN 4526816 WHEN sp.master_product_id = 2661944 THEN 4526816 WHEN sp.master_product_id = 195132 THEN 4539718 WHEN sp.master_product_id = 2193998 THEN 4539718 WHEN sp.master_product_id = 4539718 THEN 4539718 WHEN sp.master_product_id = 793980 THEN 4539718 WHEN sp.master_product_id = 97984 THEN 4539718 WHEN sp.master_product_id = 1458062 THEN 4539718 WHEN sp.master_product_id = 194318 THEN 4539718 WHEN sp.master_product_id = 4540232 THEN 4540232 WHEN sp.master_product_id = 4584074 THEN 4540232 WHEN sp.master_product_id = 3053377 THEN 4546368 WHEN sp.master_product_id = 1452602 THEN 4546368 WHEN sp.master_product_id = 2670953 THEN 4546368 WHEN sp.master_product_id = 4546368 THEN 4546368 WHEN sp.master_product_id = 4033131 THEN 4546368 WHEN sp.master_product_id = 195121 THEN 4658870 WHEN sp.master_product_id = 4658870 THEN 4658870 WHEN sp.master_product_id = 207015 THEN 4658870 WHEN sp.master_product_id = 110668 THEN 4658870 WHEN sp.master_product_id = 4592992 THEN 4541335 WHEN sp.master_product_id = 4541335 THEN 4541335 WHEN sp.master_product_id = 100076 THEN 4541335 WHEN sp.master_product_id = 4679481 THEN 4541335 WHEN sp.master_product_id = 9960259 THEN 4546323 WHEN sp.master_product_id = 4546323 THEN 4546323 WHEN sp.master_product_id = 4016585 THEN 4546323 WHEN sp.master_product_id = 149368 THEN 4546323 WHEN sp.master_product_id = 2663583 THEN 4546323 WHEN sp.master_product_id = 4546409 THEN 4546409 WHEN sp.master_product_id = 192681 THEN 4546409 WHEN sp.master_product_id = 4658871 THEN 4658871 WHEN sp.master_product_id = 207016 THEN 4658871 WHEN sp.master_product_id = 195120 THEN 4658871 WHEN sp.master_product_id = 110465 THEN 4658871 WHEN sp.master_product_id = 4546295 THEN 4546295 WHEN sp.master_product_id = 2666480 THEN 4546295 WHEN sp.master_product_id = 198954 THEN 4541685 WHEN sp.master_product_id = 4541685 THEN 4541685 WHEN sp.master_product_id = 4541684 THEN 4541684 WHEN sp.master_product_id = 198955 THEN 4541684 WHEN sp.master_product_id = 3855719 THEN 4526787 WHEN sp.master_product_id = 1980207 THEN 4526787 WHEN sp.master_product_id = 4055598 THEN 4526787 WHEN sp.master_product_id = 162816 THEN 4526787 WHEN sp.master_product_id = 160964 THEN 4526787 WHEN sp.master_product_id = 4526787 THEN 4526787 WHEN sp.master_product_id = 207014 THEN 4658869 WHEN sp.master_product_id = 195119 THEN 4658869 WHEN sp.master_product_id = 4658869 THEN 4658869 WHEN sp.master_product_id = 4527796 THEN 4527796 WHEN sp.master_product_id = 97189 THEN 4527796 WHEN sp.master_product_id = 2663682 THEN 4534927 WHEN sp.master_product_id = 1059071 THEN 4534927 WHEN sp.master_product_id = 4534927 THEN 4534927 WHEN sp.master_product_id = 4602029 THEN 4602029 WHEN sp.master_product_id = 1467932 THEN 4602029 WHEN sp.master_product_id = 4658868 THEN 4658868 WHEN sp.master_product_id = 207013 THEN 4658868 WHEN sp.master_product_id = 195118 THEN 4658868 WHEN sp.master_product_id = 4665520 THEN 4665520 WHEN sp.master_product_id = 195115 THEN 4665520 WHEN sp.master_product_id = 2680729 THEN 4546313 WHEN sp.master_product_id = 4546313 THEN 4546313 WHEN sp.master_product_id = 4546301 THEN 4546301 WHEN sp.master_product_id = 149430 THEN 4546301 WHEN sp.master_product_id = 4527799 THEN 4527799 WHEN sp.master_product_id = 96243 THEN 4527799 WHEN sp.master_product_id = 97183 THEN 4527799 WHEN sp.master_product_id = 161469 THEN 4527799 WHEN sp.master_product_id = 4983721 THEN 4525248 WHEN sp.master_product_id = 4525248 THEN 4525248 WHEN sp.master_product_id = 97174 THEN 4527794 WHEN sp.master_product_id = 4527794 THEN 4527794 WHEN sp.master_product_id = 4529854 THEN 4529854 WHEN sp.master_product_id = 158802 THEN 4529854 WHEN sp.master_product_id = 97181 THEN 4527795 WHEN sp.master_product_id = 4527795 THEN 4527795 WHEN sp.master_product_id = 96295 THEN 4527795 WHEN sp.master_product_id = 4546240 THEN 4546240 WHEN sp.master_product_id = 192680 THEN 4546240 ELSE sp.master_product_id END limit 500
Bindings:
[4935924,4928790,4777564,4665520,4658871,4658870,4658869,4658868,4628744,4603578,4602029,4601010,4599809,4592992,4584074,4574784,4548104,4546420,4546409,4546386,4546379,4546368,4546366,4546355,4546345,4546334,4546323,4546313,4546301,4546295,4546279,4546274,4546265,4546263,4546262,4546253,4546244,4546240,4546223,4546198,4546136,4546116,4545656,4544898,4544894,4541685,4541684,4541335,4540379,4540340,4540339,4540337,4540288,4540285,4540232,4539975,4539841,4539718,4539502,4539501,4539493,4536369,4536333,4535017,4534950,4534927,4534846,4534774,4534738,4534639,4534637,4534609,4534608,4534601,4534184,4534183,4533815,4533508,4533498,4533490,4532830,4531886,4531885,4529854,4529792,4529153,4528085,4528009,4527799,4527798,4527796,4527795,4527794,4526816,4526787,4525248,8775857,8775862,8775826,8775829,8775830,8775837,8775838,8775841,8775842,8775845,8775843,8775844,8775847,8775846,8775848,8775850,8775851,8775859,8775861,8775867,8775868,2645047,7696015,8775839,8775856,8775858,8775860,8775863,8775864,199939,4869230,4619338,8775832,8775833,8775836,8775865,8775825,8775828,189745,8775840,8775849,8775853,8775855,8775866,2642425,2671007,8775827,8775831,8775834,8775835,8775852,8775854,8775869,190787,157207,1456451,154874,160600,162815,96257,149434,2661944,195132,2193998,793980,97984,1458062,194318,3053377,1452602,2670953,4033131,195121,207015,110668,100076,4679481,9960259,4016585,149368,2663583,192681,207016,195120,110465,2666480,198954,198955,3855719,1980207,4055598,162816,160964,207014,195119,97189,2663682,1059071,1467932,207013,195118,195115,2680729,149430,96243,97183,161469,4983721,97174,158802,97181,96295,192680,0,713,763,147,345,1153,1201,1255,1273,348,40,111,305,426,439,549,406]
#9
⏱️ 6.42 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[6533517,6533525,6533512,6534662,5080174,5080216,5080160,5108651,5088849,5102334,5565242,746828,746816,748190,750037,1112173,1113489,1112216,1113506,1112159,1118730,1114578,1117366,1112854,1112855,1469753,1469792,1469740,1474741,1471418,1473570,5849724,5849725,1893536,1889507,1896186,1891889,1900031,1889473,1892905,1888614,2144600,2146626,2149852,2151880,2141602,2151176,2140197,3503566,3504682,3503821,3503332,3092268,2728019,3059070,3059960,7602099,7602101,7602106,2728285,2727132,2727206,2728270,2728874,3095546,2730886,2730887,2731825,2722483,2732438,2732439,2733092,7620317,2733490,2733497,2733498,2733527,2733529,7621850,2733793,2733814,2722466,7587516,2722552,7591417,7591454,7602100,7602108,3059963,2727140,7603450,2727373,3095782,2727668,2727671,7604946,2727721,2727722,7604989,3061488,2729013,2729014,2732235,2732244,7620293,7621751,7621771,2733613,2733635,2733651,2733655,2733664,2733672,7621900,2733674,2733683,2733688,2733704,2733709,2733720,2733731,2733742,2733753,7621992,2733772,2733774,7622016,2733789,2733805,2733813,2673978,2731838,2725846,2727047,2728062,2729614,3055606,2728004,2728005,2728007,2728006,2728001,3066536,3062700,499147,499187,499134,503534,500620,502461]
#10
⏱️ 3 мс
select * from "stores" where "stores"."id" in (111, 147, 305, 345, 348, 406, 426, 439, 549, 713, 763)
#11
⏱️ 1.2 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["modiin"]
#12
⏱️ 2.87 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#13
⏱️ 4.04 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]