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.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.color AS color_3
FROM
  project_classify t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_classify t0 WHERE t0.name = 'active' 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.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
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.start_at AS start_at_2,
  p0_.end_at AS end_at_3,
  p0_.created_at AS created_at_4,
  p0_.project_id AS project_id_5,
  p0_.qr_code AS qr_code_6,
  p0_.address AS address_7,
  p0_.longitude AS longitude_8,
  p0_.latitude AS latitude_9,
  p0_.scan_distance AS scan_distance_10,
  p0_.reward_time AS reward_time_11,
  p0_.work_pause AS work_pause_12,
  p0_.working_time_start AS working_time_start_13,
  p0_.working_time_stop AS working_time_stop_14,
  p0_.code_postal AS code_postal_15,
  p0_.town AS town_16,
  p0_.is_archived AS is_archived_17,
  p0_.is_recycle AS is_recycle_18,
  p0_.type AS type_19,
  p0_.owner_id AS owner_id_20,
  p0_.country_id AS country_id_21,
  p0_.invoice_type_id AS invoice_type_id_22,
  p0_.classify_id AS classify_id_23
FROM
  projects p0_
WHERE
  p0_.classify_id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.start_at AS start_at_2, p0_.end_at AS end_at_3, p0_.created_at AS created_at_4, p0_.project_id AS project_id_5, p0_.qr_code AS qr_code_6, p0_.address AS address_7, p0_.longitude AS longitude_8, p0_.latitude AS latitude_9, p0_.scan_distance AS scan_distance_10, p0_.reward_time AS reward_time_11, p0_.work_pause AS work_pause_12, p0_.working_time_start AS working_time_start_13, p0_.working_time_stop AS working_time_stop_14, p0_.code_postal AS code_postal_15, p0_.town AS town_16, p0_.is_archived AS is_archived_17, p0_.is_recycle AS is_recycle_18, p0_.type AS type_19, p0_.owner_id AS owner_id_20, p0_.country_id AS country_id_21, p0_.invoice_type_id AS invoice_type_id_22, p0_.classify_id AS classify_id_23 FROM projects p0_ WHERE p0_.classify_id = 19;

SELECT
  t0.id AS id_1,
  t0.material_budget AS material_budget_2,
  t0.timesheet_budget AS timesheet_budget_3,
  t0.target_profit AS target_profit_4,
  t0.project_id AS project_id_5
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.material_budget AS material_budget_2, t0.timesheet_budget AS timesheet_budget_3, t0.target_profit AS target_profit_4, t0.project_id AS project_id_5 FROM project_settings t0 WHERE t0.project_id = 9;

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 (9);

SELECT
  t0.id AS id_1,
  t0.spent_hours AS spent_hours_2,
  t0.spent_costs AS spent_costs_3,
  t0.expenses AS expenses_4,
  t0.half_finished AS half_finished_5,
  t0.backlog AS backlog_6,
  t0.contribution_margin AS contribution_margin_7,
  t0.finance_total AS finance_total_8,
  t0.progress AS progress_9,
  t0.open_invoices AS open_invoices_10,
  t0.received_invoices AS received_invoices_11,
  t0.total_invoices AS total_invoices_12,
  t0.open_undertakings AS open_undertakings_13,
  t0.received_undertakings AS received_undertakings_14,
  t0.total_undertakings AS total_undertakings_15,
  t0.stock_expenses AS stock_expenses_16,
  t0.total_billings AS total_billings_17,
  t0.open_billings AS open_billings_18,
  t0.paid_billings AS paid_billings_19,
  t0.project_id AS project_id_20
FROM
  project_metrics t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.spent_hours AS spent_hours_2, t0.spent_costs AS spent_costs_3, t0.expenses AS expenses_4, t0.half_finished AS half_finished_5, t0.backlog AS backlog_6, t0.contribution_margin AS contribution_margin_7, t0.finance_total AS finance_total_8, t0.progress AS progress_9, t0.open_invoices AS open_invoices_10, t0.received_invoices AS received_invoices_11, t0.total_invoices AS total_invoices_12, t0.open_undertakings AS open_undertakings_13, t0.received_undertakings AS received_undertakings_14, t0.total_undertakings AS total_undertakings_15, t0.stock_expenses AS stock_expenses_16, t0.total_billings AS total_billings_17, t0.open_billings AS open_billings_18, t0.paid_billings AS paid_billings_19, t0.project_id AS project_id_20 FROM project_metrics t0 WHERE t0.project_id = 9;

SELECT
  t0.id AS id_1,
  t0.material_budget AS material_budget_2,
  t0.timesheet_budget AS timesheet_budget_3,
  t0.target_profit AS target_profit_4,
  t0.project_id AS project_id_5
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.material_budget AS material_budget_2, t0.timesheet_budget AS timesheet_budget_3, t0.target_profit AS target_profit_4, t0.project_id AS project_id_5 FROM project_settings t0 WHERE t0.project_id = 11;

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 (11);

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.spent_hours AS spent_hours_2,
  t0.spent_costs AS spent_costs_3,
  t0.expenses AS expenses_4,
  t0.half_finished AS half_finished_5,
  t0.backlog AS backlog_6,
  t0.contribution_margin AS contribution_margin_7,
  t0.finance_total AS finance_total_8,
  t0.progress AS progress_9,
  t0.open_invoices AS open_invoices_10,
  t0.received_invoices AS received_invoices_11,
  t0.total_invoices AS total_invoices_12,
  t0.open_undertakings AS open_undertakings_13,
  t0.received_undertakings AS received_undertakings_14,
  t0.total_undertakings AS total_undertakings_15,
  t0.stock_expenses AS stock_expenses_16,
  t0.total_billings AS total_billings_17,
  t0.open_billings AS open_billings_18,
  t0.paid_billings AS paid_billings_19,
  t0.project_id AS project_id_20
FROM
  project_metrics t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.spent_hours AS spent_hours_2, t0.spent_costs AS spent_costs_3, t0.expenses AS expenses_4, t0.half_finished AS half_finished_5, t0.backlog AS backlog_6, t0.contribution_margin AS contribution_margin_7, t0.finance_total AS finance_total_8, t0.progress AS progress_9, t0.open_invoices AS open_invoices_10, t0.received_invoices AS received_invoices_11, t0.total_invoices AS total_invoices_12, t0.open_undertakings AS open_undertakings_13, t0.received_undertakings AS received_undertakings_14, t0.total_undertakings AS total_undertakings_15, t0.stock_expenses AS stock_expenses_16, t0.total_billings AS total_billings_17, t0.open_billings AS open_billings_18, t0.paid_billings AS paid_billings_19, t0.project_id AS project_id_20 FROM project_metrics t0 WHERE t0.project_id = 11;

SELECT
  t0.id AS id_1,
  t0.material_budget AS material_budget_2,
  t0.timesheet_budget AS timesheet_budget_3,
  t0.target_profit AS target_profit_4,
  t0.project_id AS project_id_5
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.material_budget AS material_budget_2, t0.timesheet_budget AS timesheet_budget_3, t0.target_profit AS target_profit_4, t0.project_id AS project_id_5 FROM project_settings t0 WHERE t0.project_id = 12;

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 (12);

SELECT
  t0.id AS id_1,
  t0.spent_hours AS spent_hours_2,
  t0.spent_costs AS spent_costs_3,
  t0.expenses AS expenses_4,
  t0.half_finished AS half_finished_5,
  t0.backlog AS backlog_6,
  t0.contribution_margin AS contribution_margin_7,
  t0.finance_total AS finance_total_8,
  t0.progress AS progress_9,
  t0.open_invoices AS open_invoices_10,
  t0.received_invoices AS received_invoices_11,
  t0.total_invoices AS total_invoices_12,
  t0.open_undertakings AS open_undertakings_13,
  t0.received_undertakings AS received_undertakings_14,
  t0.total_undertakings AS total_undertakings_15,
  t0.stock_expenses AS stock_expenses_16,
  t0.total_billings AS total_billings_17,
  t0.open_billings AS open_billings_18,
  t0.paid_billings AS paid_billings_19,
  t0.project_id AS project_id_20
FROM
  project_metrics t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.spent_hours AS spent_hours_2, t0.spent_costs AS spent_costs_3, t0.expenses AS expenses_4, t0.half_finished AS half_finished_5, t0.backlog AS backlog_6, t0.contribution_margin AS contribution_margin_7, t0.finance_total AS finance_total_8, t0.progress AS progress_9, t0.open_invoices AS open_invoices_10, t0.received_invoices AS received_invoices_11, t0.total_invoices AS total_invoices_12, t0.open_undertakings AS open_undertakings_13, t0.received_undertakings AS received_undertakings_14, t0.total_undertakings AS total_undertakings_15, t0.stock_expenses AS stock_expenses_16, t0.total_billings AS total_billings_17, t0.open_billings AS open_billings_18, t0.paid_billings AS paid_billings_19, t0.project_id AS project_id_20 FROM project_metrics t0 WHERE t0.project_id = 12;

SELECT
  t0.id AS id_1,
  t0.material_budget AS material_budget_2,
  t0.timesheet_budget AS timesheet_budget_3,
  t0.target_profit AS target_profit_4,
  t0.project_id AS project_id_5
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.material_budget AS material_budget_2, t0.timesheet_budget AS timesheet_budget_3, t0.target_profit AS target_profit_4, t0.project_id AS project_id_5 FROM project_settings t0 WHERE t0.project_id = 16;

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 (16);

SELECT
  t0.id AS id_1,
  t0.spent_hours AS spent_hours_2,
  t0.spent_costs AS spent_costs_3,
  t0.expenses AS expenses_4,
  t0.half_finished AS half_finished_5,
  t0.backlog AS backlog_6,
  t0.contribution_margin AS contribution_margin_7,
  t0.finance_total AS finance_total_8,
  t0.progress AS progress_9,
  t0.open_invoices AS open_invoices_10,
  t0.received_invoices AS received_invoices_11,
  t0.total_invoices AS total_invoices_12,
  t0.open_undertakings AS open_undertakings_13,
  t0.received_undertakings AS received_undertakings_14,
  t0.total_undertakings AS total_undertakings_15,
  t0.stock_expenses AS stock_expenses_16,
  t0.total_billings AS total_billings_17,
  t0.open_billings AS open_billings_18,
  t0.paid_billings AS paid_billings_19,
  t0.project_id AS project_id_20
FROM
  project_metrics t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.spent_hours AS spent_hours_2, t0.spent_costs AS spent_costs_3, t0.expenses AS expenses_4, t0.half_finished AS half_finished_5, t0.backlog AS backlog_6, t0.contribution_margin AS contribution_margin_7, t0.finance_total AS finance_total_8, t0.progress AS progress_9, t0.open_invoices AS open_invoices_10, t0.received_invoices AS received_invoices_11, t0.total_invoices AS total_invoices_12, t0.open_undertakings AS open_undertakings_13, t0.received_undertakings AS received_undertakings_14, t0.total_undertakings AS total_undertakings_15, t0.stock_expenses AS stock_expenses_16, t0.total_billings AS total_billings_17, t0.open_billings AS open_billings_18, t0.paid_billings AS paid_billings_19, t0.project_id AS project_id_20 FROM project_metrics t0 WHERE t0.project_id = 16;

SELECT
  t0.id AS id_1,
  t0.material_budget AS material_budget_2,
  t0.timesheet_budget AS timesheet_budget_3,
  t0.target_profit AS target_profit_4,
  t0.project_id AS project_id_5
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.material_budget AS material_budget_2, t0.timesheet_budget AS timesheet_budget_3, t0.target_profit AS target_profit_4, t0.project_id AS project_id_5 FROM project_settings t0 WHERE t0.project_id = 17;

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 (17);

SELECT
  t0.id AS id_1,
  t0.spent_hours AS spent_hours_2,
  t0.spent_costs AS spent_costs_3,
  t0.expenses AS expenses_4,
  t0.half_finished AS half_finished_5,
  t0.backlog AS backlog_6,
  t0.contribution_margin AS contribution_margin_7,
  t0.finance_total AS finance_total_8,
  t0.progress AS progress_9,
  t0.open_invoices AS open_invoices_10,
  t0.received_invoices AS received_invoices_11,
  t0.total_invoices AS total_invoices_12,
  t0.open_undertakings AS open_undertakings_13,
  t0.received_undertakings AS received_undertakings_14,
  t0.total_undertakings AS total_undertakings_15,
  t0.stock_expenses AS stock_expenses_16,
  t0.total_billings AS total_billings_17,
  t0.open_billings AS open_billings_18,
  t0.paid_billings AS paid_billings_19,
  t0.project_id AS project_id_20
FROM
  project_metrics t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.spent_hours AS spent_hours_2, t0.spent_costs AS spent_costs_3, t0.expenses AS expenses_4, t0.half_finished AS half_finished_5, t0.backlog AS backlog_6, t0.contribution_margin AS contribution_margin_7, t0.finance_total AS finance_total_8, t0.progress AS progress_9, t0.open_invoices AS open_invoices_10, t0.received_invoices AS received_invoices_11, t0.total_invoices AS total_invoices_12, t0.open_undertakings AS open_undertakings_13, t0.received_undertakings AS received_undertakings_14, t0.total_undertakings AS total_undertakings_15, t0.stock_expenses AS stock_expenses_16, t0.total_billings AS total_billings_17, t0.open_billings AS open_billings_18, t0.paid_billings AS paid_billings_19, t0.project_id AS project_id_20 FROM project_metrics t0 WHERE t0.project_id = 17;

SELECT
  t0.id AS id_1,
  t0.material_budget AS material_budget_2,
  t0.timesheet_budget AS timesheet_budget_3,
  t0.target_profit AS target_profit_4,
  t0.project_id AS project_id_5
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.material_budget AS material_budget_2, t0.timesheet_budget AS timesheet_budget_3, t0.target_profit AS target_profit_4, t0.project_id AS project_id_5 FROM project_settings t0 WHERE t0.project_id = 27;

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 (27);

SELECT
  t0.id AS id_1,
  t0.spent_hours AS spent_hours_2,
  t0.spent_costs AS spent_costs_3,
  t0.expenses AS expenses_4,
  t0.half_finished AS half_finished_5,
  t0.backlog AS backlog_6,
  t0.contribution_margin AS contribution_margin_7,
  t0.finance_total AS finance_total_8,
  t0.progress AS progress_9,
  t0.open_invoices AS open_invoices_10,
  t0.received_invoices AS received_invoices_11,
  t0.total_invoices AS total_invoices_12,
  t0.open_undertakings AS open_undertakings_13,
  t0.received_undertakings AS received_undertakings_14,
  t0.total_undertakings AS total_undertakings_15,
  t0.stock_expenses AS stock_expenses_16,
  t0.total_billings AS total_billings_17,
  t0.open_billings AS open_billings_18,
  t0.paid_billings AS paid_billings_19,
  t0.project_id AS project_id_20
FROM
  project_metrics t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.spent_hours AS spent_hours_2, t0.spent_costs AS spent_costs_3, t0.expenses AS expenses_4, t0.half_finished AS half_finished_5, t0.backlog AS backlog_6, t0.contribution_margin AS contribution_margin_7, t0.finance_total AS finance_total_8, t0.progress AS progress_9, t0.open_invoices AS open_invoices_10, t0.received_invoices AS received_invoices_11, t0.total_invoices AS total_invoices_12, t0.open_undertakings AS open_undertakings_13, t0.received_undertakings AS received_undertakings_14, t0.total_undertakings AS total_undertakings_15, t0.stock_expenses AS stock_expenses_16, t0.total_billings AS total_billings_17, t0.open_billings AS open_billings_18, t0.paid_billings AS paid_billings_19, t0.project_id AS project_id_20 FROM project_metrics t0 WHERE t0.project_id = 27;

SELECT
  t0.id AS id_1,
  t0.material_budget AS material_budget_2,
  t0.timesheet_budget AS timesheet_budget_3,
  t0.target_profit AS target_profit_4,
  t0.project_id AS project_id_5
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.material_budget AS material_budget_2, t0.timesheet_budget AS timesheet_budget_3, t0.target_profit AS target_profit_4, t0.project_id AS project_id_5 FROM project_settings t0 WHERE t0.project_id = 39;

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 (39);

SELECT
  t0.id AS id_1,
  t0.spent_hours AS spent_hours_2,
  t0.spent_costs AS spent_costs_3,
  t0.expenses AS expenses_4,
  t0.half_finished AS half_finished_5,
  t0.backlog AS backlog_6,
  t0.contribution_margin AS contribution_margin_7,
  t0.finance_total AS finance_total_8,
  t0.progress AS progress_9,
  t0.open_invoices AS open_invoices_10,
  t0.received_invoices AS received_invoices_11,
  t0.total_invoices AS total_invoices_12,
  t0.open_undertakings AS open_undertakings_13,
  t0.received_undertakings AS received_undertakings_14,
  t0.total_undertakings AS total_undertakings_15,
  t0.stock_expenses AS stock_expenses_16,
  t0.total_billings AS total_billings_17,
  t0.open_billings AS open_billings_18,
  t0.paid_billings AS paid_billings_19,
  t0.project_id AS project_id_20
FROM
  project_metrics t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.spent_hours AS spent_hours_2, t0.spent_costs AS spent_costs_3, t0.expenses AS expenses_4, t0.half_finished AS half_finished_5, t0.backlog AS backlog_6, t0.contribution_margin AS contribution_margin_7, t0.finance_total AS finance_total_8, t0.progress AS progress_9, t0.open_invoices AS open_invoices_10, t0.received_invoices AS received_invoices_11, t0.total_invoices AS total_invoices_12, t0.open_undertakings AS open_undertakings_13, t0.received_undertakings AS received_undertakings_14, t0.total_undertakings AS total_undertakings_15, t0.stock_expenses AS stock_expenses_16, t0.total_billings AS total_billings_17, t0.open_billings AS open_billings_18, t0.paid_billings AS paid_billings_19, t0.project_id AS project_id_20 FROM project_metrics t0 WHERE t0.project_id = 39;

SELECT
  t0.id AS id_1,
  t0.material_budget AS material_budget_2,
  t0.timesheet_budget AS timesheet_budget_3,
  t0.target_profit AS target_profit_4,
  t0.project_id AS project_id_5
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.material_budget AS material_budget_2, t0.timesheet_budget AS timesheet_budget_3, t0.target_profit AS target_profit_4, t0.project_id AS project_id_5 FROM project_settings t0 WHERE t0.project_id = 42;

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 (42);

SELECT
  t0.id AS id_1,
  t0.spent_hours AS spent_hours_2,
  t0.spent_costs AS spent_costs_3,
  t0.expenses AS expenses_4,
  t0.half_finished AS half_finished_5,
  t0.backlog AS backlog_6,
  t0.contribution_margin AS contribution_margin_7,
  t0.finance_total AS finance_total_8,
  t0.progress AS progress_9,
  t0.open_invoices AS open_invoices_10,
  t0.received_invoices AS received_invoices_11,
  t0.total_invoices AS total_invoices_12,
  t0.open_undertakings AS open_undertakings_13,
  t0.received_undertakings AS received_undertakings_14,
  t0.total_undertakings AS total_undertakings_15,
  t0.stock_expenses AS stock_expenses_16,
  t0.total_billings AS total_billings_17,
  t0.open_billings AS open_billings_18,
  t0.paid_billings AS paid_billings_19,
  t0.project_id AS project_id_20
FROM
  project_metrics t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.spent_hours AS spent_hours_2, t0.spent_costs AS spent_costs_3, t0.expenses AS expenses_4, t0.half_finished AS half_finished_5, t0.backlog AS backlog_6, t0.contribution_margin AS contribution_margin_7, t0.finance_total AS finance_total_8, t0.progress AS progress_9, t0.open_invoices AS open_invoices_10, t0.received_invoices AS received_invoices_11, t0.total_invoices AS total_invoices_12, t0.open_undertakings AS open_undertakings_13, t0.received_undertakings AS received_undertakings_14, t0.total_undertakings AS total_undertakings_15, t0.stock_expenses AS stock_expenses_16, t0.total_billings AS total_billings_17, t0.open_billings AS open_billings_18, t0.paid_billings AS paid_billings_19, t0.project_id AS project_id_20 FROM project_metrics t0 WHERE t0.project_id = 42;

SELECT
  t0.id AS id_1,
  t0.material_budget AS material_budget_2,
  t0.timesheet_budget AS timesheet_budget_3,
  t0.target_profit AS target_profit_4,
  t0.project_id AS project_id_5
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.material_budget AS material_budget_2, t0.timesheet_budget AS timesheet_budget_3, t0.target_profit AS target_profit_4, t0.project_id AS project_id_5 FROM project_settings t0 WHERE t0.project_id = 45;

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 (45);

SELECT
  t0.id AS id_1,
  t0.spent_hours AS spent_hours_2,
  t0.spent_costs AS spent_costs_3,
  t0.expenses AS expenses_4,
  t0.half_finished AS half_finished_5,
  t0.backlog AS backlog_6,
  t0.contribution_margin AS contribution_margin_7,
  t0.finance_total AS finance_total_8,
  t0.progress AS progress_9,
  t0.open_invoices AS open_invoices_10,
  t0.received_invoices AS received_invoices_11,
  t0.total_invoices AS total_invoices_12,
  t0.open_undertakings AS open_undertakings_13,
  t0.received_undertakings AS received_undertakings_14,
  t0.total_undertakings AS total_undertakings_15,
  t0.stock_expenses AS stock_expenses_16,
  t0.total_billings AS total_billings_17,
  t0.open_billings AS open_billings_18,
  t0.paid_billings AS paid_billings_19,
  t0.project_id AS project_id_20
FROM
  project_metrics t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.spent_hours AS spent_hours_2, t0.spent_costs AS spent_costs_3, t0.expenses AS expenses_4, t0.half_finished AS half_finished_5, t0.backlog AS backlog_6, t0.contribution_margin AS contribution_margin_7, t0.finance_total AS finance_total_8, t0.progress AS progress_9, t0.open_invoices AS open_invoices_10, t0.received_invoices AS received_invoices_11, t0.total_invoices AS total_invoices_12, t0.open_undertakings AS open_undertakings_13, t0.received_undertakings AS received_undertakings_14, t0.total_undertakings AS total_undertakings_15, t0.stock_expenses AS stock_expenses_16, t0.total_billings AS total_billings_17, t0.open_billings AS open_billings_18, t0.paid_billings AS paid_billings_19, t0.project_id AS project_id_20 FROM project_metrics t0 WHERE t0.project_id = 45;

SELECT
  t0.id AS id_1,
  t0.material_budget AS material_budget_2,
  t0.timesheet_budget AS timesheet_budget_3,
  t0.target_profit AS target_profit_4,
  t0.project_id AS project_id_5
FROM
  project_settings t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.material_budget AS material_budget_2, t0.timesheet_budget AS timesheet_budget_3, t0.target_profit AS target_profit_4, t0.project_id AS project_id_5 FROM project_settings t0 WHERE t0.project_id = 47;