Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_domain AS site_domain_3,
  t0.is_ecommerce AS is_ecommerce_4,
  t0.nb_news_home_page AS nb_news_home_page_5,
  t0.logo_in_menu AS logo_in_menu_6,
  t0.right_menu_activated AS right_menu_activated_7,
  t0.breadcrumb_is_active AS breadcrumb_is_active_8,
  t0.site_copy_mail AS site_copy_mail_9,
  t0.site_header_mail AS site_header_mail_10,
  t0.site_sender_mail AS site_sender_mail_11,
  t0.site_sender_name_mail AS site_sender_name_mail_12,
  t0.project_directory AS project_directory_13,
  t0.odyssee_type AS odyssee_type_14,
  t0.odyssee_pdv_id AS odyssee_pdv_id_15,
  t0.clickup_script AS clickup_script_16
FROM
  site t0
WHERE
  t0.project_directory = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_domain AS site_domain_3, t0.is_ecommerce AS is_ecommerce_4, t0.nb_news_home_page AS nb_news_home_page_5, t0.logo_in_menu AS logo_in_menu_6, t0.right_menu_activated AS right_menu_activated_7, t0.breadcrumb_is_active AS breadcrumb_is_active_8, t0.site_copy_mail AS site_copy_mail_9, t0.site_header_mail AS site_header_mail_10, t0.site_sender_mail AS site_sender_mail_11, t0.site_sender_name_mail AS site_sender_name_mail_12, t0.project_directory AS project_directory_13, t0.odyssee_type AS odyssee_type_14, t0.odyssee_pdv_id AS odyssee_pdv_id_15, t0.clickup_script AS clickup_script_16 FROM site t0 WHERE t0.project_directory = 'main-app' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_domain AS site_domain_3,
  t0.is_ecommerce AS is_ecommerce_4,
  t0.nb_news_home_page AS nb_news_home_page_5,
  t0.logo_in_menu AS logo_in_menu_6,
  t0.right_menu_activated AS right_menu_activated_7,
  t0.breadcrumb_is_active AS breadcrumb_is_active_8,
  t0.site_copy_mail AS site_copy_mail_9,
  t0.site_header_mail AS site_header_mail_10,
  t0.site_sender_mail AS site_sender_mail_11,
  t0.site_sender_name_mail AS site_sender_name_mail_12,
  t0.project_directory AS project_directory_13,
  t0.odyssee_type AS odyssee_type_14,
  t0.odyssee_pdv_id AS odyssee_pdv_id_15,
  t0.clickup_script AS clickup_script_16
FROM
  site t0
WHERE
  t0.project_directory = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_domain AS site_domain_3, t0.is_ecommerce AS is_ecommerce_4, t0.nb_news_home_page AS nb_news_home_page_5, t0.logo_in_menu AS logo_in_menu_6, t0.right_menu_activated AS right_menu_activated_7, t0.breadcrumb_is_active AS breadcrumb_is_active_8, t0.site_copy_mail AS site_copy_mail_9, t0.site_header_mail AS site_header_mail_10, t0.site_sender_mail AS site_sender_mail_11, t0.site_sender_name_mail AS site_sender_name_mail_12, t0.project_directory AS project_directory_13, t0.odyssee_type AS odyssee_type_14, t0.odyssee_pdv_id AS odyssee_pdv_id_15, t0.clickup_script AS clickup_script_16 FROM site t0 WHERE t0.project_directory = 'main-app' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_domain AS site_domain_3,
  t0.is_ecommerce AS is_ecommerce_4,
  t0.nb_news_home_page AS nb_news_home_page_5,
  t0.logo_in_menu AS logo_in_menu_6,
  t0.right_menu_activated AS right_menu_activated_7,
  t0.breadcrumb_is_active AS breadcrumb_is_active_8,
  t0.site_copy_mail AS site_copy_mail_9,
  t0.site_header_mail AS site_header_mail_10,
  t0.site_sender_mail AS site_sender_mail_11,
  t0.site_sender_name_mail AS site_sender_name_mail_12,
  t0.project_directory AS project_directory_13,
  t0.odyssee_type AS odyssee_type_14,
  t0.odyssee_pdv_id AS odyssee_pdv_id_15,
  t0.clickup_script AS clickup_script_16
FROM
  site t0
WHERE
  t0.project_directory = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_domain AS site_domain_3, t0.is_ecommerce AS is_ecommerce_4, t0.nb_news_home_page AS nb_news_home_page_5, t0.logo_in_menu AS logo_in_menu_6, t0.right_menu_activated AS right_menu_activated_7, t0.breadcrumb_is_active AS breadcrumb_is_active_8, t0.site_copy_mail AS site_copy_mail_9, t0.site_header_mail AS site_header_mail_10, t0.site_sender_mail AS site_sender_mail_11, t0.site_sender_name_mail AS site_sender_name_mail_12, t0.project_directory AS project_directory_13, t0.odyssee_type AS odyssee_type_14, t0.odyssee_pdv_id AS odyssee_pdv_id_15, t0.clickup_script AS clickup_script_16 FROM site t0 WHERE t0.project_directory = 'main-app' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cure_arrhes AS cure_arrhes_2,
  t0.ip_api_server AS ip_api_server_3,
  t0.port_api_server AS port_api_server_4,
  t0.cure_quota AS cure_quota_5,
  t0.nb_days_available_search AS nb_days_available_search_6,
  t0.current_year_start_date AS current_year_start_date_7,
  t0.current_year_end_date AS current_year_end_date_8,
  t0.next_year_start_date AS next_year_start_date_9,
  t0.next_year_end_date AS next_year_end_date_10,
  t0.site_id AS site_id_11
FROM
  api_settings t0
WHERE
  t0.site_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.cure_arrhes AS cure_arrhes_2, t0.ip_api_server AS ip_api_server_3, t0.port_api_server AS port_api_server_4, t0.cure_quota AS cure_quota_5, t0.nb_days_available_search AS nb_days_available_search_6, t0.current_year_start_date AS current_year_start_date_7, t0.current_year_end_date AS current_year_end_date_8, t0.next_year_start_date AS next_year_start_date_9, t0.next_year_end_date AS next_year_end_date_10, t0.site_id AS site_id_11 FROM api_settings t0 WHERE t0.site_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cure_arrhes AS cure_arrhes_2,
  t0.ip_api_server AS ip_api_server_3,
  t0.port_api_server AS port_api_server_4,
  t0.cure_quota AS cure_quota_5,
  t0.nb_days_available_search AS nb_days_available_search_6,
  t0.current_year_start_date AS current_year_start_date_7,
  t0.current_year_end_date AS current_year_end_date_8,
  t0.next_year_start_date AS next_year_start_date_9,
  t0.next_year_end_date AS next_year_end_date_10,
  t0.site_id AS site_id_11
FROM
  api_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.cure_arrhes AS cure_arrhes_2, t0.ip_api_server AS ip_api_server_3, t0.port_api_server AS port_api_server_4, t0.cure_quota AS cure_quota_5, t0.nb_days_available_search AS nb_days_available_search_6, t0.current_year_start_date AS current_year_start_date_7, t0.current_year_end_date AS current_year_end_date_8, t0.next_year_start_date AS next_year_start_date_9, t0.next_year_end_date AS next_year_end_date_10, t0.site_id AS site_id_11 FROM api_settings t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_domain AS site_domain_3,
  t0.is_ecommerce AS is_ecommerce_4,
  t0.nb_news_home_page AS nb_news_home_page_5,
  t0.logo_in_menu AS logo_in_menu_6,
  t0.right_menu_activated AS right_menu_activated_7,
  t0.breadcrumb_is_active AS breadcrumb_is_active_8,
  t0.site_copy_mail AS site_copy_mail_9,
  t0.site_header_mail AS site_header_mail_10,
  t0.site_sender_mail AS site_sender_mail_11,
  t0.site_sender_name_mail AS site_sender_name_mail_12,
  t0.project_directory AS project_directory_13,
  t0.odyssee_type AS odyssee_type_14,
  t0.odyssee_pdv_id AS odyssee_pdv_id_15,
  t0.clickup_script AS clickup_script_16
FROM
  site t0

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_domain AS site_domain_3, t0.is_ecommerce AS is_ecommerce_4, t0.nb_news_home_page AS nb_news_home_page_5, t0.logo_in_menu AS logo_in_menu_6, t0.right_menu_activated AS right_menu_activated_7, t0.breadcrumb_is_active AS breadcrumb_is_active_8, t0.site_copy_mail AS site_copy_mail_9, t0.site_header_mail AS site_header_mail_10, t0.site_sender_mail AS site_sender_mail_11, t0.site_sender_name_mail AS site_sender_name_mail_12, t0.project_directory AS project_directory_13, t0.odyssee_type AS odyssee_type_14, t0.odyssee_pdv_id AS odyssee_pdv_id_15, t0.clickup_script AS clickup_script_16 FROM site t0;

SELECT
  t0.id AS id_1,
  t0.coord_adresse AS coord_adresse_2,
  t0.coord_ville AS coord_ville_3,
  t0.coord_cp AS coord_cp_4,
  t0.coord_tel AS coord_tel_5,
  t0.coord_tel_fixe AS coord_tel_fixe_6,
  t0.coord_siret AS coord_siret_7,
  t0.coord_num_tva AS coord_num_tva_8,
  t0.coord_code_ape AS coord_code_ape_9,
  t0.coord_capital_social AS coord_capital_social_10,
  t0.site_lang AS site_lang_11,
  t0.site_uid AS site_uid_12,
  t0.coord_pays AS coord_pays_13,
  t0.type AS type_14,
  t0.coord_rcs AS coord_rcs_15
FROM
  site_coordonnees t0
WHERE
  t0.site_uid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.coord_adresse AS coord_adresse_2, t0.coord_ville AS coord_ville_3, t0.coord_cp AS coord_cp_4, t0.coord_tel AS coord_tel_5, t0.coord_tel_fixe AS coord_tel_fixe_6, t0.coord_siret AS coord_siret_7, t0.coord_num_tva AS coord_num_tva_8, t0.coord_code_ape AS coord_code_ape_9, t0.coord_capital_social AS coord_capital_social_10, t0.site_lang AS site_lang_11, t0.site_uid AS site_uid_12, t0.coord_pays AS coord_pays_13, t0.type AS type_14, t0.coord_rcs AS coord_rcs_15 FROM site_coordonnees t0 WHERE t0.site_uid = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.site_uid AS site_uid_2,
  t0.key_gtm AS key_gtm_3,
  t0.axeptio_client_id AS axeptio_client_id_4,
  t0.axeptio_cookies_version AS axeptio_cookies_version_5
FROM
  site_google_tag_manager t0
WHERE
  t0.site_uid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.site_uid AS site_uid_2, t0.key_gtm AS key_gtm_3, t0.axeptio_client_id AS axeptio_client_id_4, t0.axeptio_cookies_version AS axeptio_cookies_version_5 FROM site_google_tag_manager t0 WHERE t0.site_uid = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.acc_ref_title AS acc_ref_title_2,
  t0.acc_ref_description AS acc_ref_description_3,
  t0.acc_ref_namesite AS acc_ref_namesite_4,
  t0.acc_ref_thumbnail AS acc_ref_thumbnail_5,
  t0.site_lang AS site_lang_6,
  t0.site_uid AS site_uid_7
FROM
  site_referencement t0
WHERE
  t0.site_lang = ?
  AND t0.site_uid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.acc_ref_title AS acc_ref_title_2, t0.acc_ref_description AS acc_ref_description_3, t0.acc_ref_namesite AS acc_ref_namesite_4, t0.acc_ref_thumbnail AS acc_ref_thumbnail_5, t0.site_lang AS site_lang_6, t0.site_uid AS site_uid_7 FROM site_referencement t0 WHERE t0.site_lang = 'fr' AND t0.site_uid = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.lang_code AS lang_code_2,
  t0.lang_entitled AS lang_entitled_3,
  t0.lang_flag AS lang_flag_4,
  t0.lang_active AS lang_active_5,
  t0.lang_order AS lang_order_6,
  t0.lang_active_back AS lang_active_back_7
FROM
  language t0
WHERE
  t0.lang_active = ?
ORDER BY
  t0.lang_order ASC

SELECT t0.id AS id_1, t0.lang_code AS lang_code_2, t0.lang_entitled AS lang_entitled_3, t0.lang_flag AS lang_flag_4, t0.lang_active AS lang_active_5, t0.lang_order AS lang_order_6, t0.lang_active_back AS lang_active_back_7 FROM language t0 WHERE t0.lang_active = 1 ORDER BY t0.lang_order ASC;

SELECT
  t0.id AS id_1,
  t0.acc_res_entitled AS acc_res_entitled_2,
  t0.acc_res_link AS acc_res_link_3,
  t0.acc_res_active AS acc_res_active_4,
  t0.acc_res_thmbnail_type AS acc_res_thmbnail_type_5,
  t0.acc_res_class AS acc_res_class_6,
  t0.site_lang AS site_lang_7,
  t0.site_uid AS site_uid_8
FROM
  site_reseaux t0
WHERE
  t0.acc_res_active = ?
  AND t0.site_uid = ?
  AND t0.site_lang = ?

SELECT t0.id AS id_1, t0.acc_res_entitled AS acc_res_entitled_2, t0.acc_res_link AS acc_res_link_3, t0.acc_res_active AS acc_res_active_4, t0.acc_res_thmbnail_type AS acc_res_thmbnail_type_5, t0.acc_res_class AS acc_res_class_6, t0.site_lang AS site_lang_7, t0.site_uid AS site_uid_8 FROM site_reseaux t0 WHERE t0.acc_res_active = 1 AND t0.site_uid = 1 AND t0.site_lang = 'fr';

SELECT
  t0.id AS id_1,
  t0.acc_res_entitled AS acc_res_entitled_2,
  t0.acc_res_link AS acc_res_link_3,
  t0.acc_res_active AS acc_res_active_4,
  t0.acc_res_thmbnail_type AS acc_res_thmbnail_type_5,
  t0.acc_res_class AS acc_res_class_6,
  t0.site_lang AS site_lang_7,
  t0.site_uid AS site_uid_8
FROM
  site_reseaux t0
WHERE
  t0.acc_res_active = ?
  AND t0.site_uid = ?
  AND t0.site_lang = ?

SELECT t0.id AS id_1, t0.acc_res_entitled AS acc_res_entitled_2, t0.acc_res_link AS acc_res_link_3, t0.acc_res_active AS acc_res_active_4, t0.acc_res_thmbnail_type AS acc_res_thmbnail_type_5, t0.acc_res_class AS acc_res_class_6, t0.site_lang AS site_lang_7, t0.site_uid AS site_uid_8 FROM site_reseaux t0 WHERE t0.acc_res_active = 1 AND t0.site_uid = 1 AND t0.site_lang = 'fr';

SELECT
  t0.id AS id_1,
  t0.carrier_id AS carrier_id_2,
  t0.country_id AS country_id_3,
  t0.shipfees_amount_ttc AS shipfees_amount_ttc_4,
  t0.shipfees_tva AS shipfees_tva_5,
  t0.shipfees_weight_max AS shipfees_weight_max_6,
  t0.shipfees_level AS shipfees_level_7
FROM
  eco_shippingfees t0
WHERE
  t0.carrier_id = ?
  AND t0.country_id = ?
ORDER BY
  t0.shipfees_level ASC,
  t0.shipfees_amount_ttc ASC

SELECT t0.id AS id_1, t0.carrier_id AS carrier_id_2, t0.country_id AS country_id_3, t0.shipfees_amount_ttc AS shipfees_amount_ttc_4, t0.shipfees_tva AS shipfees_tva_5, t0.shipfees_weight_max AS shipfees_weight_max_6, t0.shipfees_level AS shipfees_level_7 FROM eco_shippingfees t0 WHERE t0.carrier_id = 1 AND t0.country_id = 1 ORDER BY t0.shipfees_level ASC, t0.shipfees_amount_ttc ASC;

SELECT
  t0.id AS id_1,
  t0.carrier_id AS carrier_id_2,
  t0.country_id AS country_id_3,
  t0.shipfees_amount_ttc AS shipfees_amount_ttc_4,
  t0.shipfees_tva AS shipfees_tva_5,
  t0.shipfees_weight_max AS shipfees_weight_max_6,
  t0.shipfees_level AS shipfees_level_7
FROM
  eco_shippingfees t0
WHERE
  t0.country_id = ?
  AND t0.carrier_id = ?
  AND t0.shipfees_level IS NULL

SELECT t0.id AS id_1, t0.carrier_id AS carrier_id_2, t0.country_id AS country_id_3, t0.shipfees_amount_ttc AS shipfees_amount_ttc_4, t0.shipfees_tva AS shipfees_tva_5, t0.shipfees_weight_max AS shipfees_weight_max_6, t0.shipfees_level AS shipfees_level_7 FROM eco_shippingfees t0 WHERE t0.country_id = 1 AND t0.carrier_id = 1 AND t0.shipfees_level IS NULL;

SELECT
  shipfees_amount_ttc
FROM
  eco_shippingfees
WHERE
  carrier_id = :carrier_id
  AND country_id = :country_id
  AND shipfees_weight_max >= :totalWeightCart
  AND shipfees_level IS NULL
ORDER BY
  shipfees_weight_max ASC
LIMIT
  0, 1

SELECT shipfees_amount_ttc 
            FROM eco_shippingfees
            WHERE carrier_id = 1
            AND country_id = 1
            AND shipfees_weight_max >= 0
            AND shipfees_level IS NULL
            ORDER BY shipfees_weight_max ASC
            LIMIT 0,1
            ;

SELECT
  shipfees_level
FROM
  eco_shippingfees
WHERE
  shipfees_amount_ttc = 0
  AND shipfees_weight_max = 0
  AND country_id = :country_id
ORDER BY
  shipfees_level DESC
LIMIT
  0, 1

SELECT shipfees_level 
            FROM eco_shippingfees
            WHERE shipfees_amount_ttc = 0
            AND shipfees_weight_max = 0
            AND country_id = 1
            ORDER BY shipfees_level DESC
            LIMIT 0,1
            ;

SELECT
  *,
  page_id AS currentPage,
  (
    SELECT
      COUNT(*)
    FROM
      pages
    WHERE
      pparent = currentPage
  ) AS nbChild
FROM
  pages
WHERE
  plang = :langue
  AND psite = :uid_site
  AND penligne = 1
ORDER BY
  pordre

SELECT *, page_id AS currentPage,
            (SELECT COUNT(*) FROM pages WHERE pparent = currentPage) AS nbChild
            FROM pages
            WHERE plang = 'fr'
            AND psite = 1
            AND penligne = 1
            ORDER BY pordre
        ;

SELECT
  *,
  page_id AS currentPage,
  (
    SELECT
      COUNT(*)
    FROM
      pages
    WHERE
      pparent = currentPage
  ) AS nbChild
FROM
  pages
WHERE
  plang = :langue
  AND psite = :uid_site
  AND penligne = 1
  AND pparent = 0
ORDER BY
  pordre

SELECT *, page_id AS currentPage,
            (SELECT COUNT(*) FROM pages WHERE pparent = currentPage) AS nbChild
            FROM pages
            WHERE plang = 'fr'
            AND psite = 1
            AND penligne = 1
            AND pparent = 0
            ORDER BY pordre
        ;

SELECT
  *,
  id AS categ_id,
  (
    SELECT
      COUNT(*)
    FROM
      eco_categories
    WHERE
      categ_parent_id = categ_id
  ) AS nbChild
FROM
  eco_categories
WHERE
  categ_isonline = 1
  AND (
    (
      SELECT
        COUNT(*)
      FROM
        eco_products
      WHERE
        eco_products.category_id = eco_categories.id
        AND eco_products.prod_isonline = 1
    ) > 0
    OR (
      SELECT
        COUNT(*)
      FROM
        eco_categories
      WHERE
        eco_categories.categ_parent_id = eco_categories.id
    ) > 0
  )
  AND site_id = 1
ORDER BY
  categ_sequence ASC

SELECT *, id AS categ_id,
                    (SELECT COUNT(*) FROM eco_categories WHERE categ_parent_id = categ_id) AS nbChild
                    FROM eco_categories
                    WHERE categ_isonline = 1
                    AND ((SELECT COUNT(*) FROM eco_products WHERE eco_products.category_id = eco_categories.id AND eco_products.prod_isonline = 1) > 0 OR (SELECT COUNT(*) FROM eco_categories WHERE eco_categories.categ_parent_id = eco_categories.id) > 0)
                    AND site_id = 1
                    ORDER BY categ_sequence ASC
                ;

SELECT
  *,
  id AS currentID,
  act_cat_intitule AS actCatIntitule,
  (
    SELECT
      COUNT(*)
    FROM
      actualite
    WHERE
      act_categ_id = currentID
      AND act_enligne = 1
  ) AS nbActus
FROM
  actualite_categs
WHERE
  site_uid = :site_uid
  AND site_lang = :site_lang
ORDER BY
  act_cat_ordre ASC

SELECT * , id AS currentID, act_cat_intitule AS actCatIntitule,
                (SELECT COUNT(*) FROM actualite
                    WHERE act_categ_id = currentID AND act_enligne = 1) AS nbActus
            FROM actualite_categs
            WHERE site_uid = 1
            AND site_lang = 'fr'
            ORDER BY act_cat_ordre ASC
            ;

SELECT
  *,
  id AS currentID,
  act_cat_intitule AS actCatIntitule,
  (
    SELECT
      COUNT(*)
    FROM
      actualite
    WHERE
      act_categ_id = currentID
      AND act_enligne = 1
  ) AS nbActus
FROM
  actualite_categs
WHERE
  site_uid = :site_uid
  AND site_lang = :site_lang
ORDER BY
  act_cat_ordre ASC

SELECT * , id AS currentID, act_cat_intitule AS actCatIntitule,
                (SELECT COUNT(*) FROM actualite
                    WHERE act_categ_id = currentID AND act_enligne = 1) AS nbActus
            FROM actualite_categs
            WHERE site_uid = 1
            AND site_lang = 'fr'
            ORDER BY act_cat_ordre ASC
            ;

SELECT
  t0.page_id AS page_id_1,
  t0.pparent AS pparent_2,
  t0.permalien AS permalien_3,
  t0.pdate_creation AS pdate_creation_4,
  t0.pdate_lastupdate AS pdate_lastupdate_5,
  t0.purl_externe AS purl_externe_6,
  t0.purl_interne AS purl_interne_7,
  t0.pblank AS pblank_8,
  t0.ptype AS ptype_9,
  t0.ptitre AS ptitre_10,
  t0.ptitremenu AS ptitremenu_11,
  t0.ptitreonglet AS ptitreonglet_12,
  t0.pbandeau AS pbandeau_13,
  t0.penligne AS penligne_14,
  t0.pordre AS pordre_15,
  t0.plang AS plang_16,
  t0.psite AS psite_17,
  t0.seo_title AS seo_title_18,
  t0.seo_description AS seo_description_19,
  t0.seo_keywords AS seo_keywords_20,
  t0.pis_linkable AS pis_linkable_21,
  t0.pcacher_menu AS pcacher_menu_22,
  t0.penavant_menu AS penavant_menu_23,
  t0.ptitre_breton AS ptitre_breton_24,
  t0.ptitre_gallo AS ptitre_gallo_25,
  t0.ppath_interne AS ppath_interne_26
FROM
  pages t0
WHERE
  t0.purl_interne = ?
LIMIT
  1

SELECT t0.page_id AS page_id_1, t0.pparent AS pparent_2, t0.permalien AS permalien_3, t0.pdate_creation AS pdate_creation_4, t0.pdate_lastupdate AS pdate_lastupdate_5, t0.purl_externe AS purl_externe_6, t0.purl_interne AS purl_interne_7, t0.pblank AS pblank_8, t0.ptype AS ptype_9, t0.ptitre AS ptitre_10, t0.ptitremenu AS ptitremenu_11, t0.ptitreonglet AS ptitreonglet_12, t0.pbandeau AS pbandeau_13, t0.penligne AS penligne_14, t0.pordre AS pordre_15, t0.plang AS plang_16, t0.psite AS psite_17, t0.seo_title AS seo_title_18, t0.seo_description AS seo_description_19, t0.seo_keywords AS seo_keywords_20, t0.pis_linkable AS pis_linkable_21, t0.pcacher_menu AS pcacher_menu_22, t0.penavant_menu AS penavant_menu_23, t0.ptitre_breton AS ptitre_breton_24, t0.ptitre_gallo AS ptitre_gallo_25, t0.ppath_interne AS ppath_interne_26 FROM pages t0 WHERE t0.purl_interne = 'page' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.stock_management AS stock_management_2,
  t0.qty_product_order AS qty_product_order_3,
  t0.site_id AS site_id_4,
  t0.unavailable_product_no_stock AS unavailable_product_no_stock_5
FROM
  eco_settings t0
WHERE
  t0.site_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.stock_management AS stock_management_2, t0.qty_product_order AS qty_product_order_3, t0.site_id AS site_id_4, t0.unavailable_product_no_stock AS unavailable_product_no_stock_5 FROM eco_settings t0 WHERE t0.site_id = 1 LIMIT 1;

SELECT
  t0.page_id AS page_id_1,
  t0.pparent AS pparent_2,
  t0.permalien AS permalien_3,
  t0.pdate_creation AS pdate_creation_4,
  t0.pdate_lastupdate AS pdate_lastupdate_5,
  t0.purl_externe AS purl_externe_6,
  t0.purl_interne AS purl_interne_7,
  t0.pblank AS pblank_8,
  t0.ptype AS ptype_9,
  t0.ptitre AS ptitre_10,
  t0.ptitremenu AS ptitremenu_11,
  t0.ptitreonglet AS ptitreonglet_12,
  t0.pbandeau AS pbandeau_13,
  t0.penligne AS penligne_14,
  t0.pordre AS pordre_15,
  t0.plang AS plang_16,
  t0.psite AS psite_17,
  t0.seo_title AS seo_title_18,
  t0.seo_description AS seo_description_19,
  t0.seo_keywords AS seo_keywords_20,
  t0.pis_linkable AS pis_linkable_21,
  t0.pcacher_menu AS pcacher_menu_22,
  t0.penavant_menu AS penavant_menu_23,
  t0.ptitre_breton AS ptitre_breton_24,
  t0.ptitre_gallo AS ptitre_gallo_25,
  t0.ppath_interne AS ppath_interne_26
FROM
  pages t0
WHERE
  t0.permalien = ?
  AND t0.psite = ?
LIMIT
  1

SELECT t0.page_id AS page_id_1, t0.pparent AS pparent_2, t0.permalien AS permalien_3, t0.pdate_creation AS pdate_creation_4, t0.pdate_lastupdate AS pdate_lastupdate_5, t0.purl_externe AS purl_externe_6, t0.purl_interne AS purl_interne_7, t0.pblank AS pblank_8, t0.ptype AS ptype_9, t0.ptitre AS ptitre_10, t0.ptitremenu AS ptitremenu_11, t0.ptitreonglet AS ptitreonglet_12, t0.pbandeau AS pbandeau_13, t0.penligne AS penligne_14, t0.pordre AS pordre_15, t0.plang AS plang_16, t0.psite AS psite_17, t0.seo_title AS seo_title_18, t0.seo_description AS seo_description_19, t0.seo_keywords AS seo_keywords_20, t0.pis_linkable AS pis_linkable_21, t0.pcacher_menu AS pcacher_menu_22, t0.penavant_menu AS penavant_menu_23, t0.ptitre_breton AS ptitre_breton_24, t0.ptitre_gallo AS ptitre_gallo_25, t0.ppath_interne AS ppath_interne_26 FROM pages t0 WHERE t0.permalien = 'thermes' AND t0.psite = 1 LIMIT 1;

SELECT
  *,
  bloc_id AS ID,
  (
    SELECT
      media_fichier
    FROM
      pages_medias
    WHERE
      id_bloc = ID
    LIMIT
      0, 1
  ) AS media_fichier
FROM
  pages_blocs
WHERE
  id_page = :id
  AND element_type = :elementType
ORDER BY
  bloc_ordre ASC

SELECT * , bloc_id AS ID, 
            (SELECT media_fichier FROM pages_medias WHERE id_bloc = ID LIMIT 0,1) AS media_fichier
            FROM pages_blocs
            WHERE id_page = 82
            AND element_type = 'page'
            ORDER BY bloc_ordre ASC        
        ;

SELECT
  *
FROM
  pages_medias
WHERE
  id_bloc = :bloc_id149
  OR id_bloc = :bloc_id150
  OR id_bloc = :bloc_id240
  OR id_bloc = :bloc_id239
ORDER BY
  media_ordre ASC

SELECT * FROM pages_medias
                WHERE  id_bloc = '149' OR  id_bloc = '150' OR  id_bloc = '240' OR  id_bloc = '239' 
                ORDER BY media_ordre ASC
            ;

SELECT
  *
FROM
  pages_medias
WHERE
  id_bloc = :bloc_id149
  OR id_bloc = :bloc_id150
  OR id_bloc = :bloc_id240
  OR id_bloc = :bloc_id239
ORDER BY
  media_ordre ASC

SELECT * FROM pages_medias
                WHERE  id_bloc = '149' OR  id_bloc = '150' OR  id_bloc = '240' OR  id_bloc = '239' 
                ORDER BY media_ordre ASC
            ;

SELECT
  *
FROM
  pages_medias
WHERE
  id_bloc = :bloc_id149
  OR id_bloc = :bloc_id150
  OR id_bloc = :bloc_id240
  OR id_bloc = :bloc_id239
ORDER BY
  media_ordre ASC

SELECT * FROM pages_medias
                WHERE  id_bloc = '149' OR  id_bloc = '150' OR  id_bloc = '240' OR  id_bloc = '239' 
                ORDER BY media_ordre ASC
            ;

SELECT
  *
FROM
  pages_medias
WHERE
  id_bloc = :bloc_id149
  OR id_bloc = :bloc_id150
  OR id_bloc = :bloc_id240
  OR id_bloc = :bloc_id239
ORDER BY
  media_ordre ASC

SELECT * FROM pages_medias
                WHERE  id_bloc = '149' OR  id_bloc = '150' OR  id_bloc = '240' OR  id_bloc = '239' 
                ORDER BY media_ordre ASC
            ;

SELECT
  *,
  bloc_id AS ID,
  (
    SELECT
      media_fichier
    FROM
      pages_medias
    WHERE
      id_bloc = ID
    LIMIT
      0, 1
  ) AS media_fichier
FROM
  pages_blocs
WHERE
  id_page = :id
  AND element_type = :elementType
ORDER BY
  bloc_ordre ASC

SELECT * , bloc_id AS ID, 
            (SELECT media_fichier FROM pages_medias WHERE id_bloc = ID LIMIT 0,1) AS media_fichier
            FROM pages_blocs
            WHERE id_page = 82
            AND element_type = 'page'
            ORDER BY bloc_ordre ASC        
        ;

SELECT
  *
FROM
  pages_medias
WHERE
  id_bloc = :bloc_id149
  OR id_bloc = :bloc_id150
  OR id_bloc = :bloc_id240
  OR id_bloc = :bloc_id239
ORDER BY
  media_ordre ASC

SELECT * FROM pages_medias
                WHERE  id_bloc = '149' OR  id_bloc = '150' OR  id_bloc = '240' OR  id_bloc = '239' 
                ORDER BY media_ordre ASC
            ;

SELECT
  *
FROM
  pages_medias
WHERE
  id_bloc = :bloc_id149
  OR id_bloc = :bloc_id150
  OR id_bloc = :bloc_id240
  OR id_bloc = :bloc_id239
ORDER BY
  media_ordre ASC

SELECT * FROM pages_medias
                WHERE  id_bloc = '149' OR  id_bloc = '150' OR  id_bloc = '240' OR  id_bloc = '239' 
                ORDER BY media_ordre ASC
            ;

SELECT
  *
FROM
  pages_medias
WHERE
  id_bloc = :bloc_id149
  OR id_bloc = :bloc_id150
  OR id_bloc = :bloc_id240
  OR id_bloc = :bloc_id239
ORDER BY
  media_ordre ASC

SELECT * FROM pages_medias
                WHERE  id_bloc = '149' OR  id_bloc = '150' OR  id_bloc = '240' OR  id_bloc = '239' 
                ORDER BY media_ordre ASC
            ;

SELECT
  *
FROM
  pages_medias
WHERE
  id_bloc = :bloc_id149
  OR id_bloc = :bloc_id150
  OR id_bloc = :bloc_id240
  OR id_bloc = :bloc_id239
ORDER BY
  media_ordre ASC

SELECT * FROM pages_medias
                WHERE  id_bloc = '149' OR  id_bloc = '150' OR  id_bloc = '240' OR  id_bloc = '239' 
                ORDER BY media_ordre ASC
            ;

SELECT
  *,
  bloc_id AS ID,
  (
    SELECT
      media_fichier
    FROM
      pages_medias
    WHERE
      id_bloc = ID
    LIMIT
      0, 1
  ) AS media_fichier
FROM
  pages_blocs
WHERE
  id_page = :id
  AND element_type = :elementType
ORDER BY
  bloc_ordre ASC

SELECT * , bloc_id AS ID, 
            (SELECT media_fichier FROM pages_medias WHERE id_bloc = ID LIMIT 0,1) AS media_fichier
            FROM pages_blocs
            WHERE id_page = 82
            AND element_type = 'page'
            ORDER BY bloc_ordre ASC        
        ;

SELECT
  t0.id AS id_1,
  t0.abc_parent_category_id AS abc_parent_category_id_2,
  t0.abc_entitled AS abc_entitled_3,
  t0.abc_headband AS abc_headband_4,
  t0.abc_site_uid AS abc_site_uid_5,
  t0.abc_site_lang AS abc_site_lang_6,
  t0.abc_order AS abc_order_7
FROM
  address_book_category t0
WHERE
  t0.abc_site_uid = ?
ORDER BY
  t0.abc_order ASC

SELECT t0.id AS id_1, t0.abc_parent_category_id AS abc_parent_category_id_2, t0.abc_entitled AS abc_entitled_3, t0.abc_headband AS abc_headband_4, t0.abc_site_uid AS abc_site_uid_5, t0.abc_site_lang AS abc_site_lang_6, t0.abc_order AS abc_order_7 FROM address_book_category t0 WHERE t0.abc_site_uid = 1 ORDER BY t0.abc_order ASC;

SELECT
  *,
  address_book.id AS ab_id
FROM
  address_book
  JOIN address_book_category ON address_book_category.id = address_book.ab_category_id
WHERE
  address_book.ab_site_uid = :site_uid
  AND address_book.ab_site_lang = :site_lang
  AND ab_is_online = 1

SELECT *, address_book.id AS ab_id 
            FROM address_book
            JOIN address_book_category ON address_book_category.id = address_book.ab_category_id
            WHERE address_book.ab_site_uid = 1
            AND address_book.ab_site_lang = 'fr'
            AND ab_is_online = 1 ;