Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

0.98 ms Query time

1 Invalid entities

24 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.42 ms
(42.89%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nif AS nif_3, t0.direccion AS direccion_4, t0.cp_ciudad AS cp_ciudad_5, t0.telefono AS telefono_6, t0.comision_tpv AS comision_tpv_7, t0.whatsapp AS whatsapp_8, t0.hero_imagen_url AS hero_imagen_url_9, t0.frase_gancho AS frase_gancho_10, t0.logo_url AS logo_url_11, t0.instagram AS instagram_12, t0.facebook AS facebook_13, t0.email AS email_14, t0.google_maps_url AS google_maps_url_15, t0.hero_video_url AS hero_video_url_16, t0.descripcion_personal AS descripcion_personal_17, t0.certificado_nombre AS certificado_nombre_18, t0.certificado_password AS certificado_password_19, t0.verifactu_activo AS verifactu_activo_20, t0.modo_pruebas AS modo_pruebas_21, t0.email_notificaciones AS email_notificaciones_22, t0.verifacti_api_key AS verifacti_api_key_23, t0.proximo_numero_f1 AS proximo_numero_f1_24, t0.proximo_numero_f2 AS proximo_numero_f2_25, t0.proximo_numero_rectificativa AS proximo_numero_rectificativa_26, t0.regimen_fiscal AS regimen_fiscal_27, t0.iban AS iban_28, t0.nombre_banco AS nombre_banco_29, t0.tipo_negocio AS tipo_negocio_30, t0.jurisdiccion_id AS jurisdiccion_id_31 FROM negocio t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.nif AS nif_3,
  t0.direccion AS direccion_4,
  t0.cp_ciudad AS cp_ciudad_5,
  t0.telefono AS telefono_6,
  t0.comision_tpv AS comision_tpv_7,
  t0.whatsapp AS whatsapp_8,
  t0.hero_imagen_url AS hero_imagen_url_9,
  t0.frase_gancho AS frase_gancho_10,
  t0.logo_url AS logo_url_11,
  t0.instagram AS instagram_12,
  t0.facebook AS facebook_13,
  t0.email AS email_14,
  t0.google_maps_url AS google_maps_url_15,
  t0.hero_video_url AS hero_video_url_16,
  t0.descripcion_personal AS descripcion_personal_17,
  t0.certificado_nombre AS certificado_nombre_18,
  t0.certificado_password AS certificado_password_19,
  t0.verifactu_activo AS verifactu_activo_20,
  t0.modo_pruebas AS modo_pruebas_21,
  t0.email_notificaciones AS email_notificaciones_22,
  t0.verifacti_api_key AS verifacti_api_key_23,
  t0.proximo_numero_f1 AS proximo_numero_f1_24,
  t0.proximo_numero_f2 AS proximo_numero_f2_25,
  t0.proximo_numero_rectificativa AS proximo_numero_rectificativa_26,
  t0.regimen_fiscal AS regimen_fiscal_27,
  t0.iban AS iban_28,
  t0.nombre_banco AS nombre_banco_29,
  t0.tipo_negocio AS tipo_negocio_30,
  t0.jurisdiccion_id AS jurisdiccion_id_31
FROM
  negocio t0

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.nif AS nif_3, t0.direccion AS direccion_4, t0.cp_ciudad AS cp_ciudad_5, t0.telefono AS telefono_6, t0.comision_tpv AS comision_tpv_7, t0.whatsapp AS whatsapp_8, t0.hero_imagen_url AS hero_imagen_url_9, t0.frase_gancho AS frase_gancho_10, t0.logo_url AS logo_url_11, t0.instagram AS instagram_12, t0.facebook AS facebook_13, t0.email AS email_14, t0.google_maps_url AS google_maps_url_15, t0.hero_video_url AS hero_video_url_16, t0.descripcion_personal AS descripcion_personal_17, t0.certificado_nombre AS certificado_nombre_18, t0.certificado_password AS certificado_password_19, t0.verifactu_activo AS verifactu_activo_20, t0.modo_pruebas AS modo_pruebas_21, t0.email_notificaciones AS email_notificaciones_22, t0.verifacti_api_key AS verifacti_api_key_23, t0.proximo_numero_f1 AS proximo_numero_f1_24, t0.proximo_numero_f2 AS proximo_numero_f2_25, t0.proximo_numero_rectificativa AS proximo_numero_rectificativa_26, t0.regimen_fiscal AS regimen_fiscal_27, t0.iban AS iban_28, t0.nombre_banco AS nombre_banco_29, t0.tipo_negocio AS tipo_negocio_30, t0.jurisdiccion_id AS jurisdiccion_id_31 FROM negocio t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	Twig\Extension\CoreExtension->getAttribute (line 1919)
6	__TwigTemplate_4bc45b0d84d9d528976ef79b258ade2d::doDisplay (line 179)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_801a73d138d386913f70f1a2f70f9445->doDisplay (line 53)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
17	App\Controller\SectorController->peluqueria (line 22)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	require_once (line 5)

0.20 ms
(19.92%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.foto AS foto_6, t0.puntos AS puntos_7, t0.telefono AS telefono_8, t0.color_calendario AS color_calendario_9, t0.biografia AS biografia_10, t0.instagram AS instagram_11, t0.especialidad AS especialidad_12, t0.dni AS dni_13, t14.id AS id_15, t14.telefono AS telefono_16, t14.alergias AS alergias_17, t14.observaciones AS observaciones_18, t14.ultimo_servicio AS ultimo_servicio_19, t14.fecha_cumple AS fecha_cumple_20, t14.puntos_fidelidad AS puntos_fidelidad_21, t14.premios_canjeados AS premios_canjeados_22, t14.document_id AS document_id_23, t14.direccion_fiscal AS direccion_fiscal_24, t14.codigo_postal AS codigo_postal_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN customer_profile t14 ON t14.user_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nombre AS nombre_5,
  t0.foto AS foto_6,
  t0.puntos AS puntos_7,
  t0.telefono AS telefono_8,
  t0.color_calendario AS color_calendario_9,
  t0.biografia AS biografia_10,
  t0.instagram AS instagram_11,
  t0.especialidad AS especialidad_12,
  t0.dni AS dni_13,
  t14.id AS id_15,
  t14.telefono AS telefono_16,
  t14.alergias AS alergias_17,
  t14.observaciones AS observaciones_18,
  t14.ultimo_servicio AS ultimo_servicio_19,
  t14.fecha_cumple AS fecha_cumple_20,
  t14.puntos_fidelidad AS puntos_fidelidad_21,
  t14.premios_canjeados AS premios_canjeados_22,
  t14.document_id AS document_id_23,
  t14.direccion_fiscal AS direccion_fiscal_24,
  t14.codigo_postal AS codigo_postal_25,
  t14.user_id AS user_id_26
FROM
  user t0
  LEFT JOIN customer_profile t14 ON t14.user_id = t0.id

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.foto AS foto_6, t0.puntos AS puntos_7, t0.telefono AS telefono_8, t0.color_calendario AS color_calendario_9, t0.biografia AS biografia_10, t0.instagram AS instagram_11, t0.especialidad AS especialidad_12, t0.dni AS dni_13, t14.id AS id_15, t14.telefono AS telefono_16, t14.alergias AS alergias_17, t14.observaciones AS observaciones_18, t14.ultimo_servicio AS ultimo_servicio_19, t14.fecha_cumple AS fecha_cumple_20, t14.puntos_fidelidad AS puntos_fidelidad_21, t14.premios_canjeados AS premios_canjeados_22, t14.document_id AS document_id_23, t14.direccion_fiscal AS direccion_fiscal_24, t14.codigo_postal AS codigo_postal_25, t14.user_id AS user_id_26 FROM user t0 LEFT JOIN customer_profile t14 ON t14.user_id = t0.id;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\SectorController->peluqueria (line 23)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.13 ms
(13.71%)

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.contenido AS contenido_3, t0.imagen AS imagen_4, t0.fecha_creacion AS fecha_creacion_5, t0.slug AS slug_6, t0.titulo_eu AS titulo_eu_7, t0.contenido_eu AS contenido_eu_8 FROM post t0 ORDER BY t0.id DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titulo AS titulo_2,
  t0.contenido AS contenido_3,
  t0.imagen AS imagen_4,
  t0.fecha_creacion AS fecha_creacion_5,
  t0.slug AS slug_6,
  t0.titulo_eu AS titulo_eu_7,
  t0.contenido_eu AS contenido_eu_8
FROM
  post t0
ORDER BY
  t0.id DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.contenido AS contenido_3, t0.imagen AS imagen_4, t0.fecha_creacion AS fecha_creacion_5, t0.slug AS slug_6, t0.titulo_eu AS titulo_eu_7, t0.contenido_eu AS contenido_eu_8 FROM post t0 ORDER BY t0.id DESC LIMIT 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\SectorController->peluqueria (line 24)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.12 ms
(12.60%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.precio AS precio_4, t0.precio_compra AS precio_compra_5, t0.stock AS stock_6, t0.codigo_barras AS codigo_barras_7, t0.imagen AS imagen_8, t0.activo AS activo_9, t0.stock_minimo AS stock_minimo_10, t0.marcado_para_pedido AS marcado_para_pedido_11, t0.indicaciones AS indicaciones_12, t0.tipo AS tipo_13, t0.iva_porcentaje AS iva_porcentaje_14, t0.cantidad_apedir AS cantidad_apedir_15, t0.nombre_eu AS nombre_eu_16, t0.descripcion_eu AS descripcion_eu_17, t0.indicaciones_eu AS indicaciones_eu_18 FROM producto t0 WHERE t0.tipo = ? AND t0.activo = ? ORDER BY t0.id DESC LIMIT 5

Parameters:

[
  "venta"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.precio AS precio_4,
  t0.precio_compra AS precio_compra_5,
  t0.stock AS stock_6,
  t0.codigo_barras AS codigo_barras_7,
  t0.imagen AS imagen_8,
  t0.activo AS activo_9,
  t0.stock_minimo AS stock_minimo_10,
  t0.marcado_para_pedido AS marcado_para_pedido_11,
  t0.indicaciones AS indicaciones_12,
  t0.tipo AS tipo_13,
  t0.iva_porcentaje AS iva_porcentaje_14,
  t0.cantidad_apedir AS cantidad_apedir_15,
  t0.nombre_eu AS nombre_eu_16,
  t0.descripcion_eu AS descripcion_eu_17,
  t0.indicaciones_eu AS indicaciones_eu_18
FROM
  producto t0
WHERE
  t0.tipo = ?
  AND t0.activo = ?
ORDER BY
  t0.id DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.precio AS precio_4, t0.precio_compra AS precio_compra_5, t0.stock AS stock_6, t0.codigo_barras AS codigo_barras_7, t0.imagen AS imagen_8, t0.activo AS activo_9, t0.stock_minimo AS stock_minimo_10, t0.marcado_para_pedido AS marcado_para_pedido_11, t0.indicaciones AS indicaciones_12, t0.tipo AS tipo_13, t0.iva_porcentaje AS iva_porcentaje_14, t0.cantidad_apedir AS cantidad_apedir_15, t0.nombre_eu AS nombre_eu_16, t0.descripcion_eu AS descripcion_eu_17, t0.indicaciones_eu AS indicaciones_eu_18 FROM producto t0 WHERE t0.tipo = 'venta' AND t0.activo = 1 ORDER BY t0.id DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\SectorController->peluqueria (line 20)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.11 ms
(10.88%)

SELECT t0.id AS id_1, t0.dia_semana AS dia_semana_2, t0.hora_apertura AS hora_apertura_3, t0.inicio_descanso AS inicio_descanso_4, t0.fin_descanso AS fin_descanso_5, t0.hora_cierre AS hora_cierre_6, t0.es_cerrado AS es_cerrado_7 FROM horario t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.dia_semana AS dia_semana_2,
  t0.hora_apertura AS hora_apertura_3,
  t0.inicio_descanso AS inicio_descanso_4,
  t0.fin_descanso AS fin_descanso_5,
  t0.hora_cierre AS hora_cierre_6,
  t0.es_cerrado AS es_cerrado_7
FROM
  horario t0

SELECT t0.id AS id_1, t0.dia_semana AS dia_semana_2, t0.hora_apertura AS hora_apertura_3, t0.inicio_descanso AS inicio_descanso_4, t0.fin_descanso AS fin_descanso_5, t0.hora_cierre AS hora_cierre_6, t0.es_cerrado AS es_cerrado_7 FROM horario t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	Twig\Extension\CoreExtension->getAttribute (line 1919)
6	__TwigTemplate_4bc45b0d84d9d528976ef79b258ade2d::doDisplay (line 425)
7	Twig\Template->yield (line 402)
8	__TwigTemplate_801a73d138d386913f70f1a2f70f9445->doDisplay (line 53)
9	Twig\Template->yield (line 402)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 373)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
17	App\Controller\SectorController->peluqueria (line 22)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 193)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 32)
23	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\User	8
App\Entity\Horario	7
App\Entity\CustomerProfile	4
App\Entity\Producto	2
App\Entity\Post	1
App\Entity\Negocio	1
App\Entity\Jurisdiccion	1

Entities Mapping

Class	Mapping errors
App\Entity\Producto	The mappings App\Entity\Producto#cantidad and App\Entity\MovimientoStock#producto are inconsistent with each other.
App\Entity\MovimientoStock	No errors.
App\Entity\User	No errors.
App\Entity\CustomerProfile	No errors.
App\Entity\Reserva	No errors.
App\Entity\Post	No errors.
App\Entity\Comentario	No errors.
App\Entity\Negocio	No errors.
App\Entity\Jurisdiccion	No errors.
App\Entity\Horario	No errors.

Symfony Profiler

GET https://www.verifakude.es/eu/sector/peluqueria

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping