Symfony Profiler

SELECT 
  a0_.id AS id_0, 
  a0_.public AS public_1, 
  a0_.publication_date AS publication_date_2, 
  a0_.creation_date AS creation_date_3, 
  a0_.require_user AS require_user_4, 
  a0_.is_model AS is_model_5, 
  a0_.template AS template_6, 
  a0_.sort AS sort_7, 
  a0_.is_template AS is_template_8, 
  u2_.type AS type_9, 
  c3_.is_recommandation AS is_recommandation_10, 
  p9_.id AS id_11, 
  p9_.version_date AS version_date_12, 
  p9_.title AS title_13, 
  p9_.description AS description_14, 
  p9_.image AS image_15, 
  p9_.link AS link_16, 
  e10_.id AS id_17, 
  e10_.template AS template_18, 
  e10_.sort AS sort_19, 
  e11_.id AS id_20, 
  e11_.name AS name_21, 
  e11_.template AS template_22, 
  e11_.description AS description_23, 
  e11_.editor_display AS editor_display_24, 
  e11_.overridable AS overridable_25, 
  a0_.discr AS discr_26, 
  a0_.parent_id AS parent_id_27, 
  a0_.model_id AS model_id_28, 
  u2_.user_id AS user_id_29, 
  c3_.user_id AS user_id_30, 
  p9_.page_id AS page_id_31, 
  e10_.type_id AS type_id_32, 
  e10_.page_version_id AS page_version_id_33 
FROM 
  abstract_page a0_ 
  LEFT JOIN static_page s1_ ON a0_.id = s1_.id 
  LEFT JOIN user_page u2_ ON a0_.id = u2_.id 
  LEFT JOIN contract c3_ ON a0_.id = c3_.id 
  LEFT JOIN contract_page c4_ ON a0_.id = c4_.id 
  LEFT JOIN service s5_ ON a0_.id = s5_.id 
  LEFT JOIN service_category s6_ ON a0_.id = s6_.id 
  LEFT JOIN about_item a7_ ON a0_.id = a7_.id 
  LEFT JOIN about_category a8_ ON a0_.id = a8_.id 
  INNER JOIN page_version p9_ ON a0_.id = p9_.page_id 
  LEFT JOIN element e10_ ON p9_.id = e10_.page_version_id 
  LEFT JOIN element_type e11_ ON e10_.type_id = e11_.id 
  INNER JOIN page_version p12_ ON a0_.id = p12_.page_id 
WHERE 
  ? LIKE CONCAT(?, p12_.link) 
ORDER BY 
  p9_.version_date DESC

SELECT a0_.id AS id_0, a0_.public AS public_1, a0_.publication_date AS publication_date_2, a0_.creation_date AS creation_date_3, a0_.require_user AS require_user_4, a0_.is_model AS is_model_5, a0_.template AS template_6, a0_.sort AS sort_7, a0_.is_template AS is_template_8, u2_.type AS type_9, c3_.is_recommandation AS is_recommandation_10, p9_.id AS id_11, p9_.version_date AS version_date_12, p9_.title AS title_13, p9_.description AS description_14, p9_.image AS image_15, p9_.link AS link_16, e10_.id AS id_17, e10_.template AS template_18, e10_.sort AS sort_19, e11_.id AS id_20, e11_.name AS name_21, e11_.template AS template_22, e11_.description AS description_23, e11_.editor_display AS editor_display_24, e11_.overridable AS overridable_25, a0_.discr AS discr_26, a0_.parent_id AS parent_id_27, a0_.model_id AS model_id_28, u2_.user_id AS user_id_29, c3_.user_id AS user_id_30, p9_.page_id AS page_id_31, e10_.type_id AS type_id_32, e10_.page_version_id AS page_version_id_33 FROM abstract_page a0_ LEFT JOIN static_page s1_ ON a0_.id = s1_.id LEFT JOIN user_page u2_ ON a0_.id = u2_.id LEFT JOIN contract c3_ ON a0_.id = c3_.id LEFT JOIN contract_page c4_ ON a0_.id = c4_.id LEFT JOIN service s5_ ON a0_.id = s5_.id LEFT JOIN service_category s6_ ON a0_.id = s6_.id LEFT JOIN about_item a7_ ON a0_.id = a7_.id LEFT JOIN about_category a8_ ON a0_.id = a8_.id INNER JOIN page_version p9_ ON a0_.id = p9_.page_id LEFT JOIN element e10_ ON p9_.id = e10_.page_version_id LEFT JOIN element_type e11_ ON e10_.type_id = e11_.id INNER JOIN page_version p12_ ON a0_.id = p12_.page_id WHERE '/services/la-gestion-de-patrimoine' LIKE CONCAT('%', p12_.link) ORDER BY p9_.version_date DESC;

SELECT 
  t0.id AS id_1, 
  t0.type AS type_2, 
  t0.value AS value_3, 
  t0.name AS name_4, 
  t0.page_version_id AS page_version_id_5 
FROM 
  page_version_attribute t0 
WHERE 
  t0.page_version_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.value AS value_3, t0.name AS name_4, t0.page_version_id AS page_version_id_5 FROM page_version_attribute t0 WHERE t0.page_version_id = 10;

SELECT 
  t0.id AS id_1, 
  t0.version_date AS version_date_2, 
  t0.title AS title_3, 
  t0.description AS description_4, 
  t0.image AS image_5, 
  t0.link AS link_6, 
  t0.page_id AS page_id_7 
FROM 
  page_version t0 
WHERE 
  t0.page_id = ? 
ORDER BY 
  t0.version_date DESC

SELECT t0.id AS id_1, t0.version_date AS version_date_2, t0.title AS title_3, t0.description AS description_4, t0.image AS image_5, t0.link AS link_6, t0.page_id AS page_id_7 FROM page_version t0 WHERE t0.page_id = 10 ORDER BY t0.version_date DESC;

SELECT 
  t0.id AS id_1, 
  t0.template AS template_2, 
  t0.sort AS sort_3, 
  t0.type_id AS type_id_4, 
  t0.page_version_id AS page_version_id_5 
FROM 
  element t0 
WHERE 
  t0.page_version_id = ?

SELECT t0.id AS id_1, t0.template AS template_2, t0.sort AS sort_3, t0.type_id AS type_id_4, t0.page_version_id AS page_version_id_5 FROM element t0 WHERE t0.page_version_id = 10;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.description AS description_3, 
  t0.sort AS sort_4, 
  t0.public AS public_5, 
  t0.update_date AS update_date_6 
FROM 
  form t0 
WHERE 
  t0.public = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.sort AS sort_4, t0.public AS public_5, t0.update_date AS update_date_6 FROM form t0 WHERE t0.public = 1;

SELECT 
  t0.id AS id_9, 
  t0.public AS public_10, 
  t0.publication_date AS publication_date_11, 
  t0.creation_date AS creation_date_12, 
  t0.require_user AS require_user_13, 
  t0.is_model AS is_model_14, 
  t0.template AS template_15, 
  t0.sort AS sort_16, 
  t0.is_template AS is_template_17, 
  t0.parent_id AS parent_id_18, 
  t0.model_id AS model_id_19, 
  t0.discr, 
  t2.type AS type_20, 
  t2.user_id AS user_id_21, 
  t3.is_recommandation AS is_recommandation_22, 
  t3.user_id AS user_id_23 
FROM 
  abstract_page t0 
  LEFT JOIN static_page t1 ON t0.id = t1.id 
  LEFT JOIN user_page t2 ON t0.id = t2.id 
  LEFT JOIN contract t3 ON t0.id = t3.id 
  LEFT JOIN contract_page t4 ON t0.id = t4.id 
  LEFT JOIN service t5 ON t0.id = t5.id 
  LEFT JOIN service_category t6 ON t0.id = t6.id 
  LEFT JOIN about_item t7 ON t0.id = t7.id 
  LEFT JOIN about_category t8 ON t0.id = t8.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = 10;

SELECT 
  t0.id AS id_9, 
  t0.public AS public_10, 
  t0.publication_date AS publication_date_11, 
  t0.creation_date AS creation_date_12, 
  t0.require_user AS require_user_13, 
  t0.is_model AS is_model_14, 
  t0.template AS template_15, 
  t0.sort AS sort_16, 
  t0.is_template AS is_template_17, 
  t0.parent_id AS parent_id_18, 
  t0.model_id AS model_id_19, 
  t0.discr, 
  t2.type AS type_20, 
  t2.user_id AS user_id_21, 
  t3.is_recommandation AS is_recommandation_22, 
  t3.user_id AS user_id_23 
FROM 
  abstract_page t0 
  LEFT JOIN static_page t1 ON t0.id = t1.id 
  LEFT JOIN user_page t2 ON t0.id = t2.id 
  LEFT JOIN contract t3 ON t0.id = t3.id 
  LEFT JOIN contract_page t4 ON t0.id = t4.id 
  LEFT JOIN service t5 ON t0.id = t5.id 
  LEFT JOIN service_category t6 ON t0.id = t6.id 
  LEFT JOIN about_item t7 ON t0.id = t7.id 
  LEFT JOIN about_category t8 ON t0.id = t8.id 
WHERE 
  t0.parent_id = ? 
ORDER BY 
  t0.sort ASC

SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.parent_id = 2 ORDER BY t0.sort ASC;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.value AS value_3, 
  t0.type AS type_4 
FROM 
  config t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.type AS type_4 FROM config t0 WHERE t0.name = 'home_page_dashboard' LIMIT 1;

SELECT 
  t0.id AS id_9, 
  t0.public AS public_10, 
  t0.publication_date AS publication_date_11, 
  t0.creation_date AS creation_date_12, 
  t0.require_user AS require_user_13, 
  t0.is_model AS is_model_14, 
  t0.template AS template_15, 
  t0.sort AS sort_16, 
  t0.is_template AS is_template_17, 
  t0.parent_id AS parent_id_18, 
  t0.model_id AS model_id_19, 
  t0.discr, 
  t2.type AS type_20, 
  t2.user_id AS user_id_21, 
  t3.is_recommandation AS is_recommandation_22, 
  t3.user_id AS user_id_23 
FROM 
  abstract_page t0 
  LEFT JOIN static_page t1 ON t0.id = t1.id 
  LEFT JOIN user_page t2 ON t0.id = t2.id 
  LEFT JOIN contract t3 ON t0.id = t3.id 
  LEFT JOIN contract_page t4 ON t0.id = t4.id 
  LEFT JOIN service t5 ON t0.id = t5.id 
  LEFT JOIN service_category t6 ON t0.id = t6.id 
  LEFT JOIN about_item t7 ON t0.id = t7.id 
  LEFT JOIN about_category t8 ON t0.id = t8.id 
WHERE 
  t0.id = ? 
  AND t0.public = ? 
LIMIT 
  1

SELECT t0.id AS id_9, t0.public AS public_10, t0.publication_date AS publication_date_11, t0.creation_date AS creation_date_12, t0.require_user AS require_user_13, t0.is_model AS is_model_14, t0.template AS template_15, t0.sort AS sort_16, t0.is_template AS is_template_17, t0.parent_id AS parent_id_18, t0.model_id AS model_id_19, t0.discr, t2.type AS type_20, t2.user_id AS user_id_21, t3.is_recommandation AS is_recommandation_22, t3.user_id AS user_id_23 FROM abstract_page t0 LEFT JOIN static_page t1 ON t0.id = t1.id LEFT JOIN user_page t2 ON t0.id = t2.id LEFT JOIN contract t3 ON t0.id = t3.id LEFT JOIN contract_page t4 ON t0.id = t4.id LEFT JOIN service t5 ON t0.id = t5.id LEFT JOIN service_category t6 ON t0.id = t6.id LEFT JOIN about_item t7 ON t0.id = t7.id LEFT JOIN about_category t8 ON t0.id = t8.id WHERE t0.id = '11' AND t0.public = 1 LIMIT 1;

SELECT 
  t1.id AS id_2, 
  t1.public AS public_3, 
  t1.publication_date AS publication_date_4, 
  t1.creation_date AS creation_date_5, 
  t1.require_user AS require_user_6, 
  t1.is_model AS is_model_7, 
  t1.template AS template_8, 
  t1.sort AS sort_9, 
  t1.is_template AS is_template_10, 
  t1.parent_id AS parent_id_11, 
  t1.model_id AS model_id_12, 
  t1.discr 
FROM 
  service_category t0 
  INNER JOIN abstract_page t1 ON t0.id = t1.id 
WHERE 
  t1.public = ?

SELECT t1.id AS id_2, t1.public AS public_3, t1.publication_date AS publication_date_4, t1.creation_date AS creation_date_5, t1.require_user AS require_user_6, t1.is_model AS is_model_7, t1.template AS template_8, t1.sort AS sort_9, t1.is_template AS is_template_10, t1.parent_id AS parent_id_11, t1.model_id AS model_id_12, t1.discr FROM service_category t0 INNER JOIN abstract_page t1 ON t0.id = t1.id WHERE t1.public = 1;

SELECT 
  t1.id AS id_2, 
  t1.public AS public_3, 
  t1.publication_date AS publication_date_4, 
  t1.creation_date AS creation_date_5, 
  t1.require_user AS require_user_6, 
  t1.is_model AS is_model_7, 
  t1.template AS template_8, 
  t1.sort AS sort_9, 
  t1.is_template AS is_template_10, 
  t1.parent_id AS parent_id_11, 
  t1.model_id AS model_id_12, 
  t1.discr 
FROM 
  about_category t0 
  INNER JOIN abstract_page t1 ON t0.id = t1.id 
WHERE 
  t1.public = ? 
ORDER BY 
  t1.sort ASC

SELECT t1.id AS id_2, t1.public AS public_3, t1.publication_date AS publication_date_4, t1.creation_date AS creation_date_5, t1.require_user AS require_user_6, t1.is_model AS is_model_7, t1.template AS template_8, t1.sort AS sort_9, t1.is_template AS is_template_10, t1.parent_id AS parent_id_11, t1.model_id AS model_id_12, t1.discr FROM about_category t0 INNER JOIN abstract_page t1 ON t0.id = t1.id WHERE t1.public = 1 ORDER BY t1.sort ASC;