| 1 |
8.34 ms |
SELECT DISTINCT g0_.id AS id_0 FROM gnreview g0_ LIMIT 20 OFFSET 1420
SELECT DISTINCT g0_.id AS id_0 FROM gnreview g0_ LIMIT 20 OFFSET 1420;
|
| 2 |
13.26 ms |
SELECT g0_.id AS id_0, g0_.description AS description_1, g0_.is_sealed AS is_sealed_2, g0_.created_at AS created_at_3, g0_.updated_at AS updated_at_4, g0_.is_twisted AS is_twisted_5, g0_.is_welded AS is_welded_6, g0_.is_pressed AS is_pressed_7, g0_.is_copper AS is_copper_8, g0_.is_lpg_inside AS is_lpg_inside_9, g0_.is_empty AS is_empty_10, g0_.gas_stove_status_id AS gas_stove_status_id_11, g0_.gas_boiler_status_id AS gas_boiler_status_id_12, g0_.installation_status_id AS installation_status_id_13, g0_.gnaddress_local_id AS gnaddress_local_id_14 FROM gnreview g0_ WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
1258
1260
1261
1263
1264
1265
1266
1267
1268
1269
1270
1271
1274
1275
1279
1280
1281
1285
1286
1287
]
SELECT g0_.id AS id_0, g0_.description AS description_1, g0_.is_sealed AS is_sealed_2, g0_.created_at AS created_at_3, g0_.updated_at AS updated_at_4, g0_.is_twisted AS is_twisted_5, g0_.is_welded AS is_welded_6, g0_.is_pressed AS is_pressed_7, g0_.is_copper AS is_copper_8, g0_.is_lpg_inside AS is_lpg_inside_9, g0_.is_empty AS is_empty_10, g0_.gas_stove_status_id AS gas_stove_status_id_11, g0_.gas_boiler_status_id AS gas_boiler_status_id_12, g0_.installation_status_id AS installation_status_id_13, g0_.gnaddress_local_id AS gnaddress_local_id_14 FROM gnreview g0_ WHERE g0_.id IN (1258, 1260, 1261, 1263, 1264, 1265, 1266, 1267, 1268, 1269, 1270, 1271, 1274, 1275, 1279, 1280, 1281, 1285, 1286, 1287);
|
| 3 |
0.45 ms |
SELECT count(g0_.id) AS sclr_0 FROM gnreview g0_
SELECT count(g0_.id) AS sclr_0 FROM gnreview g0_;
|
| 4 |
7.80 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1483;
|
| 5 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = 444;
|
| 6 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM gninstallation_status t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM gninstallation_status t0 WHERE t0.id = 1;
|
| 7 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM gngas_stove_status t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM gngas_stove_status t0 WHERE t0.id = 2;
|
| 8 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM gngas_boiler_status t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM gngas_boiler_status t0 WHERE t0.id = 1;
|
| 9 |
9.05 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 2419;
|
| 10 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = 443;
|
| 11 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 2420;
|
| 12 |
9.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1111;
|
| 13 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = 327;
|
| 14 |
0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1112;
|
| 15 |
0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1113;
|
| 16 |
3.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1114;
|
| 17 |
0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1115;
|
| 18 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1116;
|
| 19 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1117;
|
| 20 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1118;
|
| 21 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1330;
|
| 22 |
0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = 389;
|
| 23 |
0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1333;
|
| 24 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1334;
|
| 25 |
0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1322;
|
| 26 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = 385;
|
| 27 |
2.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1329;
|
| 28 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = 388;
|
| 29 |
0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM gngas_boiler_status t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM gngas_boiler_status t0 WHERE t0.id = 5;
|
| 30 |
0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1221;
|
| 31 |
0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = 356;
|
| 32 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1411;
|
| 33 |
0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = 403;
|
| 34 |
13.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1035;
|
| 35 |
0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.areaid AS areaid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM gnaddress t0 WHERE t0.id = 317;
|
| 36 |
31.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.visited AS visited_5, t0.description AS description_6, t0.visited_at AS visited_at_7, t0.gn_address_id AS gn_address_id_8 FROM gnaddress_local t0 WHERE t0.id = 1036;
|