Query Metrics
5
Database Queries
4
Different statements
2.79 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.email AS email_4, t0.password AS password_5, t0.role AS role_6 FROM users t0 WHERE t0.id = ?
Parameters:
[
6
]
|
2 | 2.17 ms |
SELECT v0_.id AS id_0, v0_.date AS date_1, v0_.client_id AS client_id_2, v0_.user_id AS user_id_3, v0_.status AS status_4, v0_.subtotal AS subtotal_5, v0_.iva AS iva_6, v0_.iva_value AS iva_value_7, v0_.total AS total_8, v0_.date_modif AS date_modif_9, v0_.payed AS payed_10, v0_.payment_method AS payment_method_11, v0_.order_wp_id AS order_wp_id_12, v0_.extra_info AS extra_info_13, v0_.global_discount AS global_discount_14 FROM ventas v0_ WHERE v0_.status <> 3 AND v0_.date BETWEEN ? AND ?
Parameters:
[ "2024-09-28 00:00:00" "2024-09-29 00:00:00" ] |
3 | 0.11 ms |
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.ventas AS ventas_3, t0.totales AS totales_4, t0.total_apertura AS total_apertura_5 FROM cierre_caja t0 WHERE t0.fecha = ? LIMIT 1
Parameters:
[
"2024-09-28 00:00:00"
]
|
4 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.email AS email_4, t0.nif AS nif_5, t0.address AS address_6, t0.cp AS cp_7, t0.city AS city_8, t0.state AS state_9, t0.country AS country_10, t0.phone AS phone_11, t0.datecreated AS datecreated_12, t0.id_wp AS id_wp_13, t0.status AS status_14 FROM clientes t0 WHERE t0.id = ?
Parameters:
[
4
]
|
5 | 0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.email AS email_4, t0.nif AS nif_5, t0.address AS address_6, t0.cp AS cp_7, t0.city AS city_8, t0.state AS state_9, t0.country AS country_10, t0.phone AS phone_11, t0.datecreated AS datecreated_12, t0.id_wp AS id_wp_13, t0.status AS status_14 FROM clientes t0 WHERE t0.id = ?
Parameters:
[
19
]
|
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\Users | No errors. |
App\Entity\Ventas | No errors. |
App\Entity\CierreCaja | No errors. |
App\Entity\Clientes | No errors. |