Query Metrics
79
Database Queries
8
Different statements
27.33 ms
Query time
32
Invalid entities
Queries
| #▲ | 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 |
|
| App\Entity\Worker |
|
| App\Entity\UserPositions | No errors. |
| App\Entity\ProjectAddendumCosts |
|
| App\Entity\AccessRoles | No errors. |
| App\Entity\WorkerTimesheetPayments |
|
| App\Entity\ProjectOrderFeedback |
|
| App\Entity\ProjectOrders |
|
| App\Entity\UserRights |
|
| App\Entity\Inventory | No errors. |
| App\Entity\SupplierOrders |
|
| App\Entity\UserScopedItem | No errors. |
| App\Entity\UserCalculationPermission | No errors. |
| App\Entity\WorkerActivities |
|
| App\Entity\PurchaseRequest |
|
| App\Entity\PurchaseRequestPositionHistoryRead | No errors. |
| App\Entity\PurchaseRequestHistoryRead | No errors. |
| App\Entity\PurchaseRequestHistories | No errors. |
| App\Entity\PurchaseRequestUserFavorites |
|
| App\Entity\PurchaseRequestPositions | No errors. |
| App\Entity\Warehouses | No errors. |
| App\Entity\StockIssue | No errors. |
| App\Entity\StockIssuePositions | No errors. |
| App\Entity\Projects |
|
| App\Entity\ProjectOwner |
|
| App\Entity\Countries |
|
| App\Entity\InvoiceType | No errors. |
| App\Entity\ProjectSettings | No errors. |
| App\Entity\ProjectStakeholders |
|
| App\Entity\Qualification | No errors. |
| App\Entity\Certificates | No errors. |
| App\Entity\ProjectExpense |
|
| App\Entity\ProjectBranches |
|
| App\Entity\Branches |
|
| App\Entity\WorkerInProject |
|
| App\Entity\ProjectStatus |
|
| App\Entity\ProjectOwnerContactPersons |
|
| App\Entity\BranchDepartements |
|
| App\Entity\ProjectOrderInvoices |
|
| App\Entity\ProjectOrderExtraCosts |
|
| App\Entity\ProjectOrderUndertakings | No errors. |
| App\Entity\ProjectOrderExpenses |
|
| App\Entity\ProjectOrderExpensePositions |
|
| App\Entity\StockTransactions |
|
| App\Entity\Material |
|
| App\Entity\Stocks |
|
| App\Entity\ScopedItems | No errors. |
| App\Entity\WorkerCertificates |
|
| App\Entity\WorkerTimesheet |
|
| App\Entity\UserAppSettings |
|