| 1 |
0.30 ms |
SELECT DISTINCT g0_.id AS id_0 FROM gnreview g0_ LIMIT 20 OFFSET 1440
SELECT DISTINCT g0_.id AS id_0 FROM gnreview g0_ LIMIT 20 OFFSET 1440;
|
| 2 |
0.41 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: [
1288
1289
1293
1295
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1310
1315
1316
1320
1321
]
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 (1288, 1289, 1293, 1295, 1297, 1298, 1299, 1300, 1301, 1302, 1303, 1304, 1305, 1306, 1307, 1310, 1315, 1316, 1320, 1321);
|
| 3 |
0.26 ms |
SELECT count(g0_.id) AS sclr_0 FROM gnreview g0_
SELECT count(g0_.id) AS sclr_0 FROM gnreview g0_;
|
| 4 |
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 = 1037;
|
| 5 |
0.19 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;
|
| 6 |
0.21 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.17 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.16 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;
|
| 9 |
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 = 1146;
|
| 10 |
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 = 336;
|
| 11 |
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;
|
| 12 |
0.16 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 = 1127;
|
| 13 |
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 = 332;
|
| 14 |
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 = 1096;
|
| 15 |
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 = 326;
|
| 16 |
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 = 1098;
|
| 17 |
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 = 1099;
|
| 18 |
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 = 1100;
|
| 19 |
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 = 1101;
|
| 20 |
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 = 1102;
|
| 21 |
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 = 1103;
|
| 22 |
0.16 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 = 1105;
|
| 23 |
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 = 1107;
|
| 24 |
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 = 1108;
|
| 25 |
0.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 = 1109;
|
| 26 |
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 = 1110;
|
| 27 |
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 = 1165;
|
| 28 |
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 = 341;
|
| 29 |
0.16 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 = 1162;
|
| 30 |
0.15 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 = 340;
|
| 31 |
0.16 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 = 1167;
|
| 32 |
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 = 342;
|
| 33 |
0.16 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 = 1466;
|
| 34 |
0.15 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 = 432;
|
| 35 |
0.14 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 = 1459;
|
| 36 |
0.13 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 = 428;
|