Query Metrics
4
Database Queries
4
Different statements
1.85 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.49 ms |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.alt AS alt_3, t0.latitud AS latitud_4, t0.longitud AS longitud_5, t0.telefono AS telefono_6, t0.direccion AS direccion_7, t0.codigo_postal AS codigo_postal_8, t0.peso AS peso_9, t0.activo AS activo_10, t0.url_google AS url_google_11, t0.provincia AS provincia_12, t0.localidad AS localidad_13, t0.oficinaERP AS oficinaERP_14, t0.imagen_id AS imagen_id_15, t0.imagen_mapa_id AS imagen_mapa_id_16 FROM oficina t0 WHERE t0.activo = ?
Parameters:
[
1
]
|
| 2 | 0.45 ms |
SELECT t0.id AS id_1, t0.estado AS estado_2, t0.fecha_alta AS fecha_alta_3, t0.fecha_modificacion AS fecha_modificacion_4, t0.fecha_publicacion AS fecha_publicacion_5, t0.locales AS locales_6, t0.error AS error_7, t0.clave AS clave_8, t0.position AS position_9, t0.imagen_id AS imagen_id_10, t0.galeria_id AS galeria_id_11, t0.ruta_id AS ruta_id_12, t0.tipo FROM contenido t0 WHERE t0.estado = ? AND t0.tipo IN ('servicio') ORDER BY t0.position ASC
Parameters:
[
1
]
|
| 3 | 0.39 ms |
SELECT t0.id AS id_1, t0.estado AS estado_2, t0.fecha_alta AS fecha_alta_3, t0.fecha_modificacion AS fecha_modificacion_4, t0.fecha_publicacion AS fecha_publicacion_5, t0.locales AS locales_6, t0.error AS error_7, t0.clave AS clave_8, t0.position AS position_9, t0.imagen_id AS imagen_id_10, t0.galeria_id AS galeria_id_11, t0.ruta_id AS ruta_id_12, t0.tipo FROM contenido t0 WHERE t0.estado = ? AND t0.tipo IN ('home') LIMIT 1
Parameters:
[
1
]
|
| 4 | 0.52 ms |
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.texto AS texto_3, t0.intro AS intro_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.meta_keywords AS meta_keywords_7, t0.meta_robots AS meta_robots_8, t0.canonical AS canonical_9, t0.config AS config_10, t0.slug AS slug_11, t0.locale AS locale_12, t0.imagen_cabecera_id AS imagen_cabecera_id_13, t0.translatable_id AS translatable_id_14, t0.tipo FROM contenido_translation t0 WHERE t0.translatable_id = ? AND t0.tipo IN ('contenido', 'pagina', 'home', 'servicio')
Parameters:
[
17
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Oficina |
|
| App\Entity\Provincia | No errors. |
| App\Entity\Localidad |
|
| App\Entity\OficinaErp | No errors. |
| Sonata\MediaBundle\Entity\BaseMedia | No errors. |
| App\Entity\Imagen | No errors. |
| App\Entity\Cotizaciones | No errors. |
| App\Entity\Reserva | No errors. |
| App\Entity\FranjaDias | No errors. |
| App\Entity\Servicio | No errors. |
| App\Entity\Stock | No errors. |
| App\Entity\Existencia | No errors. |
| App\Entity\DayOff |
|
| App\Entity\Alerta | No errors. |
| App\Entity\OficinaTranslation | No errors. |
| App\Entity\Contenido | No errors. |
| App\Entity\ContenidoServicio | No errors. |
| Sonata\MediaBundle\Entity\BaseGallery | No errors. |
| App\Entity\Galeria | No errors. |
| App\Entity\Ruta | No errors. |
| App\Entity\ContenidoTranslation | No errors. |
| App\Entity\Home | No errors. |
| App\Entity\PaginaTranslation | No errors. |
| App\Entity\HomeTranslation | No errors. |
| App\Entity\ContenidoServicioTranslation | No errors. |