Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.surname AS surname_6,
  t0.login_refused AS login_refused_7,
  t0.login_refused_message AS login_refused_message_8,
  t0.invisible_since AS invisible_since_9,
  t0.is_password_updated_at AS is_password_updated_at_10,
  t0.news_last_seen_at AS news_last_seen_at_11,
  t0.idle_timer_timeout AS idle_timer_timeout_12,
  t0.notification_preferences AS notification_preferences_13,
  t0.ui_preferences AS ui_preferences_14,
  t0.email_signature AS email_signature_15,
  t16.id AS id_17,
  t16.name AS name_18,
  t16.surname AS surname_19,
  t16.entry_at AS entry_at_20,
  t16.exit_at AS exit_at_21,
  t16.birthday_at AS birthday_at_22,
  t16.slug AS slug_23,
  t16.daily_work_time AS daily_work_time_24,
  t16.cost_per_hour AS cost_per_hour_25,
  t16.personal_id AS personal_id_26,
  t16.created_at AS created_at_27,
  t16.phone_number AS phone_number_28,
  t16.social_insurance_number AS social_insurance_number_29,
  t16.uiid AS uiid_30,
  t16.profile_image AS profile_image_31,
  t16.email AS email_32,
  t16.default_qualification_id AS default_qualification_id_33,
  t16.user_id AS user_id_34,
  t0.user_position_id AS user_position_id_35
FROM
  user t0
  LEFT JOIN worker t16 ON t16.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.surname AS surname_6, t0.login_refused AS login_refused_7, t0.login_refused_message AS login_refused_message_8, t0.invisible_since AS invisible_since_9, t0.is_password_updated_at AS is_password_updated_at_10, t0.news_last_seen_at AS news_last_seen_at_11, t0.idle_timer_timeout AS idle_timer_timeout_12, t0.notification_preferences AS notification_preferences_13, t0.ui_preferences AS ui_preferences_14, t0.email_signature AS email_signature_15, t16.id AS id_17, t16.name AS name_18, t16.surname AS surname_19, t16.entry_at AS entry_at_20, t16.exit_at AS exit_at_21, t16.birthday_at AS birthday_at_22, t16.slug AS slug_23, t16.daily_work_time AS daily_work_time_24, t16.cost_per_hour AS cost_per_hour_25, t16.personal_id AS personal_id_26, t16.created_at AS created_at_27, t16.phone_number AS phone_number_28, t16.social_insurance_number AS social_insurance_number_29, t16.uiid AS uiid_30, t16.profile_image AS profile_image_31, t16.email AS email_32, t16.default_qualification_id AS default_qualification_id_33, t16.user_id AS user_id_34, t0.user_position_id AS user_position_id_35 FROM user t0 LEFT JOIN worker t16 ON t16.user_id = t0.id WHERE t0.id = 18;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.submitted_at AS submitted_at_3,
  t0.reviewed_at AS reviewed_at_4,
  t0.last_decision_mail_at AS last_decision_mail_at_5,
  t0.created_at AS created_at_6,
  t0.task_execution_id AS task_execution_id_7,
  t0.requester_id AS requester_id_8,
  t0.reviewer_id AS reviewer_id_9
FROM
  material_request t0
WHERE
  t0.status IN (?, ?)
ORDER BY
  t0.submitted_at DESC,
  t0.id DESC

SELECT t0.id AS id_1, t0.status AS status_2, t0.submitted_at AS submitted_at_3, t0.reviewed_at AS reviewed_at_4, t0.last_decision_mail_at AS last_decision_mail_at_5, t0.created_at AS created_at_6, t0.task_execution_id AS task_execution_id_7, t0.requester_id AS requester_id_8, t0.reviewer_id AS reviewer_id_9 FROM material_request t0 WHERE t0.status IN ('submitted', 'partially_ordered') ORDER BY t0.submitted_at DESC, t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.work_content AS work_content_2,
  t0.is_linked AS is_linked_3,
  t0.planned_start_at AS planned_start_at_4,
  t0.planned_end_at AS planned_end_at_5,
  t0.actual_end_at AS actual_end_at_6,
  t0.delivery_at AS delivery_at_7,
  t0.delivery_note AS delivery_note_8,
  t0.rating AS rating_9,
  t0.cost AS cost_10,
  t0.contract_reference_nr AS contract_reference_nr_11,
  t0.execution_scope AS execution_scope_12,
  t0.execution_work_nature AS execution_work_nature_13,
  t0.status AS status_14,
  t0.published_at AS published_at_15,
  t0.accepted_at AS accepted_at_16,
  t0.declined_at AS declined_at_17,
  t0.decline_reason_category AS decline_reason_category_18,
  t0.decline_reason AS decline_reason_19,
  t0.owner_last_read_at AS owner_last_read_at_20,
  t0.executor_last_read_at AS executor_last_read_at_21,
  t0.vendor_id AS vendor_id_22,
  t0.vendor_contact_person_id AS vendor_contact_person_id_23,
  t0.reason_id AS reason_id_24,
  t0.task_id AS task_id_25,
  t0.contract_type_id AS contract_type_id_26,
  t0.branch_id AS branch_id_27,
  t0.branch_contact_person_id AS branch_contact_person_id_28,
  t0.published_by_id AS published_by_id_29
FROM
  project_order_task_fulfillment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.work_content AS work_content_2, t0.is_linked AS is_linked_3, t0.planned_start_at AS planned_start_at_4, t0.planned_end_at AS planned_end_at_5, t0.actual_end_at AS actual_end_at_6, t0.delivery_at AS delivery_at_7, t0.delivery_note AS delivery_note_8, t0.rating AS rating_9, t0.cost AS cost_10, t0.contract_reference_nr AS contract_reference_nr_11, t0.execution_scope AS execution_scope_12, t0.execution_work_nature AS execution_work_nature_13, t0.status AS status_14, t0.published_at AS published_at_15, t0.accepted_at AS accepted_at_16, t0.declined_at AS declined_at_17, t0.decline_reason_category AS decline_reason_category_18, t0.decline_reason AS decline_reason_19, t0.owner_last_read_at AS owner_last_read_at_20, t0.executor_last_read_at AS executor_last_read_at_21, t0.vendor_id AS vendor_id_22, t0.vendor_contact_person_id AS vendor_contact_person_id_23, t0.reason_id AS reason_id_24, t0.task_id AS task_id_25, t0.contract_type_id AS contract_type_id_26, t0.branch_id AS branch_id_27, t0.branch_contact_person_id AS branch_contact_person_id_28, t0.published_by_id AS published_by_id_29 FROM project_order_task_fulfillment t0 WHERE t0.id = 18;

SELECT
  t0.id AS id_1,
  t0.task_index AS task_index_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.progress_weight AS progress_weight_5,
  t0.duration_days AS duration_days_6,
  t0.started_at AS started_at_7,
  t0.completed_at AS completed_at_8,
  t0.project_order_id AS project_order_id_9,
  t0.fulfillment_stage_id AS fulfillment_stage_id_10,
  t11.id AS id_12,
  t11.work_content AS work_content_13,
  t11.is_linked AS is_linked_14,
  t11.planned_start_at AS planned_start_at_15,
  t11.planned_end_at AS planned_end_at_16,
  t11.actual_end_at AS actual_end_at_17,
  t11.delivery_at AS delivery_at_18,
  t11.delivery_note AS delivery_note_19,
  t11.rating AS rating_20,
  t11.cost AS cost_21,
  t11.contract_reference_nr AS contract_reference_nr_22,
  t11.execution_scope AS execution_scope_23,
  t11.execution_work_nature AS execution_work_nature_24,
  t11.status AS status_25,
  t11.published_at AS published_at_26,
  t11.accepted_at AS accepted_at_27,
  t11.declined_at AS declined_at_28,
  t11.decline_reason_category AS decline_reason_category_29,
  t11.decline_reason AS decline_reason_30,
  t11.owner_last_read_at AS owner_last_read_at_31,
  t11.executor_last_read_at AS executor_last_read_at_32,
  t11.vendor_id AS vendor_id_33,
  t11.vendor_contact_person_id AS vendor_contact_person_id_34,
  t11.reason_id AS reason_id_35,
  t11.task_id AS task_id_36,
  t11.contract_type_id AS contract_type_id_37,
  t11.branch_id AS branch_id_38,
  t11.branch_contact_person_id AS branch_contact_person_id_39,
  t11.published_by_id AS published_by_id_40,
  t0.responsible_person_id AS responsible_person_id_41
FROM
  project_order_tasks t0
  LEFT JOIN project_order_task_fulfillment t11 ON t11.task_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.task_index AS task_index_2, t0.title AS title_3, t0.description AS description_4, t0.progress_weight AS progress_weight_5, t0.duration_days AS duration_days_6, t0.started_at AS started_at_7, t0.completed_at AS completed_at_8, t0.project_order_id AS project_order_id_9, t0.fulfillment_stage_id AS fulfillment_stage_id_10, t11.id AS id_12, t11.work_content AS work_content_13, t11.is_linked AS is_linked_14, t11.planned_start_at AS planned_start_at_15, t11.planned_end_at AS planned_end_at_16, t11.actual_end_at AS actual_end_at_17, t11.delivery_at AS delivery_at_18, t11.delivery_note AS delivery_note_19, t11.rating AS rating_20, t11.cost AS cost_21, t11.contract_reference_nr AS contract_reference_nr_22, t11.execution_scope AS execution_scope_23, t11.execution_work_nature AS execution_work_nature_24, t11.status AS status_25, t11.published_at AS published_at_26, t11.accepted_at AS accepted_at_27, t11.declined_at AS declined_at_28, t11.decline_reason_category AS decline_reason_category_29, t11.decline_reason AS decline_reason_30, t11.owner_last_read_at AS owner_last_read_at_31, t11.executor_last_read_at AS executor_last_read_at_32, t11.vendor_id AS vendor_id_33, t11.vendor_contact_person_id AS vendor_contact_person_id_34, t11.reason_id AS reason_id_35, t11.task_id AS task_id_36, t11.contract_type_id AS contract_type_id_37, t11.branch_id AS branch_id_38, t11.branch_contact_person_id AS branch_contact_person_id_39, t11.published_by_id AS published_by_id_40, t0.responsible_person_id AS responsible_person_id_41 FROM project_order_tasks t0 LEFT JOIN project_order_task_fulfillment t11 ON t11.task_id = t0.id WHERE t0.id = 2000;

SELECT
  t0.id AS id_1,
  t0.order_nr AS order_nr_2,
  t0.order_description AS order_description_3,
  t0.order_price AS order_price_4,
  t0.order_status AS order_status_5,
  t0.should_end_at AS should_end_at_6,
  t0.is_end_at AS is_end_at_7,
  t0.hourly_rate AS hourly_rate_8,
  t0.order_at AS order_at_9,
  t0.project_owner_order_nr AS project_owner_order_nr_10,
  t0.hours_spent AS hours_spent_11,
  t0.cost_spent AS cost_spent_12,
  t0.material_budget AS material_budget_13,
  t0.timesheet_budget AS timesheet_budget_14,
  t0.target_profit AS target_profit_15,
  t0.created_at AS created_at_16,
  t0.plan_rating AS plan_rating_17,
  t0.project_id AS project_id_18,
  t0.contact_person_id AS contact_person_id_19,
  t0.author_id AS author_id_20,
  t0.invoice_type_id AS invoice_type_id_21,
  t0.order_primary_lead_id AS order_primary_lead_id_22,
  t0.order_branch_id AS order_branch_id_23,
  t0.branch_department_id AS branch_department_id_24,
  t25.id AS id_26,
  t25.spent_hours AS spent_hours_27,
  t25.spent_costs AS spent_costs_28,
  t25.expenses AS expenses_29,
  t25.half_finished AS half_finished_30,
  t25.backlog AS backlog_31,
  t25.contribution_margin AS contribution_margin_32,
  t25.stock_expenses AS stock_expenses_33,
  t25.progress AS progress_34,
  t25.open_invoices AS open_invoices_35,
  t25.received_invoices AS received_invoices_36,
  t25.total_invoices AS total_invoices_37,
  t25.open_undertakings AS open_undertakings_38,
  t25.received_undertakings AS received_undertakings_39,
  t25.total_undertakings AS total_undertakings_40,
  t25.order_progress AS order_progress_41,
  t25.total_billings AS total_billings_42,
  t25.open_billings AS open_billings_43,
  t25.paid_billings AS paid_billings_44,
  t25.project_order_id AS project_order_id_45,
  t0.works_plan_id AS works_plan_id_46
FROM
  project_orders t0
  LEFT JOIN project_order_metrics t25 ON t25.project_order_id = t0.id
WHERE
  t0.id = ?
  AND (
    (
      (
        t0.project_id IS NULL
        OR t0.project_id NOT IN (
          SELECT
            p_arch.id
          FROM
            projects p_arch
          WHERE
            p_arch.customer_id IN (
              SELECT
                c_arch.id
              FROM
                customer c_arch
              WHERE
                c_arch.is_archived = 1
            )
        )
      )
    )
  )

SELECT t0.id AS id_1, t0.order_nr AS order_nr_2, t0.order_description AS order_description_3, t0.order_price AS order_price_4, t0.order_status AS order_status_5, t0.should_end_at AS should_end_at_6, t0.is_end_at AS is_end_at_7, t0.hourly_rate AS hourly_rate_8, t0.order_at AS order_at_9, t0.project_owner_order_nr AS project_owner_order_nr_10, t0.hours_spent AS hours_spent_11, t0.cost_spent AS cost_spent_12, t0.material_budget AS material_budget_13, t0.timesheet_budget AS timesheet_budget_14, t0.target_profit AS target_profit_15, t0.created_at AS created_at_16, t0.plan_rating AS plan_rating_17, t0.project_id AS project_id_18, t0.contact_person_id AS contact_person_id_19, t0.author_id AS author_id_20, t0.invoice_type_id AS invoice_type_id_21, t0.order_primary_lead_id AS order_primary_lead_id_22, t0.order_branch_id AS order_branch_id_23, t0.branch_department_id AS branch_department_id_24, t25.id AS id_26, t25.spent_hours AS spent_hours_27, t25.spent_costs AS spent_costs_28, t25.expenses AS expenses_29, t25.half_finished AS half_finished_30, t25.backlog AS backlog_31, t25.contribution_margin AS contribution_margin_32, t25.stock_expenses AS stock_expenses_33, t25.progress AS progress_34, t25.open_invoices AS open_invoices_35, t25.received_invoices AS received_invoices_36, t25.total_invoices AS total_invoices_37, t25.open_undertakings AS open_undertakings_38, t25.received_undertakings AS received_undertakings_39, t25.total_undertakings AS total_undertakings_40, t25.order_progress AS order_progress_41, t25.total_billings AS total_billings_42, t25.open_billings AS open_billings_43, t25.paid_billings AS paid_billings_44, t25.project_order_id AS project_order_id_45, t0.works_plan_id AS works_plan_id_46 FROM project_orders t0 LEFT JOIN project_order_metrics t25 ON t25.project_order_id = t0.id WHERE t0.id = 1904 AND (((t0.project_id IS NULL OR t0.project_id NOT IN (SELECT p_arch.id FROM projects p_arch WHERE p_arch.customer_id IN (SELECT c_arch.id FROM customer c_arch WHERE c_arch.is_archived = 1)))));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.branch_location_id AS branch_location_id_4,
  t0.responsible_id AS responsible_id_5
FROM
  branches t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.branch_location_id AS branch_location_id_4, t0.responsible_id AS responsible_id_5 FROM branches t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.entry_at AS entry_at_2,
  t0.exit_at AS exit_at_3,
  t0.created_at AS created_at_4,
  t0.guest AS guest_5,
  t0.is_kpi_responsible AS is_kpi_responsible_6,
  t0.termination_reason AS termination_reason_7,
  t0.hourly_rate AS hourly_rate_8,
  t0.daily_working_hours AS daily_working_hours_9,
  t0.worker_id AS worker_id_10,
  t0.partner_id AS partner_id_11,
  t0.user_id AS user_id_12
FROM
  worker_activities t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.entry_at AS entry_at_2, t0.exit_at AS exit_at_3, t0.created_at AS created_at_4, t0.guest AS guest_5, t0.is_kpi_responsible AS is_kpi_responsible_6, t0.termination_reason AS termination_reason_7, t0.hourly_rate AS hourly_rate_8, t0.daily_working_hours AS daily_working_hours_9, t0.worker_id AS worker_id_10, t0.partner_id AS partner_id_11, t0.user_id AS user_id_12 FROM worker_activities t0 WHERE t0.id = 364;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.entry_at AS entry_at_4,
  t0.exit_at AS exit_at_5,
  t0.birthday_at AS birthday_at_6,
  t0.slug AS slug_7,
  t0.daily_work_time AS daily_work_time_8,
  t0.cost_per_hour AS cost_per_hour_9,
  t0.personal_id AS personal_id_10,
  t0.created_at AS created_at_11,
  t0.phone_number AS phone_number_12,
  t0.social_insurance_number AS social_insurance_number_13,
  t0.uiid AS uiid_14,
  t0.profile_image AS profile_image_15,
  t0.email AS email_16,
  t0.default_qualification_id AS default_qualification_id_17,
  t0.user_id AS user_id_18
FROM
  worker t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.entry_at AS entry_at_4, t0.exit_at AS exit_at_5, t0.birthday_at AS birthday_at_6, t0.slug AS slug_7, t0.daily_work_time AS daily_work_time_8, t0.cost_per_hour AS cost_per_hour_9, t0.personal_id AS personal_id_10, t0.created_at AS created_at_11, t0.phone_number AS phone_number_12, t0.social_insurance_number AS social_insurance_number_13, t0.uiid AS uiid_14, t0.profile_image AS profile_image_15, t0.email AS email_16, t0.default_qualification_id AS default_qualification_id_17, t0.user_id AS user_id_18 FROM worker t0 WHERE t0.id = 448;

SELECT
  t0.id AS id_1,
  t0.entry_at AS entry_at_2,
  t0.exit_at AS exit_at_3,
  t0.created_at AS created_at_4,
  t0.guest AS guest_5,
  t0.is_kpi_responsible AS is_kpi_responsible_6,
  t0.termination_reason AS termination_reason_7,
  t0.hourly_rate AS hourly_rate_8,
  t0.daily_working_hours AS daily_working_hours_9,
  t0.worker_id AS worker_id_10,
  t0.partner_id AS partner_id_11,
  t0.user_id AS user_id_12
FROM
  worker_activities t0
WHERE
  (
    t0.exit_at IS NULL
    AND t0.worker_id = ?
  )
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.entry_at AS entry_at_2, t0.exit_at AS exit_at_3, t0.created_at AS created_at_4, t0.guest AS guest_5, t0.is_kpi_responsible AS is_kpi_responsible_6, t0.termination_reason AS termination_reason_7, t0.hourly_rate AS hourly_rate_8, t0.daily_working_hours AS daily_working_hours_9, t0.worker_id AS worker_id_10, t0.partner_id AS partner_id_11, t0.user_id AS user_id_12 FROM worker_activities t0 WHERE (t0.exit_at IS NULL AND t0.worker_id = 448) ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.file_name AS file_name_3,
  t0.file_path AS file_path_4,
  t0.status AS status_5,
  t0.free_text AS free_text_6,
  t0.review_note AS review_note_7,
  t0.created_at AS created_at_8,
  t0.material_request_id AS material_request_id_9,
  t0.item_group_id AS item_group_id_10
FROM
  material_request_documents t0
WHERE
  t0.material_request_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.file_name AS file_name_3, t0.file_path AS file_path_4, t0.status AS status_5, t0.free_text AS free_text_6, t0.review_note AS review_note_7, t0.created_at AS created_at_8, t0.material_request_id AS material_request_id_9, t0.item_group_id AS item_group_id_10 FROM material_request_documents t0 WHERE t0.material_request_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  item_groups t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM item_groups t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  item_groups t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM item_groups t0 WHERE t0.id = 5;