Symfony Profiler

SELECT
  *,
  eco_products.id AS prod_id,
  eco_products_references.id AS ref_id,
  (
    SELECT
      SUM(op_qte)
    FROM
      eco_orders_products
      JOIN eco_products_references ON eco_products_references.id = eco_orders_products.reference_id
    WHERE
      eco_products_references.product_id = prod_id
  ) AS salesCount
FROM
  eco_products
  JOIN eco_products_references ON eco_products_references.product_id = eco_products.id
  JOIN eco_categories ON eco_categories.id = eco_products.category_id
  JOIN eco_providers ON eco_providers.id = eco_products.provider_id
WHERE
  prod_isonline = 1
GROUP BY
  eco_products.id
ORDER BY
  eco_products.prod_nbr_ventes DESC
LIMIT
  3

SELECT *, eco_products.id AS prod_id, eco_products_references.id AS ref_id,
             (SELECT SUM(op_qte) FROM eco_orders_products 
             JOIN eco_products_references ON eco_products_references.id = eco_orders_products.reference_id
                WHERE eco_products_references.product_id = prod_id) AS salesCount
            FROM eco_products
            JOIN eco_products_references ON eco_products_references.product_id = eco_products.id
            JOIN eco_categories ON eco_categories.id = eco_products.category_id
            JOIN eco_providers ON eco_providers.id = eco_products.provider_id
            WHERE prod_isonline = 1
            GROUP BY eco_products.id
             ORDER BY eco_products.prod_nbr_ventes DESC
            LIMIT 3
                        
        ;

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
  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;

DELETE FROM
  contact_historique
WHERE
  creation_datetime < ?

DELETE FROM contact_historique WHERE creation_datetime < '2023-04-02 02:40:55';

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
  t0.id AS id_1,
  t0.title AS title_2,
  t0.subtitle AS subtitle_3,
  t0.image AS image_4,
  t0.section AS section_5,
  t0.url AS url_6,
  t0.is_online AS is_online_7,
  t0.is_blank AS is_blank_8,
  t0.autopromo_order AS autopromo_order_9,
  t0.position AS position_10,
  t0.image_alt AS image_alt_11,
  t0.creation_datetime AS creation_datetime_12,
  t0.site_uid AS site_uid_13,
  t0.site_lang AS site_lang_14,
  t0.texte_bouton AS texte_bouton_15
FROM
  autopromo t0
WHERE
  t0.is_online = ?
  AND t0.site_lang = ?
  AND t0.site_uid = ?
ORDER BY
  t0.autopromo_order ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.image AS image_4, t0.section AS section_5, t0.url AS url_6, t0.is_online AS is_online_7, t0.is_blank AS is_blank_8, t0.autopromo_order AS autopromo_order_9, t0.position AS position_10, t0.image_alt AS image_alt_11, t0.creation_datetime AS creation_datetime_12, t0.site_uid AS site_uid_13, t0.site_lang AS site_lang_14, t0.texte_bouton AS texte_bouton_15 FROM autopromo t0 WHERE t0.is_online = 1 AND t0.site_lang = 'fr' AND t0.site_uid = 1 ORDER BY t0.autopromo_order 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,
  cat_illustration_fichier AS media_fichier
FROM
  catalog
WHERE
  cat_enligne = 1
  AND is_sell = 1
  AND site_lang = :site_lang
  AND site_uid = :site_uid
ORDER BY
  cat_datecreation DESC

SELECT *, id AS currentID, cat_illustration_fichier AS media_fichier
            FROM catalog
            
            WHERE cat_enligne = 1 
            
             AND is_sell = 1 
            AND site_lang = 'fr'
            AND site_uid = 1
            ORDER BY cat_datecreation DESC
            
        ;

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.flash_message AS flash_message_2,
  t0.flash_url AS flash_url_3,
  t0.flash_ordre AS flash_ordre_4,
  t0.flash_enligne AS flash_enligne_5,
  t0.site_uid AS site_uid_6,
  t0.site_lang AS site_lang_7
FROM
  flash_message t0
WHERE
  t0.flash_enligne = ?
  AND t0.site_lang = ?
  AND t0.site_uid = ?
ORDER BY
  t0.flash_ordre ASC

SELECT t0.id AS id_1, t0.flash_message AS flash_message_2, t0.flash_url AS flash_url_3, t0.flash_ordre AS flash_ordre_4, t0.flash_enligne AS flash_enligne_5, t0.site_uid AS site_uid_6, t0.site_lang AS site_lang_7 FROM flash_message t0 WHERE t0.flash_enligne = 1 AND t0.site_lang = 'fr' AND t0.site_uid = 1 ORDER BY t0.flash_ordre ASC;

SELECT
  *,
  eco_products.id AS prod_id,
  eco_products_references.id AS ref_id,
  (
    SELECT
      SUM(op_qte)
    FROM
      eco_orders_products
      JOIN eco_products_references ON eco_products_references.id = eco_orders_products.reference_id
    WHERE
      eco_products_references.product_id = prod_id
  ) AS salesCount
FROM
  eco_products
  JOIN eco_products_references ON eco_products_references.product_id = eco_products.id
  JOIN eco_categories ON eco_categories.id = eco_products.category_id
  JOIN eco_providers ON eco_providers.id = eco_products.provider_id
WHERE
  eco_products.prod_novelty = 1
  AND prod_isonline = 1
GROUP BY
  eco_products.id
ORDER BY
  salesCount DESC,
  prod_reference_price ASC
LIMIT
  3

SELECT *, eco_products.id AS prod_id, eco_products_references.id AS ref_id,
             (SELECT SUM(op_qte) FROM eco_orders_products 
             JOIN eco_products_references ON eco_products_references.id = eco_orders_products.reference_id
                WHERE eco_products_references.product_id = prod_id) AS salesCount
            FROM eco_products
            JOIN eco_products_references ON eco_products_references.product_id = eco_products.id
            JOIN eco_categories ON eco_categories.id = eco_products.category_id
            JOIN eco_providers ON eco_providers.id = eco_products.provider_id
            WHERE eco_products.prod_novelty = 1
            AND prod_isonline = 1
            GROUP BY eco_products.id
             ORDER BY salesCount DESC, prod_reference_price ASC
            LIMIT 3
        ;

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
  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.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.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.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.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.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 = '' 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.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.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.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.page_id = ?
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.page_id = 142 LIMIT 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
  *,
  id AS currentID,
  act_illustration_fichier AS media_fichier
FROM
  actualite
WHERE
  act_enligne = 1
  AND site_lang = :site_lang
  AND site_uid = :site_uid
ORDER BY
  act_date_publication DESC

SELECT *, id AS currentID, act_illustration_fichier AS media_fichier
            FROM actualite
            
            WHERE act_enligne = 1 
            
            AND site_lang = 'fr'
            AND site_uid = 1
            ORDER BY act_date_publication DESC
            
        ;

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.id = ?
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.id = 1 LIMIT 1;

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
  *,
  id AS currentID,
  cat_illustration_fichier AS media_fichier
FROM
  catalog
WHERE
  cat_enligne = 1
  AND is_sell = 2
  AND site_lang = :site_lang
  AND site_uid = :site_uid
ORDER BY
  cat_datecreation DESC

SELECT *, id AS currentID, cat_illustration_fichier AS media_fichier
            FROM catalog
            
            WHERE cat_enligne = 1 
            
             AND is_sell = 2 
            AND site_lang = 'fr'
            AND site_uid = 1
            ORDER BY cat_datecreation DESC
            
        ;