Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.location AS location_1,
  m0_.path AS path_2,
  m0_.fileName AS fileName_3,
  m0_.image_cropped AS image_cropped_4,
  m0_.type AS type_5,
  m0_.type_media_post AS type_media_post_6,
  m0_.position AS position_7,
  m0_.module AS module_8,
  m0_.module_id AS module_id_9,
  m0_.lien_externe AS lien_externe_10,
  m0_.width AS width_11,
  m0_.height AS height_12,
  m0_.filesize AS filesize_13,
  m0_.crop_width AS crop_width_14,
  m0_.crop_height AS crop_height_15,
  m0_.crop_x AS crop_x_16,
  m0_.crop_y AS crop_y_17,
  m0_.DateCreation AS DateCreation_18,
  m0_.DateModification AS DateModification_19
FROM
  media_cms m0_
WHERE
  m0_.module = ?
  AND m0_.module_id = ?
  AND m0_.type_media_post = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.location AS location_1, m0_.path AS path_2, m0_.fileName AS fileName_3, m0_.image_cropped AS image_cropped_4, m0_.type AS type_5, m0_.type_media_post AS type_media_post_6, m0_.position AS position_7, m0_.module AS module_8, m0_.module_id AS module_id_9, m0_.lien_externe AS lien_externe_10, m0_.width AS width_11, m0_.height AS height_12, m0_.filesize AS filesize_13, m0_.crop_width AS crop_width_14, m0_.crop_height AS crop_height_15, m0_.crop_x AS crop_x_16, m0_.crop_y AS crop_y_17, m0_.DateCreation AS DateCreation_18, m0_.DateModification AS DateModification_19 FROM media_cms m0_ WHERE m0_.module = 'category' AND m0_.module_id = 4 AND m0_.type_media_post = 'media' ORDER BY m0_.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.position AS position_1,
  p0_.authorization_api AS authorization_api_2,
  p0_.actif_home AS actif_home_3,
  p0_.post_archive AS post_archive_4,
  p0_.date_archive AS date_archive_5,
  p0_.image AS image_6,
  p0_.url_video AS url_video_7,
  p0_.image_bandeau AS image_bandeau_8,
  p0_.image_bandeau_height AS image_bandeau_height_9,
  p0_.image_couverture AS image_couverture_10,
  p0_.tag_managerhead AS tag_managerhead_11,
  p0_.tag_managerbody AS tag_managerbody_12,
  p0_.date_publication AS date_publication_13,
  p0_.created_at AS created_at_14,
  p0_.updated_at AS updated_at_15,
  p0_.author_id AS author_id_16,
  p0_.type_post AS type_post_17,
  p0_.template_cms_id AS template_cms_id_18,
  p0_.modele_gallerie_id AS modele_gallerie_id_19
FROM
  post p0_
  INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id
  INNER JOIN post_category p2_ ON p0_.id = p2_.post_id
WHERE
  p1_.actif = 1
  AND p2_.category_id = ?
  AND p1_.locale = ?
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.position AS position_1, p0_.authorization_api AS authorization_api_2, p0_.actif_home AS actif_home_3, p0_.post_archive AS post_archive_4, p0_.date_archive AS date_archive_5, p0_.image AS image_6, p0_.url_video AS url_video_7, p0_.image_bandeau AS image_bandeau_8, p0_.image_bandeau_height AS image_bandeau_height_9, p0_.image_couverture AS image_couverture_10, p0_.tag_managerhead AS tag_managerhead_11, p0_.tag_managerbody AS tag_managerbody_12, p0_.date_publication AS date_publication_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.author_id AS author_id_16, p0_.type_post AS type_post_17, p0_.template_cms_id AS template_cms_id_18, p0_.modele_gallerie_id AS modele_gallerie_id_19 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN post_category p2_ ON p0_.id = p2_.post_id WHERE p1_.actif = 1 AND p2_.category_id = 4 AND p1_.locale = 'fr' ORDER BY p0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.id_module AS id_module_2,
  t0.type_module AS type_module_3,
  t0.old AS old_4,
  t0.new AS new_5,
  t0.active AS active_6,
  t0.lien_externe AS lien_externe_7,
  t0.DateCreation AS DateCreation_8,
  t0.DateModification AS DateModification_9,
  t0.locale AS locale_10,
  t0.IdSite AS IdSite_11
FROM
  redirection t0
WHERE
  t0.old = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = '/reseau-borne-electrique' AND t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email_site AS email_site_2,
  t0.image AS image_3,
  t0.lien_carte AS lien_carte_4,
  t0.apercu_image_lien AS apercu_image_lien_5,
  t0.image_footer AS image_footer_6,
  t0.image_bandeau AS image_bandeau_7,
  t0.tel AS tel_8,
  t0.image_vide AS image_vide_9,
  t0.maintenance AS maintenance_10,
  t0.htaccess_val AS htaccess_val_11,
  t0.meta_index AS meta_index_12,
  t0.meta_follow AS meta_follow_13,
  t0.robots AS robots_14,
  t0.analytics AS analytics_15,
  t0.cle_key AS cle_key_16,
  t0.cle_secret AS cle_secret_17,
  t0.tag_managerhead AS tag_managerhead_18,
  t0.meta_keywords AS meta_keywords_19,
  t0.cle_map AS cle_map_20,
  t0.active_smtp AS active_smtp_21,
  t0.email_from AS email_from_22,
  t0.email_sender AS email_sender_23,
  t0.host_smtp AS host_smtp_24,
  t0.type_cryptage AS type_cryptage_25,
  t0.port_tls AS port_tls_26,
  t0.port_ssl AS port_ssl_27,
  t0.smtp_user AS smtp_user_28,
  t0.smtp_pass AS smtp_pass_29,
  t0.typeLienErrorPage AS typeLienErrorPage_30,
  t0.lienExterneErrorPage AS lienExterneErrorPage_31,
  t0.telephoneErrorPage AS telephoneErrorPage_32,
  t0.domain_api_hrz AS domain_api_hrz_33,
  t0.token_api_hrz AS token_api_hrz_34,
  t0.actif_auth_gmail AS actif_auth_gmail_35,
  t0.id_client_auth AS id_client_auth_36,
  t0.secret_client_auth AS secret_client_auth_37,
  t0.IdSite AS IdSite_38
FROM
  parametre_site t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.email_site AS email_site_2, t0.image AS image_3, t0.lien_carte AS lien_carte_4, t0.apercu_image_lien AS apercu_image_lien_5, t0.image_footer AS image_footer_6, t0.image_bandeau AS image_bandeau_7, t0.tel AS tel_8, t0.image_vide AS image_vide_9, t0.maintenance AS maintenance_10, t0.htaccess_val AS htaccess_val_11, t0.meta_index AS meta_index_12, t0.meta_follow AS meta_follow_13, t0.robots AS robots_14, t0.analytics AS analytics_15, t0.cle_key AS cle_key_16, t0.cle_secret AS cle_secret_17, t0.tag_managerhead AS tag_managerhead_18, t0.meta_keywords AS meta_keywords_19, t0.cle_map AS cle_map_20, t0.active_smtp AS active_smtp_21, t0.email_from AS email_from_22, t0.email_sender AS email_sender_23, t0.host_smtp AS host_smtp_24, t0.type_cryptage AS type_cryptage_25, t0.port_tls AS port_tls_26, t0.port_ssl AS port_ssl_27, t0.smtp_user AS smtp_user_28, t0.smtp_pass AS smtp_pass_29, t0.typeLienErrorPage AS typeLienErrorPage_30, t0.lienExterneErrorPage AS lienExterneErrorPage_31, t0.telephoneErrorPage AS telephoneErrorPage_32, t0.domain_api_hrz AS domain_api_hrz_33, t0.token_api_hrz AS token_api_hrz_34, t0.actif_auth_gmail AS actif_auth_gmail_35, t0.id_client_auth AS id_client_auth_36, t0.secret_client_auth AS secret_client_auth_37, t0.IdSite AS IdSite_38 FROM parametre_site t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.actif AS actif_1,
  c0_.actif_haut AS actif_haut_2,
  c0_.position_text AS position_text_3,
  c0_.nombre_article AS nombre_article_4,
  c0_.actif_slider AS actif_slider_5,
  c0_.pagination AS pagination_6,
  c0_.page_size AS page_size_7,
  c0_.order_by AS order_by_8,
  c0_.fixe_texte AS fixe_texte_9,
  c0_.image AS image_10,
  c0_.image_bandeau AS image_bandeau_11,
  c0_.url_video AS url_video_12,
  c0_.DateCreation AS DateCreation_13,
  c0_.DateModification AS DateModification_14,
  c0_.IdParent AS IdParent_15,
  c0_.IdSousParent AS IdSousParent_16,
  c0_.tag_managerhead AS tag_managerhead_17,
  c0_.meta_keywords AS meta_keywords_18,
  c0_.meta_robots AS meta_robots_19,
  c0_.multi_affichage AS multi_affichage_20,
  c0_.IdSite AS IdSite_21,
  c0_.id_type_post AS id_type_post_22,
  c0_.IdPostAffichage AS IdPostAffichage_23,
  c0_.modele_gallerie_id AS modele_gallerie_id_24
FROM
  category c0_
  INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id
WHERE
  c1_.slug_url = ?
  AND c1_.locale = ?

SELECT c0_.id AS id_0, c0_.actif AS actif_1, c0_.actif_haut AS actif_haut_2, c0_.position_text AS position_text_3, c0_.nombre_article AS nombre_article_4, c0_.actif_slider AS actif_slider_5, c0_.pagination AS pagination_6, c0_.page_size AS page_size_7, c0_.order_by AS order_by_8, c0_.fixe_texte AS fixe_texte_9, c0_.image AS image_10, c0_.image_bandeau AS image_bandeau_11, c0_.url_video AS url_video_12, c0_.DateCreation AS DateCreation_13, c0_.DateModification AS DateModification_14, c0_.IdParent AS IdParent_15, c0_.IdSousParent AS IdSousParent_16, c0_.tag_managerhead AS tag_managerhead_17, c0_.meta_keywords AS meta_keywords_18, c0_.meta_robots AS meta_robots_19, c0_.multi_affichage AS multi_affichage_20, c0_.IdSite AS IdSite_21, c0_.id_type_post AS id_type_post_22, c0_.IdPostAffichage AS IdPostAffichage_23, c0_.modele_gallerie_id AS modele_gallerie_id_24 FROM category c0_ INNER JOIN category_translation c1_ ON c0_.id = c1_.translatable_id WHERE c1_.slug_url = 'reseau-borne-electrique' AND c1_.locale = 'fr';

SELECT
  t0.id AS id_1,
  t0.titre_categorie AS titre_categorie_2,
  t0.slug_url AS slug_url_3,
  t0.chapeau_categorie AS chapeau_categorie_4,
  t0.texte_categorie AS texte_categorie_5,
  t0.texte_categorie2 AS texte_categorie2_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.meta_keywords AS meta_keywords_9,
  t0.canonical AS canonical_10,
  t0.settig_metaTitle AS settig_metaTitle_11,
  t0.settig_metaTitle1 AS settig_metaTitle1_12,
  t0.settig_metaTitle2 AS settig_metaTitle2_13,
  t0.settig_metaTitle3 AS settig_metaTitle3_14,
  t0.settig_metaTitle_post AS settig_metaTitle_post_15,
  t0.settig_metaDesc AS settig_metaDesc_16,
  t0.settig_metaDesc1 AS settig_metaDesc1_17,
  t0.settig_metaDesc2 AS settig_metaDesc2_18,
  t0.settig_metaDesc3 AS settig_metaDesc3_19,
  t0.settig_metaDesc_post AS settig_metaDesc_post_20,
  t0.titre_lien AS titre_lien_21,
  t0.type_lien AS type_lien_22,
  t0.lien_interne AS lien_interne_23,
  t0.lien_externe AS lien_externe_24,
  t0.telephone AS telephone_25,
  t0.locale AS locale_26,
  t0.translatable_id AS translatable_id_27
FROM
  category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.titre_categorie AS titre_categorie_2, t0.slug_url AS slug_url_3, t0.chapeau_categorie AS chapeau_categorie_4, t0.texte_categorie AS texte_categorie_5, t0.texte_categorie2 AS texte_categorie2_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.canonical AS canonical_10, t0.settig_metaTitle AS settig_metaTitle_11, t0.settig_metaTitle1 AS settig_metaTitle1_12, t0.settig_metaTitle2 AS settig_metaTitle2_13, t0.settig_metaTitle3 AS settig_metaTitle3_14, t0.settig_metaTitle_post AS settig_metaTitle_post_15, t0.settig_metaDesc AS settig_metaDesc_16, t0.settig_metaDesc1 AS settig_metaDesc1_17, t0.settig_metaDesc2 AS settig_metaDesc2_18, t0.settig_metaDesc3 AS settig_metaDesc3_19, t0.settig_metaDesc_post AS settig_metaDesc_post_20, t0.titre_lien AS titre_lien_21, t0.type_lien AS type_lien_22, t0.lien_interne AS lien_interne_23, t0.lien_externe AS lien_externe_24, t0.telephone AS telephone_25, t0.locale AS locale_26, t0.translatable_id AS translatable_id_27 FROM category_translation t0 WHERE t0.translatable_id = 4;

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.Titre AS Titre_3,
  t0.SousTitre AS SousTitre_4,
  t0.Url AS Url_5,
  t0.target AS target_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  menu_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.Titre AS Titre_3, t0.SousTitre AS SousTitre_4, t0.Url AS Url_5, t0.target AS target_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM menu_translation t0 WHERE t0.translatable_id = 1;

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.actif_haut AS actif_haut_3,
  t0.position_text AS position_text_4,
  t0.nombre_article AS nombre_article_5,
  t0.actif_slider AS actif_slider_6,
  t0.pagination AS pagination_7,
  t0.page_size AS page_size_8,
  t0.order_by AS order_by_9,
  t0.fixe_texte AS fixe_texte_10,
  t0.image AS image_11,
  t0.image_bandeau AS image_bandeau_12,
  t0.url_video AS url_video_13,
  t0.DateCreation AS DateCreation_14,
  t0.DateModification AS DateModification_15,
  t0.IdParent AS IdParent_16,
  t0.IdSousParent AS IdSousParent_17,
  t0.tag_managerhead AS tag_managerhead_18,
  t0.meta_keywords AS meta_keywords_19,
  t0.meta_robots AS meta_robots_20,
  t0.multi_affichage AS multi_affichage_21,
  t0.IdSite AS IdSite_22,
  t0.id_type_post AS id_type_post_23,
  t0.IdPostAffichage AS IdPostAffichage_24,
  t0.modele_gallerie_id AS modele_gallerie_id_25
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.actif_haut AS actif_haut_3, t0.position_text AS position_text_4, t0.nombre_article AS nombre_article_5, t0.actif_slider AS actif_slider_6, t0.pagination AS pagination_7, t0.page_size AS page_size_8, t0.order_by AS order_by_9, t0.fixe_texte AS fixe_texte_10, t0.image AS image_11, t0.image_bandeau AS image_bandeau_12, t0.url_video AS url_video_13, t0.DateCreation AS DateCreation_14, t0.DateModification AS DateModification_15, t0.IdParent AS IdParent_16, t0.IdSousParent AS IdSousParent_17, t0.tag_managerhead AS tag_managerhead_18, t0.meta_keywords AS meta_keywords_19, t0.meta_robots AS meta_robots_20, t0.multi_affichage AS multi_affichage_21, t0.IdSite AS IdSite_22, t0.id_type_post AS id_type_post_23, t0.IdPostAffichage AS IdPostAffichage_24, t0.modele_gallerie_id AS modele_gallerie_id_25 FROM category t0 WHERE t0.id = 2;

SELECT
  c0_.id AS id_0,
  c0_.actif AS actif_1,
  c0_.actif_desktop AS actif_desktop_2,
  c0_.actif_mobile AS actif_mobile_3,
  c0_.type_bloc AS type_bloc_4,
  c0_.position AS position_5,
  c0_.image AS image_6,
  c0_.bg_color AS bg_color_7,
  c0_.video_url AS video_url_8,
  c0_.position_text AS position_text_9,
  c0_.grid_carousel AS grid_carousel_10,
  c0_.id_bloc_service AS id_bloc_service_11,
  c0_.DateCreation AS DateCreation_12,
  c0_.DateModification AS DateModification_13,
  c0_.is_deleted AS is_deleted_14,
  c0_.IdForms AS IdForms_15,
  c0_.IdMedia AS IdMedia_16,
  c0_.IdWidget AS IdWidget_17,
  c0_.category_id AS category_id_18
FROM
  category_bloc c0_
  INNER JOIN category c1_ ON c0_.category_id = c1_.id
WHERE
  c1_.id = ?
  AND (
    c0_.is_deleted IS NULL
    OR c0_.is_deleted = ?
  )
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.actif AS actif_1, c0_.actif_desktop AS actif_desktop_2, c0_.actif_mobile AS actif_mobile_3, c0_.type_bloc AS type_bloc_4, c0_.position AS position_5, c0_.image AS image_6, c0_.bg_color AS bg_color_7, c0_.video_url AS video_url_8, c0_.position_text AS position_text_9, c0_.grid_carousel AS grid_carousel_10, c0_.id_bloc_service AS id_bloc_service_11, c0_.DateCreation AS DateCreation_12, c0_.DateModification AS DateModification_13, c0_.is_deleted AS is_deleted_14, c0_.IdForms AS IdForms_15, c0_.IdMedia AS IdMedia_16, c0_.IdWidget AS IdWidget_17, c0_.category_id AS category_id_18 FROM category_bloc c0_ INNER JOIN category c1_ ON c0_.category_id = c1_.id WHERE c1_.id = 4 AND (c0_.is_deleted IS NULL OR c0_.is_deleted = 0) ORDER BY c0_.position ASC;

SELECT
  u0_.id AS id_0,
  u0_.id_module AS id_module_1,
  u0_.type AS type_2,
  u0_.created_at AS created_at_3,
  u0_.updated_at AS updated_at_4
FROM
  url_post u0_
  INNER JOIN url_post_translation u1_ ON u0_.id = u1_.translatable_id
WHERE
  u1_.slug = ?
  AND u1_.locale = ?
LIMIT
  1

SELECT u0_.id AS id_0, u0_.id_module AS id_module_1, u0_.type AS type_2, u0_.created_at AS created_at_3, u0_.updated_at AS updated_at_4 FROM url_post u0_ INNER JOIN url_post_translation u1_ ON u0_.id = u1_.translatable_id WHERE u1_.slug = 'reseau-borne-electrique' AND u1_.locale = 'fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.actif_haut AS actif_haut_3,
  t0.position_text AS position_text_4,
  t0.nombre_article AS nombre_article_5,
  t0.actif_slider AS actif_slider_6,
  t0.pagination AS pagination_7,
  t0.page_size AS page_size_8,
  t0.order_by AS order_by_9,
  t0.fixe_texte AS fixe_texte_10,
  t0.image AS image_11,
  t0.image_bandeau AS image_bandeau_12,
  t0.url_video AS url_video_13,
  t0.DateCreation AS DateCreation_14,
  t0.DateModification AS DateModification_15,
  t0.IdParent AS IdParent_16,
  t0.IdSousParent AS IdSousParent_17,
  t0.tag_managerhead AS tag_managerhead_18,
  t0.meta_keywords AS meta_keywords_19,
  t0.meta_robots AS meta_robots_20,
  t0.multi_affichage AS multi_affichage_21,
  t0.IdSite AS IdSite_22,
  t0.id_type_post AS id_type_post_23,
  t0.IdPostAffichage AS IdPostAffichage_24,
  t0.modele_gallerie_id AS modele_gallerie_id_25
FROM
  category t0
WHERE
  t0.IdParent = ?
ORDER BY
  t0.order_by ASC

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.actif_haut AS actif_haut_3, t0.position_text AS position_text_4, t0.nombre_article AS nombre_article_5, t0.actif_slider AS actif_slider_6, t0.pagination AS pagination_7, t0.page_size AS page_size_8, t0.order_by AS order_by_9, t0.fixe_texte AS fixe_texte_10, t0.image AS image_11, t0.image_bandeau AS image_bandeau_12, t0.url_video AS url_video_13, t0.DateCreation AS DateCreation_14, t0.DateModification AS DateModification_15, t0.IdParent AS IdParent_16, t0.IdSousParent AS IdSousParent_17, t0.tag_managerhead AS tag_managerhead_18, t0.meta_keywords AS meta_keywords_19, t0.meta_robots AS meta_robots_20, t0.multi_affichage AS multi_affichage_21, t0.IdSite AS IdSite_22, t0.id_type_post AS id_type_post_23, t0.IdPostAffichage AS IdPostAffichage_24, t0.modele_gallerie_id AS modele_gallerie_id_25 FROM category t0 WHERE t0.IdParent = 4 ORDER BY t0.order_by ASC;

SELECT
  t0.id AS id_1,
  t0.actif_content AS actif_content_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.content2 AS content2_5,
  t0.template AS template_6,
  t0.link AS link_7,
  t0.titre_lien AS titre_lien_8,
  t0.type_lien AS type_lien_9,
  t0.lien_interne AS lien_interne_10,
  t0.lien_externe AS lien_externe_11,
  t0.telephone AS telephone_12,
  t0.locale AS locale_13,
  t0.translatable_id AS translatable_id_14
FROM
  category_bloc_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.actif_content AS actif_content_2, t0.title AS title_3, t0.content AS content_4, t0.content2 AS content2_5, t0.template AS template_6, t0.link AS link_7, t0.titre_lien AS titre_lien_8, t0.type_lien AS type_lien_9, t0.lien_interne AS lien_interne_10, t0.lien_externe AS lien_externe_11, t0.telephone AS telephone_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM category_bloc_translation t0 WHERE t0.translatable_id = 6;

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.actif_slider AS actif_slider_3,
  t0.position_text AS position_text_4,
  t0.alias AS alias_5,
  t0.nombre_article AS nombre_article_6,
  t0.bg_image AS bg_image_7,
  t0.color AS color_8,
  t0.DateCreation AS DateCreation_9,
  t0.DateModification AS DateModification_10
FROM
  bloc_service t0
WHERE
  t0.actif = ?
  AND t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.actif_slider AS actif_slider_3, t0.position_text AS position_text_4, t0.alias AS alias_5, t0.nombre_article AS nombre_article_6, t0.bg_image AS bg_image_7, t0.color AS color_8, t0.DateCreation AS DateCreation_9, t0.DateModification AS DateModification_10 FROM bloc_service t0 WHERE t0.actif = 1 AND t0.alias = 'btn_header' LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.active AS active_1,
  l0_.name AS name_2,
  l0_.language_code AS language_code_3,
  l0_.flag AS flag_4,
  l0_.created_at AS created_at_5,
  l0_.updated_at AS updated_at_6
FROM
  language l0_
WHERE
  l0_.active = 1

SELECT l0_.id AS id_0, l0_.active AS active_1, l0_.name AS name_2, l0_.language_code AS language_code_3, l0_.flag AS flag_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6 FROM language l0_ WHERE l0_.active = 1;

SELECT
  t0.id AS id_1,
  t0.couleur_text_btn AS couleur_text_btn_2,
  t0.couleur_text_btn_hover AS couleur_text_btn_hover_3,
  t0.couleur_btn AS couleur_btn_4,
  t0.couleur_btn_hover AS couleur_btn_hover_5,
  t0.bg_body AS bg_body_6,
  t0.couleur_body AS couleur_body_7,
  t0.couleur_generale AS couleur_generale_8,
  t0.couleur_secondaire AS couleur_secondaire_9,
  t0.couleur_troisieme AS couleur_troisieme_10,
  t0.typo_body AS typo_body_11,
  t0.style_typo_body AS style_typo_body_12,
  t0.font_size_typo_body AS font_size_typo_body_13,
  t0.typo_body_secondaire AS typo_body_secondaire_14,
  t0.style_typo_body_secondaire AS style_typo_body_secondaire_15,
  t0.font_size_typo_body_secondaire AS font_size_typo_body_secondaire_16,
  t0.typo_menu AS typo_menu_17,
  t0.style_typo_menu AS style_typo_menu_18,
  t0.font_size_menu AS font_size_menu_19,
  t0.typo_titre AS typo_titre_20,
  t0.style_typo_titre AS style_typo_titre_21,
  t0.font_size_titre AS font_size_titre_22,
  t0.typo_sous_titre AS typo_sous_titre_23,
  t0.style_typo_sous_titre AS style_typo_sous_titre_24,
  t0.font_size_sous_titre AS font_size_sous_titre_25,
  t0.typo_h1 AS typo_h1_26,
  t0.style_typo_h1 AS style_typo_h1_27,
  t0.font_size_h1 AS font_size_h1_28,
  t0.typo_h2 AS typo_h2_29,
  t0.style_typo_h2 AS style_typo_h2_30,
  t0.font_size_h2 AS font_size_h2_31,
  t0.typo_h3 AS typo_h3_32,
  t0.style_typo_h3 AS style_typo_h3_33,
  t0.font_size_h3 AS font_size_h3_34,
  t0.typo_h4 AS typo_h4_35,
  t0.style_typo_h4 AS style_typo_h4_36,
  t0.font_size_h4 AS font_size_h4_37,
  t0.typo_h5 AS typo_h5_38,
  t0.style_typo_h5 AS style_typo_h5_39,
  t0.font_size_h5 AS font_size_h5_40,
  t0.typo_h6 AS typo_h6_41,
  t0.style_typo_h6 AS style_typo_h6_42,
  t0.font_size_h6 AS font_size_h6_43,
  t0.theme AS theme_44,
  t0.header_style AS header_style_45,
  t0.footer_style AS footer_style_46,
  t0.header_bg_color AS header_bg_color_47,
  t0.header_top_bg_color AS header_top_bg_color_48,
  t0.header_text_color AS header_text_color_49,
  t0.header_text_color_hover AS header_text_color_hover_50,
  t0.header_top_text_color AS header_top_text_color_51,
  t0.header_top_text_color_hover AS header_top_text_color_hover_52,
  t0.header_bg_transparent AS header_bg_transparent_53,
  t0.header_top_bg_transparent AS header_top_bg_transparent_54,
  t0.actif_pictos_info AS actif_pictos_info_55,
  t0.actif_icones_navigation AS actif_icones_navigation_56,
  t0.show_reseaux_sociaux AS show_reseaux_sociaux_57,
  t0.actif_tel1 AS actif_tel1_58,
  t0.actif_tel2 AS actif_tel2_59,
  t0.actif_email1 AS actif_email1_60,
  t0.actif_email2 AS actif_email2_61,
  t0.actif_adresse1 AS actif_adresse1_62,
  t0.actif_adresse2 AS actif_adresse2_63,
  t0.actif_horaires1 AS actif_horaires1_64,
  t0.actif_horaires2 AS actif_horaires2_65,
  t0.actif_titre_tel1 AS actif_titre_tel1_66,
  t0.actif_titre_tel2 AS actif_titre_tel2_67,
  t0.actif_titre_email1 AS actif_titre_email1_68,
  t0.actif_titre_email2 AS actif_titre_email2_69,
  t0.actif_titre_adresse1 AS actif_titre_adresse1_70,
  t0.actif_titre_adresse2 AS actif_titre_adresse2_71,
  t0.actif_titre_horaires1 AS actif_titre_horaires1_72,
  t0.actif_titre_horaires2 AS actif_titre_horaires2_73,
  t0.actif_reseaux_sociaux AS actif_reseaux_sociaux_74,
  t0.actif_bouton1 AS actif_bouton1_75,
  t0.position_bouton1 AS position_bouton1_76,
  t0.actif_bouton2 AS actif_bouton2_77,
  t0.position_bouton2 AS position_bouton2_78,
  t0.actif_bouton3 AS actif_bouton3_79,
  t0.position_bouton3 AS position_bouton3_80,
  t0.actif_logo_footer AS actif_logo_footer_81,
  t0.position_logo_footer AS position_logo_footer_82,
  t0.actif_pictos_info_footer AS actif_pictos_info_footer_83,
  t0.actif_tel_footer AS actif_tel_footer_84,
  t0.actif_email_footer AS actif_email_footer_85,
  t0.actif_adresse_footer AS actif_adresse_footer_86,
  t0.actif_horaires_footer AS actif_horaires_footer_87,
  t0.actif_titre_tel_footer AS actif_titre_tel_footer_88,
  t0.actif_titre_email_footer AS actif_titre_email_footer_89,
  t0.actif_titre_adresse_footer AS actif_titre_adresse_footer_90,
  t0.actif_titre_horaires_footer AS actif_titre_horaires_footer_91,
  t0.actif_reseaux_sociaux_footer AS actif_reseaux_sociaux_footer_92,
  t0.actif_bouton1_footer AS actif_bouton1_footer_93,
  t0.actif_codeqr_footer AS actif_codeqr_footer_94,
  t0.actif_texte_footer AS actif_texte_footer_95,
  t0.nbr_contacts_footer AS nbr_contacts_footer_96,
  t0.actif_logo_copyright AS actif_logo_copyright_97,
  t0.actif_date_copyright AS actif_date_copyright_98,
  t0.bg_color_top_footer AS bg_color_top_footer_99,
  t0.color_top_footer AS color_top_footer_100,
  t0.bg_color_sub_footer AS bg_color_sub_footer_101,
  t0.color_sub_footer AS color_sub_footer_102,
  t0.DateCreation AS DateCreation_103,
  t0.DateModification AS DateModification_104
FROM
  theme_options t0
WHERE
  t0.theme = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.couleur_text_btn AS couleur_text_btn_2, t0.couleur_text_btn_hover AS couleur_text_btn_hover_3, t0.couleur_btn AS couleur_btn_4, t0.couleur_btn_hover AS couleur_btn_hover_5, t0.bg_body AS bg_body_6, t0.couleur_body AS couleur_body_7, t0.couleur_generale AS couleur_generale_8, t0.couleur_secondaire AS couleur_secondaire_9, t0.couleur_troisieme AS couleur_troisieme_10, t0.typo_body AS typo_body_11, t0.style_typo_body AS style_typo_body_12, t0.font_size_typo_body AS font_size_typo_body_13, t0.typo_body_secondaire AS typo_body_secondaire_14, t0.style_typo_body_secondaire AS style_typo_body_secondaire_15, t0.font_size_typo_body_secondaire AS font_size_typo_body_secondaire_16, t0.typo_menu AS typo_menu_17, t0.style_typo_menu AS style_typo_menu_18, t0.font_size_menu AS font_size_menu_19, t0.typo_titre AS typo_titre_20, t0.style_typo_titre AS style_typo_titre_21, t0.font_size_titre AS font_size_titre_22, t0.typo_sous_titre AS typo_sous_titre_23, t0.style_typo_sous_titre AS style_typo_sous_titre_24, t0.font_size_sous_titre AS font_size_sous_titre_25, t0.typo_h1 AS typo_h1_26, t0.style_typo_h1 AS style_typo_h1_27, t0.font_size_h1 AS font_size_h1_28, t0.typo_h2 AS typo_h2_29, t0.style_typo_h2 AS style_typo_h2_30, t0.font_size_h2 AS font_size_h2_31, t0.typo_h3 AS typo_h3_32, t0.style_typo_h3 AS style_typo_h3_33, t0.font_size_h3 AS font_size_h3_34, t0.typo_h4 AS typo_h4_35, t0.style_typo_h4 AS style_typo_h4_36, t0.font_size_h4 AS font_size_h4_37, t0.typo_h5 AS typo_h5_38, t0.style_typo_h5 AS style_typo_h5_39, t0.font_size_h5 AS font_size_h5_40, t0.typo_h6 AS typo_h6_41, t0.style_typo_h6 AS style_typo_h6_42, t0.font_size_h6 AS font_size_h6_43, t0.theme AS theme_44, t0.header_style AS header_style_45, t0.footer_style AS footer_style_46, t0.header_bg_color AS header_bg_color_47, t0.header_top_bg_color AS header_top_bg_color_48, t0.header_text_color AS header_text_color_49, t0.header_text_color_hover AS header_text_color_hover_50, t0.header_top_text_color AS header_top_text_color_51, t0.header_top_text_color_hover AS header_top_text_color_hover_52, t0.header_bg_transparent AS header_bg_transparent_53, t0.header_top_bg_transparent AS header_top_bg_transparent_54, t0.actif_pictos_info AS actif_pictos_info_55, t0.actif_icones_navigation AS actif_icones_navigation_56, t0.show_reseaux_sociaux AS show_reseaux_sociaux_57, t0.actif_tel1 AS actif_tel1_58, t0.actif_tel2 AS actif_tel2_59, t0.actif_email1 AS actif_email1_60, t0.actif_email2 AS actif_email2_61, t0.actif_adresse1 AS actif_adresse1_62, t0.actif_adresse2 AS actif_adresse2_63, t0.actif_horaires1 AS actif_horaires1_64, t0.actif_horaires2 AS actif_horaires2_65, t0.actif_titre_tel1 AS actif_titre_tel1_66, t0.actif_titre_tel2 AS actif_titre_tel2_67, t0.actif_titre_email1 AS actif_titre_email1_68, t0.actif_titre_email2 AS actif_titre_email2_69, t0.actif_titre_adresse1 AS actif_titre_adresse1_70, t0.actif_titre_adresse2 AS actif_titre_adresse2_71, t0.actif_titre_horaires1 AS actif_titre_horaires1_72, t0.actif_titre_horaires2 AS actif_titre_horaires2_73, t0.actif_reseaux_sociaux AS actif_reseaux_sociaux_74, t0.actif_bouton1 AS actif_bouton1_75, t0.position_bouton1 AS position_bouton1_76, t0.actif_bouton2 AS actif_bouton2_77, t0.position_bouton2 AS position_bouton2_78, t0.actif_bouton3 AS actif_bouton3_79, t0.position_bouton3 AS position_bouton3_80, t0.actif_logo_footer AS actif_logo_footer_81, t0.position_logo_footer AS position_logo_footer_82, t0.actif_pictos_info_footer AS actif_pictos_info_footer_83, t0.actif_tel_footer AS actif_tel_footer_84, t0.actif_email_footer AS actif_email_footer_85, t0.actif_adresse_footer AS actif_adresse_footer_86, t0.actif_horaires_footer AS actif_horaires_footer_87, t0.actif_titre_tel_footer AS actif_titre_tel_footer_88, t0.actif_titre_email_footer AS actif_titre_email_footer_89, t0.actif_titre_adresse_footer AS actif_titre_adresse_footer_90, t0.actif_titre_horaires_footer AS actif_titre_horaires_footer_91, t0.actif_reseaux_sociaux_footer AS actif_reseaux_sociaux_footer_92, t0.actif_bouton1_footer AS actif_bouton1_footer_93, t0.actif_codeqr_footer AS actif_codeqr_footer_94, t0.actif_texte_footer AS actif_texte_footer_95, t0.nbr_contacts_footer AS nbr_contacts_footer_96, t0.actif_logo_copyright AS actif_logo_copyright_97, t0.actif_date_copyright AS actif_date_copyright_98, t0.bg_color_top_footer AS bg_color_top_footer_99, t0.color_top_footer AS color_top_footer_100, t0.bg_color_sub_footer AS bg_color_sub_footer_101, t0.color_sub_footer AS color_sub_footer_102, t0.DateCreation AS DateCreation_103, t0.DateModification AS DateModification_104 FROM theme_options t0 WHERE t0.theme = 'theme1' LIMIT 1;