Query Metrics
122
Database Queries
19
Different statements
229.81 ms
Query time
1
Invalid entities
336
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.97 ms (54.38%) |
84 |
SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = ? AND t0_.activo = ?
Parameters:
[ "home.title_suffix" 1 ] |
||||||||||||||||||||||||||||||
|
45.11 ms (19.63%) |
17 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.filename_mobile AS filename_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.size_mobile AS size_mobile_8, t0.mime_type_mobile AS mime_type_mobile_9, t0.alt AS alt_10, t0.titulo AS titulo_11, t0.descripcion AS descripcion_12, t0.llave AS llave_13, t0.seccion AS seccion_14, t0.orden AS orden_15, t0.visible AS visible_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.galeria_id AS galeria_id_19 FROM imagenes t0 WHERE t0.id = ?
Parameters:
[
14
]
|
||||||||||||||||||||||||||||||
|
16.73 ms (7.28%) |
1 |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.orden AS orden_2, m0_.visible AS visible_3, m0_.created_at AS created_at_4, m0_.imagen_id AS imagen_id_5 FROM marca m0_ WHERE m0_.visible = ? ORDER BY m0_.orden ASC, m0_.nombre ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
15.48 ms (6.74%) |
4 |
SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.orden AS orden_3, t0_.visible AS visible_4, t0_.created_at AS created_at_5 FROM tipos_vehiculo t0_ WHERE t0_.visible = ? ORDER BY t0_.orden ASC, t0_.nombre ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
5.54 ms (2.41%) |
1 |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.slug AS slug_2, m0_.descripcion AS descripcion_3, m0_.precio AS precio_4, m0_.precio_desde AS precio_desde_5, m0_.precio_hasta AS precio_hasta_6, m0_.year AS year_7, m0_.img_thumbnail AS img_thumbnail_8, m0_.img_fotos AS img_fotos_9, m0_.url_modelo AS url_modelo_10, m0_.url_catalogo AS url_catalogo_11, m0_.fuente_precio AS fuente_precio_12, m0_.scrape_date AS scrape_date_13, m0_.orden AS orden_14, m0_.visible AS visible_15, m0_.destacado_home AS destacado_home_16, m0_.es_nuevo AS es_nuevo_17, m0_.vistas AS vistas_18, m0_.calificacion AS calificacion_19, m0_.created_at AS created_at_20, m0_.img AS img_21, m1_.id AS id_22, m1_.nombre AS nombre_23, m1_.orden AS orden_24, m1_.visible AS visible_25, m1_.created_at AS created_at_26, m2_.id AS id_27, m2_.orden AS orden_28, m2_.principal AS principal_29, m2_.created_at AS created_at_30, i3_.id AS id_31, i3_.filename AS filename_32, i3_.filename_mobile AS filename_mobile_33, i3_.path AS path_34, i3_.link AS link_35, i3_.size AS size_36, i3_.mime_type AS mime_type_37, i3_.size_mobile AS size_mobile_38, i3_.mime_type_mobile AS mime_type_mobile_39, i3_.alt AS alt_40, i3_.titulo AS titulo_41, i3_.descripcion AS descripcion_42, i3_.llave AS llave_43, i3_.seccion AS seccion_44, i3_.orden AS orden_45, i3_.visible AS visible_46, i3_.created_at AS created_at_47, i3_.updated_at AS updated_at_48, v4_.id AS id_49, v4_.nombre_version AS nombre_version_50, v4_.precio AS precio_51, v4_.orden AS orden_52, v4_.visible AS visible_53, v4_.destacado_home AS destacado_home_54, v4_.created_at AS created_at_55, v4_.img AS img_56, v4_.especificaciones AS especificaciones_57, v4_.motor AS motor_58, v4_.tipo_motor AS tipo_motor_59, v4_.transmision AS transmision_60, v4_.combustible AS combustible_61, v4_.cilindrada_cc AS cilindrada_cc_62, v4_.potencia_hp AS potencia_hp_63, v4_.potencia_kw AS potencia_kw_64, v4_.torque_nm AS torque_nm_65, v4_.consumo AS consumo_66, v4_.traccion AS traccion_67, v4_.autonomia_km AS autonomia_km_68, v4_.url_pdf AS url_pdf_69, t5_.id AS id_70, t5_.nombre AS nombre_71, t5_.descripcion AS descripcion_72, t5_.orden AS orden_73, t5_.visible AS visible_74, t5_.created_at AS created_at_75, m0_.marca_id AS marca_id_76, m0_.tipo_vehiculo_id AS tipo_vehiculo_id_77, m1_.imagen_id AS imagen_id_78, m2_.modelo_id AS modelo_id_79, m2_.imagen_id AS imagen_id_80, i3_.galeria_id AS galeria_id_81, v4_.tipo_vehiculo_id AS tipo_vehiculo_id_82, v4_.modelo_id AS modelo_id_83 FROM modelos m0_ INNER JOIN marca m1_ ON m0_.marca_id = m1_.id LEFT JOIN modelo_imagenes m2_ ON m0_.id = m2_.modelo_id LEFT JOIN imagenes i3_ ON m2_.imagen_id = i3_.id LEFT JOIN versiones v4_ ON m0_.id = v4_.modelo_id LEFT JOIN tipos_vehiculo t5_ ON m0_.tipo_vehiculo_id = t5_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY m0_.vistas DESC, m0_.id DESC, m2_.principal DESC, m2_.orden ASC
Parameters:
[ 564 589 569 697 684 579 ]
|
||||||||||||||||||||||||||||||
|
3.41 ms (1.49%) |
1 |
SELECT t0.id AS id_1, t0.llave AS llave_2, t0.valor AS valor_3 FROM settings t0 WHERE t0.llave = ? LIMIT 1
Parameters:
[
"banner_patrocinadores_url"
]
|
||||||||||||||||||||||||||||||
|
2.60 ms (1.13%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.color AS color_4 FROM etiquetas t0 WHERE t0.id = ?
Parameters:
[
7
]
|
||||||||||||||||||||||||||||||
|
2.54 ms (1.10%) |
1 |
SELECT c0_.id AS id_0, c0_.titulo AS titulo_1, c0_.descripcion AS descripcion_2, c0_.orden AS orden_3, c0_.activo AS activo_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, i1_.id AS id_7, i1_.filename AS filename_8, i1_.filename_mobile AS filename_mobile_9, i1_.path AS path_10, i1_.link AS link_11, i1_.size AS size_12, i1_.mime_type AS mime_type_13, i1_.size_mobile AS size_mobile_14, i1_.mime_type_mobile AS mime_type_mobile_15, i1_.alt AS alt_16, i1_.titulo AS titulo_17, i1_.descripcion AS descripcion_18, i1_.llave AS llave_19, i1_.seccion AS seccion_20, i1_.orden AS orden_21, i1_.visible AS visible_22, i1_.created_at AS created_at_23, i1_.updated_at AS updated_at_24, c0_.imagen_id AS imagen_id_25, i1_.galeria_id AS galeria_id_26 FROM caracteristicas c0_ LEFT JOIN imagenes i1_ ON c0_.imagen_id = i1_.id WHERE c0_.activo = ? ORDER BY c0_.orden ASC, c0_.id ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
2.39 ms (1.04%) |
1 |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.slug AS slug_2, m0_.descripcion AS descripcion_3, m0_.precio AS precio_4, m0_.precio_desde AS precio_desde_5, m0_.precio_hasta AS precio_hasta_6, m0_.year AS year_7, m0_.img_thumbnail AS img_thumbnail_8, m0_.img_fotos AS img_fotos_9, m0_.url_modelo AS url_modelo_10, m0_.url_catalogo AS url_catalogo_11, m0_.fuente_precio AS fuente_precio_12, m0_.scrape_date AS scrape_date_13, m0_.orden AS orden_14, m0_.visible AS visible_15, m0_.destacado_home AS destacado_home_16, m0_.es_nuevo AS es_nuevo_17, m0_.vistas AS vistas_18, m0_.calificacion AS calificacion_19, m0_.created_at AS created_at_20, m0_.img AS img_21, m1_.id AS id_22, m1_.nombre AS nombre_23, m1_.orden AS orden_24, m1_.visible AS visible_25, m1_.created_at AS created_at_26, m2_.id AS id_27, m2_.orden AS orden_28, m2_.principal AS principal_29, m2_.created_at AS created_at_30, i3_.id AS id_31, i3_.filename AS filename_32, i3_.filename_mobile AS filename_mobile_33, i3_.path AS path_34, i3_.link AS link_35, i3_.size AS size_36, i3_.mime_type AS mime_type_37, i3_.size_mobile AS size_mobile_38, i3_.mime_type_mobile AS mime_type_mobile_39, i3_.alt AS alt_40, i3_.titulo AS titulo_41, i3_.descripcion AS descripcion_42, i3_.llave AS llave_43, i3_.seccion AS seccion_44, i3_.orden AS orden_45, i3_.visible AS visible_46, i3_.created_at AS created_at_47, i3_.updated_at AS updated_at_48, t4_.id AS id_49, t4_.nombre AS nombre_50, t4_.descripcion AS descripcion_51, t4_.orden AS orden_52, t4_.visible AS visible_53, t4_.created_at AS created_at_54, m0_.marca_id AS marca_id_55, m0_.tipo_vehiculo_id AS tipo_vehiculo_id_56, m1_.imagen_id AS imagen_id_57, m2_.modelo_id AS modelo_id_58, m2_.imagen_id AS imagen_id_59, i3_.galeria_id AS galeria_id_60 FROM modelos m0_ INNER JOIN marca m1_ ON m0_.marca_id = m1_.id LEFT JOIN modelo_imagenes m2_ ON m0_.id = m2_.modelo_id LEFT JOIN imagenes i3_ ON m2_.imagen_id = i3_.id LEFT JOIN tipos_vehiculo t4_ ON m0_.tipo_vehiculo_id = t4_.id WHERE m0_.id IN (?) ORDER BY m0_.created_at DESC, m2_.principal DESC, m2_.orden ASC
Parameters:
[
754
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.72%) |
2 |
SELECT i0_.id AS id_0, i0_.filename AS filename_1, i0_.filename_mobile AS filename_mobile_2, i0_.path AS path_3, i0_.link AS link_4, i0_.size AS size_5, i0_.mime_type AS mime_type_6, i0_.size_mobile AS size_mobile_7, i0_.mime_type_mobile AS mime_type_mobile_8, i0_.alt AS alt_9, i0_.titulo AS titulo_10, i0_.descripcion AS descripcion_11, i0_.llave AS llave_12, i0_.seccion AS seccion_13, i0_.orden AS orden_14, i0_.visible AS visible_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.galeria_id AS galeria_id_18 FROM imagenes i0_ WHERE i0_.llave = ? AND i0_.visible = ?
Parameters:
[ "img-favicon" 1 ] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.60%) |
1 |
SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.departamento AS departamento_2, c0_.orden AS orden_3, c0_.visible AS visible_4, c0_.created_at AS created_at_5 FROM ciudades c0_ WHERE c0_.visible = ? ORDER BY c0_.nombre ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.57%) |
1 |
SELECT m0_.id AS id_0 FROM modelos m0_ INNER JOIN marca m1_ ON m0_.marca_id = m1_.id WHERE m0_.visible = 1 AND m1_.visible = 1 AND m0_.destacado_home = 1 ORDER BY m0_.created_at DESC
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.54%) |
1 |
SELECT e0_.id AS id_0, e0_.valor AS valor_1, e0_.descripcion AS descripcion_2, e0_.orden AS orden_3, e0_.visible AS visible_4, e0_.seccion AS seccion_5, e0_.created_at AS created_at_6, e0_.icono_id AS icono_id_7 FROM estadisticas e0_ WHERE e0_.visible = ? AND e0_.seccion = ? ORDER BY e0_.orden ASC
Parameters:
[ 1 "home" ]
|
||||||||||||||||||||||||||||||
|
1.15 ms (0.50%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, fecha_publicacion_4 FROM (SELECT n0_.id AS id_0, n0_.titulo AS titulo_1, n0_.contenido AS contenido_2, n0_.fecha_creacion AS fecha_creacion_3, n0_.fecha_publicacion AS fecha_publicacion_4, n0_.estado AS estado_5, n0_.meta_titulo AS meta_titulo_6, n0_.meta_descripcion AS meta_descripcion_7, n0_.meta_etiquetas AS meta_etiquetas_8, n0_.activo AS activo_9, n0_.slug AS slug_10, n0_.etiquetas AS etiquetas_11 FROM noticias n0_ WHERE n0_.activo = ? AND n0_.fecha_publicacion <= ? AND n0_.estado = ?) dctrn_result_inner ORDER BY fecha_publicacion_4 DESC, id_0 DESC) dctrn_result LIMIT 3
Parameters:
[ 1 "2026-03-07 18:05:21" 1 ]
|
||||||||||||||||||||||||||||||
|
1.05 ms (0.46%) |
1 |
SELECT m0_.id AS id_0 FROM modelos m0_ INNER JOIN marca m1_ ON m0_.marca_id = m1_.id WHERE m0_.visible = 1 AND m1_.visible = 1 ORDER BY m0_.vistas DESC, m0_.id DESC LIMIT 6
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.87 ms (0.38%) |
1 |
SELECT r0_.id AS id_0, r0_.nombre_cliente AS nombre_cliente_1, r0_.ciudad AS ciudad_2, r0_.testimonio AS testimonio_3, r0_.calificacion AS calificacion_4, r0_.vehiculo_comprado AS vehiculo_comprado_5, r0_.ano_vehiculo AS ano_vehiculo_6, r0_.fecha_compra AS fecha_compra_7, r0_.orden AS orden_8, r0_.visible AS visible_9, r0_.destacada AS destacada_10, r0_.created_at AS created_at_11, r0_.imagen_id AS imagen_id_12 FROM resenas r0_ WHERE r0_.visible = 1 AND r0_.destacada = 1 ORDER BY r0_.orden ASC, r0_.created_at DESC LIMIT 3
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.86 ms (0.37%) |
1 |
SELECT t0.id AS id_1, t0.llave AS llave_2, t0.nombre AS nombre_3, t0.visible AS visible_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM galeria t0 WHERE t0.llave = ? AND t0.visible = ? LIMIT 1
Parameters:
[ "home-slider" 1 ] |
||||||||||||||||||||||||||||||
|
0.84 ms (0.36%) |
1 |
SELECT n0_.id AS id_0, n0_.titulo AS titulo_1, n0_.contenido AS contenido_2, n0_.fecha_creacion AS fecha_creacion_3, n0_.fecha_publicacion AS fecha_publicacion_4, n0_.estado AS estado_5, n0_.meta_titulo AS meta_titulo_6, n0_.meta_descripcion AS meta_descripcion_7, n0_.meta_etiquetas AS meta_etiquetas_8, n0_.activo AS activo_9, n0_.slug AS slug_10, n0_.etiquetas AS etiquetas_11, n0_.imagen_id AS imagen_id_12, n0_.etiqueta_id AS etiqueta_id_13 FROM noticias n0_ WHERE n0_.activo = ? AND n0_.fecha_publicacion <= ? AND n0_.estado = ? AND n0_.id IN (?, ?, ?) ORDER BY n0_.fecha_publicacion DESC, n0_.id DESC
Parameters:
[ 1 "2026-03-07 18:05:21" 1 11 7 3 ]
|
||||||||||||||||||||||||||||||
|
0.70 ms (0.31%) |
1 |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.filename_mobile AS filename_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.size_mobile AS size_mobile_8, t0.mime_type_mobile AS mime_type_mobile_9, t0.alt AS alt_10, t0.titulo AS titulo_11, t0.descripcion AS descripcion_12, t0.llave AS llave_13, t0.seccion AS seccion_14, t0.orden AS orden_15, t0.visible AS visible_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.galeria_id AS galeria_id_19 FROM imagenes t0 WHERE t0.galeria_id = ? ORDER BY t0.orden ASC
Parameters:
[
1
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Imagen | 91 |
| App\Entity\Texto | 72 |
| App\Entity\ModeloImagen | 63 |
| App\Entity\Ciudad | 50 |
| App\Entity\Marca | 13 |
| App\Entity\Version | 12 |
| App\Entity\TipoVehiculo | 9 |
| App\Entity\Modelo | 7 |
| App\Entity\Caracteristica | 6 |
| App\Entity\Estadistica | 4 |
| App\Entity\Resena | 3 |
| App\Entity\Noticia | 3 |
| App\Entity\Etiqueta | 1 |
| App\Entity\Galeria | 1 |
| App\Entity\Setting | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Caracteristica | No errors. |
| App\Entity\Imagen | No errors. |
| App\Entity\Galeria | No errors. |
| App\Entity\Ciudad | No errors. |
| App\Entity\TipoVehiculo | No errors. |
| App\Entity\Marca | No errors. |
| App\Entity\Modelo | No errors. |
| App\Entity\ModeloImagen | No errors. |
| App\Entity\Version | No errors. |
| App\Entity\VersionImagen | No errors. |
| App\Entity\Estadistica | No errors. |
| App\Entity\Resena | No errors. |
| App\Entity\Noticia | No errors. |
| App\Entity\Etiqueta |
|
| App\Entity\Texto | No errors. |
| App\Entity\Setting | No errors. |