Query Metrics
8
Database Queries
6
Different statements
3.07 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.00 ms (0.00%) |
3 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
0.67 ms (0.00%) |
1 |
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_.client_id = ? ORDER BY v0_.date DESC
Parameters:
[
"81"
]
|
0.55 ms (0.00%) |
1 |
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_.client_id = ? ORDER BY v0_.date DESC LIMIT 1
Parameters:
[
"81"
]
|
0.32 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.date AS date_2, t0.client_id AS client_id_3, t0.user_id AS user_id_4, t0.status AS status_5, t0.subtotal AS subtotal_6, t0.iva AS iva_7, t0.iva_value AS iva_value_8, t0.total AS total_9, t0.date_modif AS date_modif_10, t0.payed AS payed_11, t0.payment_method AS payment_method_12, t0.order_wp_id AS order_wp_id_13, t0.extra_info AS extra_info_14, t0.global_discount AS global_discount_15 FROM ventas t0 WHERE t0.client_id = ?
Parameters:
[
81
]
|
0.28 ms (0.00%) |
1 |
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:
[
"81"
]
|
0.26 ms (0.00%) |
1 |
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:
[
1
]
|
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\Clientes | No errors. |
App\Entity\Ventas | No errors. |