Query Metrics

3 Database Queries
3 Different statements
13.78 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.86 ms
(42.51%)
1
SELECT r0_.id AS id_0, r1_.nombre AS nombre_1, r0_.imagen AS imagen_2 FROM region r0_ LEFT JOIN region_translation r1_ ON r0_.id = r1_.objeto_id LEFT JOIN locale l2_ ON r1_.locale_id = l2_.id WHERE l2_.locale = ? AND r0_.visible = 1 ORDER BY r0_.orden ASC
Parameters:
[
  "en"
]
4.34 ms
(31.47%)
1
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:
[
  "en"
]
3.58 ms
(26.01%)
1
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:
[
  "en"
]

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