Query Metrics
5
Database Queries
5
Different statements
2.20 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.54 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.id = ?
Parameters:
[
"544"
]
|
0.52 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.ean AS ean_3, t0.sku AS sku_4, t0.description AS description_5, t0.price AS price_6, t0.iva AS iva_7, t0.date_created AS date_created_8, t0.parent AS parent_9, t0.wp_id AS wp_id_10, t0.image AS image_11, t0.cost_price AS cost_price_12, t0.date_modify AS date_modify_13, t0.global_stock AS global_stock_14, t0.wp_stock AS wp_stock_15, t0.store_stock AS store_stock_16, t0.discount AS discount_17, t0.discount_from AS discount_from_18, t0.discount_to AS discount_to_19, t0.store_discount AS store_discount_20, t0.web_discount AS web_discount_21, t0.status AS status_22, t0.gallery AS gallery_23 FROM products t0 WHERE t0.id = ?
Parameters:
[
5919
]
|
0.48 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:
[
4
]
|
0.48 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.venta_id AS venta_id_2, t0.product_id AS product_id_3, t0.qty AS qty_4, t0.unit_price AS unit_price_5, t0.iva AS iva_6, t0.discount AS discount_7 FROM venta_products t0 WHERE t0.venta_id = ?
Parameters:
[
"544"
]
|
0.17 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:
[
6
]
|
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\VentaProducts | No errors. |
App\Entity\Clientes | No errors. |
App\Entity\Products | No errors. |