GET https://festival.winecta.com/ajax/tiny/

Query Metrics

7 Database Queries
7 Different statements
21.02 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
14.33 ms
(68.21%)
1
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.pdf AS pdf_2, p0_.descripcion AS descripcion_3, p0_.deleted_at AS deleted_at_4, p0_.nombre_ingles AS nombre_ingles_5, p0_.descripcion_ingles AS descripcion_ingles_6, p0_.evento_id AS evento_id_7 FROM programa p0_ WHERE p0_.deleted_at IS NULL ORDER BY p0_.nombre DESC
Parameters:
[]
3.00 ms
(14.26%)
1
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM programa p0_ LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id WHERE p0_.deleted_at IS NULL AND p0_.nombre LIKE ?
Parameters:
[
  "%2024 Le Concert des Nations%"
]
2.06 ms
(9.81%)
1
SELECT DISTINCT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM programa p0_ LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id WHERE p0_.deleted_at IS NULL AND p0_.nombre LIKE ? ORDER BY p0_.nombre DESC LIMIT 20
Parameters:
[
  "%2024 Le Concert des Nations%"
]
0.55 ms
(2.61%)
1
SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.pdf AS pdf_2, p0_.descripcion AS descripcion_3, p0_.deleted_at AS deleted_at_4, p0_.nombre_ingles AS nombre_ingles_5, p0_.descripcion_ingles AS descripcion_ingles_6, p0_.evento_id AS evento_id_7 FROM programa p0_ LEFT JOIN evento e1_ ON p0_.evento_id = e1_.id WHERE p0_.deleted_at IS NULL AND p0_.nombre LIKE ? AND p0_.id IN (?) ORDER BY p0_.nombre DESC
Parameters:
[
  "%2024 Le Concert des Nations%"
  7982
]
0.45 ms
(2.15%)
1
SELECT t0.id AS id_4, t0.deleted_at AS deleted_at_5, t0.roles AS roles_6, t0.password AS password_7, t0.email AS email_8, t0.nombre AS nombre_9, t0.rol FROM `usuario` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN editor t2 ON t0.id = t2.id LEFT JOIN cliente t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters:
[
  24
]
0.43 ms
(2.03%)
1
SELECT e0_.fecha AS fecha_0 FROM programa p1_ LEFT JOIN evento e0_ ON p1_.evento_id = e0_.id WHERE p1_.deleted_at IS NULL AND e0_.fecha IS NOT NULL ORDER BY e0_.fecha DESC
Parameters:
[]
0.20 ms
(0.94%)
1
SELECT c0_.id AS id_0, c0_.clave_tiny AS clave_tiny_1 FROM configuracion c0_
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
old_wp doctrine.dbal.old_wp_connection
old_t3 doctrine.dbal.old_t3_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\Usuario No errors.
App\Entity\Admin No errors.
App\Entity\Editor No errors.
App\Entity\Cliente No errors.
App\Entity\Programa No errors.
App\Entity\Evento No errors.
App\Entity\ObraPrograma No errors.
App\Entity\ArtistaObraPrograma
  • The association App\Entity\ArtistaObraPrograma#artistas refers to the owning side field App\Entity\Artista#artistaObraPrograma which does not exist.
App\Entity\Configuracion No errors.