Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.status AS status_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.year_creation AS year_creation_4,
  c0_.number_project_last12_months AS number_project_last12_months_5,
  c0_.vat_number AS vat_number_6,
  c0_.created_at AS created_at_7,
  c0_.updated_at AS updated_at_8,
  c1_.id AS id_9,
  c1_.description AS description_10,
  c1_.locale AS locale_11,
  c2_.id AS id_12,
  c2_.sort AS sort_13,
  s3_.id AS id_14,
  s3_.icon_image AS icon_image_15,
  s3_.sort AS sort_16,
  s4_.id AS id_17,
  s4_.title AS title_18,
  s4_.slug AS slug_19,
  s4_.profession_title AS profession_title_20,
  s4_.profession_description AS profession_description_21,
  s4_.seo_title AS seo_title_22,
  s4_.seo_description AS seo_description_23,
  s4_.seo_image AS seo_image_24,
  s4_.locale AS locale_25,
  c5_.id AS id_26,
  c5_.street AS street_27,
  c5_.street2 AS street2_28,
  c5_.postcode AS postcode_29,
  c5_.city AS city_30,
  c5_.country AS country_31,
  c6_.id AS id_32,
  c6_.status AS status_33,
  c6_.date_begin AS date_begin_34,
  c6_.date_end AS date_end_35,
  c6_.price_excluding_vat AS price_excluding_vat_36,
  c6_.created_at AS created_at_37,
  c1_.translatable_id AS translatable_id_38,
  c2_.company_id AS company_id_39,
  c2_.service_id AS service_id_40,
  s4_.translatable_id AS translatable_id_41,
  c5_.company_id AS company_id_42,
  c6_.company_id AS company_id_43
FROM
  company c0_
  LEFT JOIN company_translation c1_ ON c0_.id = c1_.translatable_id
  AND (c1_.locale = ?)
  LEFT JOIN company_service c2_ ON c0_.id = c2_.company_id
  LEFT JOIN service s3_ ON c2_.service_id = s3_.id
  LEFT JOIN service_translation s4_ ON s3_.id = s4_.translatable_id
  AND (s4_.locale = ?)
  LEFT JOIN company_address c5_ ON c0_.id = c5_.company_id
  LEFT JOIN company_location c7_ ON c0_.id = c7_.company_id
  INNER JOIN company_advertising_highlight c6_ ON c0_.id = c6_.company_id
WHERE
  c0_.status IN (?, ?)
  AND c6_.status = ?
  AND (
    c6_.date_end >= ?
    OR c6_.date_end IS NULL
  )
ORDER BY
  c0_.created_at DESC,
  c2_.sort ASC

SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.year_creation AS year_creation_4, c0_.number_project_last12_months AS number_project_last12_months_5, c0_.vat_number AS vat_number_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.description AS description_10, c1_.locale AS locale_11, c2_.id AS id_12, c2_.sort AS sort_13, s3_.id AS id_14, s3_.icon_image AS icon_image_15, s3_.sort AS sort_16, s4_.id AS id_17, s4_.title AS title_18, s4_.slug AS slug_19, s4_.profession_title AS profession_title_20, s4_.profession_description AS profession_description_21, s4_.seo_title AS seo_title_22, s4_.seo_description AS seo_description_23, s4_.seo_image AS seo_image_24, s4_.locale AS locale_25, c5_.id AS id_26, c5_.street AS street_27, c5_.street2 AS street2_28, c5_.postcode AS postcode_29, c5_.city AS city_30, c5_.country AS country_31, c6_.id AS id_32, c6_.status AS status_33, c6_.date_begin AS date_begin_34, c6_.date_end AS date_end_35, c6_.price_excluding_vat AS price_excluding_vat_36, c6_.created_at AS created_at_37, c1_.translatable_id AS translatable_id_38, c2_.company_id AS company_id_39, c2_.service_id AS service_id_40, s4_.translatable_id AS translatable_id_41, c5_.company_id AS company_id_42, c6_.company_id AS company_id_43 FROM company c0_ LEFT JOIN company_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = 'fr') LEFT JOIN company_service c2_ ON c0_.id = c2_.company_id LEFT JOIN service s3_ ON c2_.service_id = s3_.id LEFT JOIN service_translation s4_ ON s3_.id = s4_.translatable_id AND (s4_.locale = 'fr') LEFT JOIN company_address c5_ ON c0_.id = c5_.company_id LEFT JOIN company_location c7_ ON c0_.id = c7_.company_id INNER JOIN company_advertising_highlight c6_ ON c0_.id = c6_.company_id WHERE c0_.status IN ('active', 'cancelled') AND c6_.status = 'active' AND (c6_.date_end >= '2026-06-10 12:21:49' OR c6_.date_end IS NULL) ORDER BY c0_.created_at DESC, c2_.sort ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.whats_app AS whats_app_4,
  t0.company_id AS company_id_5
FROM
  company_contact t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.whats_app AS whats_app_4, t0.company_id AS company_id_5 FROM company_contact t0 WHERE t0.company_id = 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.subscription_discount_snapshot AS subscription_discount_snapshot_3,
  t0.created_at AS created_at_4,
  t0.company_id AS company_id_5,
  t0.subscription_plan_price_id AS subscription_plan_price_id_6
FROM
  company_pending_subscription t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.subscription_discount_snapshot AS subscription_discount_snapshot_3, t0.created_at AS created_at_4, t0.company_id AS company_id_5, t0.subscription_plan_price_id AS subscription_plan_price_id_6 FROM company_pending_subscription t0 WHERE t0.company_id = 1;

SELECT
  t0.id AS id_1,
  t0.website_link AS website_link_2,
  t0.facebook_link AS facebook_link_3,
  t0.instagram_link AS instagram_link_4,
  t0.tiktok_link AS tiktok_link_5,
  t0.x_link AS x_link_6,
  t0.company_id AS company_id_7
FROM
  company_social_link t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.website_link AS website_link_2, t0.facebook_link AS facebook_link_3, t0.instagram_link AS instagram_link_4, t0.tiktok_link AS tiktok_link_5, t0.x_link AS x_link_6, t0.company_id AS company_id_7 FROM company_social_link t0 WHERE t0.company_id = 1;

SELECT
  c0_.id AS id_0,
  c0_.status AS status_1,
  c0_.name AS name_2,
  c0_.slug AS slug_3,
  c0_.year_creation AS year_creation_4,
  c0_.number_project_last12_months AS number_project_last12_months_5,
  c0_.vat_number AS vat_number_6,
  c0_.created_at AS created_at_7,
  c0_.updated_at AS updated_at_8,
  c1_.id AS id_9,
  c1_.description AS description_10,
  c1_.locale AS locale_11,
  c2_.id AS id_12,
  c2_.sort AS sort_13,
  s3_.id AS id_14,
  s3_.icon_image AS icon_image_15,
  s3_.sort AS sort_16,
  s4_.id AS id_17,
  s4_.title AS title_18,
  s4_.slug AS slug_19,
  s4_.profession_title AS profession_title_20,
  s4_.profession_description AS profession_description_21,
  s4_.seo_title AS seo_title_22,
  s4_.seo_description AS seo_description_23,
  s4_.seo_image AS seo_image_24,
  s4_.locale AS locale_25,
  c5_.id AS id_26,
  c5_.street AS street_27,
  c5_.street2 AS street2_28,
  c5_.postcode AS postcode_29,
  c5_.city AS city_30,
  c5_.country AS country_31,
  c1_.translatable_id AS translatable_id_32,
  c2_.company_id AS company_id_33,
  c2_.service_id AS service_id_34,
  s4_.translatable_id AS translatable_id_35,
  c5_.company_id AS company_id_36
FROM
  company c0_
  LEFT JOIN company_translation c1_ ON c0_.id = c1_.translatable_id
  AND (c1_.locale = ?)
  LEFT JOIN company_service c2_ ON c0_.id = c2_.company_id
  LEFT JOIN service s3_ ON c2_.service_id = s3_.id
  LEFT JOIN service_translation s4_ ON s3_.id = s4_.translatable_id
  AND (s4_.locale = ?)
  LEFT JOIN company_address c5_ ON c0_.id = c5_.company_id
  LEFT JOIN company_location c6_ ON c0_.id = c6_.company_id
WHERE
  c0_.status IN (?, ?)
ORDER BY
  c0_.created_at DESC,
  c2_.sort ASC

SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.name AS name_2, c0_.slug AS slug_3, c0_.year_creation AS year_creation_4, c0_.number_project_last12_months AS number_project_last12_months_5, c0_.vat_number AS vat_number_6, c0_.created_at AS created_at_7, c0_.updated_at AS updated_at_8, c1_.id AS id_9, c1_.description AS description_10, c1_.locale AS locale_11, c2_.id AS id_12, c2_.sort AS sort_13, s3_.id AS id_14, s3_.icon_image AS icon_image_15, s3_.sort AS sort_16, s4_.id AS id_17, s4_.title AS title_18, s4_.slug AS slug_19, s4_.profession_title AS profession_title_20, s4_.profession_description AS profession_description_21, s4_.seo_title AS seo_title_22, s4_.seo_description AS seo_description_23, s4_.seo_image AS seo_image_24, s4_.locale AS locale_25, c5_.id AS id_26, c5_.street AS street_27, c5_.street2 AS street2_28, c5_.postcode AS postcode_29, c5_.city AS city_30, c5_.country AS country_31, c1_.translatable_id AS translatable_id_32, c2_.company_id AS company_id_33, c2_.service_id AS service_id_34, s4_.translatable_id AS translatable_id_35, c5_.company_id AS company_id_36 FROM company c0_ LEFT JOIN company_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = 'fr') LEFT JOIN company_service c2_ ON c0_.id = c2_.company_id LEFT JOIN service s3_ ON c2_.service_id = s3_.id LEFT JOIN service_translation s4_ ON s3_.id = s4_.translatable_id AND (s4_.locale = 'fr') LEFT JOIN company_address c5_ ON c0_.id = c5_.company_id LEFT JOIN company_location c6_ ON c0_.id = c6_.company_id WHERE c0_.status IN ('active', 'cancelled') ORDER BY c0_.created_at DESC, c2_.sort ASC;

SELECT
  t0.id AS id_1,
  t0.logo_image AS logo_image_2,
  t0.team_image AS team_image_3,
  t0.company_id AS company_id_4
FROM
  company_media t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.logo_image AS logo_image_2, t0.team_image AS team_image_3, t0.company_id AS company_id_4 FROM company_media t0 WHERE t0.company_id = 1;

SELECT
  s0_.id AS id_0,
  s0_.icon_image AS icon_image_1,
  s0_.sort AS sort_2,
  s1_.id AS id_3,
  s1_.title AS title_4,
  s1_.slug AS slug_5,
  s1_.profession_title AS profession_title_6,
  s1_.profession_description AS profession_description_7,
  s1_.seo_title AS seo_title_8,
  s1_.seo_description AS seo_description_9,
  s1_.seo_image AS seo_image_10,
  s1_.locale AS locale_11,
  s1_.translatable_id AS translatable_id_12
FROM
  service s0_
  LEFT JOIN service_translation s1_ ON s0_.id = s1_.translatable_id
  AND (s1_.locale = ?)

SELECT s0_.id AS id_0, s0_.icon_image AS icon_image_1, s0_.sort AS sort_2, s1_.id AS id_3, s1_.title AS title_4, s1_.slug AS slug_5, s1_.profession_title AS profession_title_6, s1_.profession_description AS profession_description_7, s1_.seo_title AS seo_title_8, s1_.seo_description AS seo_description_9, s1_.seo_image AS seo_image_10, s1_.locale AS locale_11, s1_.translatable_id AS translatable_id_12 FROM service s0_ LEFT JOIN service_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = 'fr');

SELECT
  c0_.id AS id_0,
  c0_.postcode AS postcode_1,
  c1_.id AS id_2,
  c1_.name AS name_3,
  c1_.locale AS locale_4,
  c0_.country_id AS country_id_5,
  c0_.province_id AS province_id_6,
  c1_.translatable_id AS translatable_id_7
FROM
  city c0_
  LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id
  AND (c1_.locale = ?)

SELECT c0_.id AS id_0, c0_.postcode AS postcode_1, c1_.id AS id_2, c1_.name AS name_3, c1_.locale AS locale_4, c0_.country_id AS country_id_5, c0_.province_id AS province_id_6, c1_.translatable_id AS translatable_id_7 FROM city c0_ LEFT JOIN city_translation c1_ ON c0_.id = c1_.translatable_id AND (c1_.locale = 'fr');