Query Metrics
3
Database Queries
3
Different statements
3.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.40 ms (60.89%) |
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, d1_.id AS id_31, d1_.nombre AS nombre_32, e2_.id AS id_33, e2_.nombre_corto AS nombre_corto_34, e2_.nombre AS nombre_35, c3_.id AS id_36, c3_.nombre_corto AS nombre_corto_37, c3_.nombre AS nombre_38, c3_.web AS web_39, c3_.prensa AS prensa_40, p4_.id AS id_41, p4_.cartel AS cartel_42, p4_.descripcion AS descripcion_43, p4_.principal AS principal_44, p4_.press AS press_45, p5_.id AS id_46, p5_.trailer AS trailer_47, p5_.titulo AS titulo_48, p5_.duracion AS duracion_49, p5_.idioma AS idioma_50, p5_.thumbnail AS thumbnail_51, p5_.video AS video_52, p0_.meta_id AS meta_id_53, p0_.estadoRodaje_id AS estadoRodaje_id_54, c3_.seccion_id AS seccion_id_55, p4_.pelicula_id AS pelicula_id_56, p5_.pelicula_id AS pelicula_id_57 FROM peliculas p0_ LEFT JOIN peliculas_directores p6_ ON p0_.id = p6_.pelicula_id LEFT JOIN directores d1_ ON d1_.id = p6_.director_id LEFT JOIN estados_rodaje e2_ ON p0_.estadoRodaje_id = e2_.id LEFT JOIN peliculas_categorias p7_ ON p0_.id = p7_.pelicula_id LEFT JOIN categorias c3_ ON c3_.id = p7_.categoria_id LEFT JOIN peliculas_carteles p4_ ON p0_.id = p4_.pelicula_id LEFT JOIN peliculas_videos p5_ ON p0_.id = p5_.pelicula_id WHERE p0_.activa = 1 AND p0_.destacada_web = 1 ORDER BY p0_.destacado_orden ASC, d1_.nombre ASC, p4_.principal DESC, p4_.id ASC
Parameters:
[] |
|
0.78 ms (19.88%) |
1 |
SELECT b0_.id AS id_0, b0_.titulo AS titulo_1, b0_.subtitulo AS subtitulo_2, b0_.imagen AS imagen_3, b0_.imagenMovil AS imagenMovil_4, b0_.orden AS orden_5, b0_.link AS link_6, b0_.header AS header_7, b0_.activo AS activo_8, b0_.activoTV AS activoTV_9, b0_.activoPrensa AS activoPrensa_10, b0_.modificado AS modificado_11, p1_.id AS id_12, p1_.slug AS slug_13, p1_.titulo AS titulo_14, p1_.claim AS claim_15, p1_.fecha_estreno AS fecha_estreno_16, p1_.sinopsis AS sinopsis_17, p1_.reparto AS reparto_18, p1_.equipo_tecnico AS equipo_tecnico_19, p1_.datos_tecnicos AS datos_tecnicos_20, p1_.cines AS cines_21, p1_.web AS web_22, p1_.facebook AS facebook_23, p1_.twitter AS twitter_24, p1_.instagram AS instagram_25, p1_.youtube AS youtube_26, p1_.dvd_link AS dvd_link_27, p1_.vod_link AS vod_link_28, p1_.destacada_web AS destacada_web_29, p1_.principal_prensa AS principal_prensa_30, p1_.destacada_prensa AS destacada_prensa_31, p1_.banner AS banner_32, p1_.listado AS listado_33, p1_.catalogo AS catalogo_34, p1_.catalogo_prensa AS catalogo_prensa_35, p1_.catalogo_prensa_orden AS catalogo_prensa_orden_36, p1_.activa AS activa_37, p1_.activa_prensa AS activa_prensa_38, p1_.destacado_orden AS destacado_orden_39, p1_.destacado_orden_prensa AS destacado_orden_prensa_40, p1_.catalogo_orden AS catalogo_orden_41, p1_.rodaje AS rodaje_42, n2_.id AS id_43, n2_.titular AS titular_44, n2_.slug AS slug_45, n2_.entradilla AS entradilla_46, n2_.contenido AS contenido_47, n2_.thumbnail AS thumbnail_48, n2_.imagen AS imagen_49, n2_.imagen2 AS imagen2_50, n2_.imagen3 AS imagen3_51, n2_.imagen4 AS imagen4_52, n2_.web AS web_53, n2_.home_web AS home_web_54, n2_.prensa AS prensa_55, n2_.fecha AS fecha_56, n2_.modificado AS modificado_57, b0_.pelicula_id AS pelicula_id_58, b0_.noticia_id AS noticia_id_59, b0_.tv_id AS tv_id_60, p1_.meta_id AS meta_id_61, p1_.estadoRodaje_id AS estadoRodaje_id_62, n2_.meta_id AS meta_id_63 FROM banners b0_ LEFT JOIN peliculas p1_ ON b0_.pelicula_id = p1_.id LEFT JOIN noticias n2_ ON b0_.noticia_id = n2_.id LEFT JOIN tv t3_ ON b0_.tv_id = t3_.id WHERE b0_.activo = 1 ORDER BY b0_.orden ASC
Parameters:
[] |
|
0.76 ms (19.22%) |
1 |
SELECT n0_.id AS id_0, n0_.titular AS titular_1, n0_.slug AS slug_2, n0_.entradilla AS entradilla_3, n0_.contenido AS contenido_4, n0_.thumbnail AS thumbnail_5, n0_.imagen AS imagen_6, n0_.imagen2 AS imagen2_7, n0_.imagen3 AS imagen3_8, n0_.imagen4 AS imagen4_9, n0_.web AS web_10, n0_.home_web AS home_web_11, n0_.prensa AS prensa_12, n0_.fecha AS fecha_13, n0_.modificado AS modificado_14, n0_.meta_id AS meta_id_15 FROM noticias n0_ WHERE n0_.web = 1 ORDER BY n0_.home_web DESC, n0_.fecha DESC LIMIT 4
Parameters:
[] |
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.