Symfony Profiler

Query Metrics

108 Database Queries

19 Different statements

292.50 ms Query time

0 Invalid entities

10490 Managed entities

Queries


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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.product_category_id AS product_category_id_3 FROM til_product_group t0_ ORDER BY t0_.name ASC
SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ ORDER BY t0_.name ASC, t0_.short_dosage ASC
SELECT t0_.id AS id_0, t0_.ihs_code AS ihs_code_1, t0_.name AS name_2, t0_.vat AS vat_3, t0_.address AS address_4, t0_.zip AS zip_5, t0_.lat AS lat_6, t0_.lng AS lng_7, t0_.email AS email_8, t0_.pec AS pec_9, t0_.sdi AS sdi_10, t0_.phone AS phone_11, t0_.fax AS fax_12, t0_.minister_code AS minister_code_13, t0_.is_head_group AS is_head_group_14, t0_.is_public AS is_public_15, t0_.city_id AS city_id_16, t0_.hospital_group_id AS hospital_group_id_17 FROM til_hospital t0_ ORDER BY t0_.name 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_.is_kam AS is_kam_6, t0_.is_show_in_export_presences AS is_show_in_export_presences_7, t0_.is_document_product_notify AS is_document_product_notify_8, t0_.user_id AS user_id_9, t0_.supervisor_id AS supervisor_id_10 FROM til_employee t0_ LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id WHERE t0_.is_kam = 1 ORDER BY t1_.surname ASC
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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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_0, t0_.name AS name_1 FROM til_region t0_ ORDER BY t0_.name ASC
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.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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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_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_.is_kam AS is_kam_6, t0_.is_show_in_export_presences AS is_show_in_export_presences_7, t0_.is_document_product_notify AS is_document_product_notify_8, t0_.user_id AS user_id_9, t0_.supervisor_id AS supervisor_id_10 FROM til_employee t0_ LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id WHERE t0_.is_kam = 1 ORDER BY t1_.surname ASC
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_0, t0_.january AS january_1, t0_.february AS february_2, t0_.march AS march_3, t0_.april AS april_4, t0_.may AS may_5, t0_.june AS june_6, t0_.july AS july_7, t0_.august AS august_8, t0_.september AS september_9, t0_.october AS october_10, t0_.november AS november_11, t0_.december AS december_12, t0_.january_qty AS january_qty_13, t0_.february_qty AS february_qty_14, t0_.march_qty AS march_qty_15, t0_.april_qty AS april_qty_16, t0_.may_qty AS may_qty_17, t0_.june_qty AS june_qty_18, t0_.july_qty AS july_qty_19, t0_.august_qty AS august_qty_20, t0_.september_qty AS september_qty_21, t0_.october_qty AS october_qty_22, t0_.november_qty AS november_qty_23, t0_.december_qty AS december_qty_24, t0_.product_id AS product_id_25, t0_.budget_employee_id AS budget_employee_id_26 FROM til_budget_employee_product t0_ LEFT JOIN til_product t1_ ON t0_.product_id = t1_.id LEFT JOIN til_budget_employee t2_ ON t0_.budget_employee_id = t2_.id LEFT JOIN til_employee t3_ ON t2_.employee_id = t3_.id LEFT JOIN til_budget_year t4_ ON t2_.budget_year_id = t4_.id WHERE t4_.year = ? AND t3_.id IN (?, ?, ?, ?)
SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.document_type AS document_type_2, t0_.document_number AS document_number_3, t0_.product_code AS product_code_4, t0_.atc_code AS atc_code_5, t0_.aic_code AS aic_code_6, t0_.product_description AS product_description_7, t0_.lot_number AS lot_number_8, t0_.client_category AS client_category_9, t0_.client_code AS client_code_10, t0_.client_ministerial_code AS client_ministerial_code_11, t0_.client_business_name AS client_business_name_12, t0_.client_address AS client_address_13, t0_.client_province AS client_province_14, t0_.client_city AS client_city_15, t0_.client_zip AS client_zip_16, t0_.client_region AS client_region_17, t0_.vat AS vat_18, t0_.order_number AS order_number_19, t0_.receiver_client_code AS receiver_client_code_20, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21, t0_.receiver_client_business_name AS receiver_client_business_name_22, t0_.receiver_client_address AS receiver_client_address_23, t0_.receiver_client_province AS receiver_client_province_24, t0_.receiver_client_city AS receiver_client_city_25, t0_.receiver_client_zip AS receiver_client_zip_26, t0_.receiver_client_region AS receiver_client_region_27, t0_.kam AS kam_28, t0_.extra AS extra_29, t0_.email AS email_30, t0_.vs_vi AS vs_vi_31, t0_.invoice_num AS invoice_num_32, t0_.division AS division_33, t0_.organization AS organization_34, t0_.material AS material_35, t0_.selling_unit AS selling_unit_36, t0_.tax AS tax_37, t0_.num_of_docs_control AS num_of_docs_control_38, t0_.delivery_num AS delivery_num_39, t0_.cig_number AS cig_number_40, t0_.invoice_voice AS invoice_voice_41, t0_.datetime_import AS datetime_import_42, t0_.date_issue AS date_issue_43, t0_.datetime_order AS datetime_order_44, t0_.datetime_ref AS datetime_ref_45, t0_.datetime_lot_expiration AS datetime_lot_expiration_46, t0_.datetime_control_docs AS datetime_control_docs_47, t0_.datetime_delivery AS datetime_delivery_48, t0_.week_number AS week_number_49, t0_.month_number AS month_number_50, t0_.quantity AS quantity_51, t0_.box_quantity AS box_quantity_52, t0_.backup_quantity AS backup_quantity_53, t0_.backup_net_unit_price AS backup_net_unit_price_54, t0_.net_unit_price AS net_unit_price_55, t0_.net_box_price AS net_box_price_56, t0_.net_price AS net_price_57, t0_.charged_price AS charged_price_58, t0_.cost AS cost_59, t0_.is_cold AS is_cold_60, t0_.notes AS notes_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.employee_id AS employee_id_65, t0_.employee_stats_id AS employee_stats_id_66 FROM til_sell t0_ WHERE YEAR(t0_.date_issue) = ? AND MONTH(t0_.date_issue) = ?
SELECT t0.id AS id_1, t0.year AS year_2 FROM til_budget_year t0 WHERE t0.year = ? LIMIT 1
SELECT t0.id AS id_1, t0.year AS year_2 FROM til_budget_year t0 WHERE t0.year = ? LIMIT 1
SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.budget_year_id AS budget_year_id_3 FROM til_budget_employee t0 WHERE t0.budget_year_id = ?
SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ?
SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ?
SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ?
SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.budget_year_id AS budget_year_id_3 FROM til_budget_employee t0 WHERE t0.budget_year_id = ?
SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ?
SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ?
SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ?
SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.document_type AS document_type_2, t0_.document_number AS document_number_3, t0_.product_code AS product_code_4, t0_.atc_code AS atc_code_5, t0_.aic_code AS aic_code_6, t0_.product_description AS product_description_7, t0_.lot_number AS lot_number_8, t0_.client_category AS client_category_9, t0_.client_code AS client_code_10, t0_.client_ministerial_code AS client_ministerial_code_11, t0_.client_business_name AS client_business_name_12, t0_.client_address AS client_address_13, t0_.client_province AS client_province_14, t0_.client_city AS client_city_15, t0_.client_zip AS client_zip_16, t0_.client_region AS client_region_17, t0_.vat AS vat_18, t0_.order_number AS order_number_19, t0_.receiver_client_code AS receiver_client_code_20, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21, t0_.receiver_client_business_name AS receiver_client_business_name_22, t0_.receiver_client_address AS receiver_client_address_23, t0_.receiver_client_province AS receiver_client_province_24, t0_.receiver_client_city AS receiver_client_city_25, t0_.receiver_client_zip AS receiver_client_zip_26, t0_.receiver_client_region AS receiver_client_region_27, t0_.kam AS kam_28, t0_.extra AS extra_29, t0_.email AS email_30, t0_.vs_vi AS vs_vi_31, t0_.invoice_num AS invoice_num_32, t0_.division AS division_33, t0_.organization AS organization_34, t0_.material AS material_35, t0_.selling_unit AS selling_unit_36, t0_.tax AS tax_37, t0_.num_of_docs_control AS num_of_docs_control_38, t0_.delivery_num AS delivery_num_39, t0_.cig_number AS cig_number_40, t0_.invoice_voice AS invoice_voice_41, t0_.datetime_import AS datetime_import_42, t0_.date_issue AS date_issue_43, t0_.datetime_order AS datetime_order_44, t0_.datetime_ref AS datetime_ref_45, t0_.datetime_lot_expiration AS datetime_lot_expiration_46, t0_.datetime_control_docs AS datetime_control_docs_47, t0_.datetime_delivery AS datetime_delivery_48, t0_.week_number AS week_number_49, t0_.month_number AS month_number_50, t0_.quantity AS quantity_51, t0_.box_quantity AS box_quantity_52, t0_.backup_quantity AS backup_quantity_53, t0_.backup_net_unit_price AS backup_net_unit_price_54, t0_.net_unit_price AS net_unit_price_55, t0_.net_box_price AS net_box_price_56, t0_.net_price AS net_price_57, t0_.charged_price AS charged_price_58, t0_.cost AS cost_59, t0_.is_cold AS is_cold_60, t0_.notes AS notes_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.employee_id AS employee_id_65, t0_.employee_stats_id AS employee_stats_id_66 FROM til_sell t0_ WHERE t0_.date_issue >= ? AND t0_.date_issue <= ?
SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ WHERE t0_.product_group_id IS NULL OR t0_.product_category_id IS NULL OR t0_.atc_code IS NULL ORDER BY t0_.name ASC
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 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 = ?
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.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.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.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.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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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.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.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.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.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 = ?
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.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.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 = ?
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 = ?
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 = ?
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.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 = ?
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.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 = ?
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.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.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.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.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.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.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.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.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.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.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 = ?
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 = ?
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 = ?
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.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 = ?
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 = ?
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.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 = ?
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.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 = ?
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM til_product_category t0 WHERE t0.id = ?

#▲	Time	Info
1	0.56 ms	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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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 = ? Parameters: [`"39"`] View formatted query View runnable query Explain query 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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 = '39';
2	0.25 ms	SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.product_category_id AS product_category_id_3 FROM til_product_group t0_ ORDER BY t0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.product_category_id AS product_category_id_3 FROM til_product_group t0_ ORDER BY t0_.name ASC SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.product_category_id AS product_category_id_3 FROM til_product_group t0_ ORDER BY t0_.name ASC;
3	0.53 ms	SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ ORDER BY t0_.name ASC, t0_.short_dosage ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ ORDER BY t0_.name ASC, t0_.short_dosage ASC SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ ORDER BY t0_.name ASC, t0_.short_dosage ASC;
4	2.95 ms	SELECT t0_.id AS id_0, t0_.ihs_code AS ihs_code_1, t0_.name AS name_2, t0_.vat AS vat_3, t0_.address AS address_4, t0_.zip AS zip_5, t0_.lat AS lat_6, t0_.lng AS lng_7, t0_.email AS email_8, t0_.pec AS pec_9, t0_.sdi AS sdi_10, t0_.phone AS phone_11, t0_.fax AS fax_12, t0_.minister_code AS minister_code_13, t0_.is_head_group AS is_head_group_14, t0_.is_public AS is_public_15, t0_.city_id AS city_id_16, t0_.hospital_group_id AS hospital_group_id_17 FROM til_hospital t0_ ORDER BY t0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.ihs_code AS ihs_code_1, t0_.name AS name_2, t0_.vat AS vat_3, t0_.address AS address_4, t0_.zip AS zip_5, t0_.lat AS lat_6, t0_.lng AS lng_7, t0_.email AS email_8, t0_.pec AS pec_9, t0_.sdi AS sdi_10, t0_.phone AS phone_11, t0_.fax AS fax_12, t0_.minister_code AS minister_code_13, t0_.is_head_group AS is_head_group_14, t0_.is_public AS is_public_15, t0_.city_id AS city_id_16, t0_.hospital_group_id AS hospital_group_id_17 FROM til_hospital t0_ ORDER BY t0_.name ASC SELECT t0_.id AS id_0, t0_.ihs_code AS ihs_code_1, t0_.name AS name_2, t0_.vat AS vat_3, t0_.address AS address_4, t0_.zip AS zip_5, t0_.lat AS lat_6, t0_.lng AS lng_7, t0_.email AS email_8, t0_.pec AS pec_9, t0_.sdi AS sdi_10, t0_.phone AS phone_11, t0_.fax AS fax_12, t0_.minister_code AS minister_code_13, t0_.is_head_group AS is_head_group_14, t0_.is_public AS is_public_15, t0_.city_id AS city_id_16, t0_.hospital_group_id AS hospital_group_id_17 FROM til_hospital t0_ ORDER BY t0_.name ASC;
5	0.36 ms	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_.is_kam AS is_kam_6, t0_.is_show_in_export_presences AS is_show_in_export_presences_7, t0_.is_document_product_notify AS is_document_product_notify_8, t0_.user_id AS user_id_9, t0_.supervisor_id AS supervisor_id_10 FROM til_employee t0_ LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id WHERE t0_.is_kam = 1 ORDER BY t1_.surname ASC Parameters: [] View formatted query View runnable query Explain query 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_.is_kam AS is_kam_6, t0_.is_show_in_export_presences AS is_show_in_export_presences_7, t0_.is_document_product_notify AS is_document_product_notify_8, t0_.user_id AS user_id_9, t0_.supervisor_id AS supervisor_id_10 FROM til_employee t0_ LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id WHERE t0_.is_kam = 1 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_.is_kam AS is_kam_6, t0_.is_show_in_export_presences AS is_show_in_export_presences_7, t0_.is_document_product_notify AS is_document_product_notify_8, t0_.user_id AS user_id_9, t0_.supervisor_id AS supervisor_id_10 FROM til_employee t0_ LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id WHERE t0_.is_kam = 1 ORDER BY t1_.surname ASC;
6	0.26 ms	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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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 = ? Parameters: [`"33"`] View formatted query View runnable query Explain query 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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 = '33';
7	0.24 ms	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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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 = ? Parameters: [`"1844"`] View formatted query View runnable query Explain query 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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 = '1844';
8	0.23 ms	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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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 = ? Parameters: [`"2192"`] View formatted query View runnable query Explain query 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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 = '2192';
9	0.24 ms	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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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 = ? Parameters: [`"816"`] View formatted query View runnable query Explain query 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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.is_kam AS is_kam_43, t36.is_show_in_export_presences AS is_show_in_export_presences_44, t36.is_document_product_notify AS is_document_product_notify_45, t36.user_id AS user_id_46, t36.supervisor_id AS supervisor_id_47, t0.account_type_id AS account_type_id_48 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 = '816';
10	0.14 ms	SELECT t0_.id AS id_0, t0_.name AS name_1 FROM til_region t0_ ORDER BY t0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.name AS name_1 FROM til_region t0_ ORDER BY t0_.name ASC SELECT t0_.id AS id_0, t0_.name AS name_1 FROM til_region t0_ ORDER BY t0_.name ASC;
11	0.35 ms	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 = ? Parameters: [`"39"`] View formatted query View runnable query Explain query 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 = '39';
12	0.14 ms	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 = ? Parameters: [`"1"`] View formatted query View runnable query Explain query 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';
13	0.13 ms	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 = ? Parameters: [`"2"`] View formatted query View runnable query Explain query 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 = '2';
14	0.13 ms	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 = ? Parameters: [`"3"`] View formatted query View runnable query Explain query 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 = '3';
15	0.13 ms	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 = ? Parameters: [`"4"`] View formatted query View runnable query Explain query 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 = '4';
16	0.11 ms	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 = ? Parameters: [`"40"`] View formatted query View runnable query Explain query 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 = '40';
17	0.12 ms	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 = ? Parameters: [`"41"`] View formatted query View runnable query Explain query 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 = '41';
18	0.11 ms	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 = ? Parameters: [`"42"`] View formatted query View runnable query Explain query 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 = '42';
19	0.11 ms	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 = ? Parameters: [`"39"`] View formatted query View runnable query Explain query 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 = '39';
20	0.12 ms	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 = ? Parameters: [`"35"`] View formatted query View runnable query Explain query 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 = '35';
21	0.12 ms	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 = ? Parameters: [`"5"`] View formatted query View runnable query Explain query 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 = '5';
22	0.11 ms	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 = ? Parameters: [`"58"`] View formatted query View runnable query Explain query 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 = '58';
23	0.22 ms	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_.is_kam AS is_kam_6, t0_.is_show_in_export_presences AS is_show_in_export_presences_7, t0_.is_document_product_notify AS is_document_product_notify_8, t0_.user_id AS user_id_9, t0_.supervisor_id AS supervisor_id_10 FROM til_employee t0_ LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id WHERE t0_.is_kam = 1 ORDER BY t1_.surname ASC Parameters: [] View formatted query View runnable query Explain query 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_.is_kam AS is_kam_6, t0_.is_show_in_export_presences AS is_show_in_export_presences_7, t0_.is_document_product_notify AS is_document_product_notify_8, t0_.user_id AS user_id_9, t0_.supervisor_id AS supervisor_id_10 FROM til_employee t0_ LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id WHERE t0_.is_kam = 1 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_.is_kam AS is_kam_6, t0_.is_show_in_export_presences AS is_show_in_export_presences_7, t0_.is_document_product_notify AS is_document_product_notify_8, t0_.user_id AS user_id_9, t0_.supervisor_id AS supervisor_id_10 FROM til_employee t0_ LEFT JOIN til_user t1_ ON t0_.user_id = t1_.id WHERE t0_.is_kam = 1 ORDER BY t1_.surname ASC;
24	0.12 ms	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 = ? Parameters: [`"59"`] View formatted query View runnable query Explain query 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 = '59';
25	0.82 ms	SELECT t0_.id AS id_0, t0_.january AS january_1, t0_.february AS february_2, t0_.march AS march_3, t0_.april AS april_4, t0_.may AS may_5, t0_.june AS june_6, t0_.july AS july_7, t0_.august AS august_8, t0_.september AS september_9, t0_.october AS october_10, t0_.november AS november_11, t0_.december AS december_12, t0_.january_qty AS january_qty_13, t0_.february_qty AS february_qty_14, t0_.march_qty AS march_qty_15, t0_.april_qty AS april_qty_16, t0_.may_qty AS may_qty_17, t0_.june_qty AS june_qty_18, t0_.july_qty AS july_qty_19, t0_.august_qty AS august_qty_20, t0_.september_qty AS september_qty_21, t0_.october_qty AS october_qty_22, t0_.november_qty AS november_qty_23, t0_.december_qty AS december_qty_24, t0_.product_id AS product_id_25, t0_.budget_employee_id AS budget_employee_id_26 FROM til_budget_employee_product t0_ LEFT JOIN til_product t1_ ON t0_.product_id = t1_.id LEFT JOIN til_budget_employee t2_ ON t0_.budget_employee_id = t2_.id LEFT JOIN til_employee t3_ ON t2_.employee_id = t3_.id LEFT JOIN til_budget_year t4_ ON t2_.budget_year_id = t4_.id WHERE t4_.year = ? AND t3_.id IN (?, ?, ?, ?) Parameters: [`"2025" "11" "26" "36" "25"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.january AS january_1, t0_.february AS february_2, t0_.march AS march_3, t0_.april AS april_4, t0_.may AS may_5, t0_.june AS june_6, t0_.july AS july_7, t0_.august AS august_8, t0_.september AS september_9, t0_.october AS october_10, t0_.november AS november_11, t0_.december AS december_12, t0_.january_qty AS january_qty_13, t0_.february_qty AS february_qty_14, t0_.march_qty AS march_qty_15, t0_.april_qty AS april_qty_16, t0_.may_qty AS may_qty_17, t0_.june_qty AS june_qty_18, t0_.july_qty AS july_qty_19, t0_.august_qty AS august_qty_20, t0_.september_qty AS september_qty_21, t0_.october_qty AS october_qty_22, t0_.november_qty AS november_qty_23, t0_.december_qty AS december_qty_24, t0_.product_id AS product_id_25, t0_.budget_employee_id AS budget_employee_id_26 FROM til_budget_employee_product t0_ LEFT JOIN til_product t1_ ON t0_.product_id = t1_.id LEFT JOIN til_budget_employee t2_ ON t0_.budget_employee_id = t2_.id LEFT JOIN til_employee t3_ ON t2_.employee_id = t3_.id LEFT JOIN til_budget_year t4_ ON t2_.budget_year_id = t4_.id WHERE t4_.year = ? AND t3_.id IN (?, ?, ?, ?) SELECT t0_.id AS id_0, t0_.january AS january_1, t0_.february AS february_2, t0_.march AS march_3, t0_.april AS april_4, t0_.may AS may_5, t0_.june AS june_6, t0_.july AS july_7, t0_.august AS august_8, t0_.september AS september_9, t0_.october AS october_10, t0_.november AS november_11, t0_.december AS december_12, t0_.january_qty AS january_qty_13, t0_.february_qty AS february_qty_14, t0_.march_qty AS march_qty_15, t0_.april_qty AS april_qty_16, t0_.may_qty AS may_qty_17, t0_.june_qty AS june_qty_18, t0_.july_qty AS july_qty_19, t0_.august_qty AS august_qty_20, t0_.september_qty AS september_qty_21, t0_.october_qty AS october_qty_22, t0_.november_qty AS november_qty_23, t0_.december_qty AS december_qty_24, t0_.product_id AS product_id_25, t0_.budget_employee_id AS budget_employee_id_26 FROM til_budget_employee_product t0_ LEFT JOIN til_product t1_ ON t0_.product_id = t1_.id LEFT JOIN til_budget_employee t2_ ON t0_.budget_employee_id = t2_.id LEFT JOIN til_employee t3_ ON t2_.employee_id = t3_.id LEFT JOIN til_budget_year t4_ ON t2_.budget_year_id = t4_.id WHERE t4_.year = '2025' AND t3_.id IN ('11', '26', '36', '25');
26	227.63 ms	SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.document_type AS document_type_2, t0_.document_number AS document_number_3, t0_.product_code AS product_code_4, t0_.atc_code AS atc_code_5, t0_.aic_code AS aic_code_6, t0_.product_description AS product_description_7, t0_.lot_number AS lot_number_8, t0_.client_category AS client_category_9, t0_.client_code AS client_code_10, t0_.client_ministerial_code AS client_ministerial_code_11, t0_.client_business_name AS client_business_name_12, t0_.client_address AS client_address_13, t0_.client_province AS client_province_14, t0_.client_city AS client_city_15, t0_.client_zip AS client_zip_16, t0_.client_region AS client_region_17, t0_.vat AS vat_18, t0_.order_number AS order_number_19, t0_.receiver_client_code AS receiver_client_code_20, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21, t0_.receiver_client_business_name AS receiver_client_business_name_22, t0_.receiver_client_address AS receiver_client_address_23, t0_.receiver_client_province AS receiver_client_province_24, t0_.receiver_client_city AS receiver_client_city_25, t0_.receiver_client_zip AS receiver_client_zip_26, t0_.receiver_client_region AS receiver_client_region_27, t0_.kam AS kam_28, t0_.extra AS extra_29, t0_.email AS email_30, t0_.vs_vi AS vs_vi_31, t0_.invoice_num AS invoice_num_32, t0_.division AS division_33, t0_.organization AS organization_34, t0_.material AS material_35, t0_.selling_unit AS selling_unit_36, t0_.tax AS tax_37, t0_.num_of_docs_control AS num_of_docs_control_38, t0_.delivery_num AS delivery_num_39, t0_.cig_number AS cig_number_40, t0_.invoice_voice AS invoice_voice_41, t0_.datetime_import AS datetime_import_42, t0_.date_issue AS date_issue_43, t0_.datetime_order AS datetime_order_44, t0_.datetime_ref AS datetime_ref_45, t0_.datetime_lot_expiration AS datetime_lot_expiration_46, t0_.datetime_control_docs AS datetime_control_docs_47, t0_.datetime_delivery AS datetime_delivery_48, t0_.week_number AS week_number_49, t0_.month_number AS month_number_50, t0_.quantity AS quantity_51, t0_.box_quantity AS box_quantity_52, t0_.backup_quantity AS backup_quantity_53, t0_.backup_net_unit_price AS backup_net_unit_price_54, t0_.net_unit_price AS net_unit_price_55, t0_.net_box_price AS net_box_price_56, t0_.net_price AS net_price_57, t0_.charged_price AS charged_price_58, t0_.cost AS cost_59, t0_.is_cold AS is_cold_60, t0_.notes AS notes_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.employee_id AS employee_id_65, t0_.employee_stats_id AS employee_stats_id_66 FROM til_sell t0_ WHERE YEAR(t0_.date_issue) = ? AND MONTH(t0_.date_issue) = ? Parameters: [`"2025" "06"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.document_type AS document_type_2, t0_.document_number AS document_number_3, t0_.product_code AS product_code_4, t0_.atc_code AS atc_code_5, t0_.aic_code AS aic_code_6, t0_.product_description AS product_description_7, t0_.lot_number AS lot_number_8, t0_.client_category AS client_category_9, t0_.client_code AS client_code_10, t0_.client_ministerial_code AS client_ministerial_code_11, t0_.client_business_name AS client_business_name_12, t0_.client_address AS client_address_13, t0_.client_province AS client_province_14, t0_.client_city AS client_city_15, t0_.client_zip AS client_zip_16, t0_.client_region AS client_region_17, t0_.vat AS vat_18, t0_.order_number AS order_number_19, t0_.receiver_client_code AS receiver_client_code_20, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21, t0_.receiver_client_business_name AS receiver_client_business_name_22, t0_.receiver_client_address AS receiver_client_address_23, t0_.receiver_client_province AS receiver_client_province_24, t0_.receiver_client_city AS receiver_client_city_25, t0_.receiver_client_zip AS receiver_client_zip_26, t0_.receiver_client_region AS receiver_client_region_27, t0_.kam AS kam_28, t0_.extra AS extra_29, t0_.email AS email_30, t0_.vs_vi AS vs_vi_31, t0_.invoice_num AS invoice_num_32, t0_.division AS division_33, t0_.organization AS organization_34, t0_.material AS material_35, t0_.selling_unit AS selling_unit_36, t0_.tax AS tax_37, t0_.num_of_docs_control AS num_of_docs_control_38, t0_.delivery_num AS delivery_num_39, t0_.cig_number AS cig_number_40, t0_.invoice_voice AS invoice_voice_41, t0_.datetime_import AS datetime_import_42, t0_.date_issue AS date_issue_43, t0_.datetime_order AS datetime_order_44, t0_.datetime_ref AS datetime_ref_45, t0_.datetime_lot_expiration AS datetime_lot_expiration_46, t0_.datetime_control_docs AS datetime_control_docs_47, t0_.datetime_delivery AS datetime_delivery_48, t0_.week_number AS week_number_49, t0_.month_number AS month_number_50, t0_.quantity AS quantity_51, t0_.box_quantity AS box_quantity_52, t0_.backup_quantity AS backup_quantity_53, t0_.backup_net_unit_price AS backup_net_unit_price_54, t0_.net_unit_price AS net_unit_price_55, t0_.net_box_price AS net_box_price_56, t0_.net_price AS net_price_57, t0_.charged_price AS charged_price_58, t0_.cost AS cost_59, t0_.is_cold AS is_cold_60, t0_.notes AS notes_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.employee_id AS employee_id_65, t0_.employee_stats_id AS employee_stats_id_66 FROM til_sell t0_ WHERE YEAR(t0_.date_issue) = ? AND MONTH(t0_.date_issue) = ? SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.document_type AS document_type_2, t0_.document_number AS document_number_3, t0_.product_code AS product_code_4, t0_.atc_code AS atc_code_5, t0_.aic_code AS aic_code_6, t0_.product_description AS product_description_7, t0_.lot_number AS lot_number_8, t0_.client_category AS client_category_9, t0_.client_code AS client_code_10, t0_.client_ministerial_code AS client_ministerial_code_11, t0_.client_business_name AS client_business_name_12, t0_.client_address AS client_address_13, t0_.client_province AS client_province_14, t0_.client_city AS client_city_15, t0_.client_zip AS client_zip_16, t0_.client_region AS client_region_17, t0_.vat AS vat_18, t0_.order_number AS order_number_19, t0_.receiver_client_code AS receiver_client_code_20, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21, t0_.receiver_client_business_name AS receiver_client_business_name_22, t0_.receiver_client_address AS receiver_client_address_23, t0_.receiver_client_province AS receiver_client_province_24, t0_.receiver_client_city AS receiver_client_city_25, t0_.receiver_client_zip AS receiver_client_zip_26, t0_.receiver_client_region AS receiver_client_region_27, t0_.kam AS kam_28, t0_.extra AS extra_29, t0_.email AS email_30, t0_.vs_vi AS vs_vi_31, t0_.invoice_num AS invoice_num_32, t0_.division AS division_33, t0_.organization AS organization_34, t0_.material AS material_35, t0_.selling_unit AS selling_unit_36, t0_.tax AS tax_37, t0_.num_of_docs_control AS num_of_docs_control_38, t0_.delivery_num AS delivery_num_39, t0_.cig_number AS cig_number_40, t0_.invoice_voice AS invoice_voice_41, t0_.datetime_import AS datetime_import_42, t0_.date_issue AS date_issue_43, t0_.datetime_order AS datetime_order_44, t0_.datetime_ref AS datetime_ref_45, t0_.datetime_lot_expiration AS datetime_lot_expiration_46, t0_.datetime_control_docs AS datetime_control_docs_47, t0_.datetime_delivery AS datetime_delivery_48, t0_.week_number AS week_number_49, t0_.month_number AS month_number_50, t0_.quantity AS quantity_51, t0_.box_quantity AS box_quantity_52, t0_.backup_quantity AS backup_quantity_53, t0_.backup_net_unit_price AS backup_net_unit_price_54, t0_.net_unit_price AS net_unit_price_55, t0_.net_box_price AS net_box_price_56, t0_.net_price AS net_price_57, t0_.charged_price AS charged_price_58, t0_.cost AS cost_59, t0_.is_cold AS is_cold_60, t0_.notes AS notes_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.employee_id AS employee_id_65, t0_.employee_stats_id AS employee_stats_id_66 FROM til_sell t0_ WHERE YEAR(t0_.date_issue) = '2025' AND MONTH(t0_.date_issue) = '06';
27	0.24 ms	SELECT t0.id AS id_1, t0.year AS year_2 FROM til_budget_year t0 WHERE t0.year = ? LIMIT 1 Parameters: [`"2025"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.year AS year_2 FROM til_budget_year t0 WHERE t0.year = ? LIMIT 1 SELECT t0.id AS id_1, t0.year AS year_2 FROM til_budget_year t0 WHERE t0.year = '2025' LIMIT 1;
28	0.12 ms	SELECT t0.id AS id_1, t0.year AS year_2 FROM til_budget_year t0 WHERE t0.year = ? LIMIT 1 Parameters: [`2026`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.year AS year_2 FROM til_budget_year t0 WHERE t0.year = ? LIMIT 1 SELECT t0.id AS id_1, t0.year AS year_2 FROM til_budget_year t0 WHERE t0.year = 2026 LIMIT 1;
29	0.15 ms	SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.budget_year_id AS budget_year_id_3 FROM til_budget_employee t0 WHERE t0.budget_year_id = ? Parameters: [`"2"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.budget_year_id AS budget_year_id_3 FROM til_budget_employee t0 WHERE t0.budget_year_id = ? SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.budget_year_id AS budget_year_id_3 FROM til_budget_employee t0 WHERE t0.budget_year_id = '2';
30	0.37 ms	SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? Parameters: [`"2"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = '2';
31	0.35 ms	SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = '4';
32	0.35 ms	SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? Parameters: [`"6"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = '6';
33	0.13 ms	SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.budget_year_id AS budget_year_id_3 FROM til_budget_employee t0 WHERE t0.budget_year_id = ? Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.budget_year_id AS budget_year_id_3 FROM til_budget_employee t0 WHERE t0.budget_year_id = ? SELECT t0.id AS id_1, t0.employee_id AS employee_id_2, t0.budget_year_id AS budget_year_id_3 FROM til_budget_employee t0 WHERE t0.budget_year_id = '1';
34	0.32 ms	SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = '1';
35	0.33 ms	SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? Parameters: [`"3"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = '3';
36	0.33 ms	SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? Parameters: [`"5"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = ? SELECT t0.id AS id_1, t0.january AS january_2, t0.february AS february_3, t0.march AS march_4, t0.april AS april_5, t0.may AS may_6, t0.june AS june_7, t0.july AS july_8, t0.august AS august_9, t0.september AS september_10, t0.october AS october_11, t0.november AS november_12, t0.december AS december_13, t0.january_qty AS january_qty_14, t0.february_qty AS february_qty_15, t0.march_qty AS march_qty_16, t0.april_qty AS april_qty_17, t0.may_qty AS may_qty_18, t0.june_qty AS june_qty_19, t0.july_qty AS july_qty_20, t0.august_qty AS august_qty_21, t0.september_qty AS september_qty_22, t0.october_qty AS october_qty_23, t0.november_qty AS november_qty_24, t0.december_qty AS december_qty_25, t0.product_id AS product_id_26, t0.budget_employee_id AS budget_employee_id_27 FROM til_budget_employee_product t0 WHERE t0.budget_employee_id = '5';
37	45.03 ms	SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.document_type AS document_type_2, t0_.document_number AS document_number_3, t0_.product_code AS product_code_4, t0_.atc_code AS atc_code_5, t0_.aic_code AS aic_code_6, t0_.product_description AS product_description_7, t0_.lot_number AS lot_number_8, t0_.client_category AS client_category_9, t0_.client_code AS client_code_10, t0_.client_ministerial_code AS client_ministerial_code_11, t0_.client_business_name AS client_business_name_12, t0_.client_address AS client_address_13, t0_.client_province AS client_province_14, t0_.client_city AS client_city_15, t0_.client_zip AS client_zip_16, t0_.client_region AS client_region_17, t0_.vat AS vat_18, t0_.order_number AS order_number_19, t0_.receiver_client_code AS receiver_client_code_20, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21, t0_.receiver_client_business_name AS receiver_client_business_name_22, t0_.receiver_client_address AS receiver_client_address_23, t0_.receiver_client_province AS receiver_client_province_24, t0_.receiver_client_city AS receiver_client_city_25, t0_.receiver_client_zip AS receiver_client_zip_26, t0_.receiver_client_region AS receiver_client_region_27, t0_.kam AS kam_28, t0_.extra AS extra_29, t0_.email AS email_30, t0_.vs_vi AS vs_vi_31, t0_.invoice_num AS invoice_num_32, t0_.division AS division_33, t0_.organization AS organization_34, t0_.material AS material_35, t0_.selling_unit AS selling_unit_36, t0_.tax AS tax_37, t0_.num_of_docs_control AS num_of_docs_control_38, t0_.delivery_num AS delivery_num_39, t0_.cig_number AS cig_number_40, t0_.invoice_voice AS invoice_voice_41, t0_.datetime_import AS datetime_import_42, t0_.date_issue AS date_issue_43, t0_.datetime_order AS datetime_order_44, t0_.datetime_ref AS datetime_ref_45, t0_.datetime_lot_expiration AS datetime_lot_expiration_46, t0_.datetime_control_docs AS datetime_control_docs_47, t0_.datetime_delivery AS datetime_delivery_48, t0_.week_number AS week_number_49, t0_.month_number AS month_number_50, t0_.quantity AS quantity_51, t0_.box_quantity AS box_quantity_52, t0_.backup_quantity AS backup_quantity_53, t0_.backup_net_unit_price AS backup_net_unit_price_54, t0_.net_unit_price AS net_unit_price_55, t0_.net_box_price AS net_box_price_56, t0_.net_price AS net_price_57, t0_.charged_price AS charged_price_58, t0_.cost AS cost_59, t0_.is_cold AS is_cold_60, t0_.notes AS notes_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.employee_id AS employee_id_65, t0_.employee_stats_id AS employee_stats_id_66 FROM til_sell t0_ WHERE t0_.date_issue >= ? AND t0_.date_issue <= ? Parameters: [`"2025-04-01" "2026-03-31"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.document_type AS document_type_2, t0_.document_number AS document_number_3, t0_.product_code AS product_code_4, t0_.atc_code AS atc_code_5, t0_.aic_code AS aic_code_6, t0_.product_description AS product_description_7, t0_.lot_number AS lot_number_8, t0_.client_category AS client_category_9, t0_.client_code AS client_code_10, t0_.client_ministerial_code AS client_ministerial_code_11, t0_.client_business_name AS client_business_name_12, t0_.client_address AS client_address_13, t0_.client_province AS client_province_14, t0_.client_city AS client_city_15, t0_.client_zip AS client_zip_16, t0_.client_region AS client_region_17, t0_.vat AS vat_18, t0_.order_number AS order_number_19, t0_.receiver_client_code AS receiver_client_code_20, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21, t0_.receiver_client_business_name AS receiver_client_business_name_22, t0_.receiver_client_address AS receiver_client_address_23, t0_.receiver_client_province AS receiver_client_province_24, t0_.receiver_client_city AS receiver_client_city_25, t0_.receiver_client_zip AS receiver_client_zip_26, t0_.receiver_client_region AS receiver_client_region_27, t0_.kam AS kam_28, t0_.extra AS extra_29, t0_.email AS email_30, t0_.vs_vi AS vs_vi_31, t0_.invoice_num AS invoice_num_32, t0_.division AS division_33, t0_.organization AS organization_34, t0_.material AS material_35, t0_.selling_unit AS selling_unit_36, t0_.tax AS tax_37, t0_.num_of_docs_control AS num_of_docs_control_38, t0_.delivery_num AS delivery_num_39, t0_.cig_number AS cig_number_40, t0_.invoice_voice AS invoice_voice_41, t0_.datetime_import AS datetime_import_42, t0_.date_issue AS date_issue_43, t0_.datetime_order AS datetime_order_44, t0_.datetime_ref AS datetime_ref_45, t0_.datetime_lot_expiration AS datetime_lot_expiration_46, t0_.datetime_control_docs AS datetime_control_docs_47, t0_.datetime_delivery AS datetime_delivery_48, t0_.week_number AS week_number_49, t0_.month_number AS month_number_50, t0_.quantity AS quantity_51, t0_.box_quantity AS box_quantity_52, t0_.backup_quantity AS backup_quantity_53, t0_.backup_net_unit_price AS backup_net_unit_price_54, t0_.net_unit_price AS net_unit_price_55, t0_.net_box_price AS net_box_price_56, t0_.net_price AS net_price_57, t0_.charged_price AS charged_price_58, t0_.cost AS cost_59, t0_.is_cold AS is_cold_60, t0_.notes AS notes_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.employee_id AS employee_id_65, t0_.employee_stats_id AS employee_stats_id_66 FROM til_sell t0_ WHERE t0_.date_issue >= ? AND t0_.date_issue <= ? SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.document_type AS document_type_2, t0_.document_number AS document_number_3, t0_.product_code AS product_code_4, t0_.atc_code AS atc_code_5, t0_.aic_code AS aic_code_6, t0_.product_description AS product_description_7, t0_.lot_number AS lot_number_8, t0_.client_category AS client_category_9, t0_.client_code AS client_code_10, t0_.client_ministerial_code AS client_ministerial_code_11, t0_.client_business_name AS client_business_name_12, t0_.client_address AS client_address_13, t0_.client_province AS client_province_14, t0_.client_city AS client_city_15, t0_.client_zip AS client_zip_16, t0_.client_region AS client_region_17, t0_.vat AS vat_18, t0_.order_number AS order_number_19, t0_.receiver_client_code AS receiver_client_code_20, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_21, t0_.receiver_client_business_name AS receiver_client_business_name_22, t0_.receiver_client_address AS receiver_client_address_23, t0_.receiver_client_province AS receiver_client_province_24, t0_.receiver_client_city AS receiver_client_city_25, t0_.receiver_client_zip AS receiver_client_zip_26, t0_.receiver_client_region AS receiver_client_region_27, t0_.kam AS kam_28, t0_.extra AS extra_29, t0_.email AS email_30, t0_.vs_vi AS vs_vi_31, t0_.invoice_num AS invoice_num_32, t0_.division AS division_33, t0_.organization AS organization_34, t0_.material AS material_35, t0_.selling_unit AS selling_unit_36, t0_.tax AS tax_37, t0_.num_of_docs_control AS num_of_docs_control_38, t0_.delivery_num AS delivery_num_39, t0_.cig_number AS cig_number_40, t0_.invoice_voice AS invoice_voice_41, t0_.datetime_import AS datetime_import_42, t0_.date_issue AS date_issue_43, t0_.datetime_order AS datetime_order_44, t0_.datetime_ref AS datetime_ref_45, t0_.datetime_lot_expiration AS datetime_lot_expiration_46, t0_.datetime_control_docs AS datetime_control_docs_47, t0_.datetime_delivery AS datetime_delivery_48, t0_.week_number AS week_number_49, t0_.month_number AS month_number_50, t0_.quantity AS quantity_51, t0_.box_quantity AS box_quantity_52, t0_.backup_quantity AS backup_quantity_53, t0_.backup_net_unit_price AS backup_net_unit_price_54, t0_.net_unit_price AS net_unit_price_55, t0_.net_box_price AS net_box_price_56, t0_.net_price AS net_price_57, t0_.charged_price AS charged_price_58, t0_.cost AS cost_59, t0_.is_cold AS is_cold_60, t0_.notes AS notes_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.employee_id AS employee_id_65, t0_.employee_stats_id AS employee_stats_id_66 FROM til_sell t0_ WHERE t0_.date_issue >= '2025-04-01' AND t0_.date_issue <= '2026-03-31';
38	0.37 ms	SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ WHERE t0_.product_group_id IS NULL OR t0_.product_category_id IS NULL OR t0_.atc_code IS NULL ORDER BY t0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ WHERE t0_.product_group_id IS NULL OR t0_.product_category_id IS NULL OR t0_.atc_code IS NULL ORDER BY t0_.name ASC SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.name AS name_2, t0_.dosage AS dosage_3, t0_.short_dosage AS short_dosage_4, t0_.dosage_int AS dosage_int_5, t0_.class AS class_6, t0_.aic_code AS aic_code_7, t0_.atc_code AS atc_code_8, t0_.unit_for_box AS unit_for_box_9, t0_.max_unit_price AS max_unit_price_10, t0_.image_path AS image_path_11, t0_.datetime_start AS datetime_start_12, t0_.datetime_budget_start AS datetime_budget_start_13, t0_.is_visible AS is_visible_14, t0_.is_archived AS is_archived_15, t0_.is_retail AS is_retail_16, t0_.product_category_id AS product_category_id_17, t0_.product_group_id AS product_group_id_18 FROM til_product t0_ WHERE t0_.product_group_id IS NULL OR t0_.product_category_id IS NULL OR t0_.atc_code IS NULL ORDER BY t0_.name ASC;
39	0.25 ms	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 WHERE t0.id = ? Parameters: [`"3"`] View formatted query View runnable query Explain query 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 WHERE t0.id = ? 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 WHERE t0.id = '3';
40	0.12 ms	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 = ? Parameters: [`"1"`] View formatted query View runnable query Explain query 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';
41	0.16 ms	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 = ? Parameters: [`"39"`] View formatted query View runnable query Explain query 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 = '39';
42	0.12 ms	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 = ? Parameters: [`"2"`] View formatted query View runnable query Explain query 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 = '2';
43	0.13 ms	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 = ? Parameters: [`"7"`] View formatted query View runnable query Explain query 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 = '7';
44	0.12 ms	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 = ? Parameters: [`"3"`] View formatted query View runnable query Explain query 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 = '3';
45	0.11 ms	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 = ? Parameters: [`"43"`] View formatted query View runnable query Explain query 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 = '43';
46	0.11 ms	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 = ? Parameters: [`"34"`] View formatted query View runnable query Explain query 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 = '34';
47	0.11 ms	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 = ? Parameters: [`"44"`] View formatted query View runnable query Explain query 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 = '44';
48	0.11 ms	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 = ? Parameters: [`"45"`] View formatted query View runnable query Explain query 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 = '45';
49	0.12 ms	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 = ? Parameters: [`"46"`] View formatted query View runnable query Explain query 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 = '46';
50	0.11 ms	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 = ? Parameters: [`"47"`] View formatted query View runnable query Explain query 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 = '47';
51	0.11 ms	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 = ? Parameters: [`"48"`] View formatted query View runnable query Explain query 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 = '48';
52	0.11 ms	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 = ? Parameters: [`"49"`] View formatted query View runnable query Explain query 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 = '49';
53	0.12 ms	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 = ? Parameters: [`"56"`] View formatted query View runnable query Explain query 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 = '56';
54	0.11 ms	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 = ? Parameters: [`"50"`] View formatted query View runnable query Explain query 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 = '50';
55	0.11 ms	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 = ? Parameters: [`"57"`] View formatted query View runnable query Explain query 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 = '57';
56	0.11 ms	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 = ? Parameters: [`"51"`] View formatted query View runnable query Explain query 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 = '51';
57	0.11 ms	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 = ? Parameters: [`"52"`] View formatted query View runnable query Explain query 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 = '52';
58	0.11 ms	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 = ? Parameters: [`"53"`] View formatted query View runnable query Explain query 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 = '53';
59	0.11 ms	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 = ? Parameters: [`"54"`] View formatted query View runnable query Explain query 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 = '54';
60	0.11 ms	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 = ? Parameters: [`"55"`] View formatted query View runnable query Explain query 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 = '55';
61	0.11 ms	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 = ? Parameters: [`"8"`] View formatted query View runnable query Explain query 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 = '8';
62	0.11 ms	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 = ? Parameters: [`"4"`] View formatted query View runnable query Explain query 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 = '4';
63	0.11 ms	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 = ? Parameters: [`"9"`] View formatted query View runnable query Explain query 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 = '9';
64	0.11 ms	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 = ? Parameters: [`"5"`] View formatted query View runnable query Explain query 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 = '5';
65	0.12 ms	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 = ? Parameters: [`"10"`] View formatted query View runnable query Explain query 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 = '10';
66	0.11 ms	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 = ? Parameters: [`"11"`] View formatted query View runnable query Explain query 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 = '11';
67	0.11 ms	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 = ? Parameters: [`"12"`] View formatted query View runnable query Explain query 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 = '12';
68	0.11 ms	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 = ? Parameters: [`"6"`] View formatted query View runnable query Explain query 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 = '6';
69	0.11 ms	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 = ? Parameters: [`"13"`] View formatted query View runnable query Explain query 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 = '13';
70	0.12 ms	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 = ? Parameters: [`"14"`] View formatted query View runnable query Explain query 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 = '14';
71	0.13 ms	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 = ? Parameters: [`"15"`] View formatted query View runnable query Explain query 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 = '15';
72	0.11 ms	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 = ? Parameters: [`"16"`] View formatted query View runnable query Explain query 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 = '16';
73	0.11 ms	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 = ? Parameters: [`"17"`] View formatted query View runnable query Explain query 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 = '17';
74	0.11 ms	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 = ? Parameters: [`"18"`] View formatted query View runnable query Explain query 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 = '18';
75	0.11 ms	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 = ? Parameters: [`"7"`] View formatted query View runnable query Explain query 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 = '7';
76	0.11 ms	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 = ? Parameters: [`"19"`] View formatted query View runnable query Explain query 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 = '19';
77	0.11 ms	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 = ? Parameters: [`"20"`] View formatted query View runnable query Explain query 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 = '20';
78	0.11 ms	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 = ? Parameters: [`"8"`] View formatted query View runnable query Explain query 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 = '8';
79	0.11 ms	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 = ? Parameters: [`"21"`] View formatted query View runnable query Explain query 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 = '21';
80	0.11 ms	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 = ? Parameters: [`"22"`] View formatted query View runnable query Explain query 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 = '22';
81	0.11 ms	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 = ? Parameters: [`"37"`] View formatted query View runnable query Explain query 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 = '37';
82	0.11 ms	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 = ? Parameters: [`"15"`] View formatted query View runnable query Explain query 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 = '15';
83	0.11 ms	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 = ? Parameters: [`"38"`] View formatted query View runnable query Explain query 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 = '38';
84	0.10 ms	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 = ? Parameters: [`"16"`] View formatted query View runnable query Explain query 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 = '16';
85	0.11 ms	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 = ? Parameters: [`"36"`] View formatted query View runnable query Explain query 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 = '36';
86	0.10 ms	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 = ? Parameters: [`"14"`] View formatted query View runnable query Explain query 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 = '14';
87	0.11 ms	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 = ? Parameters: [`"23"`] View formatted query View runnable query Explain query 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 = '23';
88	0.11 ms	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 = ? Parameters: [`"9"`] View formatted query View runnable query Explain query 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 = '9';
89	0.11 ms	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 = ? Parameters: [`"24"`] View formatted query View runnable query Explain query 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 = '24';
90	0.11 ms	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 = ? Parameters: [`"10"`] View formatted query View runnable query Explain query 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 = '10';
91	0.11 ms	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 = ? Parameters: [`"25"`] View formatted query View runnable query Explain query 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 = '25';
92	0.13 ms	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 = ? Parameters: [`"26"`] View formatted query View runnable query Explain query 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 = '26';
93	0.12 ms	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 = ? Parameters: [`"27"`] View formatted query View runnable query Explain query 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 = '27';
94	0.11 ms	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 = ? Parameters: [`"28"`] View formatted query View runnable query Explain query 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 = '28';
95	0.11 ms	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 = ? Parameters: [`"29"`] View formatted query View runnable query Explain query 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 = '29';
96	0.11 ms	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 = ? Parameters: [`"30"`] View formatted query View runnable query Explain query 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 = '30';
97	0.10 ms	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 = ? Parameters: [`"11"`] View formatted query View runnable query Explain query 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 = '11';
98	0.11 ms	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 = ? Parameters: [`"31"`] View formatted query View runnable query Explain query 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 = '31';
99	0.11 ms	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 = ? Parameters: [`"32"`] View formatted query View runnable query Explain query 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 = '32';
100	0.11 ms	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 = ? Parameters: [`"33"`] View formatted query View runnable query Explain query 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 = '33';
101	0.11 ms	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 = ? Parameters: [`"60"`] View formatted query View runnable query Explain query 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 = '60';
102	0.11 ms	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 = ? Parameters: [`"17"`] View formatted query View runnable query Explain query 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 = '17';
103	0.12 ms	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 = ? Parameters: [`"61"`] View formatted query View runnable query Explain query 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 = '61';
104	0.11 ms	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 = ? Parameters: [`"62"`] View formatted query View runnable query Explain query 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 = '62';
105	0.11 ms	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 = ? Parameters: [`"18"`] View formatted query View runnable query Explain query 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 = '18';
106	0.11 ms	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 = ? Parameters: [`"63"`] View formatted query View runnable query Explain query 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 = '63';
107	0.11 ms	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 = ? Parameters: [`"64"`] View formatted query View runnable query Explain query 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 = '64';
108	0.33 ms	SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM til_product_category t0 WHERE t0.id = ? Parameters: [`"2"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM til_product_category t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM til_product_category t0 WHERE t0.id = '2';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Sell	7876
App\Entity\HospitalFacility	882
App\Entity\Hospital	785
App\Entity\BudgetEmployeeProduct	324
App\Entity\City	261
App\Entity\Product	90
App\Entity\JoinTableUserPermission	63
App\Entity\Permission	63
App\Entity\ProductGroup	44
App\Entity\Region	21
App\Entity\HospitalGroup	18
App\Entity\PermissionCategory	16
App\Entity\ProductCategory	10
App\Entity\Employee	9
App\Entity\BudgetEmployee	6
App\Entity\User	5
App\Entity\UserPrivacy	5
App\Entity\UserProfile	5
App\Entity\UserProfession	3
App\Entity\UserAccountType	2
App\Entity\BudgetYear	2

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserPrivacy	No errors.
App\Entity\UserProfile	No errors.
App\Entity\City	No errors.
App\Entity\UserProfession	No errors.
App\Entity\Employee	No errors.
App\Entity\UserAccountType	No errors.
App\Entity\Document	No errors.
App\Entity\Notification	No errors.
App\Entity\Log	No errors.
App\Entity\JoinTableUserTest	No errors.
App\Entity\TestCode	No errors.
App\Entity\TestAnswer	No errors.
App\Entity\JoinTableUserPermission	No errors.
App\Entity\EmployeeLeasing	No errors.
App\Entity\EmployeeHolidayYear	No errors.
App\Entity\EmployeeHolidayRequest	No errors.
App\Entity\EmployeeActivityYear	No errors.
App\Entity\EmployeeActivity	No errors.
App\Entity\EmployeePresenceYear	No errors.
App\Entity\EmployeeRefundYear	No errors.
App\Entity\BudgetEmployee	No errors.
App\Entity\Offer	No errors.
App\Entity\OfferRequest	No errors.
App\Entity\Sell	No errors.
App\Entity\HospitalFacility	No errors.
App\Entity\Province	No errors.
App\Entity\ProductGroup	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\Product	No errors.
App\Entity\OfferProposal	No errors.
App\Entity\JoinTableFacilityProduct	No errors.
App\Entity\JoinTableHospitalProduct	No errors.
App\Entity\JoinTableRaceProduct	No errors.
App\Entity\BudgetEmployeeProduct	No errors.
App\Entity\Hospital	No errors.
App\Entity\HospitalGroup	No errors.
App\Entity\JoinTableHospitalFacilityCodes	No errors.
App\Entity\Region	No errors.
App\Entity\Race	No errors.
App\Entity\Permission	No errors.
App\Entity\PermissionCategory	No errors.
App\Entity\BudgetYear	No errors.
App\Entity\JoinTableBudgetEmployeeRefundType	No errors.
App\Entity\NotificationType	No errors.

Symfony Profiler

GET https://test.tillomeditalia.com/utente/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping