Query Metrics
8
Database Queries
8
Different statements
7.98 ms
Query time
4
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.89 ms (23.68%) |
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.29 ms (16.17%) |
1 |
SELECT COUNT(s0_.id) AS sclr_0 FROM sales s0_ WHERE s0_.status IN (?, ?)
Parameters:
[ "partial" "pending" ]
|
||||||||||||||||||||||||||||
|
1.15 ms (14.44%) |
1 |
SELECT COUNT(s0_.id) AS sclr_0 FROM sales s0_ WHERE s0_.created_at >= ?
Parameters:
[
"2026-01-12 20:22:53"
]
|
||||||||||||||||||||||||||||
|
0.98 ms (12.24%) |
1 |
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"
]
|
||||||||||||||||||||||||||||
|
0.79 ms (9.96%) |
1 |
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" ]
|
||||||||||||||||||||||||||||
|
0.69 ms (8.69%) |
1 |
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" ]
|
||||||||||||||||||||||||||||
|
0.67 ms (8.41%) |
1 |
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" ]
|
||||||||||||||||||||||||||||
|
0.51 ms (6.41%) |
1 |
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"
]
|
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 |
|
| App\Entity\Sale |
|
| App\Entity\Store |
|
| App\Entity\CashRegister |
|