Redirect 302 redirect from POST @user_sell_import (9a096e)

GET https://test.tillomeditalia.com/utente/vendite/lista-non-abbinate

Query Metrics

132 Database Queries
15 Different statements
740.89 ms Query time
0 Invalid entities
7301 Managed entities

Queries

Group similar statements

# Time Info
1 30.56 ms
SELECT t0_.id AS id_0, t0_.yellow_alarm AS yellow_alarm_1, t0_.red_alarm AS red_alarm_2, t0_.num_of_buy_dates AS num_of_buy_dates_3, t0_.avg_sell_cadence AS avg_sell_cadence_4, t0_.datetime_last_order AS datetime_last_order_5, t0_.notes AS notes_6, t0_.is_disabled AS is_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_hospital_facility t1_ ON t0_.facility_id = t1_.id ORDER BY t1_.name ASC
Parameters:
[]
2 0.26 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.12 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 108.67 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_.datetime_issue AS datetime_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 FROM til_sell t0_ WHERE t0_.datetime_import > ? AND t0_.datetime_import <= ?
Parameters:
[
  "2024-02-01"
  "2024-02-02"
]
5 0.30 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.70 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_ WHERE t0_.is_public IS NULL
Parameters:
[]
7 0.88 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_.minister_code AS minister_code_6, t0_.is_public AS is_public_7, t0_.is_abbandoned_ignored AS is_abbandoned_ignored_8, t0_.city_id AS city_id_9, t0_.hospital_id AS hospital_id_10, t0_.employee_id AS employee_id_11 FROM til_hospital_facility t0_ WHERE t0_.hospital_id IS NULL ORDER BY t0_.name ASC LIMIT 50
Parameters:
[]
8 0.20 ms
SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.motivation AS motivation_2, t0_.response AS response_3, t0_.datetime_start AS datetime_start_4, t0_.datetime_end AS datetime_end_5, t0_.datetime_send AS datetime_send_6, t0_.datetime_supervisor AS datetime_supervisor_7, t0_.employee_id AS employee_id_8 FROM til_employee_holiday_request t0_ WHERE t0_.status = ? ORDER BY t0_.datetime_send DESC
Parameters:
[
  "insert"
]
9 0.33 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.user_id AS user_id_43, t36.supervisor_id AS supervisor_id_44, t0.account_type_id AS account_type_id_45 FROM til_user t0 LEFT JOIN til_user_privacy t16 ON t16.user_id = t0.id LEFT JOIN til_user_profile t22 ON t22.user_id = t0.id LEFT JOIN til_employee t36 ON t36.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  "2"
]
10 0.16 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"
]
11 583.32 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_.datetime_issue AS datetime_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 FROM til_sell t0_ LEFT JOIN til_hospital t1_ ON t0_.hospital_id = t1_.id LEFT JOIN til_hospital_facility t2_ ON t0_.facility_id = t2_.id LEFT JOIN til_product t3_ ON t0_.product_id = t3_.id WHERE t1_.id IS NULL OR t2_.id IS NULL OR t3_.id IS NULL ORDER BY t0_.datetime_issue DESC
Parameters:
[]
12 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:
[
  "0"
]
13 0.22 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:
[
  "2"
]
14 0.20 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"
]
15 0.16 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"
]
16 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"
]
17 0.23 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:
[
  "2"
]
18 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:
[
  "3"
]
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:
[
  "4"
]
20 0.16 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"
]
21 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:
[
  "7"
]
22 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:
[
  "8"
]
23 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"
]
24 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:
[
  "10"
]
25 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:
[
  "11"
]
26 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"
]
27 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"
]
28 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:
[
  "14"
]
29 0.09 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"
]
30 0.15 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"
]
31 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:
[
  "17"
]
32 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"
]
33 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:
[
  "19"
]
34 0.09 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"
]
35 0.09 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"
]
36 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"
]
37 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"
]
38 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"
]
39 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"
]
40 0.09 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"
]
41 0.09 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"
]
42 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"
]
43 0.10 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"
]
44 0.10 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"
]
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:
[
  "31"
]
46 0.10 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"
]
47 0.09 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"
]
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:
[
  "34"
]
49 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:
[
  "35"
]
50 0.10 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"
]
51 0.10 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"
]
52 0.09 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"
]
53 0.10 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"
]
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:
[
  "40"
]
55 0.10 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"
]
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:
[
  "42"
]
57 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:
[
  "3"
]
58 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:
[
  "4"
]
59 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"
]
60 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"
]
61 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"
]
62 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:
[
  "8"
]
63 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"
]
64 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:
[
  "10"
]
65 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:
[
  "11"
]
66 0.09 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"
]
67 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:
[
  "15"
]
68 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"
]
69 0.16 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "550"
]
70 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "40"
]
71 0.14 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "432"
]
72 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "26"
]
73 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "27"
]
74 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "541"
]
75 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "64"
]
76 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "694"
]
77 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "51"
]
78 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "598"
]
79 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "42"
]
80 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "39"
]
81 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
82 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "11"
]
83 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "465"
]
84 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
85 0.12 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "634"
]
86 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "8"
]
87 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "45"
]
88 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "423"
]
89 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "18"
]
90 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "156"
]
91 0.15 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "17"
]
92 0.14 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "31"
]
93 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "25"
]
94 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "504"
]
95 0.15 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "41"
]
96 0.14 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "382"
]
97 0.15 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
98 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "22"
]
99 0.14 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "92"
]
100 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "37"
]
101 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "78"
]
102 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "551"
]
103 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "49"
]
104 0.14 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "512"
]
105 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "48"
]
106 0.14 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "508"
]
107 0.14 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "249"
]
108 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "438"
]
109 0.14 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "53"
]
110 0.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "13"
]
111 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
112 0.15 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
113 0.15 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "7"
]
114 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "478"
]
115 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "293"
]
116 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "510"
]
117 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "142"
]
118 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "57"
]
119 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "721"
]
120 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "614"
]
121 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "73"
]
122 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "364"
]
123 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "90"
]
124 0.15 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "26"
]
125 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
126 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "586"
]
127 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "588"
]
128 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "6"
]
129 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "9"
]
130 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "554"
]
131 0.13 ms
SELECT t0.id AS id_1, t0.ihs_code AS ihs_code_2, t0.name AS name_3, t0.vat AS vat_4, t0.address AS address_5, t0.zip AS zip_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.email AS email_9, t0.pec AS pec_10, t0.sdi AS sdi_11, t0.phone AS phone_12, t0.fax AS fax_13, t0.minister_code AS minister_code_14, t0.is_head_group AS is_head_group_15, t0.is_public AS is_public_16, t0.city_id AS city_id_17, t0.hospital_group_id AS hospital_group_id_18 FROM til_hospital t0 WHERE t0.id = ?
Parameters:
[
  "350"
]
132 0.13 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.dosage AS dosage_4, t0.short_dosage AS short_dosage_5, t0.dosage_int AS dosage_int_6, t0.class AS class_7, t0.aic_code AS aic_code_8, t0.atc_code AS atc_code_9, t0.unit_for_box AS unit_for_box_10, t0.max_unit_price AS max_unit_price_11, t0.image_path AS image_path_12, t0.datetime_start AS datetime_start_13, t0.datetime_budget_start AS datetime_budget_start_14, t0.is_visible AS is_visible_15, t0.is_archived AS is_archived_16, t0.is_retail AS is_retail_17, t0.product_category_id AS product_category_id_18, t0.product_group_id AS product_group_id_19 FROM til_product t0 WHERE t0.id = ?
Parameters:
[
  "20"
]

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\JoinTableFacilityProduct 4691
App\Entity\HospitalFacility 1206
App\Entity\Sell 828
App\Entity\Hospital 210
App\Entity\Notification 82
App\Entity\JoinTableUserPermission 58
App\Entity\Permission 58
App\Entity\City 57
App\Entity\Product 48
App\Entity\ProductGroup 18
App\Entity\PermissionCategory 13
App\Entity\Employee 9
App\Entity\ProductCategory 9
App\Entity\HospitalGroup 4
App\Entity\NotificationType 3
App\Entity\Settings 2
App\Entity\User 1
App\Entity\UserAccountType 1
App\Entity\UserPrivacy 1
App\Entity\UserProfile 1
App\Entity\UserProfession 1

Entities Mapping

Class Mapping errors
App\Entity\JoinTableFacilityProduct No errors.
App\Entity\HospitalFacility No errors.
App\Entity\Product No errors.
App\Entity\Settings No errors.
App\Entity\Sell No errors.
App\Entity\Hospital No errors.
App\Entity\Employee No errors.
App\Entity\City No errors.
App\Entity\HospitalGroup No errors.
App\Entity\JoinTableFacilityTest No errors.
App\Entity\TestAnswer No errors.
App\Entity\JoinTableHospitalFacilityCodes No errors.
App\Entity\HospitalDepartment No errors.
App\Entity\Offer No errors.
App\Entity\OfferRequest No errors.
App\Entity\EmployeeHolidayRequest No errors.
App\Entity\User No errors.
App\Entity\UserPrivacy No errors.
App\Entity\UserProfile No errors.
App\Entity\UserProfession 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\JoinTableUserPermission No errors.
App\Entity\EmployeeLeasing No errors.
App\Entity\EmployeeHolidayYear 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\Province No errors.
App\Entity\Permission No errors.
App\Entity\PermissionCategory No errors.
App\Entity\NotificationType No errors.
App\Entity\JoinTableHospitalProduct No errors.
App\Entity\ProductCategory No errors.
App\Entity\ProductGroup No errors.
App\Entity\OfferProposal No errors.
App\Entity\JoinTableRaceProduct No errors.
App\Entity\BudgetProduct No errors.