Query Metrics
3
Database Queries
3
Different statements
64.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 31.67 ms |
SELECT c0_.id AS id_0, c0_.imagen AS imagen_1, c1_.nombre AS nombre_2, c1_.resumen AS resumen_3, c0_.enlace AS enlace_4, c0_.slug AS slug_5, c0_.padre_id AS sclr_6, c0_.ordenmenu AS ordenmenu_7 FROM categoria_propiedades c0_ LEFT JOIN categoria_translation c1_ ON c0_.id = c1_.categoria_propiedades_id LEFT JOIN locale l2_ ON c1_.locale_id = l2_.id WHERE c0_.visible = 1 AND l2_.locale = ? AND c0_.padre_id IS NULL ORDER BY c0_.orden ASC LIMIT 8
Parameters:
[
"es"
]
|
| 2 | 30.65 ms |
SELECT t0_.llave AS llave_0, t1_.valor AS valor_1, t0_.url AS url_2 FROM texto t0_ LEFT JOIN texto_translation t1_ ON t0_.id = t1_.objeto_id LEFT JOIN locale l2_ ON t1_.locale_id = l2_.id WHERE l2_.locale = ?
Parameters:
[
"es"
]
|
| 3 | 1.80 ms |
SELECT c0_.id AS id_0, c0_.imagen AS imagen_1, c1_.nombre AS nombre_2, c1_.resumen AS resumen_3, c0_.enlace AS enlace_4, c0_.slug AS slug_5, c0_.padre_id AS sclr_6, c0_.ordenmenu AS ordenmenu_7 FROM categoria_propiedades c0_ LEFT JOIN categoria_translation c1_ ON c0_.id = c1_.categoria_propiedades_id LEFT JOIN locale l2_ ON c1_.locale_id = l2_.id WHERE c0_.visible = 1 AND l2_.locale = ? ORDER BY c0_.orden ASC
Parameters:
[
"es"
]
|
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\CategoriaPropiedades | No errors. |
| App\Entity\CategoriaTranslation | No errors. |
| App\Entity\Locale | No errors. |
| App\Entity\Texto | No errors. |
| App\Entity\TextoTranslation | No errors. |