Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.legacy_id AS legacy_id_2,
  t0.category_string AS category_string_3,
  t0.description AS description_4,
  t0.title AS title_5,
  t0.short_description AS short_description_6,
  t0.status AS status_7,
  t0.creation_date AS creation_date_8,
  t0.update_date AS update_date_9,
  t0.type AS type_10,
  t0.start_date AS start_date_11,
  t0.end_date AS end_date_12,
  t0.start_at AS start_at_13,
  t0.end_at AS end_at_14,
  t0.legacy_adress AS legacy_adress_15,
  t0.legacy_contact_name AS legacy_contact_name_16,
  t0.legacy_contact_phone AS legacy_contact_phone_17,
  t0.legacy_contact_email AS legacy_contact_email_18,
  t0.legacy_organisator_email AS legacy_organisator_email_19,
  t0.legacy_organisator_phone AS legacy_organisator_phone_20,
  t0.website AS website_21,
  t0.links AS links_22,
  t0.legacy_facebook_page AS legacy_facebook_page_23,
  t0.source AS source_24,
  t0.legacy_lat AS legacy_lat_25,
  t0.legacy_lng AS legacy_lng_26,
  t0.cover AS cover_27,
  t0.registration_form AS registration_form_28,
  t0.slug AS slug_29,
  t0.is_recurring AS is_recurring_30,
  t0.legacy_recurrence AS legacy_recurrence_31,
  t0.recurrence AS recurrence_32,
  t0.periode_on AS periode_on_33,
  t0.guid AS guid_34,
  t0.duplicate_check_done AS duplicate_check_done_35,
  t0.rrule AS rrule_36,
  t0.keep_indexable AS keep_indexable_37,
  t0.score AS score_38,
  t0.referring_url AS referring_url_39,
  t0.ticket_url AS ticket_url_40,
  t0.duplicate_id AS duplicate_id_41,
  t0.organism_id AS organism_id_42,
  t0.user_id AS user_id_43,
  t0.city_id AS city_id_44,
  t0.category_id AS category_id_45,
  t0.association_id AS association_id_46,
  t0.location_id AS location_id_47,
  t0.contact_id AS contact_id_48,
  t0.organisator_id AS organisator_id_49
FROM
  event t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.category_string AS category_string_3, t0.description AS description_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.status AS status_7, t0.creation_date AS creation_date_8, t0.update_date AS update_date_9, t0.type AS type_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.legacy_adress AS legacy_adress_15, t0.legacy_contact_name AS legacy_contact_name_16, t0.legacy_contact_phone AS legacy_contact_phone_17, t0.legacy_contact_email AS legacy_contact_email_18, t0.legacy_organisator_email AS legacy_organisator_email_19, t0.legacy_organisator_phone AS legacy_organisator_phone_20, t0.website AS website_21, t0.links AS links_22, t0.legacy_facebook_page AS legacy_facebook_page_23, t0.source AS source_24, t0.legacy_lat AS legacy_lat_25, t0.legacy_lng AS legacy_lng_26, t0.cover AS cover_27, t0.registration_form AS registration_form_28, t0.slug AS slug_29, t0.is_recurring AS is_recurring_30, t0.legacy_recurrence AS legacy_recurrence_31, t0.recurrence AS recurrence_32, t0.periode_on AS periode_on_33, t0.guid AS guid_34, t0.duplicate_check_done AS duplicate_check_done_35, t0.rrule AS rrule_36, t0.keep_indexable AS keep_indexable_37, t0.score AS score_38, t0.referring_url AS referring_url_39, t0.ticket_url AS ticket_url_40, t0.duplicate_id AS duplicate_id_41, t0.organism_id AS organism_id_42, t0.user_id AS user_id_43, t0.city_id AS city_id_44, t0.category_id AS category_id_45, t0.association_id AS association_id_46, t0.location_id AS location_id_47, t0.contact_id AS contact_id_48, t0.organisator_id AS organisator_id_49 FROM event t0 WHERE t0.slug = '24580-eglise-saint-saturnin-rouffignac-saint-cernin-de-reilhac-1016506' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.density AS density_4,
  t0.surface AS surface_5,
  t0.soundex AS soundex_6,
  t0.metaphone AS metaphone_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.website AS website_10,
  t0.population AS population_11,
  t0.description AS description_12,
  t0.legacy_id AS legacy_id_13,
  t0.last_geo_parsing AS last_geo_parsing_14,
  t0.department_id AS department_id_15
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.density AS density_4, t0.surface AS surface_5, t0.soundex AS soundex_6, t0.metaphone AS metaphone_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.website AS website_10, t0.population AS population_11, t0.description AS description_12, t0.legacy_id AS legacy_id_13, t0.last_geo_parsing AS last_geo_parsing_14, t0.department_id AS department_id_15 FROM city t0 WHERE t0.id = 8618;

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(45.047798)) * COS(RADIANS(c0_.latitude)) * COS(RADIANS(c0_.longitude) - RADIANS(0.97722)) + SIN(RADIANS(45.047798)) * SIN(RADIANS(c0_.latitude)))) < 15 ORDER BY c0_.population DESC LIMIT 10;

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 ?
  )
  AND (
    s0_.category_id = ?
    OR s0_.category_id IS NULL
  )

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-22 08:56:17' AND ((s0_.end_date IS NULL OR s0_.end_date >= '2026-06-22 08:56:17')) AND (s0_.position_frontend LIKE '%category%' OR s0_.position_frontend LIKE '%all%') AND (s0_.category_id = 49 OR s0_.category_id IS NULL);

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.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;

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 = 8618;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.plural AS plural_4,
  t0.description AS description_5,
  t0.legacy_id AS legacy_id_6,
  t0.creation_date AS creation_date_7,
  t0.update_date AS update_date_8,
  t0.color AS color_9,
  t0.page_description AS page_description_10,
  t0.marker AS marker_11,
  t0.page_title AS page_title_12,
  t0.thumbnail_filename AS thumbnail_filename_13,
  t0.count AS count_14,
  t0.position AS position_15,
  t0.card_description AS card_description_16,
  t0.is_event_or_point_of_interest AS is_event_or_point_of_interest_17,
  t0.is_legal_info AS is_legal_info_18,
  t0.is_general_organism AS is_general_organism_19,
  t0.parent_id AS parent_id_20
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.plural AS plural_4, t0.description AS description_5, t0.legacy_id AS legacy_id_6, t0.creation_date AS creation_date_7, t0.update_date AS update_date_8, t0.color AS color_9, t0.page_description AS page_description_10, t0.marker AS marker_11, t0.page_title AS page_title_12, t0.thumbnail_filename AS thumbnail_filename_13, t0.count AS count_14, t0.position AS position_15, t0.card_description AS card_description_16, t0.is_event_or_point_of_interest AS is_event_or_point_of_interest_17, t0.is_legal_info AS is_legal_info_18, t0.is_general_organism AS is_general_organism_19, t0.parent_id AS parent_id_20 FROM category t0 WHERE t0.id = 49;