Query Metrics

26 Database Queries
18 Different statements
7.11 ms Query time
0 Invalid entities
261 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.79 ms
(25.15%)
1
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.position AS position_4, t0.department AS department_5, t0.employment_type AS employment_type_6, t0.hourly_rate AS hourly_rate_7, t0.currency AS currency_8, t0.agreed_rate AS agreed_rate_9, t0.agreed_currency AS agreed_currency_10, t0.email AS email_11, t0.phone AS phone_12, t0.hire_date AS hire_date_13, t0.birth_date AS birth_date_14, t0.notes AS notes_15, t0.is_active AS is_active_16, t0.created_at AS created_at_17, t0.created_by_name AS created_by_name_18, t0.medical_exam_date AS medical_exam_date_19, t0.bhp_date AS bhp_date_20, t0.registered_country AS registered_country_21, t0.registered_city AS registered_city_22, t0.registered_address AS registered_address_23, t0.registered_postal_code AS registered_postal_code_24, t0.mailing_country AS mailing_country_25, t0.mailing_city AS mailing_city_26, t0.mailing_address AS mailing_address_27, t0.mailing_postal_code AS mailing_postal_code_28, t0.id_card_number AS id_card_number_29, t0.passport_number AS passport_number_30, t0.insurance_name AS insurance_name_31, t0.insurance_expiry AS insurance_expiry_32, t0.marital_status AS marital_status_33, t0.pesel AS pesel_34, t0.nip AS nip_35, t0.bank_account AS bank_account_36, t0.bank_name AS bank_name_37, t0.emergency_contact AS emergency_contact_38, t0.emergency_phone AS emergency_phone_39, t0.nationality AS nationality_40, t0.gross_rate AS gross_rate_41, t0.middle_name AS middle_name_42, t0.birth_place AS birth_place_43, t0.id_card_expiry AS id_card_expiry_44, t0.passport_expiry AS passport_expiry_45, t0.father_name AS father_name_46, t0.mother_name AS mother_name_47, t0.residence_card_id AS residence_card_id_48, t0.has_car AS has_car_49, t0.has_computer AS has_computer_50, t0.has_technical_equipment AS has_technical_equipment_51, t0.has_first_aid AS has_first_aid_52, t0.photo_file_name AS photo_file_name_53, t0.employment_type_abroad AS employment_type_abroad_54, t0.agreed_rate_abroad AS agreed_rate_abroad_55, t0.gross_rate_abroad AS gross_rate_abroad_56, t0.agreed_currency_abroad AS agreed_currency_abroad_57, t0.hourly_rate_abroad AS hourly_rate_abroad_58, t0.currency_abroad AS currency_abroad_59, t0.is_vat AS is_vat_60, t0.contract_valid_to AS contract_valid_to_61, t0.residence_card_expiry AS residence_card_expiry_62, t0.company_id AS company_id_63 FROM employees t0 WHERE t0.is_active = ? ORDER BY t0.last_name ASC
Parameters:
[
  1
]
0.83 ms
(11.66%)
2
SELECT t0.id AS id_1, t0.position AS position_2, t0.hire_date AS hire_date_3, t0.employment_type AS employment_type_4, t0.hourly_rate AS hourly_rate_5, t0.currency AS currency_6, t0.agreed_rate AS agreed_rate_7, t0.agreed_currency AS agreed_currency_8, t0.gross_rate AS gross_rate_9, t0.employment_type_abroad AS employment_type_abroad_10, t0.hourly_rate_abroad AS hourly_rate_abroad_11, t0.currency_abroad AS currency_abroad_12, t0.agreed_rate_abroad AS agreed_rate_abroad_13, t0.agreed_currency_abroad AS agreed_currency_abroad_14, t0.gross_rate_abroad AS gross_rate_abroad_15, t0.is_vat AS is_vat_16, t0.contract_valid_to AS contract_valid_to_17, t0.employee_id AS employee_id_18, t0.company_id AS company_id_19 FROM employee_companies t0 WHERE t0.employee_id = ?
Parameters:
[
  129
]
0.63 ms
(8.80%)
1
SELECT t0_.id AS id_0, t0_.report_date AS report_date_1, t0_.changed_by_name AS changed_by_name_2, t0_.changed_at AS changed_at_3, t0_.project_id AS project_id_4 FROM time_report_logs t0_ WHERE t0_.project_id = ? AND t0_.report_date = ? ORDER BY t0_.changed_at DESC
Parameters:
[
  39
  "2026-10-19 00:00:00"
]
0.60 ms
(8.48%)
1
SELECT t0_.id AS id_0, t0_.report_date AS report_date_1, t0_.planned_hours AS planned_hours_2, t0_.actual_hours AS actual_hours_3, t0_.comment AS comment_4, t0_.created_by_name AS created_by_name_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7, t0_.system_name AS system_name_8, t0_.employee_id AS employee_id_9, t0_.project_id AS project_id_10, t0_.company_id AS company_id_11 FROM time_reports t0_ WHERE t0_.project_id = ? AND t0_.report_date = ?
Parameters:
[
  39
  "2026-10-19 00:00:00"
]
0.47 ms
(6.61%)
2
SELECT t0.id AS id_1, t0.type AS type_2, t0.number AS number_3, t0.name AS name_4, t0.is_active AS is_active_5 FROM cost_categories t0 WHERE t0.id = ?
Parameters:
[
  43
]
0.43 ms
(6.07%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.drawing_file_name AS drawing_file_name_3, t0.quantity AS quantity_4, t0.description AS description_5, t0.created_by_name AS created_by_name_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.is_draw_accepted AS is_draw_accepted_9, t0.draw_accepted_by_name AS draw_accepted_by_name_10, t0.draw_accepted_at AS draw_accepted_at_11, t0.project_id AS project_id_12 FROM tech_cards t0 WHERE t0.project_id = ?
Parameters:
[
  39
]
0.42 ms
(5.84%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.planned_date AS planned_date_3, t0.actual_date AS actual_date_4, t0.sort_order AS sort_order_5, t0.project_id AS project_id_6 FROM project_schedules t0 WHERE t0.project_id = ? ORDER BY t0.name ASC
Parameters:
[
  39
]
0.39 ms
(5.45%)
1
SELECT m0_.id AS id_0, m0_.month AS month_1, m0_.submitted_by_name AS submitted_by_name_2, m0_.euro_rate AS euro_rate_3, m0_.submitted_at AS submitted_at_4, m0_.project_id AS project_id_5 FROM monthly_report_submissions m0_ WHERE m0_.month = ? AND m0_.project_id = ?
Parameters:
[
  "2026-10"
  39
]
0.32 ms
(4.51%)
1
SELECT m0_.id AS id_0, m0_.month AS month_1, m0_.submitted_by_name AS submitted_by_name_2, m0_.euro_rate AS euro_rate_3, m0_.submitted_at AS submitted_at_4, m0_.project_id AS project_id_5 FROM monthly_report_submissions m0_ WHERE m0_.project_id = ?
Parameters:
[
  39
]
0.23 ms
(3.22%)
1
SELECT t0.id AS id_1, t0.number AS number_2, t0.client_project_number AS client_project_number_3, t0.client_address AS client_address_4, t0.client_city AS client_city_5, t0.client_nip AS client_nip_6, t0.description AS description_7, t0.planned_hours AS planned_hours_8, t0.hourly_rate AS hourly_rate_9, t0.total_cost AS total_cost_10, t0.created_at AS created_at_11, t0.created_by_name AS created_by_name_12, t0.delivery_place AS delivery_place_13, t0.delivery_person AS delivery_person_14, t0.delivery_date AS delivery_date_15, t0.delivery_cost AS delivery_cost_16, t0.delivery_notes AS delivery_notes_17, t0.delivery_type AS delivery_type_18, t0.estimate_hours AS estimate_hours_19, t0.estimate_rate AS estimate_rate_20, t0.estimate_offer AS estimate_offer_21, t0.estimate_materials AS estimate_materials_22, t0.estimate_services AS estimate_services_23, t0.currency AS currency_24, t0.estimate_status AS estimate_status_25, t0.estimate_accepted_at AS estimate_accepted_at_26, t0.estimate_eur_rate AS estimate_eur_rate_27, t0.estimate_eur_rate_date AS estimate_eur_rate_date_28, t0.estimate_accepted_by AS estimate_accepted_by_29, t0.name AS name_30, t0.status AS status_31, t0.country AS country_32, t0.offer_number AS offer_number_33, t0.location AS location_34, t0.client_id AS client_id_35, t0.company_id AS company_id_36, t0.category_id AS category_id_37, t0.manager_id AS manager_id_38, t0.foreman_id AS foreman_id_39 FROM projects t0
Parameters:
[]
0.15 ms
(2.17%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.is_subcontractor AS is_subcontractor_5, t0.address AS address_6, t0.city AS city_7, t0.postal_code AS postal_code_8, t0.nip AS nip_9, t0.email AS email_10, t0.phone AS phone_11, t0.contact_person AS contact_person_12, t0.country AS country_13, t0.ksef_api_key AS ksef_api_key_14, t0.main_contractor_id AS main_contractor_id_15, t16.id AS id_17, t16.symfonia_email AS symfonia_email_18, t16.symfonia_api_key AS symfonia_api_key_19, t16.ksef_authfile_processed AS ksef_authfile_processed_20, t16.ksef_auth_token AS ksef_auth_token_21, t16.ksef_environment AS ksef_environment_22, t16.ksef_refresh_token AS ksef_refresh_token_23, t16.ksef_refresh_token_expiry AS ksef_refresh_token_expiry_24, t16.ksef_access_token AS ksef_access_token_25, t16.ksef_access_token_expiry AS ksef_access_token_expiry_26, t16.inthub_avatar_id AS inthub_avatar_id_27, t16.inthub_api_key AS inthub_api_key_28, t16.google_drive_enabled AS google_drive_enabled_29, t16.google_drive_gmail AS google_drive_gmail_30, t16.google_drive_access_token AS google_drive_access_token_31, t16.google_drive_refresh_token AS google_drive_refresh_token_32, t16.google_drive_token_expiry AS google_drive_token_expiry_33, t16.created_at AS created_at_34, t16.updated_at AS updated_at_35, t16.company_id AS company_id_36 FROM companies t0 LEFT JOIN company_settings t16 ON t16.company_id = t0.id WHERE t0.id = ?
Parameters:
[
  1
]
0.15 ms
(2.07%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.is_subcontractor AS is_subcontractor_5, t0.address AS address_6, t0.city AS city_7, t0.postal_code AS postal_code_8, t0.nip AS nip_9, t0.email AS email_10, t0.phone AS phone_11, t0.contact_person AS contact_person_12, t0.country AS country_13, t0.ksef_api_key AS ksef_api_key_14, t0.main_contractor_id AS main_contractor_id_15, t16.id AS id_17, t16.symfonia_email AS symfonia_email_18, t16.symfonia_api_key AS symfonia_api_key_19, t16.ksef_authfile_processed AS ksef_authfile_processed_20, t16.ksef_auth_token AS ksef_auth_token_21, t16.ksef_environment AS ksef_environment_22, t16.ksef_refresh_token AS ksef_refresh_token_23, t16.ksef_refresh_token_expiry AS ksef_refresh_token_expiry_24, t16.ksef_access_token AS ksef_access_token_25, t16.ksef_access_token_expiry AS ksef_access_token_expiry_26, t16.inthub_avatar_id AS inthub_avatar_id_27, t16.inthub_api_key AS inthub_api_key_28, t16.google_drive_enabled AS google_drive_enabled_29, t16.google_drive_gmail AS google_drive_gmail_30, t16.google_drive_access_token AS google_drive_access_token_31, t16.google_drive_refresh_token AS google_drive_refresh_token_32, t16.google_drive_token_expiry AS google_drive_token_expiry_33, t16.created_at AS created_at_34, t16.updated_at AS updated_at_35, t16.company_id AS company_id_36 FROM companies t0 LEFT JOIN company_settings t16 ON t16.company_id = t0.id WHERE t0.is_subcontractor = ? AND t0.is_active = ?
Parameters:
[
  1
  1
]
0.13 ms
(1.87%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.position AS position_7, t0.user_group AS user_group_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.created_by_name AS created_by_name_11, t0.is_active AS is_active_12, t0.countries AS countries_13 FROM users t0 WHERE t0.id = ?
Parameters:
[
  6
]
0.13 ms
(1.80%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.project_id AS project_id_3, t0.employee_id AS employee_id_4, t0.company_id AS company_id_5 FROM project_employees t0 WHERE t0.project_id = ?
Parameters:
[
  39
]
0.12 ms
(1.63%)
1
SELECT COUNT(t0_.id) AS sclr_0 FROM tickets t0_ WHERE t0_.status <> ?
Parameters:
[
  "zakończone"
]
0.11 ms
(1.60%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.short_name AS short_name_4, t0.quantity AS quantity_5, t0.unit_price AS unit_price_6, t0.created_at AS created_at_7, t0.created_by_name AS created_by_name_8, t0.project_id AS project_id_9, t0.cost_category_id AS cost_category_id_10, t0.unit_id AS unit_id_11 FROM project_calculations t0 WHERE t0.project_id = ? ORDER BY t0.position ASC
Parameters:
[
  39
]
0.11 ms
(1.58%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.city AS city_4, t0.postal_code AS postal_code_5, t0.nip AS nip_6, t0.country AS country_7, t0.email AS email_8, t0.phone AS phone_9, t0.contact_person AS contact_person_10, t0.notes AS notes_11, t0.created_at AS created_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14 FROM clients t0 WHERE t0.id = ?
Parameters:
[
  15
]
0.11 ms
(1.49%)
1
SELECT COUNT(p0_.id) AS sclr_0 FROM project_tasks p0_ WHERE p0_.assigned_to_id = ? AND p0_.status <> ?
Parameters:
[
  6
  "zakończone"
]

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\Employee 200
App\Entity\Company 20
App\Entity\ProjectSchedule 16
App\Entity\ProjectCalculation 8
App\Entity\Project 4
App\Entity\Client 4
App\Entity\User 3
App\Entity\ProjectEmployee 2
App\Entity\CostCategory 2
App\Entity\ProjectCategory 1
App\Entity\WarehouseUnit 1