http://romon-erp.com/api/project/evaluate-profit-margin/53 Return to referer URL

Query Metrics

79 Database Queries
8 Different statements
27.33 ms Query time
32 Invalid entities

Queries

Group similar statements

# Time Info
1 0.77 ms
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, t12.id AS id_13, t12.name AS name_14, t12.surname AS surname_15, t12.entry_at AS entry_at_16, t12.exit_at AS exit_at_17, t12.birthday_at AS birthday_at_18, t12.slug AS slug_19, t12.daily_work_time AS daily_work_time_20, t12.cost_per_hour AS cost_per_hour_21, t12.personal_id AS personal_id_22, t12.created_at AS created_at_23, t12.phone_number AS phone_number_24, t12.uiid AS uiid_25, t12.profile_image AS profile_image_26, t12.user_id AS user_id_27, t0.user_position_id AS user_position_id_28 FROM user t0 LEFT JOIN worker t12 ON t12.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  18
]
2 0.66 ms
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.owner_id AS owner_id_20, t0.country_id AS country_id_21, t0.invoice_type_id AS invoice_type_id_22, t23.id AS id_24, t23.material_budget AS material_budget_25, t23.timesheet_budget AS timesheet_budget_26, t23.target_profit AS target_profit_27, t23.project_id AS project_id_28 FROM projects t0 LEFT JOIN project_settings t23 ON t23.project_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "53"
]
3 0.34 ms
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 (?)
Parameters:
[
  53
]
4 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "in process"
]
5 0.81 ms
SELECT t0.id AS id_1, t0.order_nr AS order_nr_2, t0.order_description AS order_description_3, t0.order_prise AS order_prise_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_percent AS material_budget_as_percent_13, t0.timesheet_budget_as_percent AS timesheet_budget_as_percent_14, t0.target_profit_as_percent AS target_profit_as_percent_15, t0.project_id AS project_id_16, t0.contact_person_id AS contact_person_id_17, t0.author_id AS author_id_18, t0.invoice_type_id AS invoice_type_id_19, t0.order_lead_id AS order_lead_id_20, t0.order_primary_lead_id AS order_primary_lead_id_21, t0.order_branch_id AS order_branch_id_22, t0.branch_departement_id AS branch_departement_id_23 FROM project_orders t0 WHERE t0.project_id = ?
Parameters:
[
  53
]
6 0.76 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  614
]
7 0.37 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  616
]
8 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  617
]
9 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  625
]
10 0.30 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  626
]
11 0.29 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  683
]
12 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  714
]
13 0.31 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  764
]
14 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  766
]
15 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  768
]
16 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  784
]
17 0.31 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  786
]
18 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  792
]
19 0.35 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  811
]
20 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  812
]
21 0.29 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  821
]
22 0.31 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  823
]
23 0.27 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  905
]
24 0.34 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  906
]
25 0.31 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  923
]
26 0.30 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  924
]
27 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  928
]
28 0.27 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  938
]
29 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  939
]
30 0.29 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  940
]
31 0.36 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  941
]
32 0.29 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  942
]
33 0.37 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  968
]
34 0.31 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  969
]
35 0.31 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  970
]
36 0.35 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  991
]
37 0.35 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  992
]
38 0.35 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  993
]
39 0.30 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  995
]
40 0.34 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1028
]
41 0.31 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1031
]
42 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1032
]
43 0.30 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1035
]
44 0.28 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1038
]
45 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1039
]
46 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1040
]
47 0.35 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1051
]
48 0.34 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1059
]
49 0.39 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1064
]
50 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1082
]
51 0.36 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1100
]
52 0.31 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1101
]
53 0.38 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1103
]
54 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1104
]
55 0.28 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1105
]
56 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1106
]
57 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1143
]
58 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1162
]
59 0.38 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1168
]
60 0.39 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1169
]
61 0.29 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1224
]
62 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1239
]
63 0.29 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1242
]
64 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1245
]
65 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1246
]
66 0.29 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1251
]
67 0.31 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1252
]
68 0.27 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  1272
]
69 0.30 ms
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 = ?
Parameters:
[
  18
]
70 0.31 ms
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.phone_number AS phone_number_12, t0.uiid AS uiid_13, t0.profile_image AS profile_image_14, t0.user_id AS user_id_15 FROM worker t0 WHERE t0.id = ?
Parameters:
[
  120
]
71 0.42 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  615
]
72 0.36 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  729
]
73 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  730
]
74 0.36 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  731
]
75 0.35 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  740
]
76 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  743
]
77 0.33 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  744
]
78 0.32 ms
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.file_name AS file_name_12, t0.buying_price AS buying_price_13, t0.sales_price AS sales_price_14, t0.sales_margin AS sales_margin_15, t0.delivery_amount AS delivery_amount_16, t0.project_order_expense_id AS project_order_expense_id_17, t0.material_id AS material_id_18, t0.project_order_id AS project_order_id_19, t0.parent_pos_id AS parent_pos_id_20, t0.stock_id AS stock_id_21, t0.purchase_request_position_id AS purchase_request_position_id_22 FROM project_order_expense_positions t0 WHERE t0.project_order_id = ?
Parameters:
[
  751
]
79 0.28 ms
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.phone_number AS phone_number_12, t0.uiid AS uiid_13, t0.profile_image AS profile_image_14, t0.user_id AS user_id_15 FROM worker t0 WHERE t0.id = ?
Parameters:
[
  62
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The mappings App\Entity\User#user_rights and App\Entity\UserRights#user are inconsistent with each other.
  • The association App\Entity\User#inventories refers to the owning side field App\Entity\Inventory#involved_by which does not exist.
App\Entity\Worker
  • The mappings App\Entity\Worker#worker_in_projects and App\Entity\WorkerInProject#worker are inconsistent with each other.
  • The mappings App\Entity\Worker#worker_activities and App\Entity\WorkerActivities#worker are inconsistent with each other.
  • The mappings App\Entity\Worker#worker_certificates and App\Entity\WorkerCertificates#worker are inconsistent with each other.
  • The association App\Entity\Worker#worker_timesheets refers to the owning side field App\Entity\WorkerTimesheet#worker which does not exist.
  • The mappings App\Entity\Worker#user_app_settings and App\Entity\UserAppSettings#worker are inconsistent with each other.
App\Entity\UserPositions No errors.
App\Entity\ProjectAddendumCosts
  • The association App\Entity\ProjectAddendumCosts#project refers to the inverse side field App\Entity\Projects#projectAddendumCosts which does not exist.
App\Entity\AccessRoles No errors.
App\Entity\WorkerTimesheetPayments
  • The association App\Entity\WorkerTimesheetPayments#project refers to the inverse side field App\Entity\Projects#workerTimesheetPayments which does not exist.
App\Entity\ProjectOrderFeedback
  • The association App\Entity\ProjectOrderFeedback#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderFeedback which does not exist.
App\Entity\ProjectOrders
  • The mappings App\Entity\ProjectOrders#project_order_feedback and App\Entity\ProjectOrderFeedback#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_invoices and App\Entity\ProjectOrderInvoices#project_order are inconsistent with each other.
  • The association App\Entity\ProjectOrders#contact_person refers to the inverse side field App\Entity\ProjectOwnerContactPersons#projectOrders which does not exist.
  • The mappings App\Entity\ProjectOrders#project_order_extra_costs and App\Entity\ProjectOrderExtraCosts#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_expenses and App\Entity\ProjectOrderExpenses#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_expense_positions and App\Entity\ProjectOrderExpensePositions#project_order are inconsistent with each other.
  • The association App\Entity\ProjectOrders#order_branch refers to the inverse side field App\Entity\Branches#projectOrders which does not exist.
  • The association App\Entity\ProjectOrders#stock_transactions refers to the owning side field App\Entity\StockTransactions#project_order_id which does not exist.
App\Entity\UserRights
  • The association App\Entity\UserRights#user_right_module refers to the inverse side field App\Entity\UserRightModules#userRights which does not exist.
  • The association App\Entity\UserRights#user refers to the inverse side field App\Entity\User#userRights which does not exist.
App\Entity\Inventory No errors.
App\Entity\SupplierOrders
  • The association App\Entity\SupplierOrders#inventories refers to the owning side field App\Entity\Inventory#supplier_order which does not exist.
App\Entity\UserScopedItem No errors.
App\Entity\UserCalculationPermission No errors.
App\Entity\WorkerActivities
  • The association App\Entity\WorkerActivities#worker refers to the inverse side field App\Entity\Worker#workerActivities which does not exist.
  • The association App\Entity\WorkerActivities#customer refers to the inverse side field App\Entity\Customer#workerActivities which does not exist.
App\Entity\PurchaseRequest
  • The mappings App\Entity\PurchaseRequest#purchase_request_user_favorites and App\Entity\PurchaseRequestUserFavorites#purchase_request are inconsistent with each other.
  • The mappings App\Entity\PurchaseRequest#expenses and App\Entity\ProjectOrderExpenses#purchase_request are inconsistent with each other.
App\Entity\PurchaseRequestPositionHistoryRead No errors.
App\Entity\PurchaseRequestHistoryRead No errors.
App\Entity\PurchaseRequestHistories No errors.
App\Entity\PurchaseRequestUserFavorites
  • The association App\Entity\PurchaseRequestUserFavorites#purchase_request refers to the inverse side field App\Entity\PurchaseRequest#purchaseRequestUserFavorites which does not exist.
App\Entity\PurchaseRequestPositions No errors.
App\Entity\Warehouses No errors.
App\Entity\StockIssue No errors.
App\Entity\StockIssuePositions No errors.
App\Entity\Projects
  • The mappings App\Entity\Projects#project_addendum_costs and App\Entity\ProjectAddendumCosts#project are inconsistent with each other.
  • The mappings App\Entity\Projects#project_expenses and App\Entity\ProjectExpense#project are inconsistent with each other.
  • The mappings App\Entity\Projects#worker_timesheet_payments and App\Entity\WorkerTimesheetPayments#project are inconsistent with each other.
App\Entity\ProjectOwner
  • The mappings App\Entity\ProjectOwner#project_owner_contact_persons and App\Entity\ProjectOwnerContactPersons#project_owner are inconsistent with each other.
App\Entity\Countries
  • The mappings App\Entity\Countries#addresses and App\Entity\Addresses#country are inconsistent with each other.
App\Entity\InvoiceType No errors.
App\Entity\ProjectSettings No errors.
App\Entity\ProjectStakeholders
  • The mappings App\Entity\ProjectStakeholders#worker_in_projects and App\Entity\WorkerInProject#project are inconsistent with each other.
  • The association App\Entity\ProjectStakeholders#workerTimesheetPayments refers to the owning side field App\Entity\WorkerTimesheetPayments#project_stakeholder which does not exist.
App\Entity\Qualification No errors.
App\Entity\Certificates No errors.
App\Entity\ProjectExpense
  • The association App\Entity\ProjectExpense#project refers to the inverse side field App\Entity\Projects#projectExpenses which does not exist.
App\Entity\ProjectBranches
  • The association App\Entity\ProjectBranches#branch refers to the inverse side field App\Entity\Branches#projectBranches which does not exist.
App\Entity\Branches
  • The mappings App\Entity\Branches#project_branches and App\Entity\ProjectBranches#branch are inconsistent with each other.
  • The mappings App\Entity\Branches#project_orders and App\Entity\ProjectOrders#order_branch are inconsistent with each other.
  • The mappings App\Entity\Branches#branch_departements and App\Entity\BranchDepartements#branch are inconsistent with each other.
App\Entity\WorkerInProject
  • The association App\Entity\WorkerInProject#worker refers to the inverse side field App\Entity\Worker#workerInProjects which does not exist.
  • The association App\Entity\WorkerInProject#project refers to the inverse side field App\Entity\ProjectStakeholders#workerInProjects which does not exist.
App\Entity\ProjectStatus
  • The association App\Entity\ProjectStatus#workerInProjects refers to the owning side field App\Entity\WorkerInProject#status which does not exist.
App\Entity\ProjectOwnerContactPersons
  • The association App\Entity\ProjectOwnerContactPersons#project_owner refers to the inverse side field App\Entity\ProjectOwner#projectOwnerContactPersons which does not exist.
  • The association App\Entity\ProjectOwnerContactPersons#position refers to the inverse side field App\Entity\ContactPersonPositions#projectOwnerContactPersons which does not exist.
App\Entity\BranchDepartements
  • The association App\Entity\BranchDepartements#branch refers to the inverse side field App\Entity\Branches#branchDepartements which does not exist.
App\Entity\ProjectOrderInvoices
  • The association App\Entity\ProjectOrderInvoices#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderInvoices which does not exist.
  • The mappings App\Entity\ProjectOrderInvoices#project_order_invoice_positions and App\Entity\ProjectOrderInvoicePositions#project_order_invoice are inconsistent with each other.
App\Entity\ProjectOrderExtraCosts
  • The association App\Entity\ProjectOrderExtraCosts#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderExtraCosts which does not exist.
App\Entity\ProjectOrderUndertakings No errors.
App\Entity\ProjectOrderExpenses
  • The association App\Entity\ProjectOrderExpenses#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderExpenses which does not exist.
  • The mappings App\Entity\ProjectOrderExpenses#project_order_expense_positions and App\Entity\ProjectOrderExpensePositions#project_order_expense are inconsistent with each other.
  • The association App\Entity\ProjectOrderExpenses#purchase_request refers to the inverse side field App\Entity\PurchaseRequest#expense which does not exist.
App\Entity\ProjectOrderExpensePositions
  • The association App\Entity\ProjectOrderExpensePositions#project_order_expense refers to the inverse side field App\Entity\ProjectOrderExpenses#projectOrderExpensePositions which does not exist.
  • The association App\Entity\ProjectOrderExpensePositions#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderExpensePositions which does not exist.
  • The association App\Entity\ProjectOrderExpensePositions#stock refers to the inverse side field App\Entity\Stocks#projectOrderExpensePositions which does not exist.
App\Entity\StockTransactions
  • The association App\Entity\StockTransactions#stock refers to the inverse side field App\Entity\Stocks#stockTransactions which does not exist.
  • The mappings App\Entity\StockTransactions#project_order and App\Entity\ProjectOrders#stock_transactions are inconsistent with each other.
App\Entity\Material
  • The association App\Entity\Material#unit_type refers to the inverse side field App\Entity\MaterialUnitTypes#materials which does not exist.
  • The association App\Entity\Material#inventories refers to the owning side field App\Entity\Inventory#material which does not exist.
App\Entity\Stocks
  • The mappings App\Entity\Stocks#stock_transactions and App\Entity\StockTransactions#stock are inconsistent with each other.
  • The mappings App\Entity\Stocks#project_order_expense_positions and App\Entity\ProjectOrderExpensePositions#stock are inconsistent with each other.
App\Entity\ScopedItems No errors.
App\Entity\WorkerCertificates
  • The association App\Entity\WorkerCertificates#worker refers to the inverse side field App\Entity\Worker#workerCertificates which does not exist.
  • The mappings App\Entity\WorkerCertificates#worker_certificate_histories and App\Entity\WorkerCertificateHistories#worker_certificate are inconsistent with each other.
App\Entity\WorkerTimesheet
  • The mappings App\Entity\WorkerTimesheet#worker_a and App\Entity\Worker#worker_timesheets are inconsistent with each other.
App\Entity\UserAppSettings
  • The association App\Entity\UserAppSettings#worker refers to the inverse side field App\Entity\Worker#userAppSettings which does not exist.