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 = 1 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 = 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
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
  *
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 = 1
                ORDER BY lang_entitled ASC
            ;

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