Query Metrics
3
Database Queries
3
Different statements
1.83 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.04 ms |
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_.codigo_cines AS codigo_cines_22, p1_.web AS web_23, p1_.facebook AS facebook_24, p1_.twitter AS twitter_25, p1_.instagram AS instagram_26, p1_.youtube AS youtube_27, p1_.dvd_link AS dvd_link_28, p1_.vod_link AS vod_link_29, p1_.destacada_web AS destacada_web_30, p1_.principal_prensa AS principal_prensa_31, p1_.destacada_prensa AS destacada_prensa_32, p1_.banner AS banner_33, p1_.listado AS listado_34, p1_.catalogo AS catalogo_35, p1_.catalogo_prensa AS catalogo_prensa_36, p1_.catalogo_prensa_orden AS catalogo_prensa_orden_37, p1_.activa AS activa_38, p1_.activa_prensa AS activa_prensa_39, p1_.destacado_orden AS destacado_orden_40, p1_.destacado_orden_prensa AS destacado_orden_prensa_41, p1_.catalogo_orden AS catalogo_orden_42, p1_.rodaje AS rodaje_43, n2_.id AS id_44, n2_.titular AS titular_45, n2_.slug AS slug_46, n2_.entradilla AS entradilla_47, n2_.contenido AS contenido_48, n2_.thumbnail AS thumbnail_49, n2_.imagen AS imagen_50, n2_.imagen2 AS imagen2_51, n2_.imagen3 AS imagen3_52, n2_.imagen4 AS imagen4_53, n2_.web AS web_54, n2_.home_web AS home_web_55, n2_.prensa AS prensa_56, n2_.fecha AS fecha_57, n2_.modificado AS modificado_58, b0_.pelicula_id AS pelicula_id_59, b0_.noticia_id AS noticia_id_60, b0_.tv_id AS tv_id_61, p1_.meta_id AS meta_id_62, p1_.estadoRodaje_id AS estadoRodaje_id_63, n2_.meta_id AS meta_id_64 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:
[] |
| 2 | 0.56 ms |
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_.codigo_cines AS codigo_cines_10, p0_.web AS web_11, p0_.facebook AS facebook_12, p0_.twitter AS twitter_13, p0_.instagram AS instagram_14, p0_.youtube AS youtube_15, p0_.dvd_link AS dvd_link_16, p0_.vod_link AS vod_link_17, p0_.destacada_web AS destacada_web_18, p0_.principal_prensa AS principal_prensa_19, p0_.destacada_prensa AS destacada_prensa_20, p0_.banner AS banner_21, p0_.listado AS listado_22, p0_.catalogo AS catalogo_23, p0_.catalogo_prensa AS catalogo_prensa_24, p0_.catalogo_prensa_orden AS catalogo_prensa_orden_25, p0_.activa AS activa_26, p0_.activa_prensa AS activa_prensa_27, p0_.destacado_orden AS destacado_orden_28, p0_.destacado_orden_prensa AS destacado_orden_prensa_29, p0_.catalogo_orden AS catalogo_orden_30, p0_.rodaje AS rodaje_31, d1_.id AS id_32, d1_.nombre AS nombre_33, e2_.id AS id_34, e2_.nombre_corto AS nombre_corto_35, e2_.nombre AS nombre_36, c3_.id AS id_37, c3_.nombre_corto AS nombre_corto_38, c3_.nombre AS nombre_39, c3_.web AS web_40, c3_.prensa AS prensa_41, p4_.id AS id_42, p4_.cartel AS cartel_43, p4_.descripcion AS descripcion_44, p4_.principal AS principal_45, p4_.press AS press_46, p5_.id AS id_47, p5_.trailer AS trailer_48, p5_.titulo AS titulo_49, p5_.duracion AS duracion_50, p5_.idioma AS idioma_51, p5_.thumbnail AS thumbnail_52, p5_.video AS video_53, p0_.meta_id AS meta_id_54, p0_.estadoRodaje_id AS estadoRodaje_id_55, c3_.seccion_id AS seccion_id_56, p4_.pelicula_id AS pelicula_id_57, p5_.pelicula_id AS pelicula_id_58 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:
[] |
| 3 | 0.23 ms |
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.