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_autopromo' ORDER BY t0.option_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.id = ?

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.id = '19';