GET https://filmax.iteracion.net/produccion/filter/13

Query Metrics

2 Database Queries
2 Different statements
1.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.90 ms
(80.13%)
1
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.titulo AS titulo_2, p0_.claim AS claim_3, p0_.fecha_estreno AS fecha_estreno_4, p0_.sinopsis AS sinopsis_5, p0_.reparto AS reparto_6, p0_.equipo_tecnico AS equipo_tecnico_7, p0_.datos_tecnicos AS datos_tecnicos_8, p0_.cines AS cines_9, p0_.web AS web_10, p0_.facebook AS facebook_11, p0_.twitter AS twitter_12, p0_.instagram AS instagram_13, p0_.youtube AS youtube_14, p0_.dvd_link AS dvd_link_15, p0_.vod_link AS vod_link_16, p0_.destacada_web AS destacada_web_17, p0_.principal_prensa AS principal_prensa_18, p0_.destacada_prensa AS destacada_prensa_19, p0_.banner AS banner_20, p0_.listado AS listado_21, p0_.catalogo AS catalogo_22, p0_.catalogo_prensa AS catalogo_prensa_23, p0_.catalogo_prensa_orden AS catalogo_prensa_orden_24, p0_.activa AS activa_25, p0_.activa_prensa AS activa_prensa_26, p0_.destacado_orden AS destacado_orden_27, p0_.destacado_orden_prensa AS destacado_orden_prensa_28, p0_.catalogo_orden AS catalogo_orden_29, p0_.rodaje AS rodaje_30, c1_.id AS id_31, c1_.nombre_corto AS nombre_corto_32, c1_.nombre AS nombre_33, c1_.web AS web_34, c1_.prensa AS prensa_35, p0_.meta_id AS meta_id_36, p0_.estadoRodaje_id AS estadoRodaje_id_37, c1_.seccion_id AS seccion_id_38 FROM peliculas p0_ INNER JOIN peliculas_categorias p2_ ON p0_.id = p2_.pelicula_id INNER JOIN categorias c1_ ON c1_.id = p2_.categoria_id INNER JOIN pelicula_seccion p4_ ON p0_.id = p4_.pelicula_id INNER JOIN seccion s3_ ON s3_.id = p4_.seccion_id WHERE p0_.activa = 1 AND s3_.slug = ? AND p0_.listado = 1 AND c1_.id = ? ORDER BY p0_.fecha_estreno DESC, p0_.titulo ASC
Parameters:
[
  "produccion"
  "13"
]
0.22 ms
(19.87%)
1
SELECT c0_.id AS id_0, c0_.nombre_corto AS nombre_corto_1, c0_.nombre AS nombre_2, c0_.web AS web_3, c0_.prensa AS prensa_4, c0_.seccion_id AS seccion_id_5 FROM categorias c0_ INNER JOIN seccion s1_ ON c0_.seccion_id = s1_.id WHERE c0_.web = 1 AND s1_.slug = ?
Parameters:
[
  "produccion"
]

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