Query Metrics
132
Database Queries
15
Different statements
151.06 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
101.92 ms (67.47%) |
1 |
SELECT t0_.id AS id_0, t0_.import_from AS import_from_1, t0_.import_date AS import_date_2, t0_.document_type AS document_type_3, t0_.issue_date AS issue_date_4, t0_.week_number AS week_number_5, t0_.month_number AS month_number_6, t0_.document_number AS document_number_7, t0_.product_code AS product_code_8, t0_.atc_code AS atc_code_9, t0_.aic_code AS aic_code_10, t0_.product_description AS product_description_11, t0_.lot_number AS lot_number_12, t0_.quantity AS quantity_13, t0_.net_unit_price AS net_unit_price_14, t0_.box_quantity AS box_quantity_15, t0_.net_box_price AS net_box_price_16, t0_.net_price AS net_price_17, t0_.charged_price AS charged_price_18, t0_.client_category AS client_category_19, t0_.client_code AS client_code_20, t0_.client_ministerial_code AS client_ministerial_code_21, t0_.client_business_name AS client_business_name_22, t0_.client_address AS client_address_23, t0_.client_province AS client_province_24, t0_.client_city AS client_city_25, t0_.client_zip AS client_zip_26, t0_.client_region AS client_region_27, t0_.vat AS vat_28, t0_.order_number AS order_number_29, t0_.order_date AS order_date_30, t0_.ref_date AS ref_date_31, t0_.receiver_client_code AS receiver_client_code_32, t0_.receiver_client_ministerial_code AS receiver_client_ministerial_code_33, t0_.receiver_client_business_name AS receiver_client_business_name_34, t0_.receiver_client_address AS receiver_client_address_35, t0_.receiver_client_province AS receiver_client_province_36, t0_.receiver_client_city AS receiver_client_city_37, t0_.receiver_client_zip AS receiver_client_zip_38, t0_.receiver_client_region AS receiver_client_region_39, t0_.kam AS kam_40, t0_.extra AS extra_41, t0_.notes AS notes_42, t0_.email AS email_43, t0_.lot_expiration_date AS lot_expiration_date_44, t0_.vs_vi AS vs_vi_45, t0_.invoice_num AS invoice_num_46, t0_.division AS division_47, t0_.organization AS organization_48, t0_.material AS material_49, t0_.selling_unit AS selling_unit_50, t0_.tax AS tax_51, t0_.backup_quantity AS backup_quantity_52, t0_.backup_net_unit_price AS backup_net_unit_price_53, t0_.num_of_docs_control AS num_of_docs_control_54, t0_.control_docs_date AS control_docs_date_55, t0_.delivery_num AS delivery_num_56, t0_.delivery_date AS delivery_date_57, t0_.cost AS cost_58, t0_.cold AS cold_59, t0_.cig_number AS cig_number_60, t0_.invoice_voice AS invoice_voice_61, t0_.product_id AS product_id_62, t0_.hospital_id AS hospital_id_63, t0_.facility_id AS facility_id_64, t0_.user_id AS user_id_65 FROM til_sell t0_ WHERE t0_.import_date > ? AND t0_.import_date <= ?
Parameters:
[ "2023-04-28" "2023-04-30" ] |
28.89 ms (19.12%) |
1 |
SELECT t0_.id AS id_0, t0_.yellow_alarm AS yellow_alarm_1, t0_.red_alarm AS red_alarm_2, t0_.avg_sell_cadence AS avg_sell_cadence_3, t0_.num_of_buy_dates AS num_of_buy_dates_4, t0_.last_order_date AS last_order_date_5, t0_.notes AS notes_6, t0_.disabled AS disabled_7, t0_.facility_id AS facility_id_8, t0_.product_id AS product_id_9 FROM til_join_table_facility_product t0_ LEFT JOIN til_facility t1_ ON t0_.facility_id = t1_.id ORDER BY t1_.name ASC
Parameters:
[] |
8.60 ms (5.69%) |
51 |
SELECT t0.id AS id_1, t0.status AS status_2, t0.value AS value_3, t0.notes AS notes_4, t0.file_path_kam AS file_path_kam_5, t0.file_path_supervisor AS file_path_supervisor_6, t0.file_path_boss AS file_path_boss_7, t0.is_holiday_counter_active AS is_holiday_counter_active_8, t0.is_rol_counter_active AS is_rol_counter_active_9, t0.presence_year_id AS presence_year_id_10 FROM til_presence_month t0 WHERE t0.presence_year_id = ? ORDER BY t0.value ASC
Parameters:
[
"52"
]
|
2.07 ms (1.37%) |
17 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3 FROM til_presence_year t0 WHERE t0.user_id = ?
Parameters:
[
"1746"
]
|
2.03 ms (1.35%) |
17 |
SELECT t0.id AS id_1, t0.country_code AS country_code_2, t0.phone AS phone_3, t0.fax AS fax_4, t0.mobile AS mobile_5, t0.address AS address_6, t0.zip AS zip_7, t0.other_city AS other_city_8, t0.other_province AS other_province_9, t0.user_id AS user_id_10, t0.city_id AS city_id_11, t0.profession_id AS profession_id_12, t0.department_id AS department_id_13 FROM til_profile t0 WHERE t0.user_id = ?
Parameters:
[
"1746"
]
|
1.88 ms (1.24%) |
17 |
SELECT t0.id AS id_1, t0.residue_rol AS residue_rol_2, t0.residue_holiday AS residue_holiday_3, t0.start_work_date AS start_work_date_4, t0.end_work_date AS end_work_date_5, t0.show_in_list AS show_in_list_6, t0.user_id AS user_id_7 FROM til_employee_data t0 WHERE t0.user_id = ?
Parameters:
[
"1746"
]
|
1.86 ms (1.23%) |
17 |
SELECT t0.id AS id_1, t0.last_update_date_time AS last_update_date_time_2, t0.is_terms_accepted AS is_terms_accepted_3, t0.is_news_accepted AS is_news_accepted_4, t0.user_id AS user_id_5 FROM til_privacy t0 WHERE t0.user_id = ?
Parameters:
[
"1746"
]
|
0.83 ms (0.55%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.address AS address_2, t0_.zip AS zip_3, t0_.lat AS lat_4, t0_.lng AS lng_5, t0_.is_public AS is_public_6, t0_.is_abbandoned_ignored AS is_abbandoned_ignored_7, t0_.minister_code AS minister_code_8, t0_.city_id AS city_id_9, t0_.assigned_kam_id AS assigned_kam_id_10, t0_.hospital_id AS hospital_id_11 FROM til_facility t0_ WHERE t0_.hospital_id IS NULL ORDER BY t0_.name ASC LIMIT 50
Parameters:
[] |
0.66 ms (0.43%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"test_tillomeditalia_com_db"
]
|
0.55 ms (0.37%) |
1 |
SELECT t0_.id AS id_0, t0_.email AS email_1, t0_.name AS name_2, t0_.surname AS surname_3, t0_.password AS password_4, t0_.is_active AS is_active_5, t0_.is_admin_active AS is_admin_active_6, t0_.directory_path AS directory_path_7, t0_.one_time_code AS one_time_code_8, t0_.expiration_one_time_code AS expiration_one_time_code_9, t0_.is_email_notification_active AS is_email_notification_active_10, t0_.office_hours AS office_hours_11, t0_.is_alert_read AS is_alert_read_12, t0_.is_gdpr_sent AS is_gdpr_sent_13, t0_.role AS role_14, t0_.account_type_id AS account_type_id_15, t0_.supervisor_id AS supervisor_id_16 FROM til_user t0_ LEFT JOIN til_account_type t1_ ON t0_.account_type_id = t1_.id WHERE (t1_.level < 4) AND t0_.is_admin_active = 1 AND t1_.slug <> ? AND t0_.email <> ? ORDER BY t0_.surname ASC, t0_.name ASC
Parameters:
[ "supervisor_mario" "rporrati@rpgmultimedia.it" ] |
0.55 ms (0.36%) |
3 |
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"
]
|
0.47 ms (0.31%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.vat AS vat_2, t0_.address AS address_3, t0_.zip AS zip_4, t0_.email AS email_5, t0_.pec AS pec_6, t0_.sdi AS sdi_7, t0_.phone AS phone_8, t0_.fax AS fax_9, t0_.minister_code AS minister_code_10, t0_.head_group AS head_group_11, t0_.is_public AS is_public_12, t0_.lat AS lat_13, t0_.lng AS lng_14, t0_.city_id AS city_id_15, t0_.hospital_group_id AS hospital_group_id_16 FROM til_hospital t0_ WHERE t0_.is_public IS NULL
Parameters:
[] |
0.44 ms (0.29%) |
1 |
SELECT t0_.id AS id_0, t0_.motivation AS motivation_1, t0_.date AS date_2, t0_.response AS response_3, t0_.status AS status_4, t0_.is_notified AS is_notified_5, t0_.user_id AS user_id_6 FROM til_request_holiday t0_ WHERE t0_.status = ? ORDER BY t0_.date DESC
Parameters:
[
"insert"
]
|
0.21 ms (0.14%) |
2 |
SELECT DATABASE()
Parameters:
[] |
0.12 ms (0.08%) |
1 |
SELECT t0.id AS id_1, t0.object_id AS object_id_2, t0.datetime AS datetime_3, t0.type AS type_4, t0.old_value AS old_value_5, t0.new_value AS new_value_6, t0.old_notes AS old_notes_7, t0.new_notes AS new_notes_8, t0.sender_id AS sender_id_9 FROM til_edit_request t0
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\JoinTableFacilityProduct | No errors. |
App\Entity\Facility | No errors. |
App\Entity\Product | No errors. |
App\Entity\Settings | No errors. |
App\Entity\Sell | No errors. |
App\Entity\Hospital | No errors. |
App\Entity\User | No errors. |
App\Entity\City | No errors. |
App\Entity\HospitalGroup | No errors. |
App\Entity\JoinTableFacilityTest | No errors. |
App\Entity\Answer | No errors. |
App\Entity\ZucchettiCode | No errors. |
App\Entity\SapCode | No errors. |
App\Entity\Department | No errors. |
App\Entity\Offer | No errors. |
App\Entity\OfferRequest | No errors. |
App\Entity\RequestHoliday | No errors. |
App\Entity\EditRequest | No errors. |
App\Entity\AccountType | No errors. |
App\Entity\Privacy | No errors. |
App\Entity\Profile | No errors. |
App\Entity\Profession | No errors. |
App\Entity\JoinTableProfileDepartment | No errors. |
App\Entity\EmployeeData | No errors. |
App\Entity\WorkHoliday | No errors. |
App\Entity\TestCode | No errors. |
App\Entity\JoinTableUserTest | No errors. |
App\Entity\JoinTableUserReimbursmentType | No errors. |
App\Entity\Leasing | No errors. |
App\Entity\Document | No errors. |
App\Entity\Notification | No errors. |
App\Entity\Log | No errors. |
App\Entity\PresenceYear | No errors. |
App\Entity\ReimbursmentYear | No errors. |
App\Entity\ActivityYear | No errors. |
App\Entity\Activity | No errors. |
App\Entity\BudgetKam | No errors. |
App\Entity\PresenceDay | No errors. |
App\Entity\Province | No errors. |
App\Entity\PresenceMonth | No errors. |
App\Entity\Category | No errors. |
App\Entity\ProductGroup | No errors. |
App\Entity\Proposal | No errors. |
App\Entity\JoinTableRaceProduct | No errors. |
App\Entity\BudgetProduct | No errors. |
App\Entity\Test | No errors. |
App\Entity\Question | No errors. |
App\Entity\DepartmentType | No errors. |
App\Entity\Referent | No errors. |
App\Entity\ReimbursmentType | No errors. |
App\Entity\DocumentType | No errors. |
App\Entity\NotificationType | No errors. |
App\Entity\ReimbursmentMonth | No errors. |
App\Entity\ActivityMonth | No errors. |
App\Entity\ActivityDay | No errors. |
App\Entity\BudgetTotal | No errors. |
App\Entity\Region | No errors. |
App\Entity\Race | No errors. |