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.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 = '2' 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 = ?
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 = '2' 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 = 2 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
  *
FROM
  site_lang
  JOIN language ON language.id = site_lang.site_lang
WHERE
  site_lang.site_id = :site_id
ORDER BY
  lang_entitled ASC

SELECT *  
                FROM site_lang
                JOIN language ON language.id = site_lang.site_lang
                WHERE site_lang.site_id = '2'
                ORDER BY lang_entitled ASC
            ;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.creation_datetime AS creation_datetime_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.phone AS phone_8,
  t0.mobile AS mobile_9,
  t0.reset_token AS reset_token_10,
  t0.is_archive AS is_archive_11
FROM
  auth_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.creation_datetime AS creation_datetime_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.phone AS phone_8, t0.mobile AS mobile_9, t0.reset_token AS reset_token_10, t0.is_archive AS is_archive_11 FROM auth_user t0 WHERE t0.id = 29;

SELECT
  *
FROM
  auth_group

SELECT * 
            FROM auth_group
        ;

SELECT
  site.*,
  auth_group_site.ags_group_id,
  auth_group_site.ags_site_id
FROM
  site
  JOIN auth_group_site ON auth_group_site.ags_site_id = site.id
WHERE
  ags_group_id IN (7, 8)
GROUP BY
  site.id
ORDER BY
  site.site_name ASC

SELECT site.*, auth_group_site.ags_group_id, auth_group_site.ags_site_id
            FROM site
            JOIN auth_group_site ON auth_group_site.ags_site_id = site.id
            WHERE ags_group_id IN (7,8)
            GROUP BY site.id
            ORDER BY site.site_name ASC
        ;

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 = '2' LIMIT 1;

SELECT
  *
FROM
  auth_group

SELECT * 
            FROM auth_group
        ;

SELECT
  *
FROM
  auth_group_module
  JOIN module ON module.id = auth_group_module.agm_module_id
  JOIN site_module ON site_module.module_id = module.id
WHERE
  auth_group_module.agm_group_id IN (7, 8)
  AND site_module.site_id = 2
GROUP BY
  module.id
ORDER BY
  module.mod_ordre ASC

SELECT * 
            FROM auth_group_module
            JOIN module ON module.id = auth_group_module.agm_module_id 
            JOIN site_module ON site_module.module_id = module.id
            WHERE auth_group_module.agm_group_id IN (7,8)
            AND site_module.site_id = 2
            GROUP BY module.id
            ORDER BY module.mod_ordre ASC
        ;

SELECT
  module.*,
  auth_group.ag_role
FROM
  module
  JOIN auth_group_module ON module.id = auth_group_module.agm_module_id
  JOIN auth_group ON auth_group.id = auth_group_module.agm_group_id
WHERE
  auth_group.ag_role != 'ROLE_SUPER_ADMIN'
ORDER BY
  module.mod_ordre ASC

SELECT module.*, auth_group.ag_role
            FROM module
            JOIN auth_group_module
            ON module.id = auth_group_module.agm_module_id 
            JOIN auth_group
            ON auth_group.id = auth_group_module.agm_group_id
            WHERE auth_group.ag_role != 'ROLE_SUPER_ADMIN' 
            ORDER BY module.mod_ordre ASC
        ;

SELECT
  *
FROM
  module
ORDER BY
  mod_ordre ASC

SELECT *
            FROM module 
            ORDER BY mod_ordre ASC
        ;

SELECT
  module.*
FROM
  module
  JOIN auth_group_module ON module.id = auth_group_module.agm_module_id
  JOIN auth_group ON auth_group.id = auth_group_module.agm_group_id
WHERE
  auth_group.ag_role = 'ROLE_SUPER_ADMIN'

SELECT module.*
            FROM module
            JOIN auth_group_module
            ON module.id = auth_group_module.agm_module_id 
            JOIN auth_group
            ON auth_group.id = auth_group_module.agm_group_id
            WHERE auth_group.ag_role = 'ROLE_SUPER_ADMIN'
        ;

SELECT
  COUNT(*) AS nbMessUnread
FROM
  tchat_messages
  JOIN tchat ON tchat.id = tchat_messages.tchat_id
WHERE
  mess_read = 0
  AND tchat_messages.user_id = 0
  AND tchat_status = 'open'

SELECT COUNT(*) AS nbMessUnread
            FROM tchat_messages 
            JOIN tchat ON tchat.id = tchat_messages.tchat_id
            WHERE mess_read = 0 
            AND tchat_messages.user_id = 0
            AND tchat_status = 'open'
        ;

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 = '2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.option_name AS option_name_2,
  t0.option_entitled AS option_entitled_3,
  t0.option_value AS option_value_4,
  t0.option_order AS option_order_5,
  t0.option_code_interne AS option_code_interne_6
FROM
  options t0
WHERE
  t0.option_name = ?
ORDER BY
  t0.option_order ASC

SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_entitled AS option_entitled_3, t0.option_value AS option_value_4, t0.option_order AS option_order_5, t0.option_code_interne AS option_code_interne_6 FROM options t0 WHERE t0.option_name = 'admin_products' ORDER BY t0.option_order ASC;

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 = '2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.category_id AS category_id_2,
  t0.provider_id AS provider_id_3,
  t0.mark_id AS mark_id_4,
  t0.prod_creation_date AS prod_creation_date_5,
  t0.prod_type AS prod_type_6,
  t0.prod_model AS prod_model_7,
  t0.prod_picture AS prod_picture_8,
  t0.prod_description AS prod_description_9,
  t0.prod_selling_price AS prod_selling_price_10,
  t0.prod_reference_price AS prod_reference_price_11,
  t0.prod_price_type AS prod_price_type_12,
  t0.prod_novelty AS prod_novelty_13,
  t0.prod_soon AS prod_soon_14,
  t0.prod_isonline AS prod_isonline_15,
  t0.prod_meta AS prod_meta_16,
  t0.prod_title AS prod_title_17,
  t0.prod_keywords AS prod_keywords_18,
  t0.prod_ingredient AS prod_ingredient_19,
  t0.prod_conservation AS prod_conservation_20,
  t0.prod_feature AS prod_feature_21,
  t0.prod_nbr_ventes AS prod_nbr_ventes_22,
  t0.price_kg_is_visible AS price_kg_is_visible_23,
  t0.site_id AS site_id_24,
  t0.is_deliverable AS is_deliverable_25,
  t0.provider_id AS provider_id_26
FROM
  eco_products t0
WHERE
  t0.site_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.provider_id AS provider_id_3, t0.mark_id AS mark_id_4, t0.prod_creation_date AS prod_creation_date_5, t0.prod_type AS prod_type_6, t0.prod_model AS prod_model_7, t0.prod_picture AS prod_picture_8, t0.prod_description AS prod_description_9, t0.prod_selling_price AS prod_selling_price_10, t0.prod_reference_price AS prod_reference_price_11, t0.prod_price_type AS prod_price_type_12, t0.prod_novelty AS prod_novelty_13, t0.prod_soon AS prod_soon_14, t0.prod_isonline AS prod_isonline_15, t0.prod_meta AS prod_meta_16, t0.prod_title AS prod_title_17, t0.prod_keywords AS prod_keywords_18, t0.prod_ingredient AS prod_ingredient_19, t0.prod_conservation AS prod_conservation_20, t0.prod_feature AS prod_feature_21, t0.prod_nbr_ventes AS prod_nbr_ventes_22, t0.price_kg_is_visible AS price_kg_is_visible_23, t0.site_id AS site_id_24, t0.is_deliverable AS is_deliverable_25, t0.provider_id AS provider_id_26 FROM eco_products t0 WHERE t0.site_id = '2' ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.ref_entitled AS ref_entitled_3,
  t0.ref_reference AS ref_reference_4,
  t0.ref_price_type AS ref_price_type_5,
  t0.ref_reference_price AS ref_reference_price_6,
  t0.ref_buying_price AS ref_buying_price_7,
  t0.ref_selling_price AS ref_selling_price_8,
  t0.ref_promo_price AS ref_promo_price_9,
  t0.ref_solde_price AS ref_solde_price_10,
  t0.ref_tva AS ref_tva_11,
  t0.ref_weight AS ref_weight_12,
  t0.ref_quantity AS ref_quantity_13,
  t0.is_reservable AS is_reservable_14,
  t0.ref_out_of_order AS ref_out_of_order_15,
  t0.ref_sequence AS ref_sequence_16,
  t0.ref_lastupdate_date AS ref_lastupdate_date_17,
  t0.stock_alert AS stock_alert_18,
  t0.type_odyssee AS type_odyssee_19,
  t0.max_by_order AS max_by_order_20
FROM
  eco_products_references t0

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.ref_entitled AS ref_entitled_3, t0.ref_reference AS ref_reference_4, t0.ref_price_type AS ref_price_type_5, t0.ref_reference_price AS ref_reference_price_6, t0.ref_buying_price AS ref_buying_price_7, t0.ref_selling_price AS ref_selling_price_8, t0.ref_promo_price AS ref_promo_price_9, t0.ref_solde_price AS ref_solde_price_10, t0.ref_tva AS ref_tva_11, t0.ref_weight AS ref_weight_12, t0.ref_quantity AS ref_quantity_13, t0.is_reservable AS is_reservable_14, t0.ref_out_of_order AS ref_out_of_order_15, t0.ref_sequence AS ref_sequence_16, t0.ref_lastupdate_date AS ref_lastupdate_date_17, t0.stock_alert AS stock_alert_18, t0.type_odyssee AS type_odyssee_19, t0.max_by_order AS max_by_order_20 FROM eco_products_references t0;

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 = 2
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 = 2
                    ORDER BY categ_sequence ASC
                ;