Symfony Profiler

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 = ?)
WHERE
  s1_.slug = ?

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') WHERE s1_.slug = 'toiture';

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
  LEFT JOIN company_service c8_ ON c0_.id = c8_.company_id
  INNER JOIN company_advertising_highlight c6_ ON c0_.id = c6_.company_id
WHERE
  c8_.service_id = ?
  AND 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 LEFT JOIN company_service c8_ ON c0_.id = c8_.company_id INNER JOIN company_advertising_highlight c6_ ON c0_.id = c6_.company_id WHERE c8_.service_id = 3 AND c0_.status IN ('active', 'cancelled') AND c6_.status = 'active' AND (c6_.date_end >= '2026-06-10 12:22:50' 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_.date_begin AS date_begin_2,
  c0_.date_end AS date_end_3,
  c0_.price_excluding_vat AS price_excluding_vat_4,
  c0_.image AS image_5,
  c0_.image_responsive AS image_responsive_6,
  c0_.created_at AS created_at_7,
  s1_.id AS id_8,
  s1_.icon_image AS icon_image_9,
  s1_.sort AS sort_10,
  c2_.id AS id_11,
  c2_.status AS status_12,
  c2_.name AS name_13,
  c2_.slug AS slug_14,
  c2_.year_creation AS year_creation_15,
  c2_.number_project_last12_months AS number_project_last12_months_16,
  c2_.vat_number AS vat_number_17,
  c2_.created_at AS created_at_18,
  c2_.updated_at AS updated_at_19,
  c0_.company_id AS company_id_20
FROM
  company_advertising_banner c0_
  LEFT JOIN company_advertising_banner_service c3_ ON c0_.id = c3_.company_advertising_banner_id
  LEFT JOIN service s1_ ON s1_.id = c3_.service_id
  LEFT JOIN service_translation s4_ ON s1_.id = s4_.translatable_id
  AND (s4_.locale = ?)
  LEFT JOIN company c2_ ON c0_.company_id = c2_.id
WHERE
  c0_.status = ?
  AND (
    c0_.date_end >= ?
    OR c0_.date_end IS NULL
  )
  AND s1_.id IN (?)
ORDER BY
  c0_.date_begin ASC

SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.date_begin AS date_begin_2, c0_.date_end AS date_end_3, c0_.price_excluding_vat AS price_excluding_vat_4, c0_.image AS image_5, c0_.image_responsive AS image_responsive_6, c0_.created_at AS created_at_7, s1_.id AS id_8, s1_.icon_image AS icon_image_9, s1_.sort AS sort_10, c2_.id AS id_11, c2_.status AS status_12, c2_.name AS name_13, c2_.slug AS slug_14, c2_.year_creation AS year_creation_15, c2_.number_project_last12_months AS number_project_last12_months_16, c2_.vat_number AS vat_number_17, c2_.created_at AS created_at_18, c2_.updated_at AS updated_at_19, c0_.company_id AS company_id_20 FROM company_advertising_banner c0_ LEFT JOIN company_advertising_banner_service c3_ ON c0_.id = c3_.company_advertising_banner_id LEFT JOIN service s1_ ON s1_.id = c3_.service_id LEFT JOIN service_translation s4_ ON s1_.id = s4_.translatable_id AND (s4_.locale = 'fr') LEFT JOIN company c2_ ON c0_.company_id = c2_.id WHERE c0_.status = 'active' AND (c0_.date_end >= '2026-06-10 12:22:50' OR c0_.date_end IS NULL) AND s1_.id IN (3) ORDER BY c0_.date_begin 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 = ?)
  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
  LEFT JOIN company_service c7_ ON c0_.id = c7_.company_id
WHERE
  c7_.service_id = ?
  AND 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 LEFT JOIN company_service c7_ ON c0_.id = c7_.company_id WHERE c7_.service_id = 3 AND c0_.status IN ('active', 'cancelled') ORDER BY c0_.created_at DESC, c2_.sort ASC;

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');