Symfony Profiler

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.project_id = ?

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.project_id = 9;

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
  INNER JOIN projects_branches ON t0.id = projects_branches.branches_id
WHERE
  projects_branches.projects_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 INNER JOIN projects_branches ON t0.id = projects_branches.branches_id WHERE projects_branches.projects_id = 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.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.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.company AS company_2,
  t0.city AS city_3,
  t0.country_id AS country_id_4
FROM
  project_owner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company AS company_2, t0.city AS city_3, t0.country_id AS country_id_4 FROM project_owner t0 WHERE t0.id = 7;

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 = 1;

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
  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.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.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.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.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;