http://romon-erp.com/api/v3/expense/position-streamed-fetch/2751/4016

Query Metrics

3 Database Queries
3 Different statements
2.25 ms Query time
16 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
1.07 ms
(47.39%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.surname AS surname_6, t0.login_refused AS login_refused_7, t0.login_refused_message AS login_refused_message_8, t0.invisible_since AS invisible_since_9, t0.is_password_updated_at AS is_password_updated_at_10, t0.news_last_seen_at AS news_last_seen_at_11, t0.idle_timer_timeout AS idle_timer_timeout_12, t0.notification_preferences AS notification_preferences_13, t0.ui_preferences AS ui_preferences_14, t0.email_signature AS email_signature_15, t16.id AS id_17, t16.name AS name_18, t16.surname AS surname_19, t16.entry_at AS entry_at_20, t16.exit_at AS exit_at_21, t16.birthday_at AS birthday_at_22, t16.slug AS slug_23, t16.daily_work_time AS daily_work_time_24, t16.cost_per_hour AS cost_per_hour_25, t16.personal_id AS personal_id_26, t16.created_at AS created_at_27, t16.phone_number AS phone_number_28, t16.social_insurance_number AS social_insurance_number_29, t16.uiid AS uiid_30, t16.profile_image AS profile_image_31, t16.email AS email_32, t16.default_qualification_id AS default_qualification_id_33, t16.user_id AS user_id_34, t0.user_position_id AS user_position_id_35 FROM user t0 LEFT JOIN worker t16 ON t16.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  13
]
0.76 ms
(33.89%)
1
SELECT t0.id AS id_1, t0.unit AS unit_2, t0.created_at AS created_at_3, t0.delivered_at AS delivered_at_4, t0.delivery_due_at AS delivery_due_at_5, t0.amount AS amount_6, t0.delivered_unit AS delivered_unit_7, t0.content AS content_8, t0.completed AS completed_9, t0.comment AS comment_10, t0.delivered_to AS delivered_to_11, t0.an_supplier AS an_supplier_12, t0.document AS document_13, t0.documents AS documents_14, t0.buying_price AS buying_price_15, t0.price_unit AS price_unit_16, t0.sales_price AS sales_price_17, t0.sales_margin AS sales_margin_18, t0.delivery_amount AS delivery_amount_19, t0.offer_nr AS offer_nr_20, t0.position_type AS position_type_21, t0.delivery_status AS delivery_status_22, t0.size AS size_23, t0.project_order_expense_id AS project_order_expense_id_24, t0.material_id AS material_id_25, t0.project_order_id AS project_order_id_26, t0.parent_pos_id AS parent_pos_id_27, t0.stock_id AS stock_id_28, t0.purchase_request_position_id AS purchase_request_position_id_29, t0.supplier_product_id AS supplier_product_id_30 FROM project_order_expense_positions t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "4016"
]
0.42 ms
(18.72%)
1
SELECT t0.id AS id_1, t0.invoice_nr AS invoice_nr_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.total AS total_5, t0.ai_extraction_metadata AS ai_extraction_metadata_6, t0.expensed_at AS expensed_at_7, t0.expense_nr AS expense_nr_8, t0.offer_nr AS offer_nr_9, t0.offer_at AS offer_at_10, t0.delivery_due_at AS delivery_due_at_11, t0.comment AS comment_12, t0.document AS document_13, t0.documents AS documents_14, t0.supplier_id AS supplier_id_15, t0.deliver_location_id AS deliver_location_id_16, t0.purchase_request_id AS purchase_request_id_17 FROM project_order_expenses t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "2751"
]

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 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_certificates and App\Entity\WorkerCertificates#worker are inconsistent with each other.
  • The association App\Entity\Worker#projectOrders refers to the owning side field App\Entity\ProjectOrders#order_lead which does not exist.
App\Entity\Qualification No errors.
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\CustomerCollaborator#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_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.
App\Entity\UserModulePermissions No errors.
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 No errors.
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\ProjectAIReports No errors.
App\Entity\Invoices No errors.
App\Entity\ProjectOrderBillings
  • The mappings App\Entity\ProjectOrderBillings#invoice_positions and App\Entity\InvoicePositions#order_billing are inconsistent with each other.
App\Entity\UserServiceAccess No errors.
App\Entity\UserGlobalPasswordAccess No errors.
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\ProjectOrderExpenses
  • 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\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\SupplierProducts
  • The association App\Entity\SupplierProducts#supplier refers to the inverse side field App\Entity\Suppliers#supplierProducts which does not exist.
  • The association App\Entity\SupplierProducts#stock_item refers to the inverse side field App\Entity\StockItems#supplierProducts which does not exist.
App\Entity\Suppliers
  • The mappings App\Entity\Suppliers#addresses and App\Entity\Addresses#supplier are inconsistent with each other.
  • The mappings App\Entity\Suppliers#supplier_products and App\Entity\SupplierProducts#supplier are inconsistent with each other.
App\Entity\Locations No errors.