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_.street AS street_13,
  c2_.street2 AS street2_14,
  c2_.postcode AS postcode_15,
  c2_.city AS city_16,
  c2_.country AS country_17,
  c3_.id AS id_18,
  c3_.logo_image AS logo_image_19,
  c3_.team_image AS team_image_20,
  c4_.id AS id_21,
  c4_.language AS language_22,
  c4_.sort AS sort_23,
  c5_.id AS id_24,
  c5_.sort AS sort_25,
  s6_.id AS id_26,
  s6_.icon_image AS icon_image_27,
  s6_.sort AS sort_28,
  s7_.id AS id_29,
  s7_.title AS title_30,
  s7_.slug AS slug_31,
  s7_.profession_title AS profession_title_32,
  s7_.profession_description AS profession_description_33,
  s7_.seo_title AS seo_title_34,
  s7_.seo_description AS seo_description_35,
  s7_.seo_image AS seo_image_36,
  s7_.locale AS locale_37,
  c8_.id AS id_38,
  c8_.sort AS sort_39,
  c9_.id AS id_40,
  c9_.email AS email_41,
  c9_.phone AS phone_42,
  c9_.whats_app AS whats_app_43,
  c10_.id AS id_44,
  c10_.website_link AS website_link_45,
  c10_.facebook_link AS facebook_link_46,
  c10_.instagram_link AS instagram_link_47,
  c10_.tiktok_link AS tiktok_link_48,
  c10_.x_link AS x_link_49,
  c11_.id AS id_50,
  c11_.sort AS sort_51,
  c12_.id AS id_52,
  c12_.title AS title_53,
  c12_.description AS description_54,
  c12_.locale AS locale_55,
  c13_.id AS id_56,
  c13_.image AS image_57,
  c13_.sort AS sort_58,
  c1_.translatable_id AS translatable_id_59,
  c2_.company_id AS company_id_60,
  c3_.company_id AS company_id_61,
  c4_.company_id AS company_id_62,
  c5_.company_id AS company_id_63,
  c5_.service_id AS service_id_64,
  s7_.translatable_id AS translatable_id_65,
  c8_.company_id AS company_id_66,
  c9_.company_id AS company_id_67,
  c10_.company_id AS company_id_68,
  c11_.company_id AS company_id_69,
  c12_.translatable_id AS translatable_id_70,
  c13_.company_project_id AS company_project_id_71
FROM
  company c0_
  LEFT JOIN company_translation c1_ ON c0_.id = c1_.translatable_id
  LEFT JOIN company_address c2_ ON c0_.id = c2_.company_id
  LEFT JOIN company_media c3_ ON c0_.id = c3_.company_id
  LEFT JOIN company_language c4_ ON c0_.id = c4_.company_id
  LEFT JOIN company_service c5_ ON c0_.id = c5_.company_id
  LEFT JOIN service s6_ ON c5_.service_id = s6_.id
  LEFT JOIN service_translation s7_ ON s6_.id = s7_.translatable_id
  AND (s7_.locale = ?)
  LEFT JOIN company_secondary_service c8_ ON c0_.id = c8_.company_id
  LEFT JOIN company_contact c9_ ON c0_.id = c9_.company_id
  LEFT JOIN company_social_link c10_ ON c0_.id = c10_.company_id
  LEFT JOIN company_project c11_ ON c0_.id = c11_.company_id
  LEFT JOIN company_project_translation c12_ ON c11_.id = c12_.translatable_id
  AND (s7_.locale = ?)
  LEFT JOIN company_project_image c13_ ON c11_.id = c13_.company_project_id
WHERE
  c0_.id = ?
  AND c0_.status IN (?, ?)
ORDER BY
  c4_.sort ASC,
  c5_.sort ASC,
  c8_.sort ASC,
  c11_.id ASC,
  c13_.id 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_.street AS street_13, c2_.street2 AS street2_14, c2_.postcode AS postcode_15, c2_.city AS city_16, c2_.country AS country_17, c3_.id AS id_18, c3_.logo_image AS logo_image_19, c3_.team_image AS team_image_20, c4_.id AS id_21, c4_.language AS language_22, c4_.sort AS sort_23, c5_.id AS id_24, c5_.sort AS sort_25, s6_.id AS id_26, s6_.icon_image AS icon_image_27, s6_.sort AS sort_28, s7_.id AS id_29, s7_.title AS title_30, s7_.slug AS slug_31, s7_.profession_title AS profession_title_32, s7_.profession_description AS profession_description_33, s7_.seo_title AS seo_title_34, s7_.seo_description AS seo_description_35, s7_.seo_image AS seo_image_36, s7_.locale AS locale_37, c8_.id AS id_38, c8_.sort AS sort_39, c9_.id AS id_40, c9_.email AS email_41, c9_.phone AS phone_42, c9_.whats_app AS whats_app_43, c10_.id AS id_44, c10_.website_link AS website_link_45, c10_.facebook_link AS facebook_link_46, c10_.instagram_link AS instagram_link_47, c10_.tiktok_link AS tiktok_link_48, c10_.x_link AS x_link_49, c11_.id AS id_50, c11_.sort AS sort_51, c12_.id AS id_52, c12_.title AS title_53, c12_.description AS description_54, c12_.locale AS locale_55, c13_.id AS id_56, c13_.image AS image_57, c13_.sort AS sort_58, c1_.translatable_id AS translatable_id_59, c2_.company_id AS company_id_60, c3_.company_id AS company_id_61, c4_.company_id AS company_id_62, c5_.company_id AS company_id_63, c5_.service_id AS service_id_64, s7_.translatable_id AS translatable_id_65, c8_.company_id AS company_id_66, c9_.company_id AS company_id_67, c10_.company_id AS company_id_68, c11_.company_id AS company_id_69, c12_.translatable_id AS translatable_id_70, c13_.company_project_id AS company_project_id_71 FROM company c0_ LEFT JOIN company_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN company_address c2_ ON c0_.id = c2_.company_id LEFT JOIN company_media c3_ ON c0_.id = c3_.company_id LEFT JOIN company_language c4_ ON c0_.id = c4_.company_id LEFT JOIN company_service c5_ ON c0_.id = c5_.company_id LEFT JOIN service s6_ ON c5_.service_id = s6_.id LEFT JOIN service_translation s7_ ON s6_.id = s7_.translatable_id AND (s7_.locale = 'fr') LEFT JOIN company_secondary_service c8_ ON c0_.id = c8_.company_id LEFT JOIN company_contact c9_ ON c0_.id = c9_.company_id LEFT JOIN company_social_link c10_ ON c0_.id = c10_.company_id LEFT JOIN company_project c11_ ON c0_.id = c11_.company_id LEFT JOIN company_project_translation c12_ ON c11_.id = c12_.translatable_id AND (s7_.locale = 'fr') LEFT JOIN company_project_image c13_ ON c11_.id = c13_.company_project_id WHERE c0_.id = 23 AND c0_.status IN ('active', 'cancelled') ORDER BY c4_.sort ASC, c5_.sort ASC, c8_.sort ASC, c11_.id ASC, c13_.id ASC;

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

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.lastname AS lastname_3,
  t0.firstname AS firstname_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.password AS password_7,
  t0.language AS language_8,
  t0.roles AS roles_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  user t0
  INNER JOIN user_company ON t0.id = user_company.user_id
WHERE
  user_company.company_id = ?

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.lastname AS lastname_3, t0.firstname AS firstname_4, t0.email AS email_5, t0.phone AS phone_6, t0.password AS password_7, t0.language AS language_8, t0.roles AS roles_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM user t0 INNER JOIN user_company ON t0.id = user_company.user_id WHERE user_company.company_id = 23;