Symfony Profiler

Query Metrics

128 Database Queries

7 Different statements

590.19 ms Query time

0 Invalid entities

189 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

478.96 ms
(81.15%)

120

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:

[
  "cotizador.page_title"
  1
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 'cotizador.page_title' AND t0_.activo = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\TextoRepository->findByLlave (line 48)
7	App\Service\TextoService->getTexto (line 27)
8	App\Service\QI->getTexto (line 82)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_55ea18ce8d4a3075d7a5be104259b676::block_title (line 80)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_63cc729f47b309b6e0c3099850820b77->doDisplay (line 62)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_55ea18ce8d4a3075d7a5be104259b676->doDisplay (line 56)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\CotizadorController->index (line 123)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

79.12 ms
(13.41%)

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
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 1 ORDER BY c0_.nombre ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CiudadRepository->findVisibleOrdered (line 47)
7	App\Controller\CotizadorController->index (line 35)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

13.20 ms
(2.24%)

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
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 1 ORDER BY t0_.orden ASC, t0_.nombre ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\TipoVehiculoRepository->findVisibleOrdered (line 48)
7	App\Twig\TipoVehiculoExtension->getTiposVehiculo (line 25)
8	__TwigTemplate_fc6d1cfcf270acd0d5bc42ff69e783e8->doDisplay (line 116)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_63cc729f47b309b6e0c3099850820b77->doDisplay (line 102)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_55ea18ce8d4a3075d7a5be104259b676->doDisplay (line 56)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\CotizadorController->index (line 123)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

7.72 ms
(1.31%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.slug AS slug_3, t0.descripcion AS descripcion_4, t0.precio AS precio_5, t0.precio_desde AS precio_desde_6, t0.precio_hasta AS precio_hasta_7, t0.year AS year_8, t0.img_thumbnail AS img_thumbnail_9, t0.img_fotos AS img_fotos_10, t0.url_modelo AS url_modelo_11, t0.url_catalogo AS url_catalogo_12, t0.fuente_precio AS fuente_precio_13, t0.scrape_date AS scrape_date_14, t0.orden AS orden_15, t0.visible AS visible_16, t0.destacado_home AS destacado_home_17, t0.es_nuevo AS es_nuevo_18, t0.vistas AS vistas_19, t0.calificacion AS calificacion_20, t0.created_at AS created_at_21, t0.img AS img_22, t0.marca_id AS marca_id_23, t0.tipo_vehiculo_id AS tipo_vehiculo_id_24 FROM modelos t0 WHERE t0.id = ?

Parameters:

[
  "760"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.slug AS slug_3,
  t0.descripcion AS descripcion_4,
  t0.precio AS precio_5,
  t0.precio_desde AS precio_desde_6,
  t0.precio_hasta AS precio_hasta_7,
  t0.year AS year_8,
  t0.img_thumbnail AS img_thumbnail_9,
  t0.img_fotos AS img_fotos_10,
  t0.url_modelo AS url_modelo_11,
  t0.url_catalogo AS url_catalogo_12,
  t0.fuente_precio AS fuente_precio_13,
  t0.scrape_date AS scrape_date_14,
  t0.orden AS orden_15,
  t0.visible AS visible_16,
  t0.destacado_home AS destacado_home_17,
  t0.es_nuevo AS es_nuevo_18,
  t0.vistas AS vistas_19,
  t0.calificacion AS calificacion_20,
  t0.created_at AS created_at_21,
  t0.img AS img_22,
  t0.marca_id AS marca_id_23,
  t0.tipo_vehiculo_id AS tipo_vehiculo_id_24
FROM
  modelos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.slug AS slug_3, t0.descripcion AS descripcion_4, t0.precio AS precio_5, t0.precio_desde AS precio_desde_6, t0.precio_hasta AS precio_hasta_7, t0.year AS year_8, t0.img_thumbnail AS img_thumbnail_9, t0.img_fotos AS img_fotos_10, t0.url_modelo AS url_modelo_11, t0.url_catalogo AS url_catalogo_12, t0.fuente_precio AS fuente_precio_13, t0.scrape_date AS scrape_date_14, t0.orden AS orden_15, t0.visible AS visible_16, t0.destacado_home AS destacado_home_17, t0.es_nuevo AS es_nuevo_18, t0.vistas AS vistas_19, t0.calificacion AS calificacion_20, t0.created_at AS created_at_21, t0.img AS img_22, t0.marca_id AS marca_id_23, t0.tipo_vehiculo_id AS tipo_vehiculo_id_24 FROM modelos t0 WHERE t0.id = '760';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\CotizadorController->index (line 103)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

5.18 ms
(0.88%)

SELECT v0_.created_at AS created_at_0 FROM versiones v0_ WHERE v0_.visible = ? ORDER BY v0_.created_at DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.created_at AS created_at_0
FROM
  versiones v0_
WHERE
  v0_.visible = ?
ORDER BY
  v0_.created_at DESC

SELECT v0_.created_at AS created_at_0 FROM versiones v0_ WHERE v0_.visible = 1 ORDER BY v0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\CotizadorController->index (line 45)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

5.10 ms
(0.86%)

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_ INNER JOIN modelos m1_ ON m0_.id = m1_.marca_id WHERE m0_.visible = ? AND m1_.visible = ? GROUP BY m0_.id ORDER BY m0_.orden ASC, m0_.nombre ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

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_
  INNER JOIN modelos m1_ ON m0_.id = m1_.marca_id
WHERE
  m0_.visible = ?
  AND m1_.visible = ?
GROUP BY
  m0_.id
ORDER BY
  m0_.orden ASC,
  m0_.nombre ASC

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_ INNER JOIN modelos m1_ ON m0_.id = m1_.marca_id WHERE m0_.visible = 1 AND m1_.visible = 1 GROUP BY m0_.id ORDER BY m0_.orden ASC, m0_.nombre ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\MarcaRepository->findVisibleWithModels (line 81)
7	App\Controller\CotizadorController->index (line 32)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.89 ms
(0.15%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 'img-favicon' AND i0_.visible = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\ImagenRepository->findByLlave (line 53)
7	App\Service\ImagenService->getImagenByLlave (line 22)
8	App\Service\QI->getImagen (line 64)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_63cc729f47b309b6e0c3099850820b77::doDisplay (line 67)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_55ea18ce8d4a3075d7a5be104259b676->doDisplay (line 56)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\CotizadorController->index (line 123)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

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	104
App\Entity\Ciudad	50
App\Entity\Imagen	13
App\Entity\Marca	12
App\Entity\TipoVehiculo	9
App\Entity\Modelo	1

Entities Mapping

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

Symfony Profiler

GET https://estrenauto.iridian.co/cotizador?modelo=760

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping