Symfony Profiler

SELECT
  p.id
FROM
  post p
  JOIN post_type pt ON pt.id = p.post_type_id
  AND pt.slug_post_type = 'services'
  JOIN post_meta k ON k.id_post_id = p.id
  AND k.meta_key = :key
  AND k.meta_value = :value
  JOIN post_meta a ON a.id_post_id = p.id
  AND a.meta_key = 'adresse'
  AND TRIM(a.meta_value) <> ''
  JOIN post_meta t ON t.id_post_id = p.id
  AND t.meta_key = 'telephone'
  AND TRIM(t.meta_value) <> ''
  LEFT JOIN post_meta r ON r.id_post_id = p.id
  AND r.meta_key = 'rmp_avg_rating'
WHERE
  p.post_status = 'Publié'
  AND p.id NOT IN (7926)
ORDER BY
  CAST(
    COALESCE(r.meta_value, 0) AS DECIMAL(4, 2)
  ) DESC,
  p.id ASC
LIMIT
  :lim

SELECT p.id
            FROM post p
            JOIN post_type pt ON pt.id = p.post_type_id AND pt.slug_post_type = 'services'
            JOIN post_meta k ON k.id_post_id = p.id AND k.meta_key = 'code' AND k.meta_value = '22000'
            JOIN post_meta a ON a.id_post_id = p.id AND a.meta_key = 'adresse' AND TRIM(a.meta_value) <> ''
            JOIN post_meta t ON t.id_post_id = p.id AND t.meta_key = 'telephone' AND TRIM(t.meta_value) <> ''
            LEFT JOIN post_meta r ON r.id_post_id = p.id AND r.meta_key = 'rmp_avg_rating'
            WHERE p.post_status = 'Publié'
         AND p.id NOT IN (7926) ORDER BY CAST(COALESCE(r.meta_value, 0) AS DECIMAL(4,2)) DESC, p.id ASC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.url_image AS url_image_2,
  t0.name_image AS name_image_3,
  t0.description_image AS description_image_4,
  t0.alt_image AS alt_image_5,
  t0.size AS size_6,
  t0.date_add AS date_add_7,
  t0.date_update AS date_update_8,
  t0.height AS height_9,
  t0.width AS width_10,
  t0.data AS data_11,
  t0.mime_type AS mime_type_12,
  t0.id_migration AS id_migration_13,
  t0.status AS status_14,
  t0.documentation_category_id AS documentation_category_id_15
FROM
  images t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url_image AS url_image_2, t0.name_image AS name_image_3, t0.description_image AS description_image_4, t0.alt_image AS alt_image_5, t0.size AS size_6, t0.date_add AS date_add_7, t0.date_update AS date_update_8, t0.height AS height_9, t0.width AS width_10, t0.data AS data_11, t0.mime_type AS mime_type_12, t0.id_migration AS id_migration_13, t0.status AS status_14, t0.documentation_category_id AS documentation_category_id_15 FROM images t0 WHERE t0.id = '182';

SELECT
  t0.id AS id_1,
  t0.post_title AS post_title_2,
  t0.post_content AS post_content_3,
  t0.post_excerpt AS post_excerpt_4,
  t0.post_name AS post_name_5,
  t0.post_parent AS post_parent_6,
  t0.guide AS guide_7,
  t0.menu_ordre AS menu_ordre_8,
  t0.post_status AS post_status_9,
  t0.comment_status AS comment_status_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.post_content_2 AS post_content_2_13,
  t0.post_order_content AS post_order_content_14,
  t0.post_parent_migration AS post_parent_migration_15,
  t0.post_id__migration AS post_id__migration_16,
  t0.page_template AS page_template_17,
  t0.post_content_3 AS post_content_3_18,
  t0.post_content_4 AS post_content_4_19,
  t0.post_content_5 AS post_content_5_20,
  t0.post_order_content_preinsertion AS post_order_content_preinsertion_21,
  t0.is_draft AS is_draft_22,
  t0.page_menu AS page_menu_23,
  t0.sommaire AS sommaire_24,
  t0.is_index AS is_index_25,
  t0.is_follow AS is_follow_26,
  t0.post_meta_json AS post_meta_json_27,
  t0.post_meta_json_dev AS post_meta_json_dev_28,
  t0.modele_static AS modele_static_29,
  t0.id_feature_image_id AS id_feature_image_id_30,
  t0.post_type_id AS post_type_id_31,
  t0.page_template_id AS page_template_id_32,
  t0.creator_id AS creator_id_33,
  t0.author_id AS author_id_34
FROM
  post t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.post_title AS post_title_2, t0.post_content AS post_content_3, t0.post_excerpt AS post_excerpt_4, t0.post_name AS post_name_5, t0.post_parent AS post_parent_6, t0.guide AS guide_7, t0.menu_ordre AS menu_ordre_8, t0.post_status AS post_status_9, t0.comment_status AS comment_status_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.post_content_2 AS post_content_2_13, t0.post_order_content AS post_order_content_14, t0.post_parent_migration AS post_parent_migration_15, t0.post_id__migration AS post_id__migration_16, t0.page_template AS page_template_17, t0.post_content_3 AS post_content_3_18, t0.post_content_4 AS post_content_4_19, t0.post_content_5 AS post_content_5_20, t0.post_order_content_preinsertion AS post_order_content_preinsertion_21, t0.is_draft AS is_draft_22, t0.page_menu AS page_menu_23, t0.sommaire AS sommaire_24, t0.is_index AS is_index_25, t0.is_follow AS is_follow_26, t0.post_meta_json AS post_meta_json_27, t0.post_meta_json_dev AS post_meta_json_dev_28, t0.modele_static AS modele_static_29, t0.id_feature_image_id AS id_feature_image_id_30, t0.post_type_id AS post_type_id_31, t0.page_template_id AS page_template_id_32, t0.creator_id AS creator_id_33, t0.author_id AS author_id_34 FROM post t0 WHERE t0.id = 12129 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.meta_key AS meta_key_2,
  t0.meta_value AS meta_value_3,
  t0.mv_region AS mv_region_4,
  t0.mv_departement AS mv_departement_5,
  t0.mv_type_page AS mv_type_page_6,
  t0.id_post_id AS id_post_id_7,
  t0.acf_id AS acf_id_8
FROM
  post_meta t0
WHERE
  t0.id_post_id = ?

SELECT t0.id AS id_1, t0.meta_key AS meta_key_2, t0.meta_value AS meta_value_3, t0.mv_region AS mv_region_4, t0.mv_departement AS mv_departement_5, t0.mv_type_page AS mv_type_page_6, t0.id_post_id AS id_post_id_7, t0.acf_id AS acf_id_8 FROM post_meta t0 WHERE t0.id_post_id = 12155;

SELECT
  p0_.id AS id_0,
  p0_.post_title AS post_title_1,
  p0_.post_content AS post_content_2,
  p0_.post_excerpt AS post_excerpt_3,
  p0_.post_name AS post_name_4,
  p0_.post_parent AS post_parent_5,
  p0_.guide AS guide_6,
  p0_.menu_ordre AS menu_ordre_7,
  p0_.post_status AS post_status_8,
  p0_.comment_status AS comment_status_9,
  p0_.date_add AS date_add_10,
  p0_.date_upd AS date_upd_11,
  p0_.post_content_2 AS post_content_2_12,
  p0_.post_order_content AS post_order_content_13,
  p0_.post_parent_migration AS post_parent_migration_14,
  p0_.post_id__migration AS post_id__migration_15,
  p0_.page_template AS page_template_16,
  p0_.post_content_3 AS post_content_3_17,
  p0_.post_content_4 AS post_content_4_18,
  p0_.post_content_5 AS post_content_5_19,
  p0_.post_order_content_preinsertion AS post_order_content_preinsertion_20,
  p0_.is_draft AS is_draft_21,
  p0_.page_menu AS page_menu_22,
  p0_.sommaire AS sommaire_23,
  p0_.is_index AS is_index_24,
  p0_.is_follow AS is_follow_25,
  p0_.post_meta_json AS post_meta_json_26,
  p0_.post_meta_json_dev AS post_meta_json_dev_27,
  p0_.modele_static AS modele_static_28,
  p0_.id_feature_image_id AS id_feature_image_id_29,
  p0_.post_type_id AS post_type_id_30,
  p0_.page_template_id AS page_template_id_31,
  p0_.creator_id AS creator_id_32,
  p0_.author_id AS author_id_33
FROM
  post p0_
  INNER JOIN post_type p1_ ON p0_.post_type_id = p1_.id
WHERE
  p1_.slug_post_type = ?
  AND p0_.post_status = ?
ORDER BY
  p0_.id DESC
LIMIT
  6

SELECT p0_.id AS id_0, p0_.post_title AS post_title_1, p0_.post_content AS post_content_2, p0_.post_excerpt AS post_excerpt_3, p0_.post_name AS post_name_4, p0_.post_parent AS post_parent_5, p0_.guide AS guide_6, p0_.menu_ordre AS menu_ordre_7, p0_.post_status AS post_status_8, p0_.comment_status AS comment_status_9, p0_.date_add AS date_add_10, p0_.date_upd AS date_upd_11, p0_.post_content_2 AS post_content_2_12, p0_.post_order_content AS post_order_content_13, p0_.post_parent_migration AS post_parent_migration_14, p0_.post_id__migration AS post_id__migration_15, p0_.page_template AS page_template_16, p0_.post_content_3 AS post_content_3_17, p0_.post_content_4 AS post_content_4_18, p0_.post_content_5 AS post_content_5_19, p0_.post_order_content_preinsertion AS post_order_content_preinsertion_20, p0_.is_draft AS is_draft_21, p0_.page_menu AS page_menu_22, p0_.sommaire AS sommaire_23, p0_.is_index AS is_index_24, p0_.is_follow AS is_follow_25, p0_.post_meta_json AS post_meta_json_26, p0_.post_meta_json_dev AS post_meta_json_dev_27, p0_.modele_static AS modele_static_28, p0_.id_feature_image_id AS id_feature_image_id_29, p0_.post_type_id AS post_type_id_30, p0_.page_template_id AS page_template_id_31, p0_.creator_id AS creator_id_32, p0_.author_id AS author_id_33 FROM post p0_ INNER JOIN post_type p1_ ON p0_.post_type_id = p1_.id WHERE p1_.slug_post_type = 'blog' AND p0_.post_status = 'Publié' ORDER BY p0_.id DESC LIMIT 6;

SELECT
  p0_.id AS id_0,
  p0_.post_name AS post_name_1,
  p0_.post_parent AS post_parent_2
FROM
  post p0_
WHERE
  p0_.id = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.post_name AS post_name_1, p0_.post_parent AS post_parent_2 FROM post p0_ WHERE p0_.id = 12155 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.option_name AS option_name_2,
  t0.option_value AS option_value_3,
  t0.option_label AS option_label_4,
  t0.option_type AS option_type_5
FROM
  options t0
WHERE
  t0.option_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_value AS option_value_3, t0.option_label AS option_label_4, t0.option_type AS option_type_5 FROM options t0 WHERE t0.option_name = '_site_name' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name_menu AS name_menu_2,
  t0.menu_content AS menu_content_3,
  t0.status_menu AS status_menu_4,
  t0.date_add AS date_add_5,
  t0.date_update AS date_update_6,
  t0.template_menu_id AS template_menu_id_7,
  t0.user_id AS user_id_8
FROM
  menu t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_menu AS name_menu_2, t0.menu_content AS menu_content_3, t0.status_menu AS status_menu_4, t0.date_add AS date_add_5, t0.date_update AS date_update_6, t0.template_menu_id AS template_menu_id_7, t0.user_id AS user_id_8 FROM menu t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.post_title AS post_title_2,
  t0.post_content AS post_content_3,
  t0.post_excerpt AS post_excerpt_4,
  t0.post_name AS post_name_5,
  t0.post_parent AS post_parent_6,
  t0.guide AS guide_7,
  t0.menu_ordre AS menu_ordre_8,
  t0.post_status AS post_status_9,
  t0.comment_status AS comment_status_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.post_content_2 AS post_content_2_13,
  t0.post_order_content AS post_order_content_14,
  t0.post_parent_migration AS post_parent_migration_15,
  t0.post_id__migration AS post_id__migration_16,
  t0.page_template AS page_template_17,
  t0.post_content_3 AS post_content_3_18,
  t0.post_content_4 AS post_content_4_19,
  t0.post_content_5 AS post_content_5_20,
  t0.post_order_content_preinsertion AS post_order_content_preinsertion_21,
  t0.is_draft AS is_draft_22,
  t0.page_menu AS page_menu_23,
  t0.sommaire AS sommaire_24,
  t0.is_index AS is_index_25,
  t0.is_follow AS is_follow_26,
  t0.post_meta_json AS post_meta_json_27,
  t0.post_meta_json_dev AS post_meta_json_dev_28,
  t0.modele_static AS modele_static_29,
  t0.id_feature_image_id AS id_feature_image_id_30,
  t0.post_type_id AS post_type_id_31,
  t0.page_template_id AS page_template_id_32,
  t0.creator_id AS creator_id_33,
  t0.author_id AS author_id_34
FROM
  post t0
WHERE
  t0.post_name = ?
  AND t0.post_status = ?
  AND t0.post_parent = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.post_title AS post_title_2, t0.post_content AS post_content_3, t0.post_excerpt AS post_excerpt_4, t0.post_name AS post_name_5, t0.post_parent AS post_parent_6, t0.guide AS guide_7, t0.menu_ordre AS menu_ordre_8, t0.post_status AS post_status_9, t0.comment_status AS comment_status_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.post_content_2 AS post_content_2_13, t0.post_order_content AS post_order_content_14, t0.post_parent_migration AS post_parent_migration_15, t0.post_id__migration AS post_id__migration_16, t0.page_template AS page_template_17, t0.post_content_3 AS post_content_3_18, t0.post_content_4 AS post_content_4_19, t0.post_content_5 AS post_content_5_20, t0.post_order_content_preinsertion AS post_order_content_preinsertion_21, t0.is_draft AS is_draft_22, t0.page_menu AS page_menu_23, t0.sommaire AS sommaire_24, t0.is_index AS is_index_25, t0.is_follow AS is_follow_26, t0.post_meta_json AS post_meta_json_27, t0.post_meta_json_dev AS post_meta_json_dev_28, t0.modele_static AS modele_static_29, t0.id_feature_image_id AS id_feature_image_id_30, t0.post_type_id AS post_type_id_31, t0.page_template_id AS page_template_id_32, t0.creator_id AS creator_id_33, t0.author_id AS author_id_34 FROM post t0 WHERE t0.post_name = 'bretagne' AND t0.post_status = 'Publié' AND t0.post_parent = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.post_title AS post_title_2,
  t0.post_content AS post_content_3,
  t0.post_excerpt AS post_excerpt_4,
  t0.post_name AS post_name_5,
  t0.post_parent AS post_parent_6,
  t0.guide AS guide_7,
  t0.menu_ordre AS menu_ordre_8,
  t0.post_status AS post_status_9,
  t0.comment_status AS comment_status_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.post_content_2 AS post_content_2_13,
  t0.post_order_content AS post_order_content_14,
  t0.post_parent_migration AS post_parent_migration_15,
  t0.post_id__migration AS post_id__migration_16,
  t0.page_template AS page_template_17,
  t0.post_content_3 AS post_content_3_18,
  t0.post_content_4 AS post_content_4_19,
  t0.post_content_5 AS post_content_5_20,
  t0.post_order_content_preinsertion AS post_order_content_preinsertion_21,
  t0.is_draft AS is_draft_22,
  t0.page_menu AS page_menu_23,
  t0.sommaire AS sommaire_24,
  t0.is_index AS is_index_25,
  t0.is_follow AS is_follow_26,
  t0.post_meta_json AS post_meta_json_27,
  t0.post_meta_json_dev AS post_meta_json_dev_28,
  t0.modele_static AS modele_static_29,
  t0.id_feature_image_id AS id_feature_image_id_30,
  t0.post_type_id AS post_type_id_31,
  t0.page_template_id AS page_template_id_32,
  t0.creator_id AS creator_id_33,
  t0.author_id AS author_id_34
FROM
  post t0
WHERE
  t0.id IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.post_title AS post_title_2, t0.post_content AS post_content_3, t0.post_excerpt AS post_excerpt_4, t0.post_name AS post_name_5, t0.post_parent AS post_parent_6, t0.guide AS guide_7, t0.menu_ordre AS menu_ordre_8, t0.post_status AS post_status_9, t0.comment_status AS comment_status_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.post_content_2 AS post_content_2_13, t0.post_order_content AS post_order_content_14, t0.post_parent_migration AS post_parent_migration_15, t0.post_id__migration AS post_id__migration_16, t0.page_template AS page_template_17, t0.post_content_3 AS post_content_3_18, t0.post_content_4 AS post_content_4_19, t0.post_content_5 AS post_content_5_20, t0.post_order_content_preinsertion AS post_order_content_preinsertion_21, t0.is_draft AS is_draft_22, t0.page_menu AS page_menu_23, t0.sommaire AS sommaire_24, t0.is_index AS is_index_25, t0.is_follow AS is_follow_26, t0.post_meta_json AS post_meta_json_27, t0.post_meta_json_dev AS post_meta_json_dev_28, t0.modele_static AS modele_static_29, t0.id_feature_image_id AS id_feature_image_id_30, t0.post_type_id AS post_type_id_31, t0.page_template_id AS page_template_id_32, t0.creator_id AS creator_id_33, t0.author_id AS author_id_34 FROM post t0 WHERE t0.id IN (7926, 7908, 7898, 7899, 7900);

SELECT
  t0.id AS id_1,
  t0.name_modele AS name_modele_2,
  t0.content_modele AS content_modele_3,
  t0.shortcode_modele AS shortcode_modele_4,
  t0.path_modele AS path_modele_5,
  t0.variable_modele AS variable_modele_6,
  t0.status_modele AS status_modele_7,
  t0.date_add AS date_add_8,
  t0.date_upd AS date_upd_9,
  t0.fields AS fields_10,
  t0.class_sortable AS class_sortable_11,
  t0.is_new AS is_new_12,
  t0.content_system AS content_system_13,
  t0.image_preview_id AS image_preview_id_14
FROM
  modeles_post t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_modele AS name_modele_2, t0.content_modele AS content_modele_3, t0.shortcode_modele AS shortcode_modele_4, t0.path_modele AS path_modele_5, t0.variable_modele AS variable_modele_6, t0.status_modele AS status_modele_7, t0.date_add AS date_add_8, t0.date_upd AS date_upd_9, t0.fields AS fields_10, t0.class_sortable AS class_sortable_11, t0.is_new AS is_new_12, t0.content_system AS content_system_13, t0.image_preview_id AS image_preview_id_14 FROM modeles_post t0 WHERE t0.id = 10;

SELECT
  p0_.id AS id_0,
  p0_.post_title AS post_title_1,
  p0_.post_content AS post_content_2,
  p0_.post_excerpt AS post_excerpt_3,
  p0_.post_name AS post_name_4,
  p0_.post_parent AS post_parent_5,
  p0_.guide AS guide_6,
  p0_.menu_ordre AS menu_ordre_7,
  p0_.post_status AS post_status_8,
  p0_.comment_status AS comment_status_9,
  p0_.date_add AS date_add_10,
  p0_.date_upd AS date_upd_11,
  p0_.post_content_2 AS post_content_2_12,
  p0_.post_order_content AS post_order_content_13,
  p0_.post_parent_migration AS post_parent_migration_14,
  p0_.post_id__migration AS post_id__migration_15,
  p0_.page_template AS page_template_16,
  p0_.post_content_3 AS post_content_3_17,
  p0_.post_content_4 AS post_content_4_18,
  p0_.post_content_5 AS post_content_5_19,
  p0_.post_order_content_preinsertion AS post_order_content_preinsertion_20,
  p0_.is_draft AS is_draft_21,
  p0_.page_menu AS page_menu_22,
  p0_.sommaire AS sommaire_23,
  p0_.is_index AS is_index_24,
  p0_.is_follow AS is_follow_25,
  p0_.post_meta_json AS post_meta_json_26,
  p0_.post_meta_json_dev AS post_meta_json_dev_27,
  p0_.modele_static AS modele_static_28,
  p0_.id_feature_image_id AS id_feature_image_id_29,
  p0_.post_type_id AS post_type_id_30,
  p0_.page_template_id AS page_template_id_31,
  p0_.creator_id AS creator_id_32,
  p0_.author_id AS author_id_33
FROM
  post p0_
  INNER JOIN post_type p1_ ON p0_.post_type_id = p1_.id
WHERE
  p1_.slug_post_type = ?
  AND p0_.post_status = ?
  AND p0_.post_parent = ?
ORDER BY
  p0_.date_add DESC

SELECT p0_.id AS id_0, p0_.post_title AS post_title_1, p0_.post_content AS post_content_2, p0_.post_excerpt AS post_excerpt_3, p0_.post_name AS post_name_4, p0_.post_parent AS post_parent_5, p0_.guide AS guide_6, p0_.menu_ordre AS menu_ordre_7, p0_.post_status AS post_status_8, p0_.comment_status AS comment_status_9, p0_.date_add AS date_add_10, p0_.date_upd AS date_upd_11, p0_.post_content_2 AS post_content_2_12, p0_.post_order_content AS post_order_content_13, p0_.post_parent_migration AS post_parent_migration_14, p0_.post_id__migration AS post_id__migration_15, p0_.page_template AS page_template_16, p0_.post_content_3 AS post_content_3_17, p0_.post_content_4 AS post_content_4_18, p0_.post_content_5 AS post_content_5_19, p0_.post_order_content_preinsertion AS post_order_content_preinsertion_20, p0_.is_draft AS is_draft_21, p0_.page_menu AS page_menu_22, p0_.sommaire AS sommaire_23, p0_.is_index AS is_index_24, p0_.is_follow AS is_follow_25, p0_.post_meta_json AS post_meta_json_26, p0_.post_meta_json_dev AS post_meta_json_dev_27, p0_.modele_static AS modele_static_28, p0_.id_feature_image_id AS id_feature_image_id_29, p0_.post_type_id AS post_type_id_30, p0_.page_template_id AS page_template_id_31, p0_.creator_id AS creator_id_32, p0_.author_id AS author_id_33 FROM post p0_ INNER JOIN post_type p1_ ON p0_.post_type_id = p1_.id WHERE p1_.slug_post_type = 'page' AND p0_.post_status = 'Publié' AND p0_.post_parent = 12129 ORDER BY p0_.date_add DESC;

SELECT
  t0.id AS id_1,
  t0.key_emplacement AS key_emplacement_2,
  t0.status AS status_3,
  t0.date_add AS date_add_4,
  t0.date_upd AS date_upd_5,
  t0.menu_id AS menu_id_6,
  t0.user_id AS user_id_7
FROM
  emplacement t0
WHERE
  t0.key_emplacement IN (?)

SELECT t0.id AS id_1, t0.key_emplacement AS key_emplacement_2, t0.status AS status_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.menu_id AS menu_id_6, t0.user_id AS user_id_7 FROM emplacement t0 WHERE t0.key_emplacement IN ('primary');

SELECT
  r0_.id AS id_0,
  r0_.old_root AS old_root_1,
  r0_.new_root AS new_root_2,
  r0_.id_migration AS id_migration_3,
  r0_.status AS status_4
FROM
  redirection r0_
WHERE
  r0_.old_root = ?
LIMIT
  1

SELECT r0_.id AS id_0, r0_.old_root AS old_root_1, r0_.new_root AS new_root_2, r0_.id_migration AS id_migration_3, r0_.status AS status_4 FROM redirection r0_ WHERE r0_.old_root = '/bretagne/cotes-d-armor/saint-brieuc-2/' LIMIT 1;

SELECT
  p.id
FROM
  post p
  JOIN post_type pt ON pt.id = p.post_type_id
  AND pt.slug_post_type = 'services'
  JOIN post_meta k ON k.id_post_id = p.id
  AND k.meta_key = :key
  AND k.meta_value = :value
  JOIN post_meta a ON a.id_post_id = p.id
  AND a.meta_key = 'adresse'
  AND TRIM(a.meta_value) <> ''
  JOIN post_meta t ON t.id_post_id = p.id
  AND t.meta_key = 'telephone'
  AND TRIM(t.meta_value) <> ''
  LEFT JOIN post_meta r ON r.id_post_id = p.id
  AND r.meta_key = 'rmp_avg_rating'
WHERE
  p.post_status = 'Publié'
ORDER BY
  CAST(
    COALESCE(r.meta_value, 0) AS DECIMAL(4, 2)
  ) DESC,
  p.id ASC
LIMIT
  :lim

SELECT p.id
            FROM post p
            JOIN post_type pt ON pt.id = p.post_type_id AND pt.slug_post_type = 'services'
            JOIN post_meta k ON k.id_post_id = p.id AND k.meta_key = 'code_ville' AND k.meta_value = '22250'
            JOIN post_meta a ON a.id_post_id = p.id AND a.meta_key = 'adresse' AND TRIM(a.meta_value) <> ''
            JOIN post_meta t ON t.id_post_id = p.id AND t.meta_key = 'telephone' AND TRIM(t.meta_value) <> ''
            LEFT JOIN post_meta r ON r.id_post_id = p.id AND r.meta_key = 'rmp_avg_rating'
            WHERE p.post_status = 'Publié'
         ORDER BY CAST(COALESCE(r.meta_value, 0) AS DECIMAL(4,2)) DESC, p.id ASC LIMIT 5;

SELECT
  c0_.id AS id_0,
  c0_.config_name AS config_name_1,
  c0_.config_value AS config_value_2
FROM
  configuration c0_
WHERE
  c0_.config_name = ?

SELECT c0_.id AS id_0, c0_.config_name AS config_name_1, c0_.config_value AS config_value_2 FROM configuration c0_ WHERE c0_.config_name = 'langue_du_site';

SELECT
  t0.id AS id_1,
  t0.name_post_type AS name_post_type_2,
  t0.slug_post_type AS slug_post_type_3,
  t0.type_post_type AS type_post_type_4,
  t0.statut_menu_side_bar AS statut_menu_side_bar_5,
  t0.order_post_type AS order_post_type_6,
  t0.is_draft AS is_draft_7,
  t0.display_in_sitemap AS display_in_sitemap_8,
  t0.path_parent_sitemap AS path_parent_sitemap_9,
  t0.meta_title_seo_sitmap AS meta_title_seo_sitmap_10,
  t0.meta_description_seo_sitemap AS meta_description_seo_sitemap_11,
  t0.has_list AS has_list_12,
  t0.slug_in_url AS slug_in_url_13,
  t0.icone_dasbord AS icone_dasbord_14,
  t0.display_in_sidebar AS display_in_sidebar_15
FROM
  post_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_post_type AS name_post_type_2, t0.slug_post_type AS slug_post_type_3, t0.type_post_type AS type_post_type_4, t0.statut_menu_side_bar AS statut_menu_side_bar_5, t0.order_post_type AS order_post_type_6, t0.is_draft AS is_draft_7, t0.display_in_sitemap AS display_in_sitemap_8, t0.path_parent_sitemap AS path_parent_sitemap_9, t0.meta_title_seo_sitmap AS meta_title_seo_sitmap_10, t0.meta_description_seo_sitemap AS meta_description_seo_sitemap_11, t0.has_list AS has_list_12, t0.slug_in_url AS slug_in_url_13, t0.icone_dasbord AS icone_dasbord_14, t0.display_in_sidebar AS display_in_sidebar_15 FROM post_type t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.date AS date_4,
  t0.status AS status_5
FROM
  template_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.date AS date_4, t0.status AS status_5 FROM template_page t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.post_title AS post_title_2,
  t0.post_content AS post_content_3,
  t0.post_excerpt AS post_excerpt_4,
  t0.post_name AS post_name_5,
  t0.post_parent AS post_parent_6,
  t0.guide AS guide_7,
  t0.menu_ordre AS menu_ordre_8,
  t0.post_status AS post_status_9,
  t0.comment_status AS comment_status_10,
  t0.date_add AS date_add_11,
  t0.date_upd AS date_upd_12,
  t0.post_content_2 AS post_content_2_13,
  t0.post_order_content AS post_order_content_14,
  t0.post_parent_migration AS post_parent_migration_15,
  t0.post_id__migration AS post_id__migration_16,
  t0.page_template AS page_template_17,
  t0.post_content_3 AS post_content_3_18,
  t0.post_content_4 AS post_content_4_19,
  t0.post_content_5 AS post_content_5_20,
  t0.post_order_content_preinsertion AS post_order_content_preinsertion_21,
  t0.is_draft AS is_draft_22,
  t0.page_menu AS page_menu_23,
  t0.sommaire AS sommaire_24,
  t0.is_index AS is_index_25,
  t0.is_follow AS is_follow_26,
  t0.post_meta_json AS post_meta_json_27,
  t0.post_meta_json_dev AS post_meta_json_dev_28,
  t0.modele_static AS modele_static_29,
  t0.id_feature_image_id AS id_feature_image_id_30,
  t0.post_type_id AS post_type_id_31,
  t0.page_template_id AS page_template_id_32,
  t0.creator_id AS creator_id_33,
  t0.author_id AS author_id_34
FROM
  post t0
WHERE
  t0.id IN (?, ?, ?)

SELECT t0.id AS id_1, t0.post_title AS post_title_2, t0.post_content AS post_content_3, t0.post_excerpt AS post_excerpt_4, t0.post_name AS post_name_5, t0.post_parent AS post_parent_6, t0.guide AS guide_7, t0.menu_ordre AS menu_ordre_8, t0.post_status AS post_status_9, t0.comment_status AS comment_status_10, t0.date_add AS date_add_11, t0.date_upd AS date_upd_12, t0.post_content_2 AS post_content_2_13, t0.post_order_content AS post_order_content_14, t0.post_parent_migration AS post_parent_migration_15, t0.post_id__migration AS post_id__migration_16, t0.page_template AS page_template_17, t0.post_content_3 AS post_content_3_18, t0.post_content_4 AS post_content_4_19, t0.post_content_5 AS post_content_5_20, t0.post_order_content_preinsertion AS post_order_content_preinsertion_21, t0.is_draft AS is_draft_22, t0.page_menu AS page_menu_23, t0.sommaire AS sommaire_24, t0.is_index AS is_index_25, t0.is_follow AS is_follow_26, t0.post_meta_json AS post_meta_json_27, t0.post_meta_json_dev AS post_meta_json_dev_28, t0.modele_static AS modele_static_29, t0.id_feature_image_id AS id_feature_image_id_30, t0.post_type_id AS post_type_id_31, t0.page_template_id AS page_template_id_32, t0.creator_id AS creator_id_33, t0.author_id AS author_id_34 FROM post t0 WHERE t0.id IN (7002, 7003, 7004);

SELECT
  t0.id AS id_1,
  t0.key_emplacement AS key_emplacement_2,
  t0.status AS status_3,
  t0.date_add AS date_add_4,
  t0.date_upd AS date_upd_5,
  t0.menu_id AS menu_id_6,
  t0.user_id AS user_id_7
FROM
  emplacement t0
WHERE
  t0.key_emplacement IN (?, ?)

SELECT t0.id AS id_1, t0.key_emplacement AS key_emplacement_2, t0.status AS status_3, t0.date_add AS date_add_4, t0.date_upd AS date_upd_5, t0.menu_id AS menu_id_6, t0.user_id AS user_id_7 FROM emplacement t0 WHERE t0.key_emplacement IN ('footer-liens-utiles', 'footer-guide');

SELECT
  t0.id AS id_1,
  t0.option_name AS option_name_2,
  t0.option_value AS option_value_3,
  t0.option_label AS option_label_4,
  t0.option_type AS option_type_5
FROM
  options t0

SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_value AS option_value_3, t0.option_label AS option_label_4, t0.option_type AS option_type_5 FROM options t0;