Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.phone_number AS phone_number_7,
  t0.street AS street_8,
  t0.postcode AS postcode_9,
  t0.city AS city_10,
  t0.referrer AS referrer_11,
  t0.external_reference AS external_reference_12,
  t0.is_enabled AS is_enabled_13,
  t0.import_reference AS import_reference_14,
  t0.ip AS ip_15,
  t0.last_activity_at AS last_activity_at_16,
  t0.birthday AS birthday_17,
  t0.archived_at AS archived_at_18,
  t0.session_token AS session_token_19,
  t0.compliance AS compliance_20,
  t0.is_valid_email AS is_valid_email_21,
  t0.deleted_at AS deleted_at_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.uuid AS uuid_25,
  t0.civility_id AS civility_id_26,
  t0.avatar_id AS avatar_id_27,
  t0.company_id AS company_id_28
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.is_public AS is_public_4,
  t0.is_enabled AS is_enabled_5,
  t0.deleted_at AS deleted_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.uuid AS uuid_9
FROM
  app_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.is_public AS is_public_4, t0.is_enabled AS is_enabled_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.uuid AS uuid_9 FROM app_media t0 WHERE t0.id = 25;

SELECT
  a0_.id AS id_0,
  a0_.identifier AS identifier_1,
  a0_.name AS name_2,
  a0_.description AS description_3,
  a0_.is_enabled AS is_enabled_4,
  a0_.deleted_at AS deleted_at_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.uuid AS uuid_8
FROM
  app_taxonomy a0_
WHERE
  a0_.is_enabled = ?
  AND a0_.deleted_at IS NULL
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.description AS description_3, a0_.is_enabled AS is_enabled_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.uuid AS uuid_8 FROM app_taxonomy a0_ WHERE a0_.is_enabled = 1 AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC;

SELECT
  a0_.id AS id_0,
  a0_.identifier AS identifier_1,
  a0_.name AS name_2,
  a0_.description AS description_3,
  a0_."rank" AS rank_4,
  a0_.short_name AS short_name_5,
  a0_.is_enabled AS is_enabled_6,
  a0_.is_check_compliance AS is_check_compliance_7,
  a0_.icon AS icon_8,
  a0_.allowed_countries AS allowed_countries_9,
  a0_.deleted_at AS deleted_at_10,
  a0_.created_at AS created_at_11,
  a0_.updated_at AS updated_at_12,
  a0_.uuid AS uuid_13,
  a1_.id AS id_14,
  a1_.identifier AS identifier_15,
  a1_.name AS name_16,
  a1_.description AS description_17,
  a1_.is_enabled AS is_enabled_18,
  a1_.deleted_at AS deleted_at_19,
  a1_.created_at AS created_at_20,
  a1_.updated_at AS updated_at_21,
  a1_.uuid AS uuid_22,
  a0_.company_id AS company_id_23,
  a0_.taxonomy_id AS taxonomy_id_24,
  a0_.parent_id AS parent_id_25
FROM
  app_term a0_
  LEFT JOIN app_taxonomy a1_ ON a0_.taxonomy_id = a1_.id
WHERE
  a1_.identifier = ?
  AND a0_.is_enabled = ?
  AND a0_.deleted_at IS NULL
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.description AS description_3, a0_."rank" AS rank_4, a0_.short_name AS short_name_5, a0_.is_enabled AS is_enabled_6, a0_.is_check_compliance AS is_check_compliance_7, a0_.icon AS icon_8, a0_.allowed_countries AS allowed_countries_9, a0_.deleted_at AS deleted_at_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.uuid AS uuid_13, a1_.id AS id_14, a1_.identifier AS identifier_15, a1_.name AS name_16, a1_.description AS description_17, a1_.is_enabled AS is_enabled_18, a1_.deleted_at AS deleted_at_19, a1_.created_at AS created_at_20, a1_.updated_at AS updated_at_21, a1_.uuid AS uuid_22, a0_.company_id AS company_id_23, a0_.taxonomy_id AS taxonomy_id_24, a0_.parent_id AS parent_id_25 FROM app_term a0_ LEFT JOIN app_taxonomy a1_ ON a0_.taxonomy_id = a1_.id WHERE a1_.identifier = 'partner_type' AND a0_.is_enabled = 1 AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC;

SELECT
  a0_.id AS id_0,
  a0_.identifier AS identifier_1,
  a0_.name AS name_2,
  a0_.url AS url_3,
  a0_.is_enabled AS is_enabled_4,
  a0_.deleted_at AS deleted_at_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.uuid AS uuid_8,
  a0_.company_id AS company_id_9,
  a0_.campaign_id AS campaign_id_10,
  a0_.type_id AS type_id_11
FROM
  app_partner a0_
  LEFT JOIN app_term a1_ ON a0_.type_id = a1_.id
WHERE
  a1_.identifier = ?
  AND a0_.is_enabled = ?
  AND a0_.deleted_at IS NULL
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.url AS url_3, a0_.is_enabled AS is_enabled_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.uuid AS uuid_8, a0_.company_id AS company_id_9, a0_.campaign_id AS campaign_id_10, a0_.type_id AS type_id_11 FROM app_partner a0_ LEFT JOIN app_term a1_ ON a0_.type_id = a1_.id WHERE a1_.identifier = 'module' AND a0_.is_enabled = 1 AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.identifier AS identifier_1,
          a0_.name AS name_2,
          a0_.is_enabled AS is_enabled_3,
          a0_.register_url AS register_url_4,
          a0_.crm_api_key AS crm_api_key_5,
          a0_.webhook_url AS webhook_url_6,
          a0_.olead_api_key AS olead_api_key_7,
          a0_.footer_content AS footer_content_8,
          a0_.utm_variables AS utm_variables_9,
          a0_.cgu_url AS cgu_url_10,
          a0_.privacy_url AS privacy_url_11,
          a0_.site_name AS site_name_12,
          a0_.deleted_at AS deleted_at_13,
          a0_.created_at AS created_at_14,
          a0_.updated_at AS updated_at_15,
          a0_.uuid AS uuid_16
        FROM
          app_campaign a0_
        WHERE
          a0_.deleted_at IS NULL
        ORDER BY
          a0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.register_url AS register_url_4, a0_.crm_api_key AS crm_api_key_5, a0_.webhook_url AS webhook_url_6, a0_.olead_api_key AS olead_api_key_7, a0_.footer_content AS footer_content_8, a0_.utm_variables AS utm_variables_9, a0_.cgu_url AS cgu_url_10, a0_.privacy_url AS privacy_url_11, a0_.site_name AS site_name_12, a0_.deleted_at AS deleted_at_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.uuid AS uuid_16 FROM app_campaign a0_ WHERE a0_.deleted_at IS NULL ORDER BY a0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0,
  MIN(sclr_17) AS dctrn_minrownum
FROM
  (
    SELECT
      a0_.id AS id_0,
      a0_.identifier AS identifier_1,
      a0_.name AS name_2,
      a0_.is_enabled AS is_enabled_3,
      a0_.register_url AS register_url_4,
      a0_.crm_api_key AS crm_api_key_5,
      a0_.webhook_url AS webhook_url_6,
      a0_.olead_api_key AS olead_api_key_7,
      a0_.footer_content AS footer_content_8,
      a0_.utm_variables AS utm_variables_9,
      a0_.cgu_url AS cgu_url_10,
      a0_.privacy_url AS privacy_url_11,
      a0_.site_name AS site_name_12,
      a0_.deleted_at AS deleted_at_13,
      a0_.created_at AS created_at_14,
      a0_.updated_at AS updated_at_15,
      a0_.uuid AS uuid_16,
      ROW_NUMBER() OVER(
        ORDER BY
          a0_.id DESC
      ) AS sclr_17
    FROM
      app_campaign a0_
    WHERE
      a0_.deleted_at IS NULL
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  50

SELECT DISTINCT id_0, MIN(sclr_17) AS dctrn_minrownum FROM (SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.register_url AS register_url_4, a0_.crm_api_key AS crm_api_key_5, a0_.webhook_url AS webhook_url_6, a0_.olead_api_key AS olead_api_key_7, a0_.footer_content AS footer_content_8, a0_.utm_variables AS utm_variables_9, a0_.cgu_url AS cgu_url_10, a0_.privacy_url AS privacy_url_11, a0_.site_name AS site_name_12, a0_.deleted_at AS deleted_at_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.uuid AS uuid_16, ROW_NUMBER() OVER(ORDER BY a0_.id DESC) AS sclr_17 FROM app_campaign a0_ WHERE a0_.deleted_at IS NULL) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 50;

SELECT
  a0_.id AS id_0,
  a0_.identifier AS identifier_1,
  a0_.name AS name_2,
  a0_.is_enabled AS is_enabled_3,
  a0_.register_url AS register_url_4,
  a0_.crm_api_key AS crm_api_key_5,
  a0_.webhook_url AS webhook_url_6,
  a0_.olead_api_key AS olead_api_key_7,
  a0_.footer_content AS footer_content_8,
  a0_.utm_variables AS utm_variables_9,
  a0_.cgu_url AS cgu_url_10,
  a0_.privacy_url AS privacy_url_11,
  a0_.site_name AS site_name_12,
  a0_.deleted_at AS deleted_at_13,
  a0_.created_at AS created_at_14,
  a0_.updated_at AS updated_at_15,
  a0_.uuid AS uuid_16,
  a0_.company_id AS company_id_17
FROM
  app_campaign a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.register_url AS register_url_4, a0_.crm_api_key AS crm_api_key_5, a0_.webhook_url AS webhook_url_6, a0_.olead_api_key AS olead_api_key_7, a0_.footer_content AS footer_content_8, a0_.utm_variables AS utm_variables_9, a0_.cgu_url AS cgu_url_10, a0_.privacy_url AS privacy_url_11, a0_.site_name AS site_name_12, a0_.deleted_at AS deleted_at_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.uuid AS uuid_16, a0_.company_id AS company_id_17 FROM app_campaign a0_ WHERE a0_.deleted_at IS NULL AND a0_.id IN (12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1) ORDER BY a0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.modules AS modules_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_check_valid_email AS is_check_valid_email_6,
  t0.gtm_id AS gtm_id_7,
  t0.identifier AS identifier_8,
  t0.deleted_at AS deleted_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.uuid AS uuid_12
FROM
  app_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.modules AS modules_4, t0.is_enabled AS is_enabled_5, t0.is_check_valid_email AS is_check_valid_email_6, t0.gtm_id AS gtm_id_7, t0.identifier AS identifier_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12 FROM app_company t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.modules AS modules_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_check_valid_email AS is_check_valid_email_6,
  t0.gtm_id AS gtm_id_7,
  t0.identifier AS identifier_8,
  t0.deleted_at AS deleted_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.uuid AS uuid_12
FROM
  app_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.modules AS modules_4, t0.is_enabled AS is_enabled_5, t0.is_check_valid_email AS is_check_valid_email_6, t0.gtm_id AS gtm_id_7, t0.identifier AS identifier_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12 FROM app_company t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.modules AS modules_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_check_valid_email AS is_check_valid_email_6,
  t0.gtm_id AS gtm_id_7,
  t0.identifier AS identifier_8,
  t0.deleted_at AS deleted_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.uuid AS uuid_12
FROM
  app_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.modules AS modules_4, t0.is_enabled AS is_enabled_5, t0.is_check_valid_email AS is_check_valid_email_6, t0.gtm_id AS gtm_id_7, t0.identifier AS identifier_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12 FROM app_company t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.modules AS modules_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_check_valid_email AS is_check_valid_email_6,
  t0.gtm_id AS gtm_id_7,
  t0.identifier AS identifier_8,
  t0.deleted_at AS deleted_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.uuid AS uuid_12
FROM
  app_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.modules AS modules_4, t0.is_enabled AS is_enabled_5, t0.is_check_valid_email AS is_check_valid_email_6, t0.gtm_id AS gtm_id_7, t0.identifier AS identifier_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12 FROM app_company t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.modules AS modules_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_check_valid_email AS is_check_valid_email_6,
  t0.gtm_id AS gtm_id_7,
  t0.identifier AS identifier_8,
  t0.deleted_at AS deleted_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.uuid AS uuid_12
FROM
  app_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.modules AS modules_4, t0.is_enabled AS is_enabled_5, t0.is_check_valid_email AS is_check_valid_email_6, t0.gtm_id AS gtm_id_7, t0.identifier AS identifier_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12 FROM app_company t0 WHERE t0.id = 2;