Query Metrics
3
Database Queries
3
Different statements
91.46 ms
Query time
1
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
56.48 ms (61.75%) |
1 |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c1_.nombre AS nombre_2, DATE_FORMAT(c0_.fecha, '%Y-%m-%dT%H:%i:%s') AS sclr_3, DATE_FORMAT(c0_.fin, '%Y-%m-%dT%H:%i:%s') AS sclr_4, c0_.plazas AS plazas_5, c0_.lista_espera AS lista_espera_6 FROM Competicion c0_ INNER JOIN Club c2_ ON (c2_.id = c0_.Organizador_id) INNER JOIN Club c1_ ON (c1_.id = c0_.Club_id) INNER JOIN Modo m3_ ON (m3_.id = c0_.Modo_id) WHERE (c0_.estado = 'abierta' AND m3_.codigo = 'ONL' AND c0_.visible = 1 AND c0_.fin >= ? AND c2_.id LIKE '%00') AND (c0_.deleted_at IS NULL) ORDER BY c0_.fin ASC LIMIT 12
Parameters:
[
"26-02-04"
]
|
|
34.35 ms (37.56%) |
1 |
SELECT MAX(c0_.id) AS sclr_0 FROM Competicion c0_ WHERE (c0_.deleted_at IS NULL)
Parameters:
[] |
|
0.63 ms (0.69%) |
1 |
SELECT CAST(MAX(id) - 496781 AS SIGNED) AS resultado FROM Inscrito
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| encrypt | doctrine.dbal.encrypt_connection |
| nodoql | doctrine.dbal.nodoql_connection |
| copy_to_check | doctrine.dbal.copy_to_check_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| encrypt | doctrine.orm.encrypt_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Backend\Competicion |
|
| App\Entity\Backend\Inscrito | No errors. |
| App\Entity\Backend\Club | No errors. |
| App\Entity\Backend\Modo | No errors. |
encrypt entity manager
No loaded entities.