Query Metrics

6 Database Queries
5 Different statements
3.07 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.50 ms
SELECT t0.id AS id_1, t0.texto AS texto_2, t0.alt AS alt_3, t0.titulo AS titulo_4, t0.meta_keywords AS meta_keywords_5, t0.meta_description AS meta_description_6, t0.meta_title AS meta_title_7, t0.descripcion_imagen AS descripcion_imagen_8, t0.slug AS slug_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM provincia_translation t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "valencia"
  "en"
]
2 0.49 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.gastos AS gastos_3, t0.peso AS peso_4, t0.imagen_cabecera_id AS imagen_cabecera_id_5, t0.imagen_banner_id AS imagen_banner_id_6 FROM provincia t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  46
]
3 0.67 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.peso AS peso_3, t0.slug AS slug_4, t0.provincia AS provincia_5 FROM localidad t0 WHERE t0.provincia = ? ORDER BY t0.peso DESC
Parameters:
[
  46
]
4 0.41 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.peso AS peso_3, t0.slug AS slug_4, t0.provincia AS provincia_5 FROM localidad t0 WHERE t0.provincia = ? ORDER BY t0.peso DESC
Parameters:
[
  46
]
5 0.57 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.provincia = ? AND t0.activo = ?
Parameters:
[
  46
  1
]
6 0.42 ms
SELECT t0.id AS id_1, t0.texto AS texto_2, t0.alt AS alt_3, t0.titulo AS titulo_4, t0.meta_keywords AS meta_keywords_5, t0.meta_description AS meta_description_6, t0.meta_title AS meta_title_7, t0.descripcion_imagen AS descripcion_imagen_8, t0.slug AS slug_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM provincia_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  46
]

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\Provincia No errors.
App\Entity\ProvinciaTranslation No errors.
Sonata\MediaBundle\Entity\BaseMedia No errors.
App\Entity\Imagen No errors.
App\Entity\Localidad
  • The field App\Entity\Localidad#oficinas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Oficina#localidad does not contain the required 'inversedBy="oficinas"' attribute.
App\Entity\Oficina
  • The field App\Entity\Oficina#alerts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Alerta#oficina does not contain the required 'inversedBy="alerts"' attribute.
App\Entity\LocalidadTranslation No errors.
App\Entity\OficinaErp 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
  • The field App\Entity\DayOff#horarioReducidos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\HorarioReducido#dayoff does not contain the required 'inversedBy="horarioReducidos"' attribute.
App\Entity\Alerta No errors.
App\Entity\OficinaTranslation No errors.