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

Query Metrics

8 Database Queries
8 Different statements
7.98 ms Query time
4 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 1.89 ms
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
]
2 1.15 ms
SELECT COUNT(s0_.id) AS sclr_0 FROM sales s0_ WHERE s0_.created_at >= ?
Parameters:
[
  "2026-01-12 20:22:53"
]
3 0.98 ms
SELECT s0_.id AS id_0, s0_.invoice_number AS invoice_number_1, s0_.total_amount AS total_amount_2, s0_.amount_paid AS amount_paid_3, s0_.payment_method AS payment_method_4, s0_.status AS status_5, s0_.customer_name AS customer_name_6, s0_.customer_phone AS customer_phone_7, s0_.notes AS notes_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.cashier_id AS cashier_id_11, s0_.store_id AS store_id_12, s0_.cash_register_id AS cash_register_id_13 FROM sales s0_ WHERE s0_.created_at >= ? ORDER BY s0_.created_at DESC LIMIT 10
Parameters:
[
  "2026-01-12 20:22:53"
]
4 1.29 ms
SELECT COUNT(s0_.id) AS sclr_0 FROM sales s0_ WHERE s0_.status IN (?, ?)
Parameters:
[
  "partial"
  "pending"
]
5 0.69 ms
SELECT s0_.id AS id_0, s0_.invoice_number AS invoice_number_1, s0_.total_amount AS total_amount_2, s0_.amount_paid AS amount_paid_3, s0_.payment_method AS payment_method_4, s0_.status AS status_5, s0_.customer_name AS customer_name_6, s0_.customer_phone AS customer_phone_7, s0_.notes AS notes_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.cashier_id AS cashier_id_11, s0_.store_id AS store_id_12, s0_.cash_register_id AS cash_register_id_13 FROM sales s0_ WHERE s0_.status IN (?, ?) ORDER BY s0_.created_at DESC LIMIT 10
Parameters:
[
  "partial"
  "pending"
]
6 0.51 ms
SELECT s0_.id AS id_0, s0_.invoice_number AS invoice_number_1, s0_.total_amount AS total_amount_2, s0_.amount_paid AS amount_paid_3, s0_.payment_method AS payment_method_4, s0_.status AS status_5, s0_.customer_name AS customer_name_6, s0_.customer_phone AS customer_phone_7, s0_.notes AS notes_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.cashier_id AS cashier_id_11, s0_.store_id AS store_id_12, s0_.cash_register_id AS cash_register_id_13 FROM sales s0_ WHERE s0_.created_at >= ?
Parameters:
[
  "2026-01-12 20:22:53"
]
7 0.67 ms
SELECT s0_.id AS id_0, s0_.invoice_number AS invoice_number_1, s0_.total_amount AS total_amount_2, s0_.amount_paid AS amount_paid_3, s0_.payment_method AS payment_method_4, s0_.status AS status_5, s0_.customer_name AS customer_name_6, s0_.customer_phone AS customer_phone_7, s0_.notes AS notes_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.cashier_id AS cashier_id_11, s0_.store_id AS store_id_12, s0_.cash_register_id AS cash_register_id_13 FROM sales s0_ WHERE s0_.created_at >= ? AND s0_.created_at < ?
Parameters:
[
  "2026-01-19 00:00:00"
  "2026-01-20 00:00:00"
]
8 0.79 ms
SELECT s0_.id AS id_0, s0_.invoice_number AS invoice_number_1, s0_.total_amount AS total_amount_2, s0_.amount_paid AS amount_paid_3, s0_.payment_method AS payment_method_4, s0_.status AS status_5, s0_.customer_name AS customer_name_6, s0_.customer_phone AS customer_phone_7, s0_.notes AS notes_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.cashier_id AS cashier_id_11, s0_.store_id AS store_id_12, s0_.cash_register_id AS cash_register_id_13 FROM sales s0_ WHERE s0_.status IN (?, ?)
Parameters:
[
  "partial"
  "pending"
]

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

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\Sale
  • The field 'App\Entity\Sale#totalAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Sale#amountPaid' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Store
  • The field App\Entity\Store#sales is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sale#store does not contain the required 'inversedBy: "sales"' attribute.
App\Entity\CashRegister
  • The field App\Entity\CashRegister#sales is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sale#cashRegister does not contain the required 'inversedBy: "sales"' attribute.