| 1 |
15.64 ms |
SELECT DISTINCT g0_.id AS id_0 FROM gnreview g0_ LIMIT 20 OFFSET 1300
SELECT DISTINCT g0_.id AS id_0 FROM gnreview g0_ LIMIT 20 OFFSET 1300;
|
| 2 |
0.45 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: [
1078
1081
1084
1090
1092
1093
1094
1095
1096
1098
1099
1100
1101
1103
1107
1108
1109
1110
1111
1112
]
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 (1078, 1081, 1084, 1090, 1092, 1093, 1094, 1095, 1096, 1098, 1099, 1100, 1101, 1103, 1107, 1108, 1109, 1110, 1111, 1112);
|
| 3 |
0.23 ms |
SELECT count(g0_.id) AS sclr_0 FROM gnreview g0_
SELECT count(g0_.id) AS sclr_0 FROM gnreview g0_;
|
| 4 |
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 = 1001;
|
| 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 = 296;
|
| 6 |
0.17 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 = 1;
|
| 9 |
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 = 961;
|
| 10 |
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 = 291;
|
| 11 |
0.15 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;
|
| 12 |
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 = 760;
|
| 13 |
0.18 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 = 238;
|
| 14 |
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 = 480;
|
| 15 |
0.18 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 = 146;
|
| 16 |
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 = 482;
|
| 17 |
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 = 483;
|
| 18 |
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 = 484;
|
| 19 |
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 = 485;
|
| 20 |
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 = 486;
|
| 21 |
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 = 881;
|
| 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 = 276;
|
| 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 = 882;
|
| 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 = 883;
|
| 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 = 884;
|
| 26 |
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 = 887;
|
| 27 |
0.26 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 = 277;
|
| 28 |
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 = 991;
|
| 29 |
0.25 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 = 295;
|
| 30 |
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 = 992;
|
| 31 |
0.26 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 = 993;
|
| 32 |
0.26 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 = 473;
|
| 33 |
0.24 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 = 144;
|
| 34 |
0.25 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 = 474;
|
| 35 |
0.26 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 = 475;
|