GET https://estrenauto.iridian.co/vehiculos?estado=usado&tipo%5B0%5D=12

Query Metrics

94 Database Queries
8 Different statements
57.79 ms Query time
0 Invalid entities
90 Managed entities

Grouped Statements

Show all queries

Time Count Info
32.11 ms
(55.56%)
72
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:
[
  "vehicles.page_title"
  1
]
11.22 ms
(19.41%)
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
]
8.34 ms
(14.43%)
13
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
]
1.53 ms
(2.64%)
1
SELECT DISTINCT v0_.combustible AS combustible_0 FROM versiones v0_ WHERE v0_.visible = ? AND v0_.combustible IS NOT NULL AND v0_.combustible <> ? ORDER BY v0_.combustible ASC
Parameters:
[
  1
  ""
]
1.47 ms
(2.54%)
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
]
1.25 ms
(2.16%)
1
SELECT COUNT(m0_.id) AS sclr_0 FROM modelos m0_ WHERE m0_.id IN (SELECT DISTINCT m1_.id FROM modelos m1_ LEFT JOIN marca m2_ ON m1_.marca_id = m2_.id LEFT JOIN tipos_vehiculo t3_ ON m1_.tipo_vehiculo_id = t3_.id LEFT JOIN versiones v4_ ON m1_.id = v4_.modelo_id WHERE m1_.visible = 1 AND m1_.es_nuevo = ? AND t3_.id IN (?) ORDER BY m1_.nombre ASC)
Parameters:
[
  0
  "12"
]
1.17 ms
(2.02%)
1
SELECT DISTINCT m0_.id AS id_0 FROM modelos m0_ LEFT JOIN marca m1_ ON m0_.marca_id = m1_.id LEFT JOIN tipos_vehiculo t2_ ON m0_.tipo_vehiculo_id = t2_.id LEFT JOIN versiones v3_ ON m0_.id = v3_.modelo_id WHERE m0_.visible = 1 AND m0_.es_nuevo = ? AND t2_.id IN (?) ORDER BY m0_.nombre ASC LIMIT 12
Parameters:
[
  0
  "12"
]
0.72 ms
(1.24%)
1
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
]

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\Texto 54
App\Entity\Imagen 14
App\Entity\Marca 13
App\Entity\TipoVehiculo 9

Entities Mapping

Class Mapping errors
App\Entity\Marca No errors.
App\Entity\Imagen No errors.
App\Entity\Modelo No errors.
App\Entity\TipoVehiculo No errors.
App\Entity\Version No errors.
App\Entity\Texto No errors.
App\Entity\Galeria No errors.