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_.number AS number_14,
  c2_.street2 AS street2_15,
  c2_.postcode AS postcode_16,
  c2_.city AS city_17,
  c2_.country AS country_18,
  c3_.id AS id_19,
  c3_.logo_image AS logo_image_20,
  c3_.team_image AS team_image_21,
  c4_.id AS id_22,
  c4_.language AS language_23,
  c4_.sort AS sort_24,
  c5_.id AS id_25,
  c5_.sort AS sort_26,
  s6_.id AS id_27,
  s6_.icon_image AS icon_image_28,
  s6_.sort AS sort_29,
  s7_.id AS id_30,
  s7_.title AS title_31,
  s7_.slug AS slug_32,
  s7_.profession_title AS profession_title_33,
  s7_.profession_description AS profession_description_34,
  s7_.seo_title AS seo_title_35,
  s7_.seo_description AS seo_description_36,
  s7_.seo_image AS seo_image_37,
  s7_.locale AS locale_38,
  c8_.id AS id_39,
  c8_.sort AS sort_40,
  c9_.id AS id_41,
  c9_.email AS email_42,
  c9_.phone AS phone_43,
  c9_.whats_app AS whats_app_44,
  c10_.id AS id_45,
  c10_.website_link AS website_link_46,
  c10_.facebook_link AS facebook_link_47,
  c10_.instagram_link AS instagram_link_48,
  c10_.tiktok_link AS tiktok_link_49,
  c10_.x_link AS x_link_50,
  c11_.id AS id_51,
  c11_.sort AS sort_52,
  c12_.id AS id_53,
  c12_.title AS title_54,
  c12_.description AS description_55,
  c12_.locale AS locale_56,
  c13_.id AS id_57,
  c13_.image AS image_58,
  c13_.sort AS sort_59,
  c1_.translatable_id AS translatable_id_60,
  c2_.company_id AS company_id_61,
  c3_.company_id AS company_id_62,
  c4_.company_id AS company_id_63,
  c5_.company_id AS company_id_64,
  c5_.service_id AS service_id_65,
  s7_.translatable_id AS translatable_id_66,
  c8_.company_id AS company_id_67,
  c9_.company_id AS company_id_68,
  c10_.company_id AS company_id_69,
  c11_.company_id AS company_id_70,
  c12_.translatable_id AS translatable_id_71,
  c13_.company_project_id AS company_project_id_72
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_.number AS number_14, c2_.street2 AS street2_15, c2_.postcode AS postcode_16, c2_.city AS city_17, c2_.country AS country_18, c3_.id AS id_19, c3_.logo_image AS logo_image_20, c3_.team_image AS team_image_21, c4_.id AS id_22, c4_.language AS language_23, c4_.sort AS sort_24, c5_.id AS id_25, c5_.sort AS sort_26, s6_.id AS id_27, s6_.icon_image AS icon_image_28, s6_.sort AS sort_29, s7_.id AS id_30, s7_.title AS title_31, s7_.slug AS slug_32, s7_.profession_title AS profession_title_33, s7_.profession_description AS profession_description_34, s7_.seo_title AS seo_title_35, s7_.seo_description AS seo_description_36, s7_.seo_image AS seo_image_37, s7_.locale AS locale_38, c8_.id AS id_39, c8_.sort AS sort_40, c9_.id AS id_41, c9_.email AS email_42, c9_.phone AS phone_43, c9_.whats_app AS whats_app_44, c10_.id AS id_45, c10_.website_link AS website_link_46, c10_.facebook_link AS facebook_link_47, c10_.instagram_link AS instagram_link_48, c10_.tiktok_link AS tiktok_link_49, c10_.x_link AS x_link_50, c11_.id AS id_51, c11_.sort AS sort_52, c12_.id AS id_53, c12_.title AS title_54, c12_.description AS description_55, c12_.locale AS locale_56, c13_.id AS id_57, c13_.image AS image_58, c13_.sort AS sort_59, c1_.translatable_id AS translatable_id_60, c2_.company_id AS company_id_61, c3_.company_id AS company_id_62, c4_.company_id AS company_id_63, c5_.company_id AS company_id_64, c5_.service_id AS service_id_65, s7_.translatable_id AS translatable_id_66, c8_.company_id AS company_id_67, c9_.company_id AS company_id_68, c10_.company_id AS company_id_69, c11_.company_id AS company_id_70, c12_.translatable_id AS translatable_id_71, c13_.company_project_id AS company_project_id_72 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 = 13 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.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 = 13;

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