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_.number AS number_28,
  c5_.street2 AS street2_29,
  c5_.postcode AS postcode_30,
  c5_.city AS city_31,
  c5_.country AS country_32,
  c6_.id AS id_33,
  c6_.status AS status_34,
  c6_.date_begin AS date_begin_35,
  c6_.date_end AS date_end_36,
  c6_.price_excluding_vat AS price_excluding_vat_37,
  c6_.created_at AS created_at_38,
  c1_.translatable_id AS translatable_id_39,
  c2_.company_id AS company_id_40,
  c2_.service_id AS service_id_41,
  s4_.translatable_id AS translatable_id_42,
  c5_.company_id AS company_id_43,
  c6_.company_id AS company_id_44
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_.number AS number_28, c5_.street2 AS street2_29, c5_.postcode AS postcode_30, c5_.city AS city_31, c5_.country AS country_32, c6_.id AS id_33, c6_.status AS status_34, c6_.date_begin AS date_begin_35, c6_.date_end AS date_end_36, c6_.price_excluding_vat AS price_excluding_vat_37, c6_.created_at AS created_at_38, c1_.translatable_id AS translatable_id_39, c2_.company_id AS company_id_40, c2_.service_id AS service_id_41, s4_.translatable_id AS translatable_id_42, c5_.company_id AS company_id_43, c6_.company_id AS company_id_44 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 = 10 AND c0_.status IN ('active', 'cancelled') AND c6_.status = 'active' AND (c6_.date_end >= '2026-07-28 05:17:01' OR c6_.date_end IS NULL) ORDER BY c0_.created_at DESC, c2_.sort ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.profession_title AS profession_title_4,
  t0.profession_description AS profession_description_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_image AS seo_image_8,
  t0.locale AS locale_9,
  t0.translatable_id AS translatable_id_10
FROM
  service_translation t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.profession_title AS profession_title_4, t0.profession_description AS profession_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_image AS seo_image_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM service_translation t0 WHERE t0.slug = 'menuiserie' LIMIT 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_.number AS number_28,
  c5_.street2 AS street2_29,
  c5_.postcode AS postcode_30,
  c5_.city AS city_31,
  c5_.country AS country_32,
  c1_.translatable_id AS translatable_id_33,
  c2_.company_id AS company_id_34,
  c2_.service_id AS service_id_35,
  s4_.translatable_id AS translatable_id_36,
  c5_.company_id AS company_id_37
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_.number AS number_28, c5_.street2 AS street2_29, c5_.postcode AS postcode_30, c5_.city AS city_31, c5_.country AS country_32, c1_.translatable_id AS translatable_id_33, c2_.company_id AS company_id_34, c2_.service_id AS service_id_35, s4_.translatable_id AS translatable_id_36, c5_.company_id AS company_id_37 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 = 10 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_.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-07-28 05:17:01' OR c0_.date_end IS NULL) AND s1_.id IN (10) ORDER BY c0_.date_begin ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.profession_title AS profession_title_4,
  t0.profession_description AS profession_description_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_image AS seo_image_8,
  t0.locale AS locale_9,
  t0.translatable_id AS translatable_id_10
FROM
  service_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.profession_title AS profession_title_4, t0.profession_description AS profession_description_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_image AS seo_image_8, t0.locale AS locale_9, t0.translatable_id AS translatable_id_10 FROM service_translation t0 WHERE t0.translatable_id = 10;

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 = 'menuiserie';

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

SELECT
  t0.id AS id_1,
  t0.icon_image AS icon_image_2,
  t0.sort AS sort_3
FROM
  service t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.icon_image AS icon_image_2, t0.sort AS sort_3 FROM service t0 WHERE t0.id = 10;