Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.density AS density_3,
  c0_.surface AS surface_4,
  c0_.soundex AS soundex_5,
  c0_.metaphone AS metaphone_6,
  c0_.latitude AS latitude_7,
  c0_.longitude AS longitude_8,
  c0_.website AS website_9,
  c0_.population AS population_10,
  c0_.description AS description_11,
  c0_.legacy_id AS legacy_id_12,
  c0_.last_geo_parsing AS last_geo_parsing_13,
  c0_.department_id AS department_id_14
FROM
  city c0_
WHERE
  c0_.legacy_id = ?
  AND c0_.slug = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.density AS density_3, c0_.surface AS surface_4, c0_.soundex AS soundex_5, c0_.metaphone AS metaphone_6, c0_.latitude AS latitude_7, c0_.longitude AS longitude_8, c0_.website AS website_9, c0_.population AS population_10, c0_.description AS description_11, c0_.legacy_id AS legacy_id_12, c0_.last_geo_parsing AS last_geo_parsing_13, c0_.department_id AS department_id_14 FROM city c0_ WHERE c0_.legacy_id = 24172 AND c0_.slug = 'eyzies-de-tayac-sireuil' LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.legacy_id AS legacy_id_1,
  e0_.category_string AS category_string_2,
  e0_.description AS description_3,
  e0_.title AS title_4,
  e0_.short_description AS short_description_5,
  e0_.status AS status_6,
  e0_.creation_date AS creation_date_7,
  e0_.update_date AS update_date_8,
  e0_.type AS type_9,
  e0_.start_date AS start_date_10,
  e0_.end_date AS end_date_11,
  e0_.start_at AS start_at_12,
  e0_.end_at AS end_at_13,
  e0_.legacy_adress AS legacy_adress_14,
  e0_.legacy_contact_name AS legacy_contact_name_15,
  e0_.legacy_contact_phone AS legacy_contact_phone_16,
  e0_.legacy_contact_email AS legacy_contact_email_17,
  e0_.legacy_organisator_email AS legacy_organisator_email_18,
  e0_.legacy_organisator_phone AS legacy_organisator_phone_19,
  e0_.website AS website_20,
  e0_.links AS links_21,
  e0_.legacy_facebook_page AS legacy_facebook_page_22,
  e0_.source AS source_23,
  e0_.legacy_lat AS legacy_lat_24,
  e0_.legacy_lng AS legacy_lng_25,
  e0_.cover AS cover_26,
  e0_.registration_form AS registration_form_27,
  e0_.slug AS slug_28,
  e0_.is_recurring AS is_recurring_29,
  e0_.legacy_recurrence AS legacy_recurrence_30,
  e0_.recurrence AS recurrence_31,
  e0_.periode_on AS periode_on_32,
  e0_.guid AS guid_33,
  e0_.duplicate_check_done AS duplicate_check_done_34,
  e0_.rrule AS rrule_35,
  e0_.keep_indexable AS keep_indexable_36,
  e0_.score AS score_37,
  e0_.referring_url AS referring_url_38,
  e0_.ticket_url AS ticket_url_39,
  c1_.id AS id_40,
  c1_.name AS name_41,
  c1_.slug AS slug_42,
  c1_.density AS density_43,
  c1_.surface AS surface_44,
  c1_.soundex AS soundex_45,
  c1_.metaphone AS metaphone_46,
  c1_.latitude AS latitude_47,
  c1_.longitude AS longitude_48,
  c1_.website AS website_49,
  c1_.population AS population_50,
  c1_.description AS description_51,
  c1_.legacy_id AS legacy_id_52,
  c1_.last_geo_parsing AS last_geo_parsing_53,
  c2_.id AS id_54,
  c2_.title AS title_55,
  c2_.slug AS slug_56,
  c2_.plural AS plural_57,
  c2_.description AS description_58,
  c2_.legacy_id AS legacy_id_59,
  c2_.creation_date AS creation_date_60,
  c2_.update_date AS update_date_61,
  c2_.color AS color_62,
  c2_.page_description AS page_description_63,
  c2_.marker AS marker_64,
  c2_.page_title AS page_title_65,
  c2_.thumbnail_filename AS thumbnail_filename_66,
  c2_.count AS count_67,
  c2_.position AS position_68,
  c2_.card_description AS card_description_69,
  c2_.is_event_or_point_of_interest AS is_event_or_point_of_interest_70,
  c2_.is_legal_info AS is_legal_info_71,
  c2_.is_general_organism AS is_general_organism_72,
  e0_.duplicate_id AS duplicate_id_73,
  e0_.organism_id AS organism_id_74,
  e0_.user_id AS user_id_75,
  e0_.city_id AS city_id_76,
  e0_.category_id AS category_id_77,
  e0_.association_id AS association_id_78,
  e0_.location_id AS location_id_79,
  e0_.contact_id AS contact_id_80,
  e0_.organisator_id AS organisator_id_81,
  c1_.department_id AS department_id_82,
  c2_.parent_id AS parent_id_83
FROM
  event e0_
  LEFT JOIN city c1_ ON e0_.city_id = c1_.id
  LEFT JOIN category c2_ ON e0_.category_id = c2_.id
WHERE
  e0_.end_date >= ?
  AND e0_.status <> ?
  AND c2_.is_event_or_point_of_interest = ?
  AND e0_.city_id = ?
ORDER BY
  e0_.end_date ASC
LIMIT
  30

SELECT e0_.id AS id_0, e0_.legacy_id AS legacy_id_1, e0_.category_string AS category_string_2, e0_.description AS description_3, e0_.title AS title_4, e0_.short_description AS short_description_5, e0_.status AS status_6, e0_.creation_date AS creation_date_7, e0_.update_date AS update_date_8, e0_.type AS type_9, e0_.start_date AS start_date_10, e0_.end_date AS end_date_11, e0_.start_at AS start_at_12, e0_.end_at AS end_at_13, e0_.legacy_adress AS legacy_adress_14, e0_.legacy_contact_name AS legacy_contact_name_15, e0_.legacy_contact_phone AS legacy_contact_phone_16, e0_.legacy_contact_email AS legacy_contact_email_17, e0_.legacy_organisator_email AS legacy_organisator_email_18, e0_.legacy_organisator_phone AS legacy_organisator_phone_19, e0_.website AS website_20, e0_.links AS links_21, e0_.legacy_facebook_page AS legacy_facebook_page_22, e0_.source AS source_23, e0_.legacy_lat AS legacy_lat_24, e0_.legacy_lng AS legacy_lng_25, e0_.cover AS cover_26, e0_.registration_form AS registration_form_27, e0_.slug AS slug_28, e0_.is_recurring AS is_recurring_29, e0_.legacy_recurrence AS legacy_recurrence_30, e0_.recurrence AS recurrence_31, e0_.periode_on AS periode_on_32, e0_.guid AS guid_33, e0_.duplicate_check_done AS duplicate_check_done_34, e0_.rrule AS rrule_35, e0_.keep_indexable AS keep_indexable_36, e0_.score AS score_37, e0_.referring_url AS referring_url_38, e0_.ticket_url AS ticket_url_39, c1_.id AS id_40, c1_.name AS name_41, c1_.slug AS slug_42, c1_.density AS density_43, c1_.surface AS surface_44, c1_.soundex AS soundex_45, c1_.metaphone AS metaphone_46, c1_.latitude AS latitude_47, c1_.longitude AS longitude_48, c1_.website AS website_49, c1_.population AS population_50, c1_.description AS description_51, c1_.legacy_id AS legacy_id_52, c1_.last_geo_parsing AS last_geo_parsing_53, c2_.id AS id_54, c2_.title AS title_55, c2_.slug AS slug_56, c2_.plural AS plural_57, c2_.description AS description_58, c2_.legacy_id AS legacy_id_59, c2_.creation_date AS creation_date_60, c2_.update_date AS update_date_61, c2_.color AS color_62, c2_.page_description AS page_description_63, c2_.marker AS marker_64, c2_.page_title AS page_title_65, c2_.thumbnail_filename AS thumbnail_filename_66, c2_.count AS count_67, c2_.position AS position_68, c2_.card_description AS card_description_69, c2_.is_event_or_point_of_interest AS is_event_or_point_of_interest_70, c2_.is_legal_info AS is_legal_info_71, c2_.is_general_organism AS is_general_organism_72, e0_.duplicate_id AS duplicate_id_73, e0_.organism_id AS organism_id_74, e0_.user_id AS user_id_75, e0_.city_id AS city_id_76, e0_.category_id AS category_id_77, e0_.association_id AS association_id_78, e0_.location_id AS location_id_79, e0_.contact_id AS contact_id_80, e0_.organisator_id AS organisator_id_81, c1_.department_id AS department_id_82, c2_.parent_id AS parent_id_83 FROM event e0_ LEFT JOIN city c1_ ON e0_.city_id = c1_.id LEFT JOIN category c2_ ON e0_.category_id = c2_.id WHERE e0_.end_date >= '2026-06-21 23:13:31' AND e0_.status <> 'gone' AND c2_.is_event_or_point_of_interest = 1 AND e0_.city_id = 8444 ORDER BY e0_.end_date ASC LIMIT 30;

SELECT
  COUNT(e0_.id) AS sclr_0
FROM
  event e0_
WHERE
  e0_.start_date >= ?
  AND e0_.city_id = ?

SELECT COUNT(e0_.id) AS sclr_0 FROM event e0_ WHERE e0_.start_date >= '2026-06-21 23:13:31' AND e0_.city_id = 8444;

SELECT
  o0_.id AS id_0,
  o0_.is_legal_info AS is_legal_info_1,
  o0_.crm_status AS crm_status_2,
  o0_.crm_notes AS crm_notes_3,
  o0_.last_contacted_at AS last_contacted_at_4,
  o0_.next_contact_at AS next_contact_at_5,
  o0_.do_not_contact AS do_not_contact_6,
  o0_.source AS source_7,
  o0_.name AS name_8,
  o0_.type AS type_9,
  o0_.legacy_id AS legacy_id_10,
  o0_.legacy_adress AS legacy_adress_11,
  o0_.phone AS phone_12,
  o0_.email AS email_13,
  o0_.website AS website_14,
  o0_.creation_date AS creation_date_15,
  o0_.update_date AS update_date_16,
  o0_.is_for_event AS is_for_event_17,
  o0_.status AS status_18,
  o0_.guid AS guid_19,
  o0_.alway_open AS alway_open_20,
  o0_.opening_hours_string AS opening_hours_string_21,
  o0_.is_validated AS is_validated_22,
  o0_.thumbnail_filename AS thumbnail_filename_23,
  o0_.description AS description_24,
  c1_.id AS id_25,
  c1_.name AS name_26,
  c1_.slug AS slug_27,
  c1_.density AS density_28,
  c1_.surface AS surface_29,
  c1_.soundex AS soundex_30,
  c1_.metaphone AS metaphone_31,
  c1_.latitude AS latitude_32,
  c1_.longitude AS longitude_33,
  c1_.website AS website_34,
  c1_.population AS population_35,
  c1_.description AS description_36,
  c1_.legacy_id AS legacy_id_37,
  c1_.last_geo_parsing AS last_geo_parsing_38,
  c2_.id AS id_39,
  c2_.title AS title_40,
  c2_.slug AS slug_41,
  c2_.plural AS plural_42,
  c2_.description AS description_43,
  c2_.legacy_id AS legacy_id_44,
  c2_.creation_date AS creation_date_45,
  c2_.update_date AS update_date_46,
  c2_.color AS color_47,
  c2_.page_description AS page_description_48,
  c2_.marker AS marker_49,
  c2_.page_title AS page_title_50,
  c2_.thumbnail_filename AS thumbnail_filename_51,
  c2_.count AS count_52,
  c2_.position AS position_53,
  c2_.card_description AS card_description_54,
  c2_.is_event_or_point_of_interest AS is_event_or_point_of_interest_55,
  c2_.is_legal_info AS is_legal_info_56,
  c2_.is_general_organism AS is_general_organism_57,
  o0_.city_id AS city_id_58,
  o0_.location_id AS location_id_59,
  c1_.department_id AS department_id_60,
  c2_.parent_id AS parent_id_61
FROM
  organism o0_
  LEFT JOIN city c1_ ON o0_.city_id = c1_.id
  LEFT JOIN organism_category o3_ ON o0_.id = o3_.organism_id
  LEFT JOIN category c2_ ON c2_.id = o3_.category_id
WHERE
  o0_.city_id = ?
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_62
        FROM
          category c4_
        WHERE
          EXISTS (
            SELECT
              1
            FROM
              organism_category o5_
            WHERE
              o5_.organism_id = o0_.id
              AND o5_.category_id IN (c4_.id)
          )
          AND c4_.is_event_or_point_of_interest = ?
      )
    )
  )
ORDER BY
  o0_.id DESC
LIMIT
  30

SELECT o0_.id AS id_0, o0_.is_legal_info AS is_legal_info_1, o0_.crm_status AS crm_status_2, o0_.crm_notes AS crm_notes_3, o0_.last_contacted_at AS last_contacted_at_4, o0_.next_contact_at AS next_contact_at_5, o0_.do_not_contact AS do_not_contact_6, o0_.source AS source_7, o0_.name AS name_8, o0_.type AS type_9, o0_.legacy_id AS legacy_id_10, o0_.legacy_adress AS legacy_adress_11, o0_.phone AS phone_12, o0_.email AS email_13, o0_.website AS website_14, o0_.creation_date AS creation_date_15, o0_.update_date AS update_date_16, o0_.is_for_event AS is_for_event_17, o0_.status AS status_18, o0_.guid AS guid_19, o0_.alway_open AS alway_open_20, o0_.opening_hours_string AS opening_hours_string_21, o0_.is_validated AS is_validated_22, o0_.thumbnail_filename AS thumbnail_filename_23, o0_.description AS description_24, c1_.id AS id_25, c1_.name AS name_26, c1_.slug AS slug_27, c1_.density AS density_28, c1_.surface AS surface_29, c1_.soundex AS soundex_30, c1_.metaphone AS metaphone_31, c1_.latitude AS latitude_32, c1_.longitude AS longitude_33, c1_.website AS website_34, c1_.population AS population_35, c1_.description AS description_36, c1_.legacy_id AS legacy_id_37, c1_.last_geo_parsing AS last_geo_parsing_38, c2_.id AS id_39, c2_.title AS title_40, c2_.slug AS slug_41, c2_.plural AS plural_42, c2_.description AS description_43, c2_.legacy_id AS legacy_id_44, c2_.creation_date AS creation_date_45, c2_.update_date AS update_date_46, c2_.color AS color_47, c2_.page_description AS page_description_48, c2_.marker AS marker_49, c2_.page_title AS page_title_50, c2_.thumbnail_filename AS thumbnail_filename_51, c2_.count AS count_52, c2_.position AS position_53, c2_.card_description AS card_description_54, c2_.is_event_or_point_of_interest AS is_event_or_point_of_interest_55, c2_.is_legal_info AS is_legal_info_56, c2_.is_general_organism AS is_general_organism_57, o0_.city_id AS city_id_58, o0_.location_id AS location_id_59, c1_.department_id AS department_id_60, c2_.parent_id AS parent_id_61 FROM organism o0_ LEFT JOIN city c1_ ON o0_.city_id = c1_.id LEFT JOIN organism_category o3_ ON o0_.id = o3_.organism_id LEFT JOIN category c2_ ON c2_.id = o3_.category_id WHERE o0_.city_id = 8444 AND (NOT (EXISTS (SELECT 1 AS sclr_62 FROM category c4_ WHERE EXISTS (SELECT 1 FROM organism_category o5_ WHERE o5_.organism_id = o0_.id AND o5_.category_id IN (c4_.id)) AND c4_.is_event_or_point_of_interest = 0))) ORDER BY o0_.id DESC LIMIT 30;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  organism o0_
WHERE
  o0_.city_id = ?
  AND (
    NOT (
      EXISTS (
        SELECT
          1 AS sclr_1
        FROM
          category c1_
        WHERE
          EXISTS (
            SELECT
              1
            FROM
              organism_category o2_
            WHERE
              o2_.organism_id = o0_.id
              AND o2_.category_id IN (c1_.id)
          )
          AND c1_.is_event_or_point_of_interest = ?
      )
    )
  )

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM organism o0_ WHERE o0_.city_id = 8444 AND (NOT (EXISTS (SELECT 1 AS sclr_1 FROM category c1_ WHERE EXISTS (SELECT 1 FROM organism_category o2_ WHERE o2_.organism_id = o0_.id AND o2_.category_id IN (c1_.id)) AND c1_.is_event_or_point_of_interest = 0)));

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.density AS density_3,
  c0_.surface AS surface_4,
  c0_.soundex AS soundex_5,
  c0_.metaphone AS metaphone_6,
  c0_.latitude AS latitude_7,
  c0_.longitude AS longitude_8,
  c0_.website AS website_9,
  c0_.population AS population_10,
  c0_.description AS description_11,
  c0_.legacy_id AS legacy_id_12,
  c0_.last_geo_parsing AS last_geo_parsing_13,
  c0_.department_id AS department_id_14
FROM
  city c0_
WHERE
  (
    6371 * ACOS(
      COS(
        RADIANS(?)
      ) * COS(
        RADIANS(c0_.latitude)
      ) * COS(
        RADIANS(c0_.longitude) - RADIANS(?)
      ) + SIN(
        RADIANS(?)
      ) * SIN(
        RADIANS(c0_.latitude)
      )
    )
  ) < ?
ORDER BY
  c0_.population DESC
LIMIT
  10

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.density AS density_3, c0_.surface AS surface_4, c0_.soundex AS soundex_5, c0_.metaphone AS metaphone_6, c0_.latitude AS latitude_7, c0_.longitude AS longitude_8, c0_.website AS website_9, c0_.population AS population_10, c0_.description AS description_11, c0_.legacy_id AS legacy_id_12, c0_.last_geo_parsing AS last_geo_parsing_13, c0_.department_id AS department_id_14 FROM city c0_ WHERE (6371 * ACOS(COS(RADIANS(44.9356)) * COS(RADIANS(c0_.latitude)) * COS(RADIANS(c0_.longitude) - RADIANS(1.01695)) + SIN(RADIANS(44.9356)) * SIN(RADIANS(c0_.latitude)))) < 15 ORDER BY c0_.population DESC LIMIT 10;

SELECT
  o0_.id AS id_0,
  o0_.is_legal_info AS is_legal_info_1,
  o0_.crm_status AS crm_status_2,
  o0_.crm_notes AS crm_notes_3,
  o0_.last_contacted_at AS last_contacted_at_4,
  o0_.next_contact_at AS next_contact_at_5,
  o0_.do_not_contact AS do_not_contact_6,
  o0_.source AS source_7,
  o0_.name AS name_8,
  o0_.type AS type_9,
  o0_.legacy_id AS legacy_id_10,
  o0_.legacy_adress AS legacy_adress_11,
  o0_.phone AS phone_12,
  o0_.email AS email_13,
  o0_.website AS website_14,
  o0_.creation_date AS creation_date_15,
  o0_.update_date AS update_date_16,
  o0_.is_for_event AS is_for_event_17,
  o0_.status AS status_18,
  o0_.guid AS guid_19,
  o0_.alway_open AS alway_open_20,
  o0_.opening_hours_string AS opening_hours_string_21,
  o0_.is_validated AS is_validated_22,
  o0_.thumbnail_filename AS thumbnail_filename_23,
  o0_.description AS description_24,
  o0_.city_id AS city_id_25,
  o0_.location_id AS location_id_26
FROM
  organism o0_
  INNER JOIN organism_category o2_ ON o0_.id = o2_.organism_id
  INNER JOIN category c1_ ON c1_.id = o2_.category_id
WHERE
  o0_.city_id = ?
  AND c1_.is_legal_info = 1

SELECT o0_.id AS id_0, o0_.is_legal_info AS is_legal_info_1, o0_.crm_status AS crm_status_2, o0_.crm_notes AS crm_notes_3, o0_.last_contacted_at AS last_contacted_at_4, o0_.next_contact_at AS next_contact_at_5, o0_.do_not_contact AS do_not_contact_6, o0_.source AS source_7, o0_.name AS name_8, o0_.type AS type_9, o0_.legacy_id AS legacy_id_10, o0_.legacy_adress AS legacy_adress_11, o0_.phone AS phone_12, o0_.email AS email_13, o0_.website AS website_14, o0_.creation_date AS creation_date_15, o0_.update_date AS update_date_16, o0_.is_for_event AS is_for_event_17, o0_.status AS status_18, o0_.guid AS guid_19, o0_.alway_open AS alway_open_20, o0_.opening_hours_string AS opening_hours_string_21, o0_.is_validated AS is_validated_22, o0_.thumbnail_filename AS thumbnail_filename_23, o0_.description AS description_24, o0_.city_id AS city_id_25, o0_.location_id AS location_id_26 FROM organism o0_ INNER JOIN organism_category o2_ ON o0_.id = o2_.organism_id INNER JOIN category c1_ ON c1_.id = o2_.category_id WHERE o0_.city_id = 8444 AND c1_.is_legal_info = 1;

SELECT
  c0_.title AS title_0,
  COUNT(DISTINCT o1_.id) AS sclr_1,
  c0_.slug AS slug_2
FROM
  organism o1_
  INNER JOIN organism_category o2_ ON o1_.id = o2_.organism_id
  INNER JOIN category c0_ ON c0_.id = o2_.category_id
WHERE
  o1_.city_id = ?
  AND c0_.is_event_or_point_of_interest = ?
  AND c0_.is_general_organism = 1
GROUP BY
  c0_.id

SELECT c0_.title AS title_0, COUNT(DISTINCT o1_.id) AS sclr_1, c0_.slug AS slug_2 FROM organism o1_ INNER JOIN organism_category o2_ ON o1_.id = o2_.organism_id INNER JOIN category c0_ ON c0_.id = o2_.category_id WHERE o1_.city_id = 8444 AND c0_.is_event_or_point_of_interest = 0 AND c0_.is_general_organism = 1 GROUP BY c0_.id;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.description AS description_2,
  s0_.image_filename AS image_filename_3,
  s0_.start_date AS start_date_4,
  s0_.end_date AS end_date_5,
  s0_.latitude AS latitude_6,
  s0_.longitude AS longitude_7,
  s0_.updated_at AS updated_at_8,
  s0_.position_frontend AS position_frontend_9,
  s0_.link AS link_10,
  s0_.category_id AS category_id_11
FROM
  sponsor s0_
WHERE
  s0_.start_date <= ?
  AND (
    (
      s0_.end_date IS NULL
      OR s0_.end_date >= ?
    )
  )
  AND (
    s0_.position_frontend LIKE ?
    OR s0_.position_frontend LIKE ?
  )

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.image_filename AS image_filename_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.latitude AS latitude_6, s0_.longitude AS longitude_7, s0_.updated_at AS updated_at_8, s0_.position_frontend AS position_frontend_9, s0_.link AS link_10, s0_.category_id AS category_id_11 FROM sponsor s0_ WHERE s0_.start_date <= '2026-06-21 23:13:31' AND ((s0_.end_date IS NULL OR s0_.end_date >= '2026-06-21 23:13:31')) AND (s0_.position_frontend LIKE '%category%' OR s0_.position_frontend LIKE '%all%');

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.soundex AS soundex_4,
  t0.legacy_id AS legacy_id_5,
  t0.page_title AS page_title_6,
  t0.with_article AS with_article_7,
  t0.meta_description AS meta_description_8,
  t0.description AS description_9,
  t0.content AS content_10,
  t0.latitude AS latitude_11,
  t0.longitude AS longitude_12,
  t0.img_path AS img_path_13,
  t0.region_id AS region_id_14,
  t0.city_id AS city_id_15
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.soundex AS soundex_4, t0.legacy_id AS legacy_id_5, t0.page_title AS page_title_6, t0.with_article AS with_article_7, t0.meta_description AS meta_description_8, t0.description AS description_9, t0.content AS content_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.img_path AS img_path_13, t0.region_id AS region_id_14, t0.city_id AS city_id_15 FROM department t0 WHERE t0.id = 23;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.city_id AS city_id_3
FROM
  postcode t0
WHERE
  t0.city_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.city_id AS city_id_3 FROM postcode t0 WHERE t0.city_id = 8444;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.with_article AS with_article_4,
  t0.img_path AS img_path_5,
  t0.content AS content_6
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.with_article AS with_article_4, t0.img_path AS img_path_5, t0.content AS content_6 FROM region t0 WHERE t0.id = 10;