Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.status AS status_1,
  p0_.postcode AS postcode_2,
  p0_.year_of_construction AS year_of_construction_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p1_.id AS id_6,
  p1_.title AS title_7,
  p1_.description AS description_8,
  p1_.locale AS locale_9,
  s2_.id AS id_10,
  s2_.icon_image AS icon_image_11,
  s2_.sort AS sort_12,
  p3_.id AS id_13,
  p3_.sort AS sort_14,
  p4_.id AS id_15,
  p4_.title AS title_16,
  p4_.locale AS locale_17,
  p5_.id AS id_18,
  p5_.image AS image_19,
  p5_.sort AS sort_20,
  p0_.particular_project_budget_id AS particular_project_budget_id_21,
  p0_.user_id AS user_id_22,
  p1_.translatable_id AS translatable_id_23,
  p4_.translatable_id AS translatable_id_24,
  p5_.particular_project_id AS particular_project_id_25
FROM
  particular_project p0_
  LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id
  LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id
  LEFT JOIN service s2_ ON s2_.id = p6_.service_id
  LEFT JOIN service_translation s7_ ON s2_.id = s7_.translatable_id
  AND (s7_.locale = ?)
  LEFT JOIN particular_project_budget p3_ ON p0_.particular_project_budget_id = p3_.id
  LEFT JOIN particular_project_budget_translation p4_ ON p3_.id = p4_.translatable_id
  AND (p4_.locale = ?)
  LEFT JOIN particular_project_image p5_ ON p0_.id = p5_.particular_project_id
WHERE
  p0_.status = ?
  AND p0_.id = ?

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.postcode AS postcode_2, p0_.year_of_construction AS year_of_construction_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p1_.id AS id_6, p1_.title AS title_7, p1_.description AS description_8, p1_.locale AS locale_9, s2_.id AS id_10, s2_.icon_image AS icon_image_11, s2_.sort AS sort_12, p3_.id AS id_13, p3_.sort AS sort_14, p4_.id AS id_15, p4_.title AS title_16, p4_.locale AS locale_17, p5_.id AS id_18, p5_.image AS image_19, p5_.sort AS sort_20, p0_.particular_project_budget_id AS particular_project_budget_id_21, p0_.user_id AS user_id_22, p1_.translatable_id AS translatable_id_23, p4_.translatable_id AS translatable_id_24, p5_.particular_project_id AS particular_project_id_25 FROM particular_project p0_ LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id LEFT JOIN service s2_ ON s2_.id = p6_.service_id LEFT JOIN service_translation s7_ ON s2_.id = s7_.translatable_id AND (s7_.locale = 'fr') LEFT JOIN particular_project_budget p3_ ON p0_.particular_project_budget_id = p3_.id LEFT JOIN particular_project_budget_translation p4_ ON p3_.id = p4_.translatable_id AND (p4_.locale = 'fr') LEFT JOIN particular_project_image p5_ ON p0_.id = p5_.particular_project_id WHERE p0_.status = 'active' AND p0_.id = 15;

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 = ?)
WHERE
  c0_.postcode = ?

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') WHERE c0_.postcode = '1025';

SELECT
  p0_.id AS id_0,
  p0_.status AS status_1,
  p0_.postcode AS postcode_2,
  p0_.year_of_construction AS year_of_construction_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p1_.id AS id_6,
  p1_.title AS title_7,
  p1_.description AS description_8,
  p1_.locale AS locale_9,
  s2_.id AS id_10,
  s2_.icon_image AS icon_image_11,
  s2_.sort AS sort_12,
  p3_.id AS id_13,
  p3_.sort AS sort_14,
  p4_.id AS id_15,
  p4_.title AS title_16,
  p4_.locale AS locale_17,
  p5_.id AS id_18,
  p5_.image AS image_19,
  p5_.sort AS sort_20,
  p0_.particular_project_budget_id AS particular_project_budget_id_21,
  p0_.user_id AS user_id_22,
  p1_.translatable_id AS translatable_id_23,
  p4_.translatable_id AS translatable_id_24,
  p5_.particular_project_id AS particular_project_id_25
FROM
  particular_project p0_
  LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id
  LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id
  LEFT JOIN service s2_ ON s2_.id = p6_.service_id
  LEFT JOIN service_translation s7_ ON s2_.id = s7_.translatable_id
  AND (s7_.locale = ?)
  LEFT JOIN particular_project_budget p3_ ON p0_.particular_project_budget_id = p3_.id
  LEFT JOIN particular_project_budget_translation p4_ ON p3_.id = p4_.translatable_id
  AND (p4_.locale = ?)
  LEFT JOIN particular_project_image p5_ ON p0_.id = p5_.particular_project_id
WHERE
  p0_.status = ?
  AND s2_.id IN (?, ?, ?, ?)
  AND p0_.id NOT IN (?)
ORDER BY
  p0_.created_at DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.postcode AS postcode_2, p0_.year_of_construction AS year_of_construction_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p1_.id AS id_6, p1_.title AS title_7, p1_.description AS description_8, p1_.locale AS locale_9, s2_.id AS id_10, s2_.icon_image AS icon_image_11, s2_.sort AS sort_12, p3_.id AS id_13, p3_.sort AS sort_14, p4_.id AS id_15, p4_.title AS title_16, p4_.locale AS locale_17, p5_.id AS id_18, p5_.image AS image_19, p5_.sort AS sort_20, p0_.particular_project_budget_id AS particular_project_budget_id_21, p0_.user_id AS user_id_22, p1_.translatable_id AS translatable_id_23, p4_.translatable_id AS translatable_id_24, p5_.particular_project_id AS particular_project_id_25 FROM particular_project p0_ LEFT JOIN particular_project_translation p1_ ON p0_.id = p1_.translatable_id LEFT JOIN particular_project_service p6_ ON p0_.id = p6_.particular_project_id LEFT JOIN service s2_ ON s2_.id = p6_.service_id LEFT JOIN service_translation s7_ ON s2_.id = s7_.translatable_id AND (s7_.locale = 'fr') LEFT JOIN particular_project_budget p3_ ON p0_.particular_project_budget_id = p3_.id LEFT JOIN particular_project_budget_translation p4_ ON p3_.id = p4_.translatable_id AND (p4_.locale = 'fr') LEFT JOIN particular_project_image p5_ ON p0_.id = p5_.particular_project_id WHERE p0_.status = 'active' AND s2_.id IN (1, 2, 3, 5) AND p0_.id NOT IN (15) ORDER BY p0_.created_at DESC LIMIT 4;

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 = 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.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 = 2;

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

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

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
WHERE
  t0.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 WHERE t0.id = 46;