Symfony Profiler

[
  "route" => "app_time_report_index"
  "route_parameters" => [
    "_route" => "app_time_report_index"
    "_controller" => "App\Controller\TimeReportController::index"
  ]
  "request_uri" => "https://wmsys.eu/time-reports?embed=1&project=39&returnTo=https%3A%2F%2Fwmsys.eu%2Fprojects%2F39%23tab-employees"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "westmar"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "westmar"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "radek"
]

[
  "sql" => "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"
]

[
  "sql" => "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"
  "params" => [
    1 => 39
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 39
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 39
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2221
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 39
    2 => "2026-10-19 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2228
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 39
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "2026-10"
    2 => 39
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2228
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 39
    2 => "2026-10-19 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2228
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2221
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#2221}
  ]
]

[
  "sql" => "SELECT COUNT(t0_.id) AS sclr_0 FROM tickets t0_ WHERE t0_.status <> ?"
  "params" => [
    1 => "zakończone"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2228
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(p0_.id) AS sclr_0 FROM project_tasks p0_ WHERE p0_.assigned_to_id = ? AND p0_.status <> ?"
  "params" => [
    1 => 6
    2 => "zakończone"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2228
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 39
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 129
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 98
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#538
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]