http://romon-erp.com/api/v3/project-order/streamed-fetch/64/1852

Query Metrics

5 Database Queries
5 Different statements
3.47 ms Query time
28 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.94 ms
(27.09%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.created_at AS created_at_5, t0.project_id AS project_id_6, t0.qr_code AS qr_code_7, t0.address AS address_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.scan_distance AS scan_distance_11, t0.reward_time AS reward_time_12, t0.work_pause AS work_pause_13, t0.working_time_start AS working_time_start_14, t0.working_time_stop AS working_time_stop_15, t0.code_postal AS code_postal_16, t0.town AS town_17, t0.is_archived AS is_archived_18, t0.is_recycle AS is_recycle_19, t0.type AS type_20, t0.owner_id AS owner_id_21, t0.country_id AS country_id_22, t0.invoice_type_id AS invoice_type_id_23, t24.id AS id_25, t24.material_budget AS material_budget_26, t24.timesheet_budget AS timesheet_budget_27, t24.target_profit AS target_profit_28, t24.project_id AS project_id_29, t30.id AS id_31, t30.spent_hours AS spent_hours_32, t30.spent_costs AS spent_costs_33, t30.expenses AS expenses_34, t30.half_finished AS half_finished_35, t30.backlog AS backlog_36, t30.contribution_margin AS contribution_margin_37, t30.finance_total AS finance_total_38, t30.progress AS progress_39, t30.open_invoices AS open_invoices_40, t30.received_invoices AS received_invoices_41, t30.total_invoices AS total_invoices_42, t30.open_undertakings AS open_undertakings_43, t30.received_undertakings AS received_undertakings_44, t30.total_undertakings AS total_undertakings_45, t30.stock_expenses AS stock_expenses_46, t30.total_billings AS total_billings_47, t30.open_billings AS open_billings_48, t30.paid_billings AS paid_billings_49, t30.project_id AS project_id_50, t0.classify_id AS classify_id_51 FROM projects t0 LEFT JOIN project_settings t24 ON t24.project_id = t0.id LEFT JOIN project_metrics t30 ON t30.project_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "64"
]
0.84 ms
(24.23%)
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.email_signature AS email_signature_14, t15.id AS id_16, t15.name AS name_17, t15.surname AS surname_18, t15.entry_at AS entry_at_19, t15.exit_at AS exit_at_20, t15.birthday_at AS birthday_at_21, t15.slug AS slug_22, t15.daily_work_time AS daily_work_time_23, t15.cost_per_hour AS cost_per_hour_24, t15.personal_id AS personal_id_25, t15.created_at AS created_at_26, t15.phone_number AS phone_number_27, t15.uiid AS uiid_28, t15.profile_image AS profile_image_29, t15.email AS email_30, t15.user_id AS user_id_31, t0.user_position_id AS user_position_id_32 FROM user t0 LEFT JOIN worker t15 ON t15.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  28
]
0.70 ms
(20.25%)
1
SELECT t0.id AS id_1, t0.order_nr AS order_nr_2, t0.order_description AS order_description_3, t0.order_price AS order_price_4, t0.order_status AS order_status_5, t0.should_end_at AS should_end_at_6, t0.is_end_at AS is_end_at_7, t0.hourly_rate AS hourly_rate_8, t0.order_at AS order_at_9, t0.project_owner_order_nr AS project_owner_order_nr_10, t0.hours_spent AS hours_spent_11, t0.cost_spent AS cost_spent_12, t0.material_budget AS material_budget_13, t0.timesheet_budget AS timesheet_budget_14, t0.target_profit AS target_profit_15, t0.created_at AS created_at_16, t0.plan_rating AS plan_rating_17, t0.project_id AS project_id_18, t0.contact_person_id AS contact_person_id_19, t0.author_id AS author_id_20, t0.invoice_type_id AS invoice_type_id_21, t0.order_primary_lead_id AS order_primary_lead_id_22, t0.order_branch_id AS order_branch_id_23, t0.branch_department_id AS branch_department_id_24, t25.id AS id_26, t25.spent_hours AS spent_hours_27, t25.spent_costs AS spent_costs_28, t25.expenses AS expenses_29, t25.half_finished AS half_finished_30, t25.backlog AS backlog_31, t25.contribution_margin AS contribution_margin_32, t25.stock_expenses AS stock_expenses_33, t25.progress AS progress_34, t25.open_invoices AS open_invoices_35, t25.received_invoices AS received_invoices_36, t25.total_invoices AS total_invoices_37, t25.open_undertakings AS open_undertakings_38, t25.received_undertakings AS received_undertakings_39, t25.total_undertakings AS total_undertakings_40, t25.order_progress AS order_progress_41, t25.total_billings AS total_billings_42, t25.open_billings AS open_billings_43, t25.paid_billings AS paid_billings_44, t25.project_order_id AS project_order_id_45, t0.works_plan_id AS works_plan_id_46 FROM project_orders t0 LEFT JOIN project_order_metrics t25 ON t25.project_order_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "1852"
]
0.54 ms
(15.46%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3 FROM project_status t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.45 ms
(12.98%)
1
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:
[
  64
]

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\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_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\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\ProjectMetrics No errors.
App\Entity\ProjectClassify 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
  • The mappings App\Entity\Certificates#workerCertificates and App\Entity\WorkerCertificates#certificate are inconsistent with each other.
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.
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\BranchDepartments No errors.
App\Entity\ProjectOrderMetrics No errors.
App\Entity\WorksPlan No errors.
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.
  • The association App\Entity\ProjectOrderInvoices#invoice_positions refers to the owning side field App\Entity\InvoicePositions#order_invoice which does not exist.
App\Entity\ProjectOrderUndertakings
  • The association App\Entity\ProjectOrderUndertakings#invoice_positions refers to the owning side field App\Entity\InvoicePositions#order_undertaking which does not exist.
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\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.
App\Entity\ProjectOrderTasks
  • The mappings App\Entity\ProjectOrderTasks#task_jobs and App\Entity\ProjectOrderTaskJobs#order_task are inconsistent with each other.
App\Entity\InvoicePositions
  • The association App\Entity\InvoicePositions#order_billing refers to the inverse side field App\Entity\ProjectOrderBillings#invoice_position which does not exist.