Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          o0_.id AS id_0,
          o0_.logo AS logo_1,
          o0_.name AS name_2,
          o0_.created_at AS created_at_3,
          o0_.refrer_code AS refrer_code_4,
          o0_.facebook_link AS facebook_link_5,
          o0_.youtube_link AS youtube_link_6,
          o0_.instagram_link AS instagram_link_7,
          o0_.linkedin_link AS linkedin_link_8,
          o0_.visits_count AS visits_count_9,
          o0_.latitude AS latitude_10,
          o0_.longitude AS longitude_11,
          o0_.subscription_status AS subscription_status_12,
          o0_.email AS email_13,
          o0_.gain AS gain_14,
          o0_.total_members AS total_members_15,
          o0_.monetizing_enabled AS monetizing_enabled_16,
          o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17,
          o0_.description AS description_18,
          o0_.password AS password_19,
          o0_.subscribers_count AS subscribers_count_20,
          o0_.type AS type_21,
          o0_.address AS address_22,
          o0_.phone AS phone_23,
          o0_.whatsapp_phone AS whatsapp_phone_24,
          o0_.is_enabled AS is_enabled_25,
          o0_.can_create_coupon AS can_create_coupon_26,
          o0_.can_receive_partnership_request AS can_receive_partnership_request_27,
          o0_.website_link AS website_link_28,
          o0_.can_receive_agreements AS can_receive_agreements_29,
          o0_.can_send_agreements AS can_send_agreements_30,
          o0_.slug AS slug_31,
          o0_.devis_enabled AS devis_enabled_32,
          o0_.is_managed_in_house AS is_managed_in_house_33,
          o0_.is_slug_manuel AS is_slug_manuel_34,
          o0_.use_calendar AS use_calendar_35,
          o0_.params AS params_36
        FROM
          organization o0_
          LEFT JOIN city c1_ ON o0_.city_id = c1_.id
          LEFT JOIN sector s2_ ON o0_.sector_id = s2_.id
        WHERE
          o0_.is_enabled = 1
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  15

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.logo AS logo_1, o0_.name AS name_2, o0_.created_at AS created_at_3, o0_.refrer_code AS refrer_code_4, o0_.facebook_link AS facebook_link_5, o0_.youtube_link AS youtube_link_6, o0_.instagram_link AS instagram_link_7, o0_.linkedin_link AS linkedin_link_8, o0_.visits_count AS visits_count_9, o0_.latitude AS latitude_10, o0_.longitude AS longitude_11, o0_.subscription_status AS subscription_status_12, o0_.email AS email_13, o0_.gain AS gain_14, o0_.total_members AS total_members_15, o0_.monetizing_enabled AS monetizing_enabled_16, o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17, o0_.description AS description_18, o0_.password AS password_19, o0_.subscribers_count AS subscribers_count_20, o0_.type AS type_21, o0_.address AS address_22, o0_.phone AS phone_23, o0_.whatsapp_phone AS whatsapp_phone_24, o0_.is_enabled AS is_enabled_25, o0_.can_create_coupon AS can_create_coupon_26, o0_.can_receive_partnership_request AS can_receive_partnership_request_27, o0_.website_link AS website_link_28, o0_.can_receive_agreements AS can_receive_agreements_29, o0_.can_send_agreements AS can_send_agreements_30, o0_.slug AS slug_31, o0_.devis_enabled AS devis_enabled_32, o0_.is_managed_in_house AS is_managed_in_house_33, o0_.is_slug_manuel AS is_slug_manuel_34, o0_.use_calendar AS use_calendar_35, o0_.params AS params_36 FROM organization o0_ LEFT JOIN city c1_ ON o0_.city_id = c1_.id LEFT JOIN sector s2_ ON o0_.sector_id = s2_.id WHERE o0_.is_enabled = 1) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 15;

SELECT
  o0_.id AS id_0,
  o0_.logo AS logo_1,
  o0_.name AS name_2,
  o0_.created_at AS created_at_3,
  o0_.refrer_code AS refrer_code_4,
  o0_.facebook_link AS facebook_link_5,
  o0_.youtube_link AS youtube_link_6,
  o0_.instagram_link AS instagram_link_7,
  o0_.linkedin_link AS linkedin_link_8,
  o0_.visits_count AS visits_count_9,
  o0_.latitude AS latitude_10,
  o0_.longitude AS longitude_11,
  o0_.subscription_status AS subscription_status_12,
  o0_.email AS email_13,
  o0_.gain AS gain_14,
  o0_.total_members AS total_members_15,
  o0_.monetizing_enabled AS monetizing_enabled_16,
  o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17,
  o0_.description AS description_18,
  o0_.password AS password_19,
  o0_.subscribers_count AS subscribers_count_20,
  o0_.type AS type_21,
  o0_.address AS address_22,
  o0_.phone AS phone_23,
  o0_.whatsapp_phone AS whatsapp_phone_24,
  o0_.is_enabled AS is_enabled_25,
  o0_.can_create_coupon AS can_create_coupon_26,
  o0_.can_receive_partnership_request AS can_receive_partnership_request_27,
  o0_.website_link AS website_link_28,
  o0_.can_receive_agreements AS can_receive_agreements_29,
  o0_.can_send_agreements AS can_send_agreements_30,
  o0_.slug AS slug_31,
  o0_.devis_enabled AS devis_enabled_32,
  o0_.is_managed_in_house AS is_managed_in_house_33,
  o0_.is_slug_manuel AS is_slug_manuel_34,
  o0_.use_calendar AS use_calendar_35,
  o0_.params AS params_36,
  o0_.sector_id AS sector_id_37,
  o0_.city_id AS city_id_38,
  o0_.subscription_id AS subscription_id_39
FROM
  organization o0_
  LEFT JOIN city c1_ ON o0_.city_id = c1_.id
  LEFT JOIN sector s2_ ON o0_.sector_id = s2_.id
WHERE
  o0_.is_enabled = 1
  AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  o0_.id DESC

SELECT o0_.id AS id_0, o0_.logo AS logo_1, o0_.name AS name_2, o0_.created_at AS created_at_3, o0_.refrer_code AS refrer_code_4, o0_.facebook_link AS facebook_link_5, o0_.youtube_link AS youtube_link_6, o0_.instagram_link AS instagram_link_7, o0_.linkedin_link AS linkedin_link_8, o0_.visits_count AS visits_count_9, o0_.latitude AS latitude_10, o0_.longitude AS longitude_11, o0_.subscription_status AS subscription_status_12, o0_.email AS email_13, o0_.gain AS gain_14, o0_.total_members AS total_members_15, o0_.monetizing_enabled AS monetizing_enabled_16, o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17, o0_.description AS description_18, o0_.password AS password_19, o0_.subscribers_count AS subscribers_count_20, o0_.type AS type_21, o0_.address AS address_22, o0_.phone AS phone_23, o0_.whatsapp_phone AS whatsapp_phone_24, o0_.is_enabled AS is_enabled_25, o0_.can_create_coupon AS can_create_coupon_26, o0_.can_receive_partnership_request AS can_receive_partnership_request_27, o0_.website_link AS website_link_28, o0_.can_receive_agreements AS can_receive_agreements_29, o0_.can_send_agreements AS can_send_agreements_30, o0_.slug AS slug_31, o0_.devis_enabled AS devis_enabled_32, o0_.is_managed_in_house AS is_managed_in_house_33, o0_.is_slug_manuel AS is_slug_manuel_34, o0_.use_calendar AS use_calendar_35, o0_.params AS params_36, o0_.sector_id AS sector_id_37, o0_.city_id AS city_id_38, o0_.subscription_id AS subscription_id_39 FROM organization o0_ LEFT JOIN city c1_ ON o0_.city_id = c1_.id LEFT JOIN sector s2_ ON o0_.sector_id = s2_.id WHERE o0_.is_enabled = 1 AND o0_.id IN (301, 300, 299, 297, 294, 293, 291, 290, 288, 287, 286, 285, 284, 283, 282) ORDER BY o0_.id DESC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          o0_.id AS id_0,
          o0_.logo AS logo_1,
          o0_.name AS name_2,
          o0_.created_at AS created_at_3,
          o0_.refrer_code AS refrer_code_4,
          o0_.facebook_link AS facebook_link_5,
          o0_.youtube_link AS youtube_link_6,
          o0_.instagram_link AS instagram_link_7,
          o0_.linkedin_link AS linkedin_link_8,
          o0_.visits_count AS visits_count_9,
          o0_.latitude AS latitude_10,
          o0_.longitude AS longitude_11,
          o0_.subscription_status AS subscription_status_12,
          o0_.email AS email_13,
          o0_.gain AS gain_14,
          o0_.total_members AS total_members_15,
          o0_.monetizing_enabled AS monetizing_enabled_16,
          o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17,
          o0_.description AS description_18,
          o0_.password AS password_19,
          o0_.subscribers_count AS subscribers_count_20,
          o0_.type AS type_21,
          o0_.address AS address_22,
          o0_.phone AS phone_23,
          o0_.whatsapp_phone AS whatsapp_phone_24,
          o0_.is_enabled AS is_enabled_25,
          o0_.can_create_coupon AS can_create_coupon_26,
          o0_.can_receive_partnership_request AS can_receive_partnership_request_27,
          o0_.website_link AS website_link_28,
          o0_.can_receive_agreements AS can_receive_agreements_29,
          o0_.can_send_agreements AS can_send_agreements_30,
          o0_.slug AS slug_31,
          o0_.devis_enabled AS devis_enabled_32,
          o0_.is_managed_in_house AS is_managed_in_house_33,
          o0_.is_slug_manuel AS is_slug_manuel_34,
          o0_.use_calendar AS use_calendar_35,
          o0_.params AS params_36
        FROM
          organization o0_
          LEFT JOIN city c1_ ON o0_.city_id = c1_.id
          LEFT JOIN sector s2_ ON o0_.sector_id = s2_.id
        WHERE
          o0_.is_enabled = 1
        ORDER BY
          o0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.logo AS logo_1, o0_.name AS name_2, o0_.created_at AS created_at_3, o0_.refrer_code AS refrer_code_4, o0_.facebook_link AS facebook_link_5, o0_.youtube_link AS youtube_link_6, o0_.instagram_link AS instagram_link_7, o0_.linkedin_link AS linkedin_link_8, o0_.visits_count AS visits_count_9, o0_.latitude AS latitude_10, o0_.longitude AS longitude_11, o0_.subscription_status AS subscription_status_12, o0_.email AS email_13, o0_.gain AS gain_14, o0_.total_members AS total_members_15, o0_.monetizing_enabled AS monetizing_enabled_16, o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17, o0_.description AS description_18, o0_.password AS password_19, o0_.subscribers_count AS subscribers_count_20, o0_.type AS type_21, o0_.address AS address_22, o0_.phone AS phone_23, o0_.whatsapp_phone AS whatsapp_phone_24, o0_.is_enabled AS is_enabled_25, o0_.can_create_coupon AS can_create_coupon_26, o0_.can_receive_partnership_request AS can_receive_partnership_request_27, o0_.website_link AS website_link_28, o0_.can_receive_agreements AS can_receive_agreements_29, o0_.can_send_agreements AS can_send_agreements_30, o0_.slug AS slug_31, o0_.devis_enabled AS devis_enabled_32, o0_.is_managed_in_house AS is_managed_in_house_33, o0_.is_slug_manuel AS is_slug_manuel_34, o0_.use_calendar AS use_calendar_35, o0_.params AS params_36 FROM organization o0_ LEFT JOIN city c1_ ON o0_.city_id = c1_.id LEFT JOIN sector s2_ ON o0_.sector_id = s2_.id WHERE o0_.is_enabled = 1 ORDER BY o0_.id DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3
FROM
  city t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM city t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  sector t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM sector t0;

SELECT
  t0.id AS id_1,
  t0.source_route AS source_route_2,
  t0.target_route AS target_route_3,
  t0.creation_date AS creation_date_4
FROM
  redirections t0
WHERE
  t0.source_route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.source_route AS source_route_2, t0.target_route AS target_route_3, t0.creation_date AS creation_date_4 FROM redirections t0 WHERE t0.source_route = '/nos-partenaires' LIMIT 1;