Query Metrics
129
Database Queries
13
Different statements
154.30 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 30.77 ms |
SELECT t0_.id AS id_0, t0_.yellow_alarm AS yellow_alarm_1, t0_.red_alarm AS red_alarm_2, t0_.avg_sell_cadence AS avg_sell_cadence_3, t0_.num_of_buy_dates AS num_of_buy_dates_4, t0_.last_order_date AS last_order_date_5, t0_.notes AS notes_6, t0_.disabled AS disabled_7, t0_.facility_id AS facility_id_8, t0_.product_id AS product_id_9 FROM til_join_table_facility_product t0_ LEFT JOIN til_facility t1_ ON t0_.facility_id = t1_.id ORDER BY t1_.name ASC
Parameters:
[] |
2 | 0.31 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.value AS value_4, t0.description AS description_5 FROM til_settings t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"sells_last_import_date"
]
|
3 | 0.11 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.value AS value_4, t0.description AS description_5 FROM til_settings t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"sells_old_last_import_date"
]
|
4 | 102.53 ms |
SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.import_date AS import_date_2, t0_.document_type AS document_type_3, t0_.issue_date AS issue_date_4, t0_.week_number AS week_number_5, t0_.month_number AS month_number_6, t0_.document_number AS document_number_7, t0_.product_code AS product_code_8, t0_.atc_code AS atc_code_9, t0_.aic_code AS aic_code_10, t0_.product_description AS product_description_11, t0_.lot_number AS lot_number_12, t0_.quantity AS quantity_13, t0_.net_unit_price AS net_unit_price_14, t0_.box_quantity AS box_quantity_15, t0_.net_box_price AS net_box_price_16, t0_.net_price AS net_price_17, t0_.charged_price AS charged_price_18, t0_.client_category AS client_category_19, t0_.client_code AS client_code_20, t0_.client_ministerial_code AS client_ministerial_code_21, t0_.client_business_name AS client_business_name_22, t0_.client_address AS client_address_23, t0_.client_province AS client_province_24, t0_.client_city AS client_city_25, t0_.client_zip AS client_zip_26, t0_.client_region AS client_region_27, t0_.vat AS vat_28, t0_.order_number AS order_number_29, t0_.order_date AS order_date_30, t0_.ref_date AS ref_date_31, t0_.receiver_client_code AS receiver_client_code_32, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_33, t0_.receiver_client_business_name AS receiver_client_business_name_34, t0_.receiver_client_address AS receiver_client_address_35, t0_.receiver_client_province AS receiver_client_province_36, t0_.receiver_client_city AS receiver_client_city_37, t0_.receiver_client_zip AS receiver_client_zip_38, t0_.receiver_client_region AS receiver_client_region_39, t0_.kam AS kam_40, t0_.extra AS extra_41, t0_.notes AS notes_42, t0_.email AS email_43, t0_.lot_expiration_date AS lot_expiration_date_44, t0_.vs_vi AS vs_vi_45, t0_.invoice_num AS invoice_num_46, t0_.division AS division_47, t0_.organization AS organization_48, t0_.material AS material_49, t0_.selling_unit AS selling_unit_50, t0_.tax AS tax_51, t0_.backup_quantity AS backup_quantity_52, t0_.backup_net_unit_price AS backup_net_unit_price_53, t0_.num_of_docs_control AS num_of_docs_control_54, t0_.control_docs_date AS control_docs_date_55, t0_.delivery_num AS delivery_num_56, t0_.delivery_date AS delivery_date_57, t0_.cost AS cost_58, t0_.cold AS cold_59, t0_.cig_number AS cig_number_60, t0_.invoice_voice AS invoice_voice_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.user_id AS user_id_65 FROM til_sell t0_ WHERE t0_.import_date > ? AND t0_.import_date <= ?
Parameters:
[ "2023-04-28" "2023-04-30" ] |
5 | 0.27 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.type AS type_3, t0.value AS value_4, t0.description AS description_5 FROM til_settings t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"sells_last_import_date"
]
|
6 | 0.54 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.vat AS vat_2, t0_.address AS address_3, t0_.zip AS zip_4, t0_.email AS email_5, t0_.pec AS pec_6, t0_.sdi AS sdi_7, t0_.phone AS phone_8, t0_.fax AS fax_9, t0_.minister_code AS minister_code_10, t0_.head_group AS head_group_11, t0_.is_public AS is_public_12, t0_.lat AS lat_13, t0_.lng AS lng_14, t0_.city_id AS city_id_15, t0_.hospital_group_id AS hospital_group_id_16 FROM til_hospital t0_ WHERE t0_.is_public IS NULL
Parameters:
[] |
7 | 1.03 ms |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.address AS address_2, t0_.zip AS zip_3, t0_.lat AS lat_4, t0_.lng AS lng_5, t0_.is_public AS is_public_6, t0_.is_abbandoned_ignored AS is_abbandoned_ignored_7, t0_.minister_code AS minister_code_8, t0_.city_id AS city_id_9, t0_.assigned_kam_id AS assigned_kam_id_10, t0_.hospital_id AS hospital_id_11 FROM til_facility t0_ WHERE t0_.hospital_id IS NULL ORDER BY t0_.name ASC LIMIT 50
Parameters:
[] |
8 | 0.49 ms |
SELECT t0_.id AS id_0, t0_.motivation AS motivation_1, t0_.date AS date_2, t0_.response AS response_3, t0_.status AS status_4, t0_.is_notified AS is_notified_5, t0_.user_id AS user_id_6 FROM til_request_holiday t0_ WHERE t0_.status = ? ORDER BY t0_.date DESC
Parameters:
[
"insert"
]
|
9 | 0.19 ms |
SELECT t0.id AS id_1, t0.object_id AS object_id_2, t0.datetime AS datetime_3, t0.type AS type_4, t0.old_value AS old_value_5, t0.new_value AS new_value_6, t0.old_notes AS old_notes_7, t0.new_notes AS new_notes_8, t0.sender_id AS sender_id_9 FROM til_edit_request t0
Parameters:
[] |
10 | 0.65 ms |
SELECT t0_.id AS id_0, t0_.email AS email_1, t0_.name AS name_2, t0_.surname AS surname_3, t0_.password AS password_4, t0_.is_active AS is_active_5, t0_.is_admin_active AS is_admin_active_6, t0_.directory_path AS directory_path_7, t0_.one_time_code AS one_time_code_8, t0_.expiration_one_time_code AS expiration_one_time_code_9, t0_.is_email_notification_active AS is_email_notification_active_10, t0_.office_hours AS office_hours_11, t0_.is_alert_read AS is_alert_read_12, t0_.is_gdpr_sent AS is_gdpr_sent_13, t0_.role AS role_14, t0_.account_type_id AS account_type_id_15, t0_.supervisor_id AS supervisor_id_16 FROM til_user t0_ LEFT JOIN til_account_type t1_ ON t0_.account_type_id = t1_.id WHERE (t1_.level < 4) AND t0_.is_admin_active = 1 AND t1_.slug <> ? AND t0_.email <> ? ORDER BY t0_.surname ASC, t0_.name ASC
Parameters:
[ "supervisor_mario" "rporrati@rpgmultimedia.it" ] |
11 | 0.19 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1746"
]
|
12 | 0.15 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1746"
]
|
13 | 0.17 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1746"
]
|
14 | 0.13 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"33"
]
|
15 | 0.18 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"33"
]
|
16 | 0.13 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"33"
]
|
17 | 0.12 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1926"
]
|
18 | 0.12 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1926"
]
|
19 | 0.13 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1926"
]
|
20 | 0.12 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1844"
]
|
21 | 0.12 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1844"
]
|
22 | 0.11 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1844"
]
|
23 | 0.09 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1748"
]
|
24 | 0.14 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1748"
]
|
25 | 0.12 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1748"
]
|
26 | 0.11 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1348"
]
|
27 | 0.12 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1348"
]
|
28 | 0.09 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1348"
]
|
29 | 0.13 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"2187"
]
|
30 | 0.13 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"2187"
]
|
31 | 0.11 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"2187"
]
|
32 | 0.11 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"29"
]
|
33 | 0.10 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"29"
]
|
34 | 0.13 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"29"
]
|
35 | 0.11 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1845"
]
|
36 | 0.12 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1845"
]
|
37 | 0.11 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1845"
]
|
38 | 0.10 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1940"
]
|
39 | 0.12 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1940"
]
|
40 | 0.11 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1940"
]
|
41 | 0.10 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1174"
]
|
42 | 0.10 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1174"
]
|
43 | 0.09 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1174"
]
|
44 | 0.10 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1867"
]
|
45 | 0.11 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1867"
]
|
46 | 0.11 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1867"
]
|
47 | 0.11 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"39"
]
|
48 | 0.11 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"39"
]
|
49 | 0.11 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"39"
]
|
50 | 0.11 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"24"
]
|
51 | 0.12 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"24"
]
|
52 | 0.10 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"24"
]
|
53 | 0.09 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"35"
]
|
54 | 0.12 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"35"
]
|
55 | 0.11 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"35"
]
|
56 | 0.11 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1481"
]
|
57 | 0.12 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1481"
]
|
58 | 0.09 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1481"
]
|
59 | 0.12 ms |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"816"
]
|
60 | 0.12 ms |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"816"
]
|
61 | 0.10 ms |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"816"
]
|
62 | 0.13 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1746"
]
|
63 | 0.19 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"52"
]
|
64 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"73"
]
|
65 | 0.11 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"33"
]
|
66 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"2"
]
|
67 | 0.17 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"12"
]
|
68 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"29"
]
|
69 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"42"
]
|
70 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"63"
]
|
71 | 0.16 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1926"
]
|
72 | 0.22 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"59"
]
|
73 | 0.14 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"78"
]
|
74 | 0.10 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1844"
]
|
75 | 0.19 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"54"
]
|
76 | 0.17 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"62"
]
|
77 | 0.10 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1748"
]
|
78 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"50"
]
|
79 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"72"
]
|
80 | 0.12 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1348"
]
|
81 | 0.17 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"36"
]
|
82 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"51"
]
|
83 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"76"
]
|
84 | 0.12 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"2187"
]
|
85 | 0.19 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"80"
]
|
86 | 0.14 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"29"
]
|
87 | 0.15 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"3"
]
|
88 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"17"
]
|
89 | 0.17 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"25"
]
|
90 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"47"
]
|
91 | 0.17 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"65"
]
|
92 | 0.12 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1845"
]
|
93 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"55"
]
|
94 | 0.32 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"69"
]
|
95 | 0.14 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1940"
]
|
96 | 0.15 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"60"
]
|
97 | 0.15 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"64"
]
|
98 | 0.17 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1174"
]
|
99 | 0.20 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"23"
]
|
100 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"31"
]
|
101 | 0.21 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"49"
]
|
102 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"70"
]
|
103 | 0.11 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1867"
]
|
104 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"56"
]
|
105 | 0.20 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"61"
]
|
106 | 0.11 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"39"
]
|
107 | 0.13 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"10"
]
|
108 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"13"
]
|
109 | 0.17 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"34"
]
|
110 | 0.19 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"40"
]
|
111 | 0.20 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"67"
]
|
112 | 0.12 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"24"
]
|
113 | 0.15 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"6"
]
|
114 | 0.24 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"18"
]
|
115 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"30"
]
|
116 | 0.25 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"53"
]
|
117 | 0.17 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"75"
]
|
118 | 0.12 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"35"
]
|
119 | 0.23 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"5"
]
|
120 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"15"
]
|
121 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"32"
]
|
122 | 0.23 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"48"
]
|
123 | 0.16 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"74"
]
|
124 | 0.16 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1481"
]
|
125 | 0.21 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"38"
]
|
126 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"41"
]
|
127 | 0.23 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"66"
]
|
128 | 0.12 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"816"
]
|
129 | 0.14 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"35"
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\JoinTableFacilityProduct | No errors. |
App\Entity\Facility | No errors. |
App\Entity\Product | No errors. |
App\Entity\Settings | No errors. |
App\Entity\Sell | No errors. |
App\Entity\Hospital | No errors. |
App\Entity\User | No errors. |
App\Entity\City | No errors. |
App\Entity\HospitalGroup | No errors. |
App\Entity\JoinTableFacilityTest | No errors. |
App\Entity\Answer | No errors. |
App\Entity\ZucchettiCode | No errors. |
App\Entity\SapCode | No errors. |
App\Entity\Department | No errors. |
App\Entity\Offer | No errors. |
App\Entity\OfferRequest | No errors. |
App\Entity\RequestHoliday | No errors. |
App\Entity\EditRequest | No errors. |
App\Entity\AccountType | No errors. |
App\Entity\Privacy | No errors. |
App\Entity\Profile | No errors. |
App\Entity\Profession | No errors. |
App\Entity\JoinTableProfileDepartment | No errors. |
App\Entity\EmployeeData | No errors. |
App\Entity\WorkHoliday | No errors. |
App\Entity\TestCode | No errors. |
App\Entity\JoinTableUserTest | No errors. |
App\Entity\JoinTableUserReimbursmentType | No errors. |
App\Entity\Leasing | No errors. |
App\Entity\Document | No errors. |
App\Entity\Notification | No errors. |
App\Entity\Log | No errors. |
App\Entity\PresenceYear | No errors. |
App\Entity\ReimbursmentYear | No errors. |
App\Entity\ActivityYear | No errors. |
App\Entity\Activity | No errors. |
App\Entity\BudgetKam | No errors. |
App\Entity\PresenceDay | No errors. |
App\Entity\Province | No errors. |
App\Entity\PresenceMonth | No errors. |