GET https://pharma.cassaclock.com/admin/stock

Query Metrics

3 Database Queries
3 Different statements
4.33 ms Query time
3 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.64 ms
(37.97%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.barcode AS barcode_4, t0.purchase_price AS purchase_price_5, t0.selling_price AS selling_price_6, t0.stock_quantity AS stock_quantity_7, t0.min_stock_alert AS min_stock_alert_8, t0.unit AS unit_9, t0.image AS image_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.category_id AS category_id_14, t0.supplier_id AS supplier_id_15 FROM products t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
1.49 ms
(34.44%)
1
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.email AS email_3, t0.phone AS phone_4, t0.password AS password_5, t0.roles AS roles_6, t0.position AS position_7, t0.salary AS salary_8, t0.hire_date AS hire_date_9, t0.address AS address_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12 FROM employees t0 WHERE t0.id = ?
Parameters:
[
  5
]
1.19 ms
(27.59%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.quantity AS quantity_3, t0.reason AS reason_4, t0.notes AS notes_5, t0.reference AS reference_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t0.employee_id AS employee_id_9 FROM stock_movement t0 ORDER BY t0.created_at DESC LIMIT 100
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Employee 1
App\Entity\Product 1
App\Entity\Category 1
App\Entity\Supplier 1

Entities Mapping

Class Mapping errors
App\Entity\Employee
  • The field 'App\Entity\Employee#salary' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\StockMovement No errors.
App\Entity\Product
  • The field 'App\Entity\Product#purchasePrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Product#sellingPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The association App\Entity\Product#supplier refers to the inverse side field App\Entity\Supplier#products which does not exist.
  • The field App\Entity\Product#stockMovements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\StockMovement#product does not contain the required 'inversedBy: "stockMovements"' attribute.
App\Entity\Category No errors.
App\Entity\Supplier No errors.
App\Entity\SaleItem
  • The field 'App\Entity\SaleItem#unitPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\SaleItem#subtotal' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\StockBatch No errors.