Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3,
  t0.description AS description_4,
  t0.priority AS priority_5,
  t0.category_id AS category_id_6
FROM
  til_permission t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM til_permission t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.country_code AS country_code_2,
  t0.phone AS phone_3,
  t0.fax AS fax_4,
  t0.mobile AS mobile_5,
  t0.address AS address_6,
  t0.zip AS zip_7,
  t0.other_city AS other_city_8,
  t0.other_province AS other_province_9,
  t0.avatar AS avatar_10,
  t0.user_id AS user_id_11,
  t0.city_id AS city_id_12,
  t0.user_profession_id AS user_profession_id_13
FROM
  til_user_profile t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.avatar AS avatar_10, t0.user_id AS user_id_11, t0.city_id AS city_id_12, t0.user_profession_id AS user_profession_id_13 FROM til_user_profile t0 WHERE t0.user_id = '35';

SELECT
  t0.id AS id_1,
  t0.residue_rol AS residue_rol_2,
  t0.residue_holiday AS residue_holiday_3,
  t0.datetime_start_work AS datetime_start_work_4,
  t0.datetime_end_work AS datetime_end_work_5,
  t0.show_in_list AS show_in_list_6,
  t0.user_id AS user_id_7,
  t0.supervisor_id AS supervisor_id_8
FROM
  til_employee t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.datetime_start_work AS datetime_start_work_4, t0.datetime_end_work AS datetime_end_work_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7, t0.supervisor_id AS supervisor_id_8 FROM til_employee t0 WHERE t0.user_id = '35';

SELECT
  t0.id AS id_1,
  t0.datetime_last_update AS datetime_last_update_2,
  t0.is_terms_accepted AS is_terms_accepted_3,
  t0.is_news_accepted AS is_news_accepted_4,
  t0.user_id AS user_id_5
FROM
  til_user_privacy t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.datetime_last_update AS datetime_last_update_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_user_privacy t0 WHERE t0.user_id = '35';

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3,
  t0.priority AS priority_4
FROM
  til_permission_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM til_permission_category t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.surname AS surname_4,
  t0.password AS password_5,
  t0.directory_path AS directory_path_6,
  t0.one_time_code AS one_time_code_7,
  t0.role AS role_8,
  t0.expiration_one_time_code AS expiration_one_time_code_9,
  t0.office_hours AS office_hours_10,
  t0.is_active AS is_active_11,
  t0.is_admin_active AS is_admin_active_12,
  t0.is_email_notification_active AS is_email_notification_active_13,
  t0.is_alert_read AS is_alert_read_14,
  t0.is_gdpr_sent AS is_gdpr_sent_15,
  t16.id AS id_17,
  t16.datetime_last_update AS datetime_last_update_18,
  t16.is_terms_accepted AS is_terms_accepted_19,
  t16.is_news_accepted AS is_news_accepted_20,
  t16.user_id AS user_id_21,
  t22.id AS id_23,
  t22.country_code AS country_code_24,
  t22.phone AS phone_25,
  t22.fax AS fax_26,
  t22.mobile AS mobile_27,
  t22.address AS address_28,
  t22.zip AS zip_29,
  t22.other_city AS other_city_30,
  t22.other_province AS other_province_31,
  t22.avatar AS avatar_32,
  t22.user_id AS user_id_33,
  t22.city_id AS city_id_34,
  t22.user_profession_id AS user_profession_id_35,
  t36.id AS id_37,
  t36.residue_rol AS residue_rol_38,
  t36.residue_holiday AS residue_holiday_39,
  t36.datetime_start_work AS datetime_start_work_40,
  t36.datetime_end_work AS datetime_end_work_41,
  t36.show_in_list AS show_in_list_42,
  t36.user_id AS user_id_43,
  t36.supervisor_id AS supervisor_id_44,
  t0.account_type_id AS account_type_id_45
FROM
  til_user t0
  LEFT JOIN til_user_privacy t16 ON t16.user_id = t0.id
  LEFT JOIN til_user_profile t22 ON t22.user_id = t0.id
  LEFT JOIN til_employee t36 ON t36.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.password AS password_5, t0.directory_path AS directory_path_6, t0.one_time_code AS one_time_code_7, t0.role AS role_8, t0.expiration_one_time_code AS expiration_one_time_code_9, t0.office_hours AS office_hours_10, t0.is_active AS is_active_11, t0.is_admin_active AS is_admin_active_12, t0.is_email_notification_active AS is_email_notification_active_13, t0.is_alert_read AS is_alert_read_14, t0.is_gdpr_sent AS is_gdpr_sent_15, t16.id AS id_17, t16.datetime_last_update AS datetime_last_update_18, t16.is_terms_accepted AS is_terms_accepted_19, t16.is_news_accepted AS is_news_accepted_20, t16.user_id AS user_id_21, t22.id AS id_23, t22.country_code AS country_code_24, t22.phone AS phone_25, t22.fax AS fax_26, t22.mobile AS mobile_27, t22.address AS address_28, t22.zip AS zip_29, t22.other_city AS other_city_30, t22.other_province AS other_province_31, t22.avatar AS avatar_32, t22.user_id AS user_id_33, t22.city_id AS city_id_34, t22.user_profession_id AS user_profession_id_35, t36.id AS id_37, t36.residue_rol AS residue_rol_38, t36.residue_holiday AS residue_holiday_39, t36.datetime_start_work AS datetime_start_work_40, t36.datetime_end_work AS datetime_end_work_41, t36.show_in_list AS show_in_list_42, t36.user_id AS user_id_43, t36.supervisor_id AS supervisor_id_44, t0.account_type_id AS account_type_id_45 FROM til_user t0 LEFT JOIN til_user_privacy t16 ON t16.user_id = t0.id LEFT JOIN til_user_profile t22 ON t22.user_id = t0.id LEFT JOIN til_employee t36 ON t36.user_id = t0.id WHERE t0.id = '2';

SELECT
  t0_.id AS id_0,
  t0_.email AS email_1,
  t0_.name AS name_2,
  t0_.surname AS surname_3,
  t0_.password AS password_4,
  t0_.directory_path AS directory_path_5,
  t0_.one_time_code AS one_time_code_6,
  t0_.role AS role_7,
  t0_.expiration_one_time_code AS expiration_one_time_code_8,
  t0_.office_hours AS office_hours_9,
  t0_.is_active AS is_active_10,
  t0_.is_admin_active AS is_admin_active_11,
  t0_.is_email_notification_active AS is_email_notification_active_12,
  t0_.is_alert_read AS is_alert_read_13,
  t0_.is_gdpr_sent AS is_gdpr_sent_14,
  t0_.account_type_id AS account_type_id_15
FROM
  til_user t0_
  LEFT JOIN til_user_account_type t1_ ON t0_.account_type_id = t1_.id
  LEFT JOIN til_user_profile t2_ ON t0_.id = t2_.user_id
  LEFT JOIN til_employee t3_ ON t0_.id = t3_.user_id
WHERE
  t3_.show_in_list = 1
  AND t0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  t0_.is_admin_active DESC

SELECT t0_.id AS id_0, t0_.email AS email_1, t0_.name AS name_2, t0_.surname AS surname_3, t0_.password AS password_4, t0_.directory_path AS directory_path_5, t0_.one_time_code AS one_time_code_6, t0_.role AS role_7, t0_.expiration_one_time_code AS expiration_one_time_code_8, t0_.office_hours AS office_hours_9, t0_.is_active AS is_active_10, t0_.is_admin_active AS is_admin_active_11, t0_.is_email_notification_active AS is_email_notification_active_12, t0_.is_alert_read AS is_alert_read_13, t0_.is_gdpr_sent AS is_gdpr_sent_14, t0_.account_type_id AS account_type_id_15 FROM til_user t0_ LEFT JOIN til_user_account_type t1_ ON t0_.account_type_id = t1_.id LEFT JOIN til_user_profile t2_ ON t0_.id = t2_.user_id LEFT JOIN til_employee t3_ ON t0_.id = t3_.user_id WHERE t3_.show_in_list = 1 AND t0_.id IN ('1940', '2187', '2191', '816', '2', '1174', '24', '1348', '1481', '29', '33', '1746', '1748', '35', '1844', '1845', '37', '1867', '39', '1926') ORDER BY t0_.is_admin_active DESC;

SELECT
  t0_.id AS id_0,
  t0_.email AS email_1,
  t0_.name AS name_2,
  t0_.surname AS surname_3,
  t0_.password AS password_4,
  t0_.directory_path AS directory_path_5,
  t0_.one_time_code AS one_time_code_6,
  t0_.role AS role_7,
  t0_.expiration_one_time_code AS expiration_one_time_code_8,
  t0_.office_hours AS office_hours_9,
  t0_.is_active AS is_active_10,
  t0_.is_admin_active AS is_admin_active_11,
  t0_.is_email_notification_active AS is_email_notification_active_12,
  t0_.is_alert_read AS is_alert_read_13,
  t0_.is_gdpr_sent AS is_gdpr_sent_14,
  t0_.account_type_id AS account_type_id_15
FROM
  til_user t0_
  LEFT JOIN til_user_account_type t1_ ON t0_.account_type_id = t1_.id
  LEFT JOIN til_user_profile t2_ ON t0_.id = t2_.user_id
  LEFT JOIN til_employee t3_ ON t0_.id = t3_.user_id
WHERE
  t3_.show_in_list = 1
ORDER BY
  t0_.is_admin_active DESC

SELECT t0_.id AS id_0, t0_.email AS email_1, t0_.name AS name_2, t0_.surname AS surname_3, t0_.password AS password_4, t0_.directory_path AS directory_path_5, t0_.one_time_code AS one_time_code_6, t0_.role AS role_7, t0_.expiration_one_time_code AS expiration_one_time_code_8, t0_.office_hours AS office_hours_9, t0_.is_active AS is_active_10, t0_.is_admin_active AS is_admin_active_11, t0_.is_email_notification_active AS is_email_notification_active_12, t0_.is_alert_read AS is_alert_read_13, t0_.is_gdpr_sent AS is_gdpr_sent_14, t0_.account_type_id AS account_type_id_15 FROM til_user t0_ LEFT JOIN til_user_account_type t1_ ON t0_.account_type_id = t1_.id LEFT JOIN til_user_profile t2_ ON t0_.id = t2_.user_id LEFT JOIN til_employee t3_ ON t0_.id = t3_.user_id WHERE t3_.show_in_list = 1 ORDER BY t0_.is_admin_active DESC;

SELECT
  count(DISTINCT t0_.id) AS sclr_0
FROM
  til_user t0_
  LEFT JOIN til_user_account_type t1_ ON t0_.account_type_id = t1_.id
  LEFT JOIN til_user_profile t2_ ON t0_.id = t2_.user_id
  LEFT JOIN til_employee t3_ ON t0_.id = t3_.user_id
WHERE
  t3_.show_in_list = 1

SELECT count(DISTINCT t0_.id) AS sclr_0 FROM til_user t0_ LEFT JOIN til_user_account_type t1_ ON t0_.account_type_id = t1_.id LEFT JOIN til_user_profile t2_ ON t0_.id = t2_.user_id LEFT JOIN til_employee t3_ ON t0_.id = t3_.user_id WHERE t3_.show_in_list = 1;

SELECT
  t0_.id AS id_0,
  t0_.residue_rol AS residue_rol_1,
  t0_.residue_holiday AS residue_holiday_2,
  t0_.datetime_start_work AS datetime_start_work_3,
  t0_.datetime_end_work AS datetime_end_work_4,
  t0_.show_in_list AS show_in_list_5,
  t0_.user_id AS user_id_6,
  t0_.supervisor_id AS supervisor_id_7
FROM
  til_employee t0_
  LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id
  LEFT JOIN til_user_account_type t2_ ON t1_.account_type_id = t2_.id
WHERE
  t2_.slug IN (?, ?, ?, ?)
ORDER BY
  t1_.surname ASC

SELECT t0_.id AS id_0, t0_.residue_rol AS residue_rol_1, t0_.residue_holiday AS residue_holiday_2, t0_.datetime_start_work AS datetime_start_work_3, t0_.datetime_end_work AS datetime_end_work_4, t0_.show_in_list AS show_in_list_5, t0_.user_id AS user_id_6, t0_.supervisor_id AS supervisor_id_7 FROM til_employee t0_ LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id LEFT JOIN til_user_account_type t2_ ON t1_.account_type_id = t2_.id WHERE t2_.slug IN ('ceo', 'administration', 'customer_service', 'regulatory') ORDER BY t1_.surname ASC;

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.is_admin_active AS is_admin_active_1
FROM
  til_user t0_
  LEFT JOIN til_user_account_type t1_ ON t0_.account_type_id = t1_.id
  LEFT JOIN til_user_profile t2_ ON t0_.id = t2_.user_id
  LEFT JOIN til_employee t3_ ON t0_.id = t3_.user_id
WHERE
  t3_.show_in_list = 1
ORDER BY
  t0_.is_admin_active DESC
LIMIT
  20

SELECT DISTINCT t0_.id AS id_0, t0_.is_admin_active AS is_admin_active_1 FROM til_user t0_ LEFT JOIN til_user_account_type t1_ ON t0_.account_type_id = t1_.id LEFT JOIN til_user_profile t2_ ON t0_.id = t2_.user_id LEFT JOIN til_employee t3_ ON t0_.id = t3_.user_id WHERE t3_.show_in_list = 1 ORDER BY t0_.is_admin_active DESC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.level AS level_2,
  t0.content AS content_3,
  t0.datetime AS datetime_4,
  t0.is_read AS is_read_5,
  t0.is_hidden AS is_hidden_6,
  t0.is_personal AS is_personal_7,
  t0.is_for_admin AS is_for_admin_8,
  t0.type_id AS type_id_9,
  t0.user_id AS user_id_10
FROM
  til_notification t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.level AS level_2, t0.content AS content_3, t0.datetime AS datetime_4, t0.is_read AS is_read_5, t0.is_hidden AS is_hidden_6, t0.is_personal AS is_personal_7, t0.is_for_admin AS is_for_admin_8, t0.type_id AS type_id_9, t0.user_id AS user_id_10 FROM til_notification t0 WHERE t0.user_id = '2';

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.user_id AS user_id_3,
  t0.permission_id AS permission_id_4
FROM
  til_join_table_user_permission t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3, t0.permission_id AS permission_id_4 FROM til_join_table_user_permission t0 WHERE t0.user_id = '2';

SELECT
  t0_.id AS id_0,
  t0_.slug AS slug_1,
  t0_.value AS value_2,
  t0_.level AS level_3
FROM
  til_user_account_type t0_

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.value AS value_2, t0_.level AS level_3 FROM til_user_account_type t0_;

SELECT
  t0_.id AS id_0,
  t0_.value AS value_1
FROM
  til_user_profession t0_

SELECT t0_.id AS id_0, t0_.value AS value_1 FROM til_user_profession t0_;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3,
  t0.level AS level_4
FROM
  til_user_account_type t0

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.level AS level_4 FROM til_user_account_type t0;