Symfony Profiler

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.stock_expenses AS stock_expenses_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.order_progress AS order_progress_16,
  t0.total_billings AS total_billings_17,
  t0.open_billings AS open_billings_18,
  t0.paid_billings AS paid_billings_19,
  t0.project_order_id AS project_order_id_20
FROM
  project_order_metrics t0
WHERE
  t0.project_order_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.stock_expenses AS stock_expenses_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.order_progress AS order_progress_16, t0.total_billings AS total_billings_17, t0.open_billings AS open_billings_18, t0.paid_billings AS paid_billings_19, t0.project_order_id AS project_order_id_20 FROM project_order_metrics t0 WHERE t0.project_order_id = 2;

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

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 = 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
  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,
  p0_.project_id AS project_id_17,
  p0_.contact_person_id AS contact_person_id_18,
  p0_.author_id AS author_id_19,
  p0_.invoice_type_id AS invoice_type_id_20,
  p0_.order_primary_lead_id AS order_primary_lead_id_21,
  p0_.order_branch_id AS order_branch_id_22,
  p0_.branch_department_id AS branch_department_id_23,
  p0_.works_plan_id AS works_plan_id_24
FROM
  project_orders p0_

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, p0_.project_id AS project_id_17, p0_.contact_person_id AS contact_person_id_18, p0_.author_id AS author_id_19, p0_.invoice_type_id AS invoice_type_id_20, p0_.order_primary_lead_id AS order_primary_lead_id_21, p0_.order_branch_id AS order_branch_id_22, p0_.branch_department_id AS branch_department_id_23, p0_.works_plan_id AS works_plan_id_24 FROM project_orders p0_;

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

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

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 IS NULL
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 IS NULL 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 = 13;

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;