https://nubesdecoloreskids.sell-io.es/tpv/cierre_caja

Query Metrics

5 Database Queries
4 Different statements
2.79 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.17 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_.status <> 3 AND v0_.date BETWEEN ? AND ?
Parameters:
[
  "2024-09-28 00:00:00"
  "2024-09-29 00:00:00"
]
0.39 ms
(0.00%)
2
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.11 ms
(0.00%)
1
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"
]
0.11 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\CierreCaja No errors.
App\Entity\Clientes No errors.