Symfony Profiler

SELECT
  p.id AS id0,
  p.name AS name1,
  p.description AS description2,
  p.address AS address3,
  p.additional_address AS additional_address4,
  p.postcode AS postcode5,
  p.identify_number AS identify_number6,
  p.website AS website7,
  p.prepaid_amount AS prepaid_amount8,
  p.sponsor_code AS sponsor_code9,
  p.sponsor_points AS sponsor_points10,
  p.reference AS reference11,
  p.sepa_name AS sepa_name12,
  p.population AS population13,
  p.typology AS typology14,
  p.is_rdc AS is_rdc15,
  p.is_contract_historic AS is_contract_historic16,
  p.collectivity_service_code AS collectivity_service_code17,
  p.is_number_ej AS is_number_ej18,
  p.demo AS demo19,
  p.vat AS vat20,
  p.logo AS logo21,
  p.is_data_different_invoice AS is_data_different_invoice22,
  p.other_name AS other_name23,
  p.other_address AS other_address24,
  p.other_identify_number AS other_identify_number25,
  p.manual_renewal AS manual_renewal26,
  p.testimony_answered AS testimony_answered27,
  p.is_cmd AS is_cmd28,
  p.notes AS notes29,
  p.date_invitation_ceo_interview AS date_invitation_ceo_interview30,
  p.date_ceo_interview AS date_ceo_interview31,
  p.top_ranking AS top_ranking32,
  p.rdc_feeling AS rdc_feeling33,
  p.created_at AS created_at34,
  p.updated_at AS updated_at35,
  p.deleted_at AS deleted_at36,
  p.lat AS lat37,
  p.lng AS lng38,
  p.type_id AS type_id39,
  p.category_id AS category_id40,
  p.city_id AS city_id41,
  p.user_id AS user_id42,
  p.othet_city_id AS othet_city_id43,
  p.intercommunality_id AS intercommunality_id44,
  p.attachments AS attachments45,
  c.id AS id,
  c.postcode AS postcode,
  c.slug AS slug,
  c.lat AS lat,
  c.lng AS lng,
  c.country_id AS country_id,
  (
    6371 * acos(
      cos(
        radians(48.778100)
      ) * cos(
        radians(c.lat)
      ) * cos(
        radians(c.lng) - radians(2.297500)
      ) + sin(
        radians(48.778100)
      ) * sin(
        radians(c.lat)
      )
    )
  ) as distance
FROM
  projects p
  INNER JOIN cities c ON c.id = p.city_id
WHERE
  p.demo = 0
HAVING
  distance < ?
ORDER BY
  distance ASC

SELECT p.id AS id0, p.name AS name1, p.description AS description2, p.address AS address3, p.additional_address AS additional_address4, p.postcode AS postcode5, p.identify_number AS identify_number6, p.website AS website7, p.prepaid_amount AS prepaid_amount8, p.sponsor_code AS sponsor_code9, p.sponsor_points AS sponsor_points10, p.reference AS reference11, p.sepa_name AS sepa_name12, p.population AS population13, p.typology AS typology14, p.is_rdc AS is_rdc15, p.is_contract_historic AS is_contract_historic16, p.collectivity_service_code AS collectivity_service_code17, p.is_number_ej AS is_number_ej18, p.demo AS demo19, p.vat AS vat20, p.logo AS logo21, p.is_data_different_invoice AS is_data_different_invoice22, p.other_name AS other_name23, p.other_address AS other_address24, p.other_identify_number AS other_identify_number25, p.manual_renewal AS manual_renewal26, p.testimony_answered AS testimony_answered27, p.is_cmd AS is_cmd28, p.notes AS notes29, p.date_invitation_ceo_interview AS date_invitation_ceo_interview30, p.date_ceo_interview AS date_ceo_interview31, p.top_ranking AS top_ranking32, p.rdc_feeling AS rdc_feeling33, p.created_at AS created_at34, p.updated_at AS updated_at35, p.deleted_at AS deleted_at36, p.lat AS lat37, p.lng AS lng38, p.type_id AS type_id39, p.category_id AS category_id40, p.city_id AS city_id41, p.user_id AS user_id42, p.othet_city_id AS othet_city_id43, p.intercommunality_id AS intercommunality_id44, p.attachments AS attachments45, c.id AS id, c.postcode AS postcode, c.slug AS slug, c.lat AS lat, c.lng AS lng, c.country_id AS country_id, ( 6371 * acos(cos(radians(48.778100)) * cos( radians( c.lat ) )
                        * cos( radians( c.lng ) - radians(2.297500) ) + sin( radians(48.778100) ) * sin( radians( c.lat ) ) ) ) as distance
                  FROM projects p
                  INNER JOIN cities c ON c.id = p.city_id
                  WHERE p.demo = 0
                  HAVING distance < 30
                  ORDER BY distance ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4,
  t5.id AS id_6,
  t5.postcode AS postcode_7,
  t5.slug AS slug_8,
  t5.lat AS lat_9,
  t5.lng AS lng_10,
  t5.country_id AS country_id_11
FROM
  cities_translation t0
  LEFT JOIN cities t5 ON t0.translatable_id = t5.id
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4, t5.id AS id_6, t5.postcode AS postcode_7, t5.slug AS slug_8, t5.lat AS lat_9, t5.lng AS lng_10, t5.country_id AS country_id_11 FROM cities_translation t0 LEFT JOIN cities t5 ON t0.translatable_id = t5.id WHERE t0.translatable_id = 36443;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.email AS email_4,
  t0.new_email AS new_email_5,
  t0.roles AS roles_6,
  t0.firstname AS firstname_7,
  t0.lastname AS lastname_8,
  t0.newsletter_accepted AS newsletter_accepted_9,
  t0.terms_accepted AS terms_accepted_10,
  t0.is_valid AS is_valid_11,
  t0.confirmation_token AS confirmation_token_12,
  t0.shortcuts AS shortcuts_13,
  t0.lastlogin AS lastlogin_14,
  t0.locale AS locale_15,
  t0.birthday AS birthday_16,
  t0.description AS description_17,
  t0.gender_id AS gender_id_18,
  t0.picture_name AS picture_name_19,
  t0.password_request_at AS password_request_at_20,
  t0.enabled AS enabled_21,
  t0.come_from AS come_from_22,
  t0.display_scenario AS display_scenario_23,
  t0.phone AS phone_24,
  t0.info_shared_neopse AS info_shared_neopse_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.city_id AS city_id_28,
  t0.admin_group_id AS admin_group_id_29
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = 'jean-sebastien.leleu@epicture.fr' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.address AS address_3,
  p0_.additional_address AS additional_address_4,
  p0_.postcode AS postcode_5,
  p0_.identify_number AS identify_number_6,
  p0_.website AS website_7,
  p0_.prepaid_amount AS prepaid_amount_8,
  p0_.sponsor_code AS sponsor_code_9,
  p0_.sponsor_points AS sponsor_points_10,
  p0_.reference AS reference_11,
  p0_.sepa_name AS sepa_name_12,
  p0_.population AS population_13,
  p0_.typology AS typology_14,
  p0_.is_rdc AS is_rdc_15,
  p0_.is_contract_historic AS is_contract_historic_16,
  p0_.collectivity_service_code AS collectivity_service_code_17,
  p0_.is_number_ej AS is_number_ej_18,
  p0_.demo AS demo_19,
  p0_.vat AS vat_20,
  p0_.logo AS logo_21,
  p0_.is_data_different_invoice AS is_data_different_invoice_22,
  p0_.other_name AS other_name_23,
  p0_.other_address AS other_address_24,
  p0_.other_identify_number AS other_identify_number_25,
  p0_.manual_renewal AS manual_renewal_26,
  p0_.testimony_answered AS testimony_answered_27,
  p0_.is_cmd AS is_cmd_28,
  p0_.notes AS notes_29,
  p0_.date_invitation_ceo_interview AS date_invitation_ceo_interview_30,
  p0_.date_ceo_interview AS date_ceo_interview_31,
  p0_.top_ranking AS top_ranking_32,
  p0_.rdc_feeling AS rdc_feeling_33,
  p0_.created_at AS created_at_34,
  p0_.updated_at AS updated_at_35,
  p0_.deleted_at AS deleted_at_36,
  p0_.lat AS lat_37,
  p0_.lng AS lng_38,
  p1_.date_end AS date_end_39,
  p1_.status AS status_40,
  p1_.additional_size AS additional_size_41,
  p1_.free AS free_42,
  p1_.next_data AS next_data_43,
  p1_.pending_order AS pending_order_44,
  p1_.size_platform AS size_platform_45,
  p1_.pack AS pack_46,
  p1_.reminded_at AS reminded_at_47,
  p1_.delete_at AS delete_at_48,
  p1_.locked AS locked_49,
  p1_.renewal_refused AS renewal_refused_50,
  p1_.renewal_refused_reason AS renewal_refused_reason_51,
  p1_.renewal_refused_filename AS renewal_refused_filename_52,
  p2_.id AS id_53,
  p2_.name AS name_54,
  p2_.always_checked AS always_checked_55,
  p2_.projecttool_key AS projecttool_key_56,
  p2_.max_size AS max_size_57,
  p2_.index_route AS index_route_58,
  p2_.enabled AS enabled_59,
  p0_.type_id AS type_id_60,
  p0_.category_id AS category_id_61,
  p0_.city_id AS city_id_62,
  p0_.user_id AS user_id_63,
  p0_.othet_city_id AS othet_city_id_64,
  p0_.intercommunality_id AS intercommunality_id_65,
  p0_.attachments AS attachments_66,
  p1_.projecttool_id AS projecttool_id_67,
  p1_.project_id AS project_id_68
FROM
  projects p0_
  INNER JOIN users_access u3_ ON (p0_.id = u3_.project_id)
  INNER JOIN users u4_ ON (u4_.id = u3_.user_id)
  LEFT JOIN projects_projecttools p1_ ON p0_.id = p1_.project_id
  LEFT JOIN projecttools p2_ ON p1_.projecttool_id = p2_.id
WHERE
  u4_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.address AS address_3, p0_.additional_address AS additional_address_4, p0_.postcode AS postcode_5, p0_.identify_number AS identify_number_6, p0_.website AS website_7, p0_.prepaid_amount AS prepaid_amount_8, p0_.sponsor_code AS sponsor_code_9, p0_.sponsor_points AS sponsor_points_10, p0_.reference AS reference_11, p0_.sepa_name AS sepa_name_12, p0_.population AS population_13, p0_.typology AS typology_14, p0_.is_rdc AS is_rdc_15, p0_.is_contract_historic AS is_contract_historic_16, p0_.collectivity_service_code AS collectivity_service_code_17, p0_.is_number_ej AS is_number_ej_18, p0_.demo AS demo_19, p0_.vat AS vat_20, p0_.logo AS logo_21, p0_.is_data_different_invoice AS is_data_different_invoice_22, p0_.other_name AS other_name_23, p0_.other_address AS other_address_24, p0_.other_identify_number AS other_identify_number_25, p0_.manual_renewal AS manual_renewal_26, p0_.testimony_answered AS testimony_answered_27, p0_.is_cmd AS is_cmd_28, p0_.notes AS notes_29, p0_.date_invitation_ceo_interview AS date_invitation_ceo_interview_30, p0_.date_ceo_interview AS date_ceo_interview_31, p0_.top_ranking AS top_ranking_32, p0_.rdc_feeling AS rdc_feeling_33, p0_.created_at AS created_at_34, p0_.updated_at AS updated_at_35, p0_.deleted_at AS deleted_at_36, p0_.lat AS lat_37, p0_.lng AS lng_38, p1_.date_end AS date_end_39, p1_.status AS status_40, p1_.additional_size AS additional_size_41, p1_.free AS free_42, p1_.next_data AS next_data_43, p1_.pending_order AS pending_order_44, p1_.size_platform AS size_platform_45, p1_.pack AS pack_46, p1_.reminded_at AS reminded_at_47, p1_.delete_at AS delete_at_48, p1_.locked AS locked_49, p1_.renewal_refused AS renewal_refused_50, p1_.renewal_refused_reason AS renewal_refused_reason_51, p1_.renewal_refused_filename AS renewal_refused_filename_52, p2_.id AS id_53, p2_.name AS name_54, p2_.always_checked AS always_checked_55, p2_.projecttool_key AS projecttool_key_56, p2_.max_size AS max_size_57, p2_.index_route AS index_route_58, p2_.enabled AS enabled_59, p0_.type_id AS type_id_60, p0_.category_id AS category_id_61, p0_.city_id AS city_id_62, p0_.user_id AS user_id_63, p0_.othet_city_id AS othet_city_id_64, p0_.intercommunality_id AS intercommunality_id_65, p0_.attachments AS attachments_66, p1_.projecttool_id AS projecttool_id_67, p1_.project_id AS project_id_68 FROM projects p0_ INNER JOIN users_access u3_ ON (p0_.id = u3_.project_id) INNER JOIN users u4_ ON (u4_.id = u3_.user_id) LEFT JOIN projects_projecttools p1_ ON p0_.id = p1_.project_id LEFT JOIN projecttools p2_ ON p1_.projecttool_id = p2_.id WHERE u4_.id = 2797;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.address AS address_4,
  t0.additional_address AS additional_address_5,
  t0.postcode AS postcode_6,
  t0.identify_number AS identify_number_7,
  t0.website AS website_8,
  t0.prepaid_amount AS prepaid_amount_9,
  t0.sponsor_code AS sponsor_code_10,
  t0.sponsor_points AS sponsor_points_11,
  t0.reference AS reference_12,
  t0.sepa_name AS sepa_name_13,
  t0.population AS population_14,
  t0.typology AS typology_15,
  t0.is_rdc AS is_rdc_16,
  t0.is_contract_historic AS is_contract_historic_17,
  t0.collectivity_service_code AS collectivity_service_code_18,
  t0.is_number_ej AS is_number_ej_19,
  t0.demo AS demo_20,
  t0.vat AS vat_21,
  t0.logo AS logo_22,
  t0.is_data_different_invoice AS is_data_different_invoice_23,
  t0.other_name AS other_name_24,
  t0.other_address AS other_address_25,
  t0.other_identify_number AS other_identify_number_26,
  t0.manual_renewal AS manual_renewal_27,
  t0.testimony_answered AS testimony_answered_28,
  t0.is_cmd AS is_cmd_29,
  t0.notes AS notes_30,
  t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31,
  t0.date_ceo_interview AS date_ceo_interview_32,
  t0.top_ranking AS top_ranking_33,
  t0.rdc_feeling AS rdc_feeling_34,
  t0.created_at AS created_at_35,
  t0.updated_at AS updated_at_36,
  t0.deleted_at AS deleted_at_37,
  t0.lat AS lat_38,
  t0.lng AS lng_39,
  t0.type_id AS type_id_40,
  t0.category_id AS category_id_41,
  t0.city_id AS city_id_42,
  t0.user_id AS user_id_43,
  t0.othet_city_id AS othet_city_id_44,
  t0.intercommunality_id AS intercommunality_id_45,
  t0.attachments AS attachments_46
FROM
  projects t0
  INNER JOIN users_projects ON t0.id = users_projects.project_id
WHERE
  users_projects.user_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 INNER JOIN users_projects ON t0.id = users_projects.project_id WHERE users_projects.user_id = 2797 ORDER BY t0.name ASC;

SELECT
  f0_.id AS id_0,
  f0_.icon AS icon_1,
  f0_.title AS title_2,
  f0_.summary AS summary_3,
  f0_.button_label AS button_label_4,
  f0_.button_url AS button_url_5,
  f0_.display_at AS display_at_6,
  f0_.unpublish_at AS unpublish_at_7,
  f0_.targets AS targets_8,
  f0_.created_at AS created_at_9,
  f0_.updated_at AS updated_at_10
FROM
  flash_message f0_
WHERE
  (
    f0_.display_at IS NULL
    OR f0_.display_at <= ?
  )
  AND (
    f0_.unpublish_at IS NULL
    OR f0_.unpublish_at >= ?
  )
ORDER BY
  f0_.created_at DESC

SELECT f0_.id AS id_0, f0_.icon AS icon_1, f0_.title AS title_2, f0_.summary AS summary_3, f0_.button_label AS button_label_4, f0_.button_url AS button_url_5, f0_.display_at AS display_at_6, f0_.unpublish_at AS unpublish_at_7, f0_.targets AS targets_8, f0_.created_at AS created_at_9, f0_.updated_at AS updated_at_10 FROM flash_message f0_ WHERE (f0_.display_at IS NULL OR f0_.display_at <= '2026-06-13 00:38:34') AND (f0_.unpublish_at IS NULL OR f0_.unpublish_at >= '2026-06-13 00:38:34') ORDER BY f0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.always_checked AS always_checked_3,
  t0.projecttool_key AS projecttool_key_4,
  t0.max_size AS max_size_5,
  t0.index_route AS index_route_6,
  t0.enabled AS enabled_7
FROM
  projecttools t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.always_checked AS always_checked_3, t0.projecttool_key AS projecttool_key_4, t0.max_size AS max_size_5, t0.index_route AS index_route_6, t0.enabled AS enabled_7 FROM projecttools t0 WHERE t0.enabled = 1;

SELECT
  m0_.id AS id_0,
  m0_.date_publication AS date_publication_1,
  m0_.date_unpublication AS date_unpublication_2,
  m0_.on_account AS on_account_3,
  m0_.on_back_office AS on_back_office_4,
  m0_.on_website AS on_website_5,
  m0_.on_intranet AS on_intranet_6,
  m0_.on_ticketing AS on_ticketing_7,
  m1_.id AS id_8,
  m1_.title AS title_9,
  m1_.content AS content_10,
  m1_.locale AS locale_11,
  m1_.translatable_id AS translatable_id_12
FROM
  messages m0_
  INNER JOIN messages_translation m1_ ON m0_.id = m1_.translatable_id
WHERE
  m0_.on_account = 1
  AND m0_.date_publication <= CURRENT_DATE
  AND m0_.date_unpublication > CURRENT_DATE
ORDER BY
  m0_.date_publication DESC

SELECT m0_.id AS id_0, m0_.date_publication AS date_publication_1, m0_.date_unpublication AS date_unpublication_2, m0_.on_account AS on_account_3, m0_.on_back_office AS on_back_office_4, m0_.on_website AS on_website_5, m0_.on_intranet AS on_intranet_6, m0_.on_ticketing AS on_ticketing_7, m1_.id AS id_8, m1_.title AS title_9, m1_.content AS content_10, m1_.locale AS locale_11, m1_.translatable_id AS translatable_id_12 FROM messages m0_ INNER JOIN messages_translation m1_ ON m0_.id = m1_.translatable_id WHERE m0_.on_account = 1 AND m0_.date_publication <= CURRENT_DATE AND m0_.date_unpublication > CURRENT_DATE ORDER BY m0_.date_publication DESC;

SELECT
  t0.id AS id_1,
  t0.postcode AS postcode_2,
  t0.slug AS slug_3,
  t0.lat AS lat_4,
  t0.lng AS lng_5,
  t0.country_id AS country_id_6
FROM
  cities t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.postcode AS postcode_2, t0.slug AS slug_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.country_id AS country_id_6 FROM cities t0 WHERE t0.id = 36443;