| 1 |
35.49 ms |
SELECT DISTINCT g0_.id AS id_0 FROM gnreview g0_ LIMIT 20 OFFSET 1500
SELECT DISTINCT g0_.id AS id_0 FROM gnreview g0_ LIMIT 20 OFFSET 1500;
|
| 2 |
0.58 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: [
1407
1409
1410
1414
1416
1417
1418
1422
1425
1427
1428
1430
1431
1432
1433
1434
1435
1438
1439
1440
]
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 (1407, 1409, 1410, 1414, 1416, 1417, 1418, 1422, 1425, 1427, 1428, 1430, 1431, 1432, 1433, 1434, 1435, 1438, 1439, 1440);
|
| 3 |
0.27 ms |
SELECT count(g0_.id) AS sclr_0 FROM gnreview g0_
SELECT count(g0_.id) AS sclr_0 FROM gnreview g0_;
|
| 4 |
2.01 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 = 1274;
|
| 5 |
0.22 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 = 374;
|
| 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.20 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 |
25.53 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 = 1276;
|
| 10 |
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;
|
| 11 |
0.21 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 = 1277;
|
| 12 |
10.88 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 = 2354;
|
| 13 |
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 = 442;
|
| 14 |
0.21 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 = 2356;
|
| 15 |
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 = 2357;
|
| 16 |
14.13 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 = 2358;
|
| 17 |
0.53 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 = 2362;
|
| 18 |
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 = 2365;
|
| 19 |
0.32 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 = 2367;
|
| 20 |
11.69 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 = 2368;
|
| 21 |
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 = 2370;
|
| 22 |
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 = 2371;
|
| 23 |
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 = 2372;
|
| 24 |
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 = 2373;
|
| 25 |
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 = 2374;
|
| 26 |
0.20 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 = 2;
|
| 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 = 2375;
|
| 28 |
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 = 2378;
|
| 29 |
13.64 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 = 2379;
|
| 30 |
6.55 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 = 2380;
|