Query Metrics
132
Database Queries
15
Different statements
740.89 ms
Query time
0
Invalid entities
7301
Managed entities
Queries
#▲ | 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 |