http://romon-erp.com/api/material/materials/59 Return to referer URL

Query Metrics

3 Database Queries
3 Different statements
1.57 ms Query time
18 Invalid entities

Queries

Group similar statements

# Time Info
1 0.81 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:
[
  13
]
2 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.alias AS alias_4, t0.company AS company_5, t0.terms_to_payment AS terms_to_payment_6, t0.tax AS tax_7, t0.email AS email_8, t0.address_id AS address_id_9 FROM suppliers t0 WHERE t0.id = ?
Parameters:
[
  59
]
3 0.34 ms
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.description AS description_3, t0.price AS price_4, t0.editable_content AS editable_content_5, t0.content AS content_6, t0.article_nr AS article_nr_7, t0.supplier_id AS supplier_id_8, t0.unit_type_id AS unit_type_id_9 FROM material t0 WHERE t0.supplier_id = ?
Parameters:
[
  59
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The mappings App\Entity\User#user_rights and App\Entity\UserRights#user are inconsistent with each other.
  • The association App\Entity\User#inventories refers to the owning side field App\Entity\Inventory#involved_by which does not exist.
App\Entity\Worker
  • The mappings App\Entity\Worker#worker_in_projects and App\Entity\WorkerInProject#worker are inconsistent with each other.
  • The mappings App\Entity\Worker#worker_activities and App\Entity\WorkerActivities#worker are inconsistent with each other.
  • The mappings App\Entity\Worker#worker_certificates and App\Entity\WorkerCertificates#worker are inconsistent with each other.
  • The association App\Entity\Worker#worker_timesheets refers to the owning side field App\Entity\WorkerTimesheet#worker which does not exist.
  • The mappings App\Entity\Worker#user_app_settings and App\Entity\UserAppSettings#worker are inconsistent with each other.
App\Entity\UserPositions No errors.
App\Entity\ProjectAddendumCosts
  • The association App\Entity\ProjectAddendumCosts#project refers to the inverse side field App\Entity\Projects#projectAddendumCosts which does not exist.
App\Entity\AccessRoles No errors.
App\Entity\WorkerTimesheetPayments
  • The association App\Entity\WorkerTimesheetPayments#project refers to the inverse side field App\Entity\Projects#workerTimesheetPayments which does not exist.
App\Entity\ProjectOrderFeedback
  • The association App\Entity\ProjectOrderFeedback#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderFeedback which does not exist.
App\Entity\ProjectOrders
  • The mappings App\Entity\ProjectOrders#project_order_feedback and App\Entity\ProjectOrderFeedback#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_invoices and App\Entity\ProjectOrderInvoices#project_order are inconsistent with each other.
  • The association App\Entity\ProjectOrders#contact_person refers to the inverse side field App\Entity\ProjectOwnerContactPersons#projectOrders which does not exist.
  • The mappings App\Entity\ProjectOrders#project_order_extra_costs and App\Entity\ProjectOrderExtraCosts#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_expenses and App\Entity\ProjectOrderExpenses#project_order are inconsistent with each other.
  • The mappings App\Entity\ProjectOrders#project_order_expense_positions and App\Entity\ProjectOrderExpensePositions#project_order are inconsistent with each other.
  • The association App\Entity\ProjectOrders#order_branch refers to the inverse side field App\Entity\Branches#projectOrders which does not exist.
  • The association App\Entity\ProjectOrders#stock_transactions refers to the owning side field App\Entity\StockTransactions#project_order_id which does not exist.
App\Entity\UserRights
  • The association App\Entity\UserRights#user_right_module refers to the inverse side field App\Entity\UserRightModules#userRights which does not exist.
  • The association App\Entity\UserRights#user refers to the inverse side field App\Entity\User#userRights which does not exist.
App\Entity\Inventory No errors.
App\Entity\SupplierOrders
  • The association App\Entity\SupplierOrders#inventories refers to the owning side field App\Entity\Inventory#supplier_order which does not exist.
App\Entity\UserScopedItem No errors.
App\Entity\UserCalculationPermission No errors.
App\Entity\WorkerActivities
  • The association App\Entity\WorkerActivities#worker refers to the inverse side field App\Entity\Worker#workerActivities which does not exist.
  • The association App\Entity\WorkerActivities#customer refers to the inverse side field App\Entity\Customer#workerActivities which does not exist.
App\Entity\PurchaseRequest
  • The mappings App\Entity\PurchaseRequest#purchase_request_user_favorites and App\Entity\PurchaseRequestUserFavorites#purchase_request are inconsistent with each other.
  • The mappings App\Entity\PurchaseRequest#expenses and App\Entity\ProjectOrderExpenses#purchase_request are inconsistent with each other.
App\Entity\PurchaseRequestPositionHistoryRead No errors.
App\Entity\PurchaseRequestHistoryRead No errors.
App\Entity\PurchaseRequestHistories No errors.
App\Entity\PurchaseRequestUserFavorites
  • The association App\Entity\PurchaseRequestUserFavorites#purchase_request refers to the inverse side field App\Entity\PurchaseRequest#purchaseRequestUserFavorites which does not exist.
App\Entity\PurchaseRequestPositions No errors.
App\Entity\Warehouses No errors.
App\Entity\StockIssue No errors.
App\Entity\StockIssuePositions No errors.
App\Entity\Suppliers
  • The mappings App\Entity\Suppliers#addresses and App\Entity\Addresses#supplier are inconsistent with each other.
App\Entity\Addresses
  • The association App\Entity\Addresses#supplier refers to the inverse side field App\Entity\Suppliers#adresses which does not exist.
  • The association App\Entity\Addresses#country refers to the inverse side field App\Entity\Countries#adresses 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\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\ProjectOrderExpenses
  • The association App\Entity\ProjectOrderExpenses#project_order refers to the inverse side field App\Entity\ProjectOrders#projectOrderExpenses which does not exist.
  • The mappings App\Entity\ProjectOrderExpenses#project_order_expense_positions and App\Entity\ProjectOrderExpensePositions#project_order_expense are inconsistent with each other.
  • The association App\Entity\ProjectOrderExpenses#purchase_request refers to the inverse side field App\Entity\PurchaseRequest#expense which does not exist.
App\Entity\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#stock_item refers to the inverse side field App\Entity\StockItems#supplierProducts which does not exist.
App\Entity\MaterialUnitTypes No errors.