| 1 |
0.22 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.surname AS surname_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.surname AS surname_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7 FROM user t0 WHERE t0.id = 1;
|
| 2 |
0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places t0 WHERE t0.id = '97';
|
| 3 |
0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places t0 WHERE t0.id = 96;
|
| 4 |
0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places t0 WHERE t0.parent_id = ? ORDER BY t0.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.alt_names AS alt_names_5, t0.alvin_id AS alvin_id_6, t0.type AS type_7, t0.approximate_location AS approximate_location_8, t0.location_precision AS location_precision_9, t0.description AS description_10, t0.wikidata_id AS wikidata_id_11, t0.mindat_id AS mindat_id_12, t0.updated_at AS updated_at_13, t0.parent_id AS parent_id_14 FROM places t0 WHERE t0.parent_id = 97 ORDER BY t0.name ASC;
|
| 5 |
0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_establishment AS date_of_establishment_3, t0.date_of_establishment_accuracy AS date_of_establishment_accuracy_4, t0.date_of_dissolution AS date_of_dissolution_5, t0.date_of_dissolution_accuracy AS date_of_dissolution_accuracy_6, t0.sv_description AS sv_description_7, t0.en_description AS en_description_8, t0.research_notes AS research_notes_9, t0.updated_at AS updated_at_10, t0.place_id AS place_id_11, t12.id AS id_13, t12.actor_id AS actor_id_14, t12.institution_id AS institution_id_15, t0.archive_id AS archive_id_16 FROM institutions t0 LEFT JOIN correspondents t12 ON t12.institution_id = t0.id WHERE t0.place_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_of_establishment AS date_of_establishment_3, t0.date_of_establishment_accuracy AS date_of_establishment_accuracy_4, t0.date_of_dissolution AS date_of_dissolution_5, t0.date_of_dissolution_accuracy AS date_of_dissolution_accuracy_6, t0.sv_description AS sv_description_7, t0.en_description AS en_description_8, t0.research_notes AS research_notes_9, t0.updated_at AS updated_at_10, t0.place_id AS place_id_11, t12.id AS id_13, t12.actor_id AS actor_id_14, t12.institution_id AS institution_id_15, t0.archive_id AS archive_id_16 FROM institutions t0 LEFT JOIN correspondents t12 ON t12.institution_id = t0.id WHERE t0.place_id = 97;
|
| 6 |
0.09 ms |
SELECT t0.id AS id_1, t0.date_of_arrival AS date_of_arrival_2, t0.date_of_leaving AS date_of_leaving_3, t0.information AS information_4, t0.date_of_arrival_accuracy AS date_of_arrival_accuracy_5, t0.date_of_leaving_accuracy AS date_of_leaving_accuracy_6, t0.type AS type_7, t0.actor_id AS actor_id_8, t0.place_id AS place_id_9 FROM actors_to_places t0 WHERE t0.place_id = ?
SELECT t0.id AS id_1, t0.date_of_arrival AS date_of_arrival_2, t0.date_of_leaving AS date_of_leaving_3, t0.information AS information_4, t0.date_of_arrival_accuracy AS date_of_arrival_accuracy_5, t0.date_of_leaving_accuracy AS date_of_leaving_accuracy_6, t0.type AS type_7, t0.actor_id AS actor_id_8, t0.place_id AS place_id_9 FROM actors_to_places t0 WHERE t0.place_id = 97;
|