| 1 |
0.29 ms |
SELECT DISTINCT g0_.id AS id_0 FROM gnreview g0_ LIMIT 20 OFFSET 1320
SELECT DISTINCT g0_.id AS id_0 FROM gnreview g0_ LIMIT 20 OFFSET 1320;
|
| 2 |
0.40 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: [
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1127
1128
1129
1131
1132
1135
1136
1137
]
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 (1113, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1127, 1128, 1129, 1131, 1132, 1135, 1136, 1137);
|
| 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.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 = 812;
|
| 5 |
0.23 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 = 257;
|
| 6 |
0.28 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.25 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.27 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.30 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 = 813;
|
| 10 |
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 = 814;
|
| 11 |
0.30 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 = 811;
|
| 12 |
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 = 256;
|
| 13 |
0.28 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;
|
| 14 |
0.31 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 = 865;
|
| 15 |
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 = 271;
|
| 16 |
0.30 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 = 866;
|
| 17 |
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 = 797;
|
| 18 |
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 = 254;
|
| 19 |
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 = 798;
|
| 20 |
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 = 799;
|
| 21 |
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 = 800;
|
| 22 |
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 = 801;
|
| 23 |
0.30 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 = 802;
|
| 24 |
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 = 868;
|
| 25 |
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 = 272;
|
| 26 |
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 = 476;
|
| 27 |
0.27 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 = 145;
|
| 28 |
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 = 803;
|
| 29 |
0.27 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 = 255;
|
| 30 |
0.30 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 = 805;
|
| 31 |
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 = 806;
|
| 32 |
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 = 809;
|
| 33 |
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 = 810;
|
| 34 |
0.29 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 = 2;
|
| 35 |
0.30 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 = 815;
|
| 36 |
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 = 258;
|