Query Metrics
6
Database Queries
4
Different statements
6.85 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.26 ms |
SELECT t0.id AS id_1, t0.suscripcion_importe AS suscripcion_importe_2, t0.suscripcion_importe_inicial AS suscripcion_importe_inicial_3, t0.suscripcion_importe_comentario AS suscripcion_importe_comentario_4, t0.suscripcion_fin AS suscripcion_fin_5, t0.email AS email_6, t0.empresa_nombre AS empresa_nombre_7, t0.empresa_cif AS empresa_cif_8, t0.empresa_direccion AS empresa_direccion_9, t0.iva AS iva_10 FROM configuracion t0
Parameters:
[] |
2 | 4.11 ms |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.simulacro AS simulacro_2 FROM tema t0_ LEFT JOIN bloque b1_ ON t0_.id = b1_.tema_id LEFT JOIN cuestionario c2_ ON b1_.id = c2_.bloque_id WHERE c2_.visible = 1 AND c2_.gratis = 1 ORDER BY t0_.nombre ASC
Parameters:
[] |
3 | 1.20 ms |
SELECT b0_.id AS id_0, b0_.nombre AS nombre_1, b0_.orden AS orden_2, b0_.tema_id AS tema_id_3 FROM bloque b0_ LEFT JOIN cuestionario c1_ ON b0_.id = c1_.bloque_id WHERE b0_.tema_id = ? AND c1_.visible = 1 AND c1_.gratis = 1 ORDER BY b0_.nombre ASC
Parameters:
[
4
]
|
4 | 0.43 ms |
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.simulacro AS simulacro_3, t0.gratis AS gratis_4, t0.duracion AS duracion_5, t0.nombre AS nombre_6, t0.bloque_id AS bloque_id_7 FROM cuestionario t0 WHERE t0.bloque_id = ? AND t0.visible = ? AND t0.gratis = ? ORDER BY t0.nombre ASC
Parameters:
[ 16 1 1 ] |
5 | 0.49 ms |
SELECT b0_.id AS id_0, b0_.nombre AS nombre_1, b0_.orden AS orden_2, b0_.tema_id AS tema_id_3 FROM bloque b0_ LEFT JOIN cuestionario c1_ ON b0_.id = c1_.bloque_id WHERE b0_.tema_id = ? AND c1_.visible = 1 AND c1_.gratis = 1 ORDER BY b0_.nombre ASC
Parameters:
[
9
]
|
6 | 0.35 ms |
SELECT t0.id AS id_1, t0.visible AS visible_2, t0.simulacro AS simulacro_3, t0.gratis AS gratis_4, t0.duracion AS duracion_5, t0.nombre AS nombre_6, t0.bloque_id AS bloque_id_7 FROM cuestionario t0 WHERE t0.bloque_id = ? AND t0.visible = ? AND t0.gratis = ? ORDER BY t0.nombre ASC
Parameters:
[ 26 1 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\Suscripcion | No errors. |
App\Entity\Pago | No errors. |
App\Entity\Tema | No errors. |
App\Entity\Bloque | No errors. |
App\Entity\Configuracion | No errors. |
App\Entity\Cuestionario | No errors. |
App\Entity\CuestionarioUsuario | No errors. |
App\Entity\Factura | No errors. |
App\Entity\Impugnacion | No errors. |
App\Entity\Noticia | No errors. |
App\Entity\Pregunta | No errors. |
App\Entity\RespuestaUsuario | No errors. |
App\Entity\RespuestaUsuarioGratis | No errors. |
App\Entity\Recurso | No errors. |
App\Entity\Contacto | No errors. |
App\Entity\CuestionarioUsuarioGratis | No errors. |