1
1.24 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . slug AS slug_4 , t0 . de_nom AS de_nom_5 , t0 . main_cities AS main_cities_6 , t0 . lat AS lat_7 , t0 . lng AS lng_8 , t0 . region_id AS region_id_9 FROM department t0 WHERE t0 . code = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . slug AS slug_4 , t0 . de_nom AS de_nom_5 , t0 . main_cities AS main_cities_6 , t0 . lat AS lat_7 , t0 . lng AS lng_8 , t0 . region_id AS region_id_9 FROM department t0 WHERE t0 . code = '34' LIMIT 1 ;
Copy
2
0.82 ms
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . legacy_department AS legacy_department_3 , c0_ . latitude AS latitude_4 , c0_ . longitude AS longitude_5 , c0_ . website AS website_6 , c0_ . departement_id AS departement_id_7 FROM city c0_ WHERE c0_ . departement_id = ? AND ((LOWER (c0_ . slug ) = ? ) OR (LOWER (c0_ . name ) = ? )) LIMIT 1
Parameters :
[
35
"lattes "
"lattes "
]
SELECT c0_ . id AS id_0 , c0_ . name AS name_1 , c0_ . slug AS slug_2 , c0_ . legacy_department AS legacy_department_3 , c0_ . latitude AS latitude_4 , c0_ . longitude AS longitude_5 , c0_ . website AS website_6 , c0_ . departement_id AS departement_id_7 FROM city c0_ WHERE c0_ . departement_id = 35 AND ((LOWER (c0_ . slug ) = 'lattes' ) OR (LOWER (c0_ . name ) = 'lattes' )) LIMIT 1 ;
Copy
3
0.58 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . description_de AS description_de_4 , t0 . description_fr AS description_fr_5 , t0 . description_en AS description_en_6 , t0 . description_es AS description_es_7 , t0 . image_name AS image_name_8 , t0 . updated_at AS updated_at_9 FROM region_unofficial t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . description_de AS description_de_4 , t0 . description_fr AS description_fr_5 , t0 . description_en AS description_en_6 , t0 . description_es AS description_es_7 , t0 . image_name AS image_name_8 , t0 . updated_at AS updated_at_9 FROM region_unofficial t0 ;
Copy
4
0.42 ms
SELECT t0 . id AS id_1 , t0 . weekday AS weekday_2 , t0 . time_from AS time_from_3 , t0 . time_to AS time_to_4 , t0 . note_periode AS note_periode_5 , t0 . note_hour AS note_hour_6 , t0 . link AS link_7 , t0 . link_available AS link_available_8 , t0 . legacy_city AS legacy_city_9 , t0 . legacy_adress AS legacy_adress_10 , t0 . description AS description_11 , t0 . periode_on AS periode_on_12 , t0 . slug_city AS slug_city_13 , t0 . location_id AS location_id_14 , t0 . legacy_dpt_id AS legacy_dpt_id_15 , t0 . city_id AS city_id_16 FROM market t0 WHERE t0 . city_id = ?
SELECT t0 . id AS id_1 , t0 . weekday AS weekday_2 , t0 . time_from AS time_from_3 , t0 . time_to AS time_to_4 , t0 . note_periode AS note_periode_5 , t0 . note_hour AS note_hour_6 , t0 . link AS link_7 , t0 . link_available AS link_available_8 , t0 . legacy_city AS legacy_city_9 , t0 . legacy_adress AS legacy_adress_10 , t0 . description AS description_11 , t0 . periode_on AS periode_on_12 , t0 . slug_city AS slug_city_13 , t0 . location_id AS location_id_14 , t0 . legacy_dpt_id AS legacy_dpt_id_15 , t0 . city_id AS city_id_16 FROM market t0 WHERE t0 . city_id = 13598 ;
Copy
5
0.45 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 FROM region t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 FROM region t0 WHERE t0 . id = 12 ;
Copy