#1
⏱️ 43.98 мс
select "id" from "stores" where "is_active" = ? and "city_slug" = ?
Bindings:
[true,"israel"]
#2
⏱️ 4903.57 мс
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:
[1107,7,1119,1127,1148,1158,1183,404,270,1266,385,395,1284,1393,1401,1372,1373,1374,1375,1391,1115,1116,1117,1122,1128,1130,1134,1135,1136,1137,1376,1144,1149,1150,1152,1154,1161,1162,1163,1164,1165,1167,1171,1172,1174,1176,1178,1179,1180,1184,1185,1187,1189,1190,1191,1193,1195,1197,1199,1200,1202,1203,1204,1208,1212,1213,1214,1215,1222,1225,1227,1228,1231,1233,1234,1235,1237,1242,1247,1248,1252,1253,1256,1257,1258,1259,1267,1268,1269,1270,1272,1276,1278,1281,1294,1295,1297,1302,1304,1408,1309,1310,1314,1322,1323,1324,1329,1331,1332,1333,1335,1337,1338,1340,1341,1346,1347,136,206,255,248,213,177,179,304,283,314,344,372,375,374,386,388,389,401,403,394,396,397,400,402,393,411,408,1348,1351,1357,1358,1360,1363,1364,1365,1366,1367,1378,1381,1383,1387,1389,1392,1396,1399,1403,1404,1406,1407,1410,269,289,225,true,1107,7,1119,1127,1148,1158,1183,404,270,1266,385,395,1284,1393,1401,1372,1373,1374,1375,1391,1115,1116,1117,1122,1128,1130,1134,1135,1136,1137,1376,1144,1149,1150,1152,1154,1161,1162,1163,1164,1165,1167,1171,1172,1174,1176,1178,1179,1180,1184,1185,1187,1189,1190,1191,1193,1195,1197,1199,1200,1202,1203,1204,1208,1212,1213,1214,1215,1222,1225,1227,1228,1231,1233,1234,1235,1237,1242,1247,1248,1252,1253,1256,1257,1258,1259,1267,1268,1269,1270,1272,1276,1278,1281,1294,1295,1297,1302,1304,1408,1309,1310,1314,1322,1323,1324,1329,1331,1332,1333,1335,1337,1338,1340,1341,1346,1347,136,206,255,248,213,177,179,304,283,314,344,372,375,374,386,388,389,401,403,394,396,397,400,402,393,411,408,1348,1351,1357,1358,1360,1363,1364,1365,1366,1367,1378,1381,1383,1387,1389,1392,1396,1399,1403,1404,1406,1407,1410,269,289,225]
#3
⏱️ 1546.65 мс
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:
[1107,7,1119,1127,1148,1158,1183,404,270,1266,385,395,1284,1393,1401,1372,1373,1374,1375,1391,1115,1116,1117,1122,1128,1130,1134,1135,1136,1137,1376,1144,1149,1150,1152,1154,1161,1162,1163,1164,1165,1167,1171,1172,1174,1176,1178,1179,1180,1184,1185,1187,1189,1190,1191,1193,1195,1197,1199,1200,1202,1203,1204,1208,1212,1213,1214,1215,1222,1225,1227,1228,1231,1233,1234,1235,1237,1242,1247,1248,1252,1253,1256,1257,1258,1259,1267,1268,1269,1270,1272,1276,1278,1281,1294,1295,1297,1302,1304,1408,1309,1310,1314,1322,1323,1324,1329,1331,1332,1333,1335,1337,1338,1340,1341,1346,1347,136,206,255,248,213,177,179,304,283,314,344,372,375,374,386,388,389,401,403,394,396,397,400,402,393,411,408,1348,1351,1357,1358,1360,1363,1364,1365,1366,1367,1378,1381,1383,1387,1389,1392,1396,1399,1403,1404,1406,1407,1410,269,289,225,true,1107,7,1119,1127,1148,1158,1183,404,270,1266,385,395,1284,1393,1401,1372,1373,1374,1375,1391,1115,1116,1117,1122,1128,1130,1134,1135,1136,1137,1376,1144,1149,1150,1152,1154,1161,1162,1163,1164,1165,1167,1171,1172,1174,1176,1178,1179,1180,1184,1185,1187,1189,1190,1191,1193,1195,1197,1199,1200,1202,1203,1204,1208,1212,1213,1214,1215,1222,1225,1227,1228,1231,1233,1234,1235,1237,1242,1247,1248,1252,1253,1256,1257,1258,1259,1267,1268,1269,1270,1272,1276,1278,1281,1294,1295,1297,1302,1304,1408,1309,1310,1314,1322,1323,1324,1329,1331,1332,1333,1335,1337,1338,1340,1341,1346,1347,136,206,255,248,213,177,179,304,283,314,344,372,375,374,386,388,389,401,403,394,396,397,400,402,393,411,408,1348,1351,1357,1358,1360,1363,1364,1365,1366,1367,1378,1381,1383,1387,1389,1392,1396,1399,1403,1404,1406,1407,1410,269,289,225]
#4
⏱️ 4.77 мс
select * from "canonical_products" where "canonical_products"."id" in (30, 71, 79, 90, 92, 111, 121, 123, 138, 182, 189, 205, 222, 242, 246, 256, 261)
#5
⏱️ 2.46 мс
select "id", "canonical_product_id" from "master_products" where "canonical_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[111,189,79,123,182,256,205,30,90,246,92,138,242,121,261,71,222]
#6
⏱️ 1191.07 мс
select * from "deals" where "master_product_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and "is_active" = ? and "store_id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[4533815,4531886,4072560,2864871,2634246,2460379,2427312,2423943,2413856,2413855,2390497,2319509,2257475,2244024,2190128,2178279,2167056,2151263,2136438,2058963,2049531,2047938,2045870,2045396,2000831,1966954,1962021,1960939,1959857,1952957,1939916,1938566,1935988,1935265,1933366,1933365,1931249,1930007,1928902,1928901,1928807,1928253,1926920,1926835,1926121,1926120,1922599,1922388,1921228,1920468,1919767,1918295,1918287,1917004,1916627,1915898,1915867,1915609,1915186,1915185,1913217,1913216,1912369,1912286,1912226,1912088,1912087,1912018,1912003,1911972,1911874,1911613,1911330,1910510,1910474,1910399,1910197,1910173,1910051,1909949,1909941,1909939,1909908,1909873,1909866,1909865,1909827,1909820,1909819,1909719,1909474,1909369,1909366,1909358,1909289,1909168,2681942,2927777,1920702,95650,703893,7477797,134045,4039359,97564,2066134,97351,1458061,4227275,109026,160117,109547,2986223,129463,1453314,1453315,107092,2670949,205836,164584,112818,3000385,1455029,1986966,1907946,1907936,1456475,190894,131891,199437,160440,2637094,133463,1907938,157086,98428,166132,98240,99834,109313,98238,127440,true,1107,7,1119,1127,1148,1158,1183,404,270,1266,385,395,1284,1393,1401,1372,1373,1374,1375,1391,1115,1116,1117,1122,1128,1130,1134,1135,1136,1137,1376,1144,1149,1150,1152,1154,1161,1162,1163,1164,1165,1167,1171,1172,1174,1176,1178,1179,1180,1184,1185,1187,1189,1190,1191,1193,1195,1197,1199,1200,1202,1203,1204,1208,1212,1213,1214,1215,1222,1225,1227,1228,1231,1233,1234,1235,1237,1242,1247,1248,1252,1253,1256,1257,1258,1259,1267,1268,1269,1270,1272,1276,1278,1281,1294,1295,1297,1302,1304,1408,1309,1310,1314,1322,1323,1324,1329,1331,1332,1333,1335,1337,1338,1340,1341,1346,1347,136,206,255,248,213,177,179,304,283,314,344,372,375,374,386,388,389,401,403,394,396,397,400,402,393,411,408,1348,1351,1357,1358,1360,1363,1364,1365,1366,1367,1378,1381,1383,1387,1389,1392,1396,1399,1403,1404,1406,1407,1410,269,289,225]
#7
⏱️ 5.3 мс
select * from "stores" where "stores"."id" in (7, 136, 283, 289, 304, 314, 344, 372, 374, 375, 385, 386, 388, 389, 393, 394, 395, 396, 397, 400, 401, 402, 403, 404, 408, 411, 1107, 1115, 1116, 1117, 1119, 1122, 1127, 1128, 1130, 1134, 1135, 1136, 1137, 1144, 1148, 1149, 1150, 1152, 1154, 1158, 1161, 1162, 1163, 1164, 1165, 1167, 1171, 1172, 1174, 1176, 1178, 1179, 1180, 1183, 1184, 1185, 1187, 1189, 1190, 1191, 1193, 1195, 1197, 1199, 1200, 1202, 1203, 1204, 1208, 1212, 1213, 1214, 1215, 1222, 1225, 1227, 1228, 1231, 1233, 1234, 1235, 1237, 1242, 1247, 1248, 1252, 1253, 1256, 1257, 1258, 1259, 1266, 1267, 1268, 1269, 1270, 1272, 1276, 1278, 1281, 1284, 1294, 1295, 1297, 1302, 1304, 1309, 1310, 1314, 1322, 1323, 1324, 1329, 1331, 1332, 1333, 1335, 1337, 1338, 1340, 1341, 1346, 1347, 1348, 1351, 1357, 1358, 1360, 1363, 1364, 1365, 1366, 1367, 1372, 1373, 1374, 1375, 1376, 1378, 1381, 1383, 1387, 1389, 1391, 1392, 1393, 1396, 1399, 1401, 1403, 1404, 1406, 1407, 1408, 1410)
#8
⏱️ 310.83 мс
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 = 2681942 THEN 1960939 WHEN sp.master_product_id = 1933366 THEN 1933366 WHEN sp.master_product_id = 2927777 THEN 1909820 WHEN sp.master_product_id = 2190128 THEN 2190128 WHEN sp.master_product_id = 1909820 THEN 1909820 WHEN sp.master_product_id = 1920702 THEN 1917004 WHEN sp.master_product_id = 95650 THEN 1915898 WHEN sp.master_product_id = 703893 THEN 2257475 WHEN sp.master_product_id = 7477797 THEN 1909820 WHEN sp.master_product_id = 134045 THEN 1909820 WHEN sp.master_product_id = 1910399 THEN 1910399 WHEN sp.master_product_id = 4039359 THEN 1909941 WHEN sp.master_product_id = 97564 THEN 2190128 WHEN sp.master_product_id = 2066134 THEN 2244024 WHEN sp.master_product_id = 97351 THEN 1915898 WHEN sp.master_product_id = 1909168 THEN 1909168 WHEN sp.master_product_id = 2257475 THEN 2257475 WHEN sp.master_product_id = 1458061 THEN 1909941 WHEN sp.master_product_id = 1915185 THEN 1915185 WHEN sp.master_product_id = 1952957 THEN 1952957 WHEN sp.master_product_id = 1909939 THEN 1909939 WHEN sp.master_product_id = 4227275 THEN 1915185 WHEN sp.master_product_id = 109026 THEN 1939916 WHEN sp.master_product_id = 160117 THEN 1926920 WHEN sp.master_product_id = 1926920 THEN 1926920 WHEN sp.master_product_id = 1939916 THEN 1939916 WHEN sp.master_product_id = 109547 THEN 1909939 WHEN sp.master_product_id = 2986223 THEN 1915898 WHEN sp.master_product_id = 129463 THEN 1909941 WHEN sp.master_product_id = 1453314 THEN 2058963 WHEN sp.master_product_id = 1453315 THEN 1939916 WHEN sp.master_product_id = 107092 THEN 1915898 WHEN sp.master_product_id = 2670949 THEN 1933366 WHEN sp.master_product_id = 205836 THEN 1909941 WHEN sp.master_product_id = 1915898 THEN 1915898 WHEN sp.master_product_id = 164584 THEN 1910399 WHEN sp.master_product_id = 1909941 THEN 1909941 WHEN sp.master_product_id = 1917004 THEN 1917004 WHEN sp.master_product_id = 2244024 THEN 2244024 WHEN sp.master_product_id = 112818 THEN 1909941 WHEN sp.master_product_id = 3000385 THEN 2058963 WHEN sp.master_product_id = 1455029 THEN 1915898 WHEN sp.master_product_id = 2058963 THEN 2058963 WHEN sp.master_product_id = 1986966 THEN 1915898 WHEN sp.master_product_id = 1960939 THEN 1960939 WHEN sp.master_product_id = 1907946 THEN 1939916 WHEN sp.master_product_id = 1907936 THEN 1915898 WHEN sp.master_product_id = 1456475 THEN 1909168 WHEN sp.master_product_id = 190894 THEN 1915898 WHEN sp.master_product_id = 131891 THEN 1909939 WHEN sp.master_product_id = 199437 THEN 2058963 WHEN sp.master_product_id = 160440 THEN 1909939 WHEN sp.master_product_id = 2637094 THEN 1915898 WHEN sp.master_product_id = 133463 THEN 1915898 WHEN sp.master_product_id = 1907938 THEN 2058963 WHEN sp.master_product_id = 157086 THEN 1939916 WHEN sp.master_product_id = 98428 THEN 1909939 WHEN sp.master_product_id = 166132 THEN 1926920 WHEN sp.master_product_id = 98240 THEN 2058963 WHEN sp.master_product_id = 99834 THEN 1952957 WHEN sp.master_product_id = 1930007 THEN 1909941 WHEN sp.master_product_id = 109313 THEN 1915898 WHEN sp.master_product_id = 98238 THEN 1915898 WHEN sp.master_product_id = 127440 THEN 1909941 ELSE sp.master_product_id END limit 500
Bindings:
[4533815,4531886,4072560,2864871,2634246,2460379,2427312,2423943,2413856,2413855,2390497,2319509,2257475,2244024,2190128,2178279,2167056,2151263,2136438,2058963,2049531,2047938,2045870,2045396,2000831,1966954,1962021,1960939,1959857,1952957,1939916,1938566,1935988,1935265,1933366,1933365,1931249,1930007,1928902,1928901,1928807,1928253,1926920,1926835,1926121,1926120,1922599,1922388,1921228,1920468,1919767,1918295,1918287,1917004,1916627,1915898,1915867,1915609,1915186,1915185,1913217,1913216,1912369,1912286,1912226,1912088,1912087,1912018,1912003,1911972,1911874,1911613,1911330,1910510,1910474,1910399,1910197,1910173,1910051,1909949,1909941,1909939,1909908,1909873,1909866,1909865,1909827,1909820,1909819,1909719,1909474,1909369,1909366,1909358,1909289,1909168,2681942,2927777,1920702,95650,703893,7477797,134045,4039359,97564,2066134,97351,1458061,4227275,109026,160117,109547,2986223,129463,1453314,1453315,107092,2670949,205836,164584,112818,3000385,1455029,1986966,1907946,1907936,1456475,190894,131891,199437,160440,2637094,133463,1907938,157086,98428,166132,98240,99834,109313,98238,127440,0,1107,7,1119,1127,1148,1158,1183,404,270,1266,385,395,1284,1393,1401,1372,1373,1374,1375,1391,1115,1116,1117,1122,1128,1130,1134,1135,1136,1137,1376,1144,1149,1150,1152,1154,1161,1162,1163,1164,1165,1167,1171,1172,1174,1176,1178,1179,1180,1184,1185,1187,1189,1190,1191,1193,1195,1197,1199,1200,1202,1203,1204,1208,1212,1213,1214,1215,1222,1225,1227,1228,1231,1233,1234,1235,1237,1242,1247,1248,1252,1253,1256,1257,1258,1259,1267,1268,1269,1270,1272,1276,1278,1281,1294,1295,1297,1302,1304,1408,1309,1310,1314,1322,1323,1324,1329,1331,1332,1333,1335,1337,1338,1340,1341,1346,1347,136,206,255,248,213,177,179,304,283,314,344,372,375,374,386,388,389,401,403,394,396,397,400,402,393,411,408,1348,1351,1357,1358,1360,1363,1364,1365,1366,1367,1378,1381,1383,1387,1389,1392,1396,1399,1403,1404,1406,1407,1410,269,289,225]
#9
⏱️ 208.45 мс
select * from "store_prices" where "id" in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Bindings:
[805280,803028,806602,6320171,805106,804670,807880,856485,852889,858392,856215,855376,852843,7576472,10470810,860029,879470,875976,881239,879211,878341,882793,887214,884017,888914,886969,886210,890424,894652,891616,896256,894426,893681,902871,899156,904760,902578,901674,906385,910242,907552,911713,910041,909534,913076,933495,929610,935476,933210,932258,929574,937157,948725,945467,950488,948478,947672,952047,963062,959640,964815,962800,961995,959594,966356,620998,617890,622581,620784,620032,624046,5554467,5554594,5554690,5554693,5554814,5557200,5557237,5557238,5557244,5557279,970665,5559166,5557316,5557414,5559223,5559502,5561594,5561633,5564509,5566854,5567088,5569059,5569074,5569145,5569146,5569278,5569318,5569420,5542287,5542288,5554433,5554434,5554840,5557100,967608,5559479,5567078,5567086,5544410,5557135,5557334,5542238,5542239,5547020,5557102,5557103,5567062,5559416,5547015,972310,5547283,5552120,5547019,5549910,970426,969740,973813,5216121,5216212,5216220,5216223,5216323,5218694,5218695,5218703,5218737,5218744,978189,5216211,5218821,5218928,5221385,5221754,5221847,5221884,5226804,5229141,5229406,5231440,5231466,5231481,5231552,5231553,5231700,5231767,5231860,5213949,5213950,975023,5223601,5229404,5203860,5209250,5212006,5203732,5203733,5209187,5213966,5216496,5209107,5209108,5216558,5221666,5233677,5209186,979849,977932,977300,981337,1008710,1004945,1010653,5572510,1008437,1007603,1012244,1016126,1013422,1017606,4977989,1015942,4977977,1015392,4978058,1018982,1106414,1102674,1108301,5373044,1106137,1105194,1109913,1218932,1215805,1220648,5975607,1218681,1217990,1222117,1234296,1230617,1236139,1234012,1233033,1237738,1241592,1238921,1243014,5928292,1241401,1240871,1244401,1309600,1305772,1311532,4502957,4514904,1309316,4508226,1309791,1308393,1313145,1317031,1314345,1318482,4383847,4393307,1316809,1316280,1319849,1333071,1329993,1334808,4267699,1332832,1332201,4261851,4282883,4267753,1336297,1340158,1337438,1341640,1339942,1339393,6533391,6531820,6531981,1377674,1373706,1379578,1377379,1376404,1373659,7970555,1373571,1381216,1386636,1382789,1388598,1386340,1385412,1382752,10811428,6518061,1390229,1393976,1391426,1395350,6411646,1393785,1393281,7882649,6425281,1401074,1397920,1402785,1400829,6385913,1400188,1404301,1425940,1422337,1427790,1425647,1424733,1422292,6322456,1429389,1432935,1430533,1434339,6293580,1432756,1432230,6290723,6290638,6290639,1435698,1439386,1436758,1440825,5935939,1439185,1438655,5932782,5709731,5935908,5797101,5970725,1447354,1443551,1449274,6092398,1447055,1446083,1450899,1456138,1452396,1458040,5842814,1455842,1454898,5838009,1459632,1487992,1484280,1489910,5302437,1487703,5319767,1486788,5317262,5298011,5298012,1491527,1512150,1509566,5826655,5801226,1511947,5818768,1511450,1514911,4121034,4121006,4120960]
#10
⏱️ 5.06 мс
select * from "stores" where "stores"."id" in (7, 136, 177, 179, 206, 213, 225, 248, 255, 269, 270, 283, 289, 304, 314, 344, 372, 374, 375, 385, 386, 388, 389, 393, 394, 395, 396, 397, 400, 401, 402, 403, 404, 408, 411, 1107)
#11
⏱️ 2.42 мс
select * from "stores" where "is_active" = ? and "latitude" is not null and "longitude" is not null and "city_slug" = ?
Bindings:
[true,"israel"]
#12
⏱️ 2.35 мс
select * from "locations" where "city_slug" = ? limit 1
Bindings:
["israel"]
#13
⏱️ 1.89 мс
select * from "locations" where "is_popular" = ? order by "sort_order" asc
Bindings:
[true]
#14
⏱️ 2.67 мс
select * from "locations" where "is_active" = ? order by "is_popular" desc, "sort_order" asc
Bindings:
[true]