Symfony Profiler

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,
  t10.id AS id_11,
  t10.work_content AS work_content_12,
  t10.is_linked AS is_linked_13,
  t10.planned_start_at AS planned_start_at_14,
  t10.planned_end_at AS planned_end_at_15,
  t10.actual_end_at AS actual_end_at_16,
  t10.delivery_at AS delivery_at_17,
  t10.delivery_note AS delivery_note_18,
  t10.rating AS rating_19,
  t10.cost AS cost_20,
  t10.contract_reference_nr AS contract_reference_nr_21,
  t10.execution_scope AS execution_scope_22,
  t10.execution_work_nature AS execution_work_nature_23,
  t10.vendor_id AS vendor_id_24,
  t10.vendor_contact_person_id AS vendor_contact_person_id_25,
  t10.reason_id AS reason_id_26,
  t10.task_id AS task_id_27,
  t10.contract_type_id AS contract_type_id_28,
  t10.branch_id AS branch_id_29,
  t10.branch_contact_person_id AS branch_contact_person_id_30,
  t0.responsible_person_id AS responsible_person_id_31
FROM
  project_order_tasks t0
  LEFT JOIN project_order_task_fulfillment t10 ON t10.task_id = t0.id
WHERE
  t0.project_order_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, t10.id AS id_11, t10.work_content AS work_content_12, t10.is_linked AS is_linked_13, t10.planned_start_at AS planned_start_at_14, t10.planned_end_at AS planned_end_at_15, t10.actual_end_at AS actual_end_at_16, t10.delivery_at AS delivery_at_17, t10.delivery_note AS delivery_note_18, t10.rating AS rating_19, t10.cost AS cost_20, t10.contract_reference_nr AS contract_reference_nr_21, t10.execution_scope AS execution_scope_22, t10.execution_work_nature AS execution_work_nature_23, t10.vendor_id AS vendor_id_24, t10.vendor_contact_person_id AS vendor_contact_person_id_25, t10.reason_id AS reason_id_26, t10.task_id AS task_id_27, t10.contract_type_id AS contract_type_id_28, t10.branch_id AS branch_id_29, t10.branch_contact_person_id AS branch_contact_person_id_30, t0.responsible_person_id AS responsible_person_id_31 FROM project_order_tasks t0 LEFT JOIN project_order_task_fulfillment t10 ON t10.task_id = t0.id WHERE t0.project_order_id = 1795;

SELECT
  t0.id AS id_1,
  t0.unit AS unit_2,
  t0.created_at AS created_at_3,
  t0.delivered_at AS delivered_at_4,
  t0.amount AS amount_5,
  t0.delivered_unit AS delivered_unit_6,
  t0.content AS content_7,
  t0.completed AS completed_8,
  t0.comment AS comment_9,
  t0.delivered_to AS delivered_to_10,
  t0.an_supplier AS an_supplier_11,
  t0.document AS document_12,
  t0.documents AS documents_13,
  t0.buying_price AS buying_price_14,
  t0.price_unit AS price_unit_15,
  t0.sales_price AS sales_price_16,
  t0.sales_margin AS sales_margin_17,
  t0.delivery_amount AS delivery_amount_18,
  t0.offer_nr AS offer_nr_19,
  t0.position_type AS position_type_20,
  t0.delivery_status AS delivery_status_21,
  t0.size AS size_22,
  t0.project_order_expense_id AS project_order_expense_id_23,
  t0.material_id AS material_id_24,
  t0.project_order_id AS project_order_id_25,
  t0.parent_pos_id AS parent_pos_id_26,
  t0.stock_id AS stock_id_27,
  t0.purchase_request_position_id AS purchase_request_position_id_28,
  t0.supplier_product_id AS supplier_product_id_29
FROM
  project_order_expense_positions t0
WHERE
  t0.project_order_id = ?

SELECT t0.id AS id_1, t0.unit AS unit_2, t0.created_at AS created_at_3, t0.delivered_at AS delivered_at_4, t0.amount AS amount_5, t0.delivered_unit AS delivered_unit_6, t0.content AS content_7, t0.completed AS completed_8, t0.comment AS comment_9, t0.delivered_to AS delivered_to_10, t0.an_supplier AS an_supplier_11, t0.document AS document_12, t0.documents AS documents_13, t0.buying_price AS buying_price_14, t0.price_unit AS price_unit_15, t0.sales_price AS sales_price_16, t0.sales_margin AS sales_margin_17, t0.delivery_amount AS delivery_amount_18, t0.offer_nr AS offer_nr_19, t0.position_type AS position_type_20, t0.delivery_status AS delivery_status_21, t0.size AS size_22, t0.project_order_expense_id AS project_order_expense_id_23, t0.material_id AS material_id_24, t0.project_order_id AS project_order_id_25, t0.parent_pos_id AS parent_pos_id_26, t0.stock_id AS stock_id_27, t0.purchase_request_position_id AS purchase_request_position_id_28, t0.supplier_product_id AS supplier_product_id_29 FROM project_order_expense_positions t0 WHERE t0.project_order_id = 1795;

SELECT
  t0.id AS id_1,
  t0.job_weight AS job_weight_2,
  t0.job_index AS job_index_3,
  t0.start_at AS start_at_4,
  t0.end_at AS end_at_5,
  t0.rating AS rating_6,
  t0.real_days AS real_days_7,
  t0.job_description AS job_description_8,
  t0.duration_days AS duration_days_9,
  t0.order_task_id AS order_task_id_10,
  t0.source_plan_job_id AS source_plan_job_id_11
FROM
  project_order_task_jobs t0
WHERE
  t0.order_task_id = ?

SELECT t0.id AS id_1, t0.job_weight AS job_weight_2, t0.job_index AS job_index_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5, t0.rating AS rating_6, t0.real_days AS real_days_7, t0.job_description AS job_description_8, t0.duration_days AS duration_days_9, t0.order_task_id AS order_task_id_10, t0.source_plan_job_id AS source_plan_job_id_11 FROM project_order_task_jobs t0 WHERE t0.order_task_id = 1746;

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
  INNER JOIN project_order_alternate_leads ON t0.id = project_order_alternate_leads.worker_activity_id
WHERE
  project_order_alternate_leads.project_order_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 INNER JOIN project_order_alternate_leads ON t0.id = project_order_alternate_leads.worker_activity_id WHERE project_order_alternate_leads.project_order_id = 1795;

SELECT
  t0.id AS id_1,
  t0.feedback AS feedback_2,
  t0.created_at AS created_at_3,
  t0.order_status AS order_status_4,
  t0.comment AS comment_5,
  t0.status_at AS status_at_6,
  t0.project_order_id AS project_order_id_7,
  t0.user_id AS user_id_8
FROM
  project_order_feedback t0
WHERE
  t0.project_order_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.feedback AS feedback_2, t0.created_at AS created_at_3, t0.order_status AS order_status_4, t0.comment AS comment_5, t0.status_at AS status_at_6, t0.project_order_id AS project_order_id_7, t0.user_id AS user_id_8 FROM project_order_feedback t0 WHERE t0.project_order_id = 1795 ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.invoice_nr AS invoice_nr_2,
  t0.created_at AS created_at_3,
  t0.amount AS amount_4,
  t0.total AS total_5,
  t0.expensed_at AS expensed_at_6,
  t0.expense_nr AS expense_nr_7,
  t0.offer_nr AS offer_nr_8,
  t0.offer_at AS offer_at_9,
  t0.delivery_due_at AS delivery_due_at_10,
  t0.comment AS comment_11,
  t0.document AS document_12,
  t0.documents AS documents_13,
  t0.supplier_id AS supplier_id_14,
  t0.deliver_location_id AS deliver_location_id_15,
  t0.purchase_request_id AS purchase_request_id_16
FROM
  project_order_expenses t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.invoice_nr AS invoice_nr_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.total AS total_5, t0.expensed_at AS expensed_at_6, t0.expense_nr AS expense_nr_7, t0.offer_nr AS offer_nr_8, t0.offer_at AS offer_at_9, t0.delivery_due_at AS delivery_due_at_10, t0.comment AS comment_11, t0.document AS document_12, t0.documents AS documents_13, t0.supplier_id AS supplier_id_14, t0.deliver_location_id AS deliver_location_id_15, t0.purchase_request_id AS purchase_request_id_16 FROM project_order_expenses t0 WHERE t0.id = 2606;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.branch_id AS branch_id_5
FROM
  branch_departments t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.branch_id AS branch_id_5 FROM branch_departments t0 WHERE t0.id = 427;

SELECT
  p0_.id AS id_0,
  p0_.order_nr AS order_nr_1,
  p0_.order_description AS order_description_2,
  p0_.order_price AS order_price_3,
  p0_.order_status AS order_status_4,
  p0_.should_end_at AS should_end_at_5,
  p0_.is_end_at AS is_end_at_6,
  p0_.hourly_rate AS hourly_rate_7,
  p0_.order_at AS order_at_8,
  p0_.project_owner_order_nr AS project_owner_order_nr_9,
  p0_.hours_spent AS hours_spent_10,
  p0_.cost_spent AS cost_spent_11,
  p0_.material_budget AS material_budget_12,
  p0_.timesheet_budget AS timesheet_budget_13,
  p0_.target_profit AS target_profit_14,
  p0_.created_at AS created_at_15,
  p0_.plan_rating AS plan_rating_16,
  p1_.id AS id_17,
  p1_.spent_hours AS spent_hours_18,
  p1_.spent_costs AS spent_costs_19,
  p1_.expenses AS expenses_20,
  p1_.half_finished AS half_finished_21,
  p1_.backlog AS backlog_22,
  p1_.contribution_margin AS contribution_margin_23,
  p1_.stock_expenses AS stock_expenses_24,
  p1_.progress AS progress_25,
  p1_.open_invoices AS open_invoices_26,
  p1_.received_invoices AS received_invoices_27,
  p1_.total_invoices AS total_invoices_28,
  p1_.open_undertakings AS open_undertakings_29,
  p1_.received_undertakings AS received_undertakings_30,
  p1_.total_undertakings AS total_undertakings_31,
  p1_.order_progress AS order_progress_32,
  p1_.total_billings AS total_billings_33,
  p1_.open_billings AS open_billings_34,
  p1_.paid_billings AS paid_billings_35,
  p0_.project_id AS project_id_36,
  p0_.contact_person_id AS contact_person_id_37,
  p0_.author_id AS author_id_38,
  p0_.invoice_type_id AS invoice_type_id_39,
  p0_.order_primary_lead_id AS order_primary_lead_id_40,
  p0_.order_branch_id AS order_branch_id_41,
  p0_.branch_department_id AS branch_department_id_42,
  p0_.works_plan_id AS works_plan_id_43,
  p1_.project_order_id AS project_order_id_44
FROM
  project_orders p0_
  LEFT JOIN project_order_metrics p1_ ON p0_.id = p1_.project_order_id
  LEFT JOIN worker_activities w2_ ON p0_.order_primary_lead_id = w2_.id
  LEFT JOIN worker_activity_substitutions w4_ ON w2_.id = w4_.substituted_activity_id
  LEFT JOIN worker_activities w3_ ON w3_.id = w4_.main_activity_id
WHERE
  p0_.project_id = ?
  AND (
    (
      SELECT
        MAX(p5_.progress) AS sclr_45
      FROM
        project_order_metrics p5_
      WHERE
        p5_.project_order_id = p0_.id
    ) >= ?
    AND (
      SELECT
        MAX(p6_.progress) AS sclr_46
      FROM
        project_order_metrics p6_
      WHERE
        p6_.project_order_id = p0_.id
    ) <= ?
  )
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.order_nr AS order_nr_1, p0_.order_description AS order_description_2, p0_.order_price AS order_price_3, p0_.order_status AS order_status_4, p0_.should_end_at AS should_end_at_5, p0_.is_end_at AS is_end_at_6, p0_.hourly_rate AS hourly_rate_7, p0_.order_at AS order_at_8, p0_.project_owner_order_nr AS project_owner_order_nr_9, p0_.hours_spent AS hours_spent_10, p0_.cost_spent AS cost_spent_11, p0_.material_budget AS material_budget_12, p0_.timesheet_budget AS timesheet_budget_13, p0_.target_profit AS target_profit_14, p0_.created_at AS created_at_15, p0_.plan_rating AS plan_rating_16, p1_.id AS id_17, p1_.spent_hours AS spent_hours_18, p1_.spent_costs AS spent_costs_19, p1_.expenses AS expenses_20, p1_.half_finished AS half_finished_21, p1_.backlog AS backlog_22, p1_.contribution_margin AS contribution_margin_23, p1_.stock_expenses AS stock_expenses_24, p1_.progress AS progress_25, p1_.open_invoices AS open_invoices_26, p1_.received_invoices AS received_invoices_27, p1_.total_invoices AS total_invoices_28, p1_.open_undertakings AS open_undertakings_29, p1_.received_undertakings AS received_undertakings_30, p1_.total_undertakings AS total_undertakings_31, p1_.order_progress AS order_progress_32, p1_.total_billings AS total_billings_33, p1_.open_billings AS open_billings_34, p1_.paid_billings AS paid_billings_35, p0_.project_id AS project_id_36, p0_.contact_person_id AS contact_person_id_37, p0_.author_id AS author_id_38, p0_.invoice_type_id AS invoice_type_id_39, p0_.order_primary_lead_id AS order_primary_lead_id_40, p0_.order_branch_id AS order_branch_id_41, p0_.branch_department_id AS branch_department_id_42, p0_.works_plan_id AS works_plan_id_43, p1_.project_order_id AS project_order_id_44 FROM project_orders p0_ LEFT JOIN project_order_metrics p1_ ON p0_.id = p1_.project_order_id LEFT JOIN worker_activities w2_ ON p0_.order_primary_lead_id = w2_.id LEFT JOIN worker_activity_substitutions w4_ ON w2_.id = w4_.substituted_activity_id LEFT JOIN worker_activities w3_ ON w3_.id = w4_.main_activity_id WHERE p0_.project_id = 64 AND ((SELECT MAX(p5_.progress) AS sclr_45 FROM project_order_metrics p5_ WHERE p5_.project_order_id = p0_.id) >= 0 AND (SELECT MAX(p6_.progress) AS sclr_46 FROM project_order_metrics p6_ WHERE p6_.project_order_id = p0_.id) <= 100) ORDER BY p0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.tel AS tel_4,
  t0.email AS email_5,
  t0.project_owner_id AS project_owner_id_6,
  t0.position_id AS position_id_7
FROM
  project_owner_contact_persons t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.tel AS tel_4, t0.email AS email_5, t0.project_owner_id AS project_owner_id_6, t0.position_id AS position_id_7 FROM project_owner_contact_persons t0 WHERE t0.id = 18;

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.idle_timer_timeout AS idle_timer_timeout_11,
  t0.notification_preferences AS notification_preferences_12,
  t0.email_signature AS email_signature_13,
  t14.id AS id_15,
  t14.name AS name_16,
  t14.surname AS surname_17,
  t14.entry_at AS entry_at_18,
  t14.exit_at AS exit_at_19,
  t14.birthday_at AS birthday_at_20,
  t14.slug AS slug_21,
  t14.daily_work_time AS daily_work_time_22,
  t14.cost_per_hour AS cost_per_hour_23,
  t14.personal_id AS personal_id_24,
  t14.created_at AS created_at_25,
  t14.tel AS tel_26,
  t14.uiid AS uiid_27,
  t14.profile_image AS profile_image_28,
  t14.email AS email_29,
  t14.user_id AS user_id_30,
  t0.user_position_id AS user_position_id_31
FROM
  user t0
  LEFT JOIN worker t14 ON t14.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.idle_timer_timeout AS idle_timer_timeout_11, t0.notification_preferences AS notification_preferences_12, t0.email_signature AS email_signature_13, t14.id AS id_15, t14.name AS name_16, t14.surname AS surname_17, t14.entry_at AS entry_at_18, t14.exit_at AS exit_at_19, t14.birthday_at AS birthday_at_20, t14.slug AS slug_21, t14.daily_work_time AS daily_work_time_22, t14.cost_per_hour AS cost_per_hour_23, t14.personal_id AS personal_id_24, t14.created_at AS created_at_25, t14.tel AS tel_26, t14.uiid AS uiid_27, t14.profile_image AS profile_image_28, t14.email AS email_29, t14.user_id AS user_id_30, t0.user_position_id AS user_position_id_31 FROM user t0 LEFT JOIN worker t14 ON t14.user_id = t0.id WHERE t0.id = 29;

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.tel AS tel_12,
  t0.uiid AS uiid_13,
  t0.profile_image AS profile_image_14,
  t0.email AS email_15,
  t0.user_id AS user_id_16
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.tel AS tel_12, t0.uiid AS uiid_13, t0.profile_image AS profile_image_14, t0.email AS email_15, t0.user_id AS user_id_16 FROM worker t0 WHERE t0.id = 182;

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 = 182) 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.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 = 151;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.created_at AS created_at_5,
  t0.project_id AS project_id_6,
  t0.qr_code AS qr_code_7,
  t0.address AS address_8,
  t0.longitude AS longitude_9,
  t0.latitude AS latitude_10,
  t0.scan_distance AS scan_distance_11,
  t0.reward_time AS reward_time_12,
  t0.work_pause AS work_pause_13,
  t0.working_time_start AS working_time_start_14,
  t0.working_time_stop AS working_time_stop_15,
  t0.code_postal AS code_postal_16,
  t0.town AS town_17,
  t0.is_archived AS is_archived_18,
  t0.is_recycle AS is_recycle_19,
  t0.type AS type_20,
  t0.owner_id AS owner_id_21,
  t0.country_id AS country_id_22,
  t0.invoice_type_id AS invoice_type_id_23,
  t24.id AS id_25,
  t24.material_budget AS material_budget_26,
  t24.timesheet_budget AS timesheet_budget_27,
  t24.target_profit AS target_profit_28,
  t24.project_id AS project_id_29,
  t30.id AS id_31,
  t30.spent_hours AS spent_hours_32,
  t30.spent_costs AS spent_costs_33,
  t30.expenses AS expenses_34,
  t30.half_finished AS half_finished_35,
  t30.backlog AS backlog_36,
  t30.contribution_margin AS contribution_margin_37,
  t30.finance_total AS finance_total_38,
  t30.progress AS progress_39,
  t30.open_invoices AS open_invoices_40,
  t30.received_invoices AS received_invoices_41,
  t30.total_invoices AS total_invoices_42,
  t30.open_undertakings AS open_undertakings_43,
  t30.received_undertakings AS received_undertakings_44,
  t30.total_undertakings AS total_undertakings_45,
  t30.stock_expenses AS stock_expenses_46,
  t30.total_billings AS total_billings_47,
  t30.open_billings AS open_billings_48,
  t30.paid_billings AS paid_billings_49,
  t30.project_id AS project_id_50,
  t0.classify_id AS classify_id_51
FROM
  projects t0
  LEFT JOIN project_settings t24 ON t24.project_id = t0.id
  LEFT JOIN project_metrics t30 ON t30.project_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.project_id AS project_id_6, t0.qr_code AS qr_code_7, t0.address AS address_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.scan_distance AS scan_distance_11, t0.reward_time AS reward_time_12, t0.work_pause AS work_pause_13, t0.working_time_start AS working_time_start_14, t0.working_time_stop AS working_time_stop_15, t0.code_postal AS code_postal_16, t0.town AS town_17, t0.is_archived AS is_archived_18, t0.is_recycle AS is_recycle_19, t0.type AS type_20, t0.owner_id AS owner_id_21, t0.country_id AS country_id_22, t0.invoice_type_id AS invoice_type_id_23, t24.id AS id_25, t24.material_budget AS material_budget_26, t24.timesheet_budget AS timesheet_budget_27, t24.target_profit AS target_profit_28, t24.project_id AS project_id_29, t30.id AS id_31, t30.spent_hours AS spent_hours_32, t30.spent_costs AS spent_costs_33, t30.expenses AS expenses_34, t30.half_finished AS half_finished_35, t30.backlog AS backlog_36, t30.contribution_margin AS contribution_margin_37, t30.finance_total AS finance_total_38, t30.progress AS progress_39, t30.open_invoices AS open_invoices_40, t30.received_invoices AS received_invoices_41, t30.total_invoices AS total_invoices_42, t30.open_undertakings AS open_undertakings_43, t30.received_undertakings AS received_undertakings_44, t30.total_undertakings AS total_undertakings_45, t30.stock_expenses AS stock_expenses_46, t30.total_billings AS total_billings_47, t30.open_billings AS open_billings_48, t30.paid_billings AS paid_billings_49, t30.project_id AS project_id_50, t0.classify_id AS classify_id_51 FROM projects t0 LEFT JOIN project_settings t24 ON t24.project_id = t0.id LEFT JOIN project_metrics t30 ON t30.project_id = t0.id WHERE t0.id = '64' 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.user_id = ?
ORDER BY
  t0.id ASC

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.user_id = 29 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.project_id AS project_id_2,
  t0.branch_id AS branch_id_3
FROM
  project_branches t0
WHERE
  t0.project_id IN (?)

SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.branch_id AS branch_id_3 FROM project_branches t0 WHERE t0.project_id IN (64);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.color AS color_3
FROM
  project_status t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.only_owned AS only_owned_2,
  t0.user_id AS user_id_3,
  t0.scoped_item_id AS scoped_item_id_4
FROM
  user_scoped_item t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.only_owned AS only_owned_2, t0.user_id AS user_id_3, t0.scoped_item_id AS scoped_item_id_4 FROM user_scoped_item t0 WHERE t0.user_id = 29;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.severity AS severity_4
FROM
  invoice_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.severity AS severity_4 FROM invoice_type t0 WHERE t0.id = 2;

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
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 FROM branches t0 WHERE t0.id = 5;