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.email_signature AS email_signature_14,
  t15.id AS id_16,
  t15.name AS name_17,
  t15.surname AS surname_18,
  t15.entry_at AS entry_at_19,
  t15.exit_at AS exit_at_20,
  t15.birthday_at AS birthday_at_21,
  t15.slug AS slug_22,
  t15.daily_work_time AS daily_work_time_23,
  t15.cost_per_hour AS cost_per_hour_24,
  t15.personal_id AS personal_id_25,
  t15.created_at AS created_at_26,
  t15.phone_number AS phone_number_27,
  t15.uiid AS uiid_28,
  t15.profile_image AS profile_image_29,
  t15.email AS email_30,
  t15.user_id AS user_id_31,
  t0.user_position_id AS user_position_id_32
FROM
  user t0
  LEFT JOIN worker t15 ON t15.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.email_signature AS email_signature_14, t15.id AS id_16, t15.name AS name_17, t15.surname AS surname_18, t15.entry_at AS entry_at_19, t15.exit_at AS exit_at_20, t15.birthday_at AS birthday_at_21, t15.slug AS slug_22, t15.daily_work_time AS daily_work_time_23, t15.cost_per_hour AS cost_per_hour_24, t15.personal_id AS personal_id_25, t15.created_at AS created_at_26, t15.phone_number AS phone_number_27, t15.uiid AS uiid_28, t15.profile_image AS profile_image_29, t15.email AS email_30, t15.user_id AS user_id_31, t0.user_position_id AS user_position_id_32 FROM user t0 LEFT JOIN worker t15 ON t15.user_id = t0.id WHERE t0.id = 13;

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

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

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.ai_extraction_metadata AS ai_extraction_metadata_6,
  t0.expensed_at AS expensed_at_7,
  t0.expense_nr AS expense_nr_8,
  t0.offer_nr AS offer_nr_9,
  t0.offer_at AS offer_at_10,
  t0.delivery_due_at AS delivery_due_at_11,
  t0.comment AS comment_12,
  t0.document AS document_13,
  t0.documents AS documents_14,
  t0.supplier_id AS supplier_id_15,
  t0.deliver_location_id AS deliver_location_id_16,
  t0.purchase_request_id AS purchase_request_id_17
FROM
  project_order_expenses t0
WHERE
  t0.id = ?
LIMIT
  1

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.ai_extraction_metadata AS ai_extraction_metadata_6, t0.expensed_at AS expensed_at_7, t0.expense_nr AS expense_nr_8, t0.offer_nr AS offer_nr_9, t0.offer_at AS offer_at_10, t0.delivery_due_at AS delivery_due_at_11, t0.comment AS comment_12, t0.document AS document_13, t0.documents AS documents_14, t0.supplier_id AS supplier_id_15, t0.deliver_location_id AS deliver_location_id_16, t0.purchase_request_id AS purchase_request_id_17 FROM project_order_expenses t0 WHERE t0.id = '2770' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.alias AS alias_2,
  t0.description AS description_3,
  t0.price AS price_4,
  t0.editable_content AS editable_content_5,
  t0.content AS content_6,
  t0.article_nr AS article_nr_7,
  t0.supplier_id AS supplier_id_8,
  t0.unit_type_id AS unit_type_id_9
FROM
  material t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.alias AS alias_2, t0.description AS description_3, t0.price AS price_4, t0.editable_content AS editable_content_5, t0.content AS content_6, t0.article_nr AS article_nr_7, t0.supplier_id AS supplier_id_8, t0.unit_type_id AS unit_type_id_9 FROM material t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.city AS city_3,
  t0.alias AS alias_4,
  t0.company AS company_5,
  t0.terms_to_payment AS terms_to_payment_6,
  t0.tax AS tax_7,
  t0.email AS email_8,
  t0.order_confirmation_content AS order_confirmation_content_9,
  t0.monthly_limit AS monthly_limit_10,
  t0.documents_prompts AS documents_prompts_11,
  t0.address_id AS address_id_12,
  t0.location_id AS location_id_13
FROM
  suppliers t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.alias AS alias_4, t0.company AS company_5, t0.terms_to_payment AS terms_to_payment_6, t0.tax AS tax_7, t0.email AS email_8, t0.order_confirmation_content AS order_confirmation_content_9, t0.monthly_limit AS monthly_limit_10, t0.documents_prompts AS documents_prompts_11, t0.address_id AS address_id_12, t0.location_id AS location_id_13 FROM suppliers t0 WHERE t0.id = 300;

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

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

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.delivery_due_at AS delivery_due_at_5,
  t0.amount AS amount_6,
  t0.delivered_unit AS delivered_unit_7,
  t0.content AS content_8,
  t0.completed AS completed_9,
  t0.comment AS comment_10,
  t0.delivered_to AS delivered_to_11,
  t0.an_supplier AS an_supplier_12,
  t0.document AS document_13,
  t0.documents AS documents_14,
  t0.buying_price AS buying_price_15,
  t0.price_unit AS price_unit_16,
  t0.sales_price AS sales_price_17,
  t0.sales_margin AS sales_margin_18,
  t0.delivery_amount AS delivery_amount_19,
  t0.offer_nr AS offer_nr_20,
  t0.position_type AS position_type_21,
  t0.delivery_status AS delivery_status_22,
  t0.size AS size_23,
  t0.project_order_expense_id AS project_order_expense_id_24,
  t0.material_id AS material_id_25,
  t0.project_order_id AS project_order_id_26,
  t0.parent_pos_id AS parent_pos_id_27,
  t0.stock_id AS stock_id_28,
  t0.purchase_request_position_id AS purchase_request_position_id_29,
  t0.supplier_product_id AS supplier_product_id_30
FROM
  project_order_expense_positions t0
WHERE
  t0.project_order_expense_id = ?
ORDER BY
  t0.id DESC

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.delivery_due_at AS delivery_due_at_5, t0.amount AS amount_6, t0.delivered_unit AS delivered_unit_7, t0.content AS content_8, t0.completed AS completed_9, t0.comment AS comment_10, t0.delivered_to AS delivered_to_11, t0.an_supplier AS an_supplier_12, t0.document AS document_13, t0.documents AS documents_14, t0.buying_price AS buying_price_15, t0.price_unit AS price_unit_16, t0.sales_price AS sales_price_17, t0.sales_margin AS sales_margin_18, t0.delivery_amount AS delivery_amount_19, t0.offer_nr AS offer_nr_20, t0.position_type AS position_type_21, t0.delivery_status AS delivery_status_22, t0.size AS size_23, t0.project_order_expense_id AS project_order_expense_id_24, t0.material_id AS material_id_25, t0.project_order_id AS project_order_id_26, t0.parent_pos_id AS parent_pos_id_27, t0.stock_id AS stock_id_28, t0.purchase_request_position_id AS purchase_request_position_id_29, t0.supplier_product_id AS supplier_product_id_30 FROM project_order_expense_positions t0 WHERE t0.project_order_expense_id = 2770 ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.created_at AS created_at_4
FROM
  unit t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.created_at AS created_at_4 FROM unit t0;

SELECT
  t0.id AS id_1,
  t0.norm AS norm_2,
  t0.description AS description_3
FROM
  norm t0

SELECT t0.id AS id_1, t0.norm AS norm_2, t0.description AS description_3 FROM norm t0;

SELECT
  t0.id AS id_1,
  t0.prompt AS prompt_2,
  t0.supplier_id AS supplier_id_3
FROM
  supplier_education t0
WHERE
  t0.supplier_id = ?

SELECT t0.id AS id_1, t0.prompt AS prompt_2, t0.supplier_id AS supplier_id_3 FROM supplier_education t0 WHERE t0.supplier_id = 300;