Symfony Profiler

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 = '/amenagement-exterieur' AND t0.active = 1 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
ORDER BY
  l0_.id ASC

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 ORDER BY l0_.id 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 = 'amenagement-exterieur' AND u1_.locale = 'fr' 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 = ?
  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 = 'amenagement-exterieur' AND u1_.locale = 'fr' LIMIT 1;

SELECT
  u0_.locale AS locale_0
FROM
  url_post u1_
  INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id
WHERE
  u0_.slug = ?
LIMIT
  1

SELECT u0_.locale AS locale_0 FROM url_post u1_ INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id WHERE u0_.slug = 'amenagement-exterieur' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.folder_media AS folder_media_1,
  a0_.position AS position_2,
  a0_.actif AS actif_3,
  a0_.afficher_home AS afficher_home_4,
  a0_.image AS image_5,
  a0_.folder_image AS folder_image_6,
  a0_.tag_managerhead AS tag_managerhead_7,
  a0_.tag_managerbody AS tag_managerbody_8,
  a0_.DateCreation AS DateCreation_9,
  a0_.DateModification AS DateModification_10
FROM
  activites a0_
  INNER JOIN activites_translation a1_ ON a0_.id = a1_.translatable_id
WHERE
  a1_.libelle_url = ?
  AND a1_.locale = ?

SELECT a0_.id AS id_0, a0_.folder_media AS folder_media_1, a0_.position AS position_2, a0_.actif AS actif_3, a0_.afficher_home AS afficher_home_4, a0_.image AS image_5, a0_.folder_image AS folder_image_6, a0_.tag_managerhead AS tag_managerhead_7, a0_.tag_managerbody AS tag_managerbody_8, a0_.DateCreation AS DateCreation_9, a0_.DateModification AS DateModification_10 FROM activites a0_ INNER JOIN activites_translation a1_ ON a0_.id = a1_.translatable_id WHERE a1_.libelle_url = 'amenagement-exterieur' AND a1_.locale = 'fr';

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.titre_activite AS titre_activite_3,
  t0.libelle_url AS libelle_url_4,
  t0.var_active AS var_active_5,
  t0.text_activite_principal AS text_activite_principal_6,
  t0.text_generer_activite_principal AS text_generer_activite_principal_7,
  t0.text_activite_secondaire AS text_activite_secondaire_8,
  t0.text_generer_activite_secondaire AS text_generer_activite_secondaire_9,
  t0.text_activite_principal_final AS text_activite_principal_final_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.alt_image AS alt_image_14,
  t0.breadcrumb AS breadcrumb_15,
  t0.schema_script AS schema_script_16,
  t0.canonical_url AS canonical_url_17,
  t0.meta_robots AS meta_robots_18,
  t0.setting_meta_title AS setting_meta_title_19,
  t0.setting_meta_desc AS setting_meta_desc_20,
  t0.locale AS locale_21,
  t0.translatable_id AS translatable_id_22
FROM
  activites_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_activite AS titre_activite_3, t0.libelle_url AS libelle_url_4, t0.var_active AS var_active_5, t0.text_activite_principal AS text_activite_principal_6, t0.text_generer_activite_principal AS text_generer_activite_principal_7, t0.text_activite_secondaire AS text_activite_secondaire_8, t0.text_generer_activite_secondaire AS text_generer_activite_secondaire_9, t0.text_activite_principal_final AS text_activite_principal_final_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.alt_image AS alt_image_14, t0.breadcrumb AS breadcrumb_15, t0.schema_script AS schema_script_16, t0.canonical_url AS canonical_url_17, t0.meta_robots AS meta_robots_18, t0.setting_meta_title AS setting_meta_title_19, t0.setting_meta_desc AS setting_meta_desc_20, t0.locale AS locale_21, t0.translatable_id AS translatable_id_22 FROM activites_translation t0 WHERE t0.translatable_id = 1;

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.alias AS alias_3,
  t0.lien_param_ref AS lien_param_ref_4,
  t0.nombre_jour_generer AS nombre_jour_generer_5,
  t0.image_bandeau AS image_bandeau_6,
  t0.nb_secteur AS nb_secteur_7,
  t0.nb_activite AS nb_activite_8,
  t0.nb_maillage_secteur AS nb_maillage_secteur_9,
  t0.nb_maillage_activite AS nb_maillage_activite_10
FROM
  parametre_ref t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.alias AS alias_3, t0.lien_param_ref AS lien_param_ref_4, t0.nombre_jour_generer AS nombre_jour_generer_5, t0.image_bandeau AS image_bandeau_6, t0.nb_secteur AS nb_secteur_7, t0.nb_activite AS nb_activite_8, t0.nb_maillage_secteur AS nb_maillage_secteur_9, t0.nb_maillage_activite AS nb_maillage_activite_10 FROM parametre_ref t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.order_by AS order_by_2,
  t0.actif AS actif_3,
  t0.DateCreation AS DateCreation_4,
  t0.DateModification AS DateModification_5
FROM
  parametre_label t0
WHERE
  t0.actif = ?

SELECT t0.id AS id_1, t0.order_by AS order_by_2, t0.actif AS actif_3, t0.DateCreation AS DateCreation_4, t0.DateModification AS DateModification_5 FROM parametre_label t0 WHERE t0.actif = 1;

SELECT
  t0.id AS id_1,
  t0.order_by AS order_by_2,
  t0.actif AS actif_3,
  t0.DateCreation AS DateCreation_4,
  t0.DateModification AS DateModification_5
FROM
  parametre_label_phrase t0
WHERE
  t0.actif = ?

SELECT t0.id AS id_1, t0.order_by AS order_by_2, t0.actif AS actif_3, t0.DateCreation AS DateCreation_4, t0.DateModification AS DateModification_5 FROM parametre_label_phrase t0 WHERE t0.actif = 1;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.actif AS actif_3,
  t0.activite_primaire_ids AS activite_primaire_ids_4,
  t0.activite_secondaire_ids AS activite_secondaire_ids_5,
  t0.tag_managerhead AS tag_managerhead_6,
  t0.tag_managerbody AS tag_managerbody_7,
  t0.DateCreation AS DateCreation_8,
  t0.DateModification AS DateModification_9
FROM
  secteurs t0
WHERE
  t0.actif = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.actif AS actif_3, t0.activite_primaire_ids AS activite_primaire_ids_4, t0.activite_secondaire_ids AS activite_secondaire_ids_5, t0.tag_managerhead AS tag_managerhead_6, t0.tag_managerbody AS tag_managerbody_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9 FROM secteurs t0 WHERE t0.actif = 1;

SELECT
  t0.id AS id_1,
  t0.location AS location_2,
  t0.path AS path_3,
  t0.fileName AS fileName_4,
  t0.image_cropped AS image_cropped_5,
  t0.type AS type_6,
  t0.type_media_post AS type_media_post_7,
  t0.position AS position_8,
  t0.module AS module_9,
  t0.module_id AS module_id_10,
  t0.lien_externe AS lien_externe_11,
  t0.media_import AS media_import_12,
  t0.width AS width_13,
  t0.height AS height_14,
  t0.filesize AS filesize_15,
  t0.crop_width AS crop_width_16,
  t0.crop_height AS crop_height_17,
  t0.crop_x AS crop_x_18,
  t0.crop_y AS crop_y_19,
  t0.DateCreation AS DateCreation_20,
  t0.DateModification AS DateModification_21
FROM
  media_cms t0
WHERE
  t0.module = ?
  AND t0.module_id = ?

SELECT t0.id AS id_1, t0.location AS location_2, t0.path AS path_3, t0.fileName AS fileName_4, t0.image_cropped AS image_cropped_5, t0.type AS type_6, t0.type_media_post AS type_media_post_7, t0.position AS position_8, t0.module AS module_9, t0.module_id AS module_id_10, t0.lien_externe AS lien_externe_11, t0.media_import AS media_import_12, t0.width AS width_13, t0.height AS height_14, t0.filesize AS filesize_15, t0.crop_width AS crop_width_16, t0.crop_height AS crop_height_17, t0.crop_x AS crop_x_18, t0.crop_y AS crop_y_19, t0.DateCreation AS DateCreation_20, t0.DateModification AS DateModification_21 FROM media_cms t0 WHERE t0.module = 'Activite' AND t0.module_id = 1;

SELECT
  p0_.id AS id_0,
  p0_.alias AS alias_1,
  p0_.position AS position_2,
  p0_.authorization_api AS authorization_api_3,
  p0_.actif_home AS actif_home_4,
  p0_.post_archive AS post_archive_5,
  p0_.date_archive AS date_archive_6,
  p0_.image AS image_7,
  p0_.url_video AS url_video_8,
  p0_.image_bandeau AS image_bandeau_9,
  p0_.image_bandeau_height AS image_bandeau_height_10,
  p0_.image_couverture AS image_couverture_11,
  p0_.tag_managerhead AS tag_managerhead_12,
  p0_.tag_managerbody AS tag_managerbody_13,
  p0_.default_categorie AS default_categorie_14,
  p0_.date_publication AS date_publication_15,
  p0_.date_import AS date_import_16,
  p0_.created_at AS created_at_17,
  p0_.updated_at AS updated_at_18,
  p0_.id_activite AS id_activite_19,
  p0_.id_sous_activite AS id_sous_activite_20,
  p0_.id_secteur AS id_secteur_21,
  p0_.type_page_ref AS type_page_ref_22,
  p0_.disponibilite_produit AS disponibilite_produit_23,
  p0_.prix_produit AS prix_produit_24,
  p0_.referance_produit AS referance_produit_25,
  p0_.position_image AS position_image_26,
  p0_.id_import_categorie_old AS id_import_categorie_old_27,
  p0_.old_id_import AS old_id_import_28,
  p0_.module_import AS module_import_29,
  p0_.posts_associes AS posts_associes_30,
  p0_.posts_associes_autres_types AS posts_associes_autres_types_31,
  p0_.author_id AS author_id_32,
  p0_.type_post AS type_post_33,
  p0_.template_cms_id AS template_cms_id_34,
  p0_.modele_gallerie_id AS modele_gallerie_id_35
FROM
  post p0_
  INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id
  INNER JOIN post_type p2_ ON p0_.type_post = p2_.id
WHERE
  p2_.id = 11
  AND p1_.actif = 1
  AND p0_.id_activite = ?
  AND p1_.locale = ?
  AND (
    p0_.date_publication IS NULL
    OR p0_.date_publication <= ?
  )
  AND p0_.id_sous_activite IS NULL
ORDER BY
  p0_.id DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.alias AS alias_1, p0_.position AS position_2, p0_.authorization_api AS authorization_api_3, p0_.actif_home AS actif_home_4, p0_.post_archive AS post_archive_5, p0_.date_archive AS date_archive_6, p0_.image AS image_7, p0_.url_video AS url_video_8, p0_.image_bandeau AS image_bandeau_9, p0_.image_bandeau_height AS image_bandeau_height_10, p0_.image_couverture AS image_couverture_11, p0_.tag_managerhead AS tag_managerhead_12, p0_.tag_managerbody AS tag_managerbody_13, p0_.default_categorie AS default_categorie_14, p0_.date_publication AS date_publication_15, p0_.date_import AS date_import_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p0_.id_activite AS id_activite_19, p0_.id_sous_activite AS id_sous_activite_20, p0_.id_secteur AS id_secteur_21, p0_.type_page_ref AS type_page_ref_22, p0_.disponibilite_produit AS disponibilite_produit_23, p0_.prix_produit AS prix_produit_24, p0_.referance_produit AS referance_produit_25, p0_.position_image AS position_image_26, p0_.id_import_categorie_old AS id_import_categorie_old_27, p0_.old_id_import AS old_id_import_28, p0_.module_import AS module_import_29, p0_.posts_associes AS posts_associes_30, p0_.posts_associes_autres_types AS posts_associes_autres_types_31, p0_.author_id AS author_id_32, p0_.type_post AS type_post_33, p0_.template_cms_id AS template_cms_id_34, p0_.modele_gallerie_id AS modele_gallerie_id_35 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN post_type p2_ ON p0_.type_post = p2_.id WHERE p2_.id = 11 AND p1_.actif = 1 AND p0_.id_activite = 1 AND p1_.locale = 'fr' AND (p0_.date_publication IS NULL OR p0_.date_publication <= '2024-11-18 17:40:50') AND p0_.id_sous_activite IS NULL ORDER BY p0_.id DESC LIMIT 3;

SELECT
  p0_.id AS id_0,
  p0_.alias AS alias_1,
  p0_.position AS position_2,
  p0_.authorization_api AS authorization_api_3,
  p0_.actif_home AS actif_home_4,
  p0_.post_archive AS post_archive_5,
  p0_.date_archive AS date_archive_6,
  p0_.image AS image_7,
  p0_.url_video AS url_video_8,
  p0_.image_bandeau AS image_bandeau_9,
  p0_.image_bandeau_height AS image_bandeau_height_10,
  p0_.image_couverture AS image_couverture_11,
  p0_.tag_managerhead AS tag_managerhead_12,
  p0_.tag_managerbody AS tag_managerbody_13,
  p0_.default_categorie AS default_categorie_14,
  p0_.date_publication AS date_publication_15,
  p0_.date_import AS date_import_16,
  p0_.created_at AS created_at_17,
  p0_.updated_at AS updated_at_18,
  p0_.id_activite AS id_activite_19,
  p0_.id_sous_activite AS id_sous_activite_20,
  p0_.id_secteur AS id_secteur_21,
  p0_.type_page_ref AS type_page_ref_22,
  p0_.disponibilite_produit AS disponibilite_produit_23,
  p0_.prix_produit AS prix_produit_24,
  p0_.referance_produit AS referance_produit_25,
  p0_.position_image AS position_image_26,
  p0_.id_import_categorie_old AS id_import_categorie_old_27,
  p0_.old_id_import AS old_id_import_28,
  p0_.module_import AS module_import_29,
  p0_.posts_associes AS posts_associes_30,
  p0_.posts_associes_autres_types AS posts_associes_autres_types_31,
  p0_.author_id AS author_id_32,
  p0_.type_post AS type_post_33,
  p0_.template_cms_id AS template_cms_id_34,
  p0_.modele_gallerie_id AS modele_gallerie_id_35
FROM
  post p0_
  INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id
  INNER JOIN post_type p2_ ON p0_.type_post = p2_.id
WHERE
  p2_.id <> 11
  AND p1_.actif = 1
  AND (
    p0_.date_publication IS NULL
    OR p0_.date_publication <= ?
  )
  AND p1_.locale = ?
  AND p0_.id_activite = ?
ORDER BY
  p0_.id DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.alias AS alias_1, p0_.position AS position_2, p0_.authorization_api AS authorization_api_3, p0_.actif_home AS actif_home_4, p0_.post_archive AS post_archive_5, p0_.date_archive AS date_archive_6, p0_.image AS image_7, p0_.url_video AS url_video_8, p0_.image_bandeau AS image_bandeau_9, p0_.image_bandeau_height AS image_bandeau_height_10, p0_.image_couverture AS image_couverture_11, p0_.tag_managerhead AS tag_managerhead_12, p0_.tag_managerbody AS tag_managerbody_13, p0_.default_categorie AS default_categorie_14, p0_.date_publication AS date_publication_15, p0_.date_import AS date_import_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p0_.id_activite AS id_activite_19, p0_.id_sous_activite AS id_sous_activite_20, p0_.id_secteur AS id_secteur_21, p0_.type_page_ref AS type_page_ref_22, p0_.disponibilite_produit AS disponibilite_produit_23, p0_.prix_produit AS prix_produit_24, p0_.referance_produit AS referance_produit_25, p0_.position_image AS position_image_26, p0_.id_import_categorie_old AS id_import_categorie_old_27, p0_.old_id_import AS old_id_import_28, p0_.module_import AS module_import_29, p0_.posts_associes AS posts_associes_30, p0_.posts_associes_autres_types AS posts_associes_autres_types_31, p0_.author_id AS author_id_32, p0_.type_post AS type_post_33, p0_.template_cms_id AS template_cms_id_34, p0_.modele_gallerie_id AS modele_gallerie_id_35 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id INNER JOIN post_type p2_ ON p0_.type_post = p2_.id WHERE p2_.id <> 11 AND p1_.actif = 1 AND (p0_.date_publication IS NULL OR p0_.date_publication <= '2024-11-18 17:40:50') AND p1_.locale = 'fr' AND p0_.id_activite = 1 ORDER BY p0_.id DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.actif_bar_serach AS actif_bar_serach_2,
  t0.actif_oscar AS actif_oscar_3,
  t0.actif_titre AS actif_titre_4,
  t0.email_site AS email_site_5,
  t0.image AS image_6,
  t0.lien_carte AS lien_carte_7,
  t0.apercu_image_lien AS apercu_image_lien_8,
  t0.image_header AS image_header_9,
  t0.image_footer AS image_footer_10,
  t0.image_bandeau AS image_bandeau_11,
  t0.tel AS tel_12,
  t0.image_vide AS image_vide_13,
  t0.maintenance AS maintenance_14,
  t0.htaccess_val AS htaccess_val_15,
  t0.meta_index AS meta_index_16,
  t0.meta_follow AS meta_follow_17,
  t0.robots AS robots_18,
  t0.analytics AS analytics_19,
  t0.cle_key AS cle_key_20,
  t0.cle_secret AS cle_secret_21,
  t0.tag_managerhead AS tag_managerhead_22,
  t0.meta_keywords AS meta_keywords_23,
  t0.cle_map AS cle_map_24,
  t0.active_smtp AS active_smtp_25,
  t0.email_from AS email_from_26,
  t0.email_sender AS email_sender_27,
  t0.host_smtp AS host_smtp_28,
  t0.type_cryptage AS type_cryptage_29,
  t0.port_tls AS port_tls_30,
  t0.port_ssl AS port_ssl_31,
  t0.smtp_user AS smtp_user_32,
  t0.smtp_pass AS smtp_pass_33,
  t0.typeLienErrorPage AS typeLienErrorPage_34,
  t0.lienExterneErrorPage AS lienExterneErrorPage_35,
  t0.telephoneErrorPage AS telephoneErrorPage_36,
  t0.domain_api_hrz AS domain_api_hrz_37,
  t0.token_api_hrz AS token_api_hrz_38,
  t0.actif_auth_gmail AS actif_auth_gmail_39,
  t0.id_client_auth AS id_client_auth_40,
  t0.secret_client_auth AS secret_client_auth_41,
  t0.id_matomo AS id_matomo_42,
  t0.code_head AS code_head_43,
  t0.code_body AS code_body_44,
  t0.google_verification AS google_verification_45,
  t0.IdSite AS IdSite_46
FROM
  parametre_site t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.actif_bar_serach AS actif_bar_serach_2, t0.actif_oscar AS actif_oscar_3, t0.actif_titre AS actif_titre_4, t0.email_site AS email_site_5, t0.image AS image_6, t0.lien_carte AS lien_carte_7, t0.apercu_image_lien AS apercu_image_lien_8, t0.image_header AS image_header_9, t0.image_footer AS image_footer_10, t0.image_bandeau AS image_bandeau_11, t0.tel AS tel_12, t0.image_vide AS image_vide_13, t0.maintenance AS maintenance_14, t0.htaccess_val AS htaccess_val_15, t0.meta_index AS meta_index_16, t0.meta_follow AS meta_follow_17, t0.robots AS robots_18, t0.analytics AS analytics_19, t0.cle_key AS cle_key_20, t0.cle_secret AS cle_secret_21, t0.tag_managerhead AS tag_managerhead_22, t0.meta_keywords AS meta_keywords_23, t0.cle_map AS cle_map_24, t0.active_smtp AS active_smtp_25, t0.email_from AS email_from_26, t0.email_sender AS email_sender_27, t0.host_smtp AS host_smtp_28, t0.type_cryptage AS type_cryptage_29, t0.port_tls AS port_tls_30, t0.port_ssl AS port_ssl_31, t0.smtp_user AS smtp_user_32, t0.smtp_pass AS smtp_pass_33, t0.typeLienErrorPage AS typeLienErrorPage_34, t0.lienExterneErrorPage AS lienExterneErrorPage_35, t0.telephoneErrorPage AS telephoneErrorPage_36, t0.domain_api_hrz AS domain_api_hrz_37, t0.token_api_hrz AS token_api_hrz_38, t0.actif_auth_gmail AS actif_auth_gmail_39, t0.id_client_auth AS id_client_auth_40, t0.secret_client_auth AS secret_client_auth_41, t0.id_matomo AS id_matomo_42, t0.code_head AS code_head_43, t0.code_body AS code_body_44, t0.google_verification AS google_verification_45, t0.IdSite AS IdSite_46 FROM parametre_site t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.alias AS alias_1,
  p0_.position AS position_2,
  p0_.authorization_api AS authorization_api_3,
  p0_.actif_home AS actif_home_4,
  p0_.post_archive AS post_archive_5,
  p0_.date_archive AS date_archive_6,
  p0_.image AS image_7,
  p0_.url_video AS url_video_8,
  p0_.image_bandeau AS image_bandeau_9,
  p0_.image_bandeau_height AS image_bandeau_height_10,
  p0_.image_couverture AS image_couverture_11,
  p0_.tag_managerhead AS tag_managerhead_12,
  p0_.tag_managerbody AS tag_managerbody_13,
  p0_.default_categorie AS default_categorie_14,
  p0_.date_publication AS date_publication_15,
  p0_.date_import AS date_import_16,
  p0_.created_at AS created_at_17,
  p0_.updated_at AS updated_at_18,
  p0_.id_activite AS id_activite_19,
  p0_.id_sous_activite AS id_sous_activite_20,
  p0_.id_secteur AS id_secteur_21,
  p0_.type_page_ref AS type_page_ref_22,
  p0_.disponibilite_produit AS disponibilite_produit_23,
  p0_.prix_produit AS prix_produit_24,
  p0_.referance_produit AS referance_produit_25,
  p0_.position_image AS position_image_26,
  p0_.id_import_categorie_old AS id_import_categorie_old_27,
  p0_.old_id_import AS old_id_import_28,
  p0_.module_import AS module_import_29,
  p0_.posts_associes AS posts_associes_30,
  p0_.posts_associes_autres_types AS posts_associes_autres_types_31,
  p0_.author_id AS author_id_32,
  p0_.type_post AS type_post_33,
  p0_.template_cms_id AS template_cms_id_34,
  p0_.modele_gallerie_id AS modele_gallerie_id_35
FROM
  post p0_
  INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id
WHERE
  p1_.locale = ?
  AND p1_.slug = ?

SELECT p0_.id AS id_0, p0_.alias AS alias_1, p0_.position AS position_2, p0_.authorization_api AS authorization_api_3, p0_.actif_home AS actif_home_4, p0_.post_archive AS post_archive_5, p0_.date_archive AS date_archive_6, p0_.image AS image_7, p0_.url_video AS url_video_8, p0_.image_bandeau AS image_bandeau_9, p0_.image_bandeau_height AS image_bandeau_height_10, p0_.image_couverture AS image_couverture_11, p0_.tag_managerhead AS tag_managerhead_12, p0_.tag_managerbody AS tag_managerbody_13, p0_.default_categorie AS default_categorie_14, p0_.date_publication AS date_publication_15, p0_.date_import AS date_import_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p0_.id_activite AS id_activite_19, p0_.id_sous_activite AS id_sous_activite_20, p0_.id_secteur AS id_secteur_21, p0_.type_page_ref AS type_page_ref_22, p0_.disponibilite_produit AS disponibilite_produit_23, p0_.prix_produit AS prix_produit_24, p0_.referance_produit AS referance_produit_25, p0_.position_image AS position_image_26, p0_.id_import_categorie_old AS id_import_categorie_old_27, p0_.old_id_import AS old_id_import_28, p0_.module_import AS module_import_29, p0_.posts_associes AS posts_associes_30, p0_.posts_associes_autres_types AS posts_associes_autres_types_31, p0_.author_id AS author_id_32, p0_.type_post AS type_post_33, p0_.template_cms_id AS template_cms_id_34, p0_.modele_gallerie_id AS modele_gallerie_id_35 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id WHERE p1_.locale = 'fr' AND p1_.slug = 'Home';

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.title AS title_3,
  t0.title_affichage AS title_affichage_4,
  t0.slug AS slug_5,
  t0.summary AS summary_6,
  t0.content AS content_7,
  t0.content2 AS content2_8,
  t0.meta_title AS meta_title_9,
  t0.meta_description AS meta_description_10,
  t0.meta_keys AS meta_keys_11,
  t0.script_sc AS script_sc_12,
  t0.breadcrumb AS breadcrumb_13,
  t0.canonical AS canonical_14,
  t0.meta_robots AS meta_robots_15,
  t0.settig_metaTitle AS settig_metaTitle_16,
  t0.settig_metaDesc AS settig_metaDesc_17,
  t0.traduite AS traduite_18,
  t0.image_alt AS image_alt_19,
  t0.image_bandeau_alt AS image_bandeau_alt_20,
  t0.image_couverture_alt AS image_couverture_alt_21,
  t0.titre_lien AS titre_lien_22,
  t0.type_lien AS type_lien_23,
  t0.lien_interne AS lien_interne_24,
  t0.lien_externe AS lien_externe_25,
  t0.telephone AS telephone_26,
  t0.locale AS locale_27,
  t0.export_traductions_id AS export_traductions_id_28,
  t0.translatable_id AS translatable_id_29
FROM
  post_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.title AS title_3, t0.title_affichage AS title_affichage_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.content AS content_7, t0.content2 AS content2_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.meta_keys AS meta_keys_11, t0.script_sc AS script_sc_12, t0.breadcrumb AS breadcrumb_13, t0.canonical AS canonical_14, t0.meta_robots AS meta_robots_15, t0.settig_metaTitle AS settig_metaTitle_16, t0.settig_metaDesc AS settig_metaDesc_17, t0.traduite AS traduite_18, t0.image_alt AS image_alt_19, t0.image_bandeau_alt AS image_bandeau_alt_20, t0.image_couverture_alt AS image_couverture_alt_21, t0.titre_lien AS titre_lien_22, t0.type_lien AS type_lien_23, t0.lien_interne AS lien_interne_24, t0.lien_externe AS lien_externe_25, t0.telephone AS telephone_26, t0.locale AS locale_27, t0.export_traductions_id AS export_traductions_id_28, t0.translatable_id AS translatable_id_29 FROM post_translation t0 WHERE t0.translatable_id = 1;

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.alias AS alias_3,
  t0.lien_param_ref AS lien_param_ref_4,
  t0.nombre_jour_generer AS nombre_jour_generer_5,
  t0.image_bandeau AS image_bandeau_6,
  t0.nb_secteur AS nb_secteur_7,
  t0.nb_activite AS nb_activite_8,
  t0.nb_maillage_secteur AS nb_maillage_secteur_9,
  t0.nb_maillage_activite AS nb_maillage_activite_10
FROM
  parametre_ref t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.alias AS alias_3, t0.lien_param_ref AS lien_param_ref_4, t0.nombre_jour_generer AS nombre_jour_generer_5, t0.image_bandeau AS image_bandeau_6, t0.nb_secteur AS nb_secteur_7, t0.nb_activite AS nb_activite_8, t0.nb_maillage_secteur AS nb_maillage_secteur_9, t0.nb_maillage_activite AS nb_maillage_activite_10 FROM parametre_ref t0 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.order_by AS order_by_2,
  t0.actif AS actif_3,
  t0.DateCreation AS DateCreation_4,
  t0.DateModification AS DateModification_5
FROM
  parametre_label t0
WHERE
  t0.actif = ?

SELECT t0.id AS id_1, t0.order_by AS order_by_2, t0.actif AS actif_3, t0.DateCreation AS DateCreation_4, t0.DateModification AS DateModification_5 FROM parametre_label t0 WHERE t0.actif = 1;

SELECT
  t0.id AS id_1,
  t0.order_by AS order_by_2,
  t0.actif AS actif_3,
  t0.DateCreation AS DateCreation_4,
  t0.DateModification AS DateModification_5
FROM
  parametre_label_phrase t0
WHERE
  t0.actif = ?

SELECT t0.id AS id_1, t0.order_by AS order_by_2, t0.actif AS actif_3, t0.DateCreation AS DateCreation_4, t0.DateModification AS DateModification_5 FROM parametre_label_phrase t0 WHERE t0.actif = 1;

SELECT
  p0_.id AS id_0,
  p0_.alias AS alias_1,
  p0_.position AS position_2,
  p0_.authorization_api AS authorization_api_3,
  p0_.actif_home AS actif_home_4,
  p0_.post_archive AS post_archive_5,
  p0_.date_archive AS date_archive_6,
  p0_.image AS image_7,
  p0_.url_video AS url_video_8,
  p0_.image_bandeau AS image_bandeau_9,
  p0_.image_bandeau_height AS image_bandeau_height_10,
  p0_.image_couverture AS image_couverture_11,
  p0_.tag_managerhead AS tag_managerhead_12,
  p0_.tag_managerbody AS tag_managerbody_13,
  p0_.default_categorie AS default_categorie_14,
  p0_.date_publication AS date_publication_15,
  p0_.date_import AS date_import_16,
  p0_.created_at AS created_at_17,
  p0_.updated_at AS updated_at_18,
  p0_.id_activite AS id_activite_19,
  p0_.id_sous_activite AS id_sous_activite_20,
  p0_.id_secteur AS id_secteur_21,
  p0_.type_page_ref AS type_page_ref_22,
  p0_.disponibilite_produit AS disponibilite_produit_23,
  p0_.prix_produit AS prix_produit_24,
  p0_.referance_produit AS referance_produit_25,
  p0_.position_image AS position_image_26,
  p0_.id_import_categorie_old AS id_import_categorie_old_27,
  p0_.old_id_import AS old_id_import_28,
  p0_.module_import AS module_import_29,
  p0_.posts_associes AS posts_associes_30,
  p0_.posts_associes_autres_types AS posts_associes_autres_types_31,
  p0_.author_id AS author_id_32,
  p0_.type_post AS type_post_33,
  p0_.template_cms_id AS template_cms_id_34,
  p0_.modele_gallerie_id AS modele_gallerie_id_35
FROM
  post p0_
  INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id
  INNER JOIN post_type p2_ ON p0_.type_post = p2_.id
WHERE
  p2_.id = 11
  AND p1_.actif = 1
  AND p0_.id_sous_activite IS NOT NULL
  AND (
    p0_.date_publication IS NULL
    OR p0_.date_publication <= ?
  )
  AND p0_.type_page_ref = ?
  AND p0_.id_activite = ?
  AND p1_.locale = ?
GROUP BY
  p0_.id_sous_activite
ORDER BY
  RAND() ASC
LIMIT
  3