Query Metrics
10
Database Queries
9
Different statements
8.20 ms
Query time
5
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.48 ms |
SELECT u0_.id AS id_0, u0_.session_id AS session_id_1, u0_.uuid AS uuid_2, u0_.session_start AS session_start_3, u0_.last_update AS last_update_4, u0_.visited_pages AS visited_pages_5, u0_.referer AS referer_6, u0_.ip AS ip_7, u0_.device AS device_8, u0_.country AS country_9, u0_.region AS region_10, u0_.city AS city_11, u0_.zip AS zip_12, u0_.locale AS locale_13, u0_.user AS user_14 FROM user_stats u0_ WHERE u0_.session_id = ? OR u0_.uuid = ? LIMIT 1
Parameters:
[ "745m2j98ra0h2f5bctvvltasr0" Ramsey\Uuid\Lazy\LazyUuidFromString {#144 : "bb02f6d6-9e1e-46e6-b78d-33c58a8c7b0a" } ] |
| 2 | 0.23 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 0.45 ms |
UPDATE user_stats SET last_update = ?, visited_pages = ?, locale = ? WHERE id = ?
Parameters:
[ "2025-10-31 02:23:51" "["\/servicios\/western-union-7","\/en\/currency-exchange-offices\/granada"]" "en" 1569 ] |
| 4 | 3.28 ms |
"COMMIT"
Parameters:
[] |
| 5 | 0.63 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:
[ "granada" "en" ] |
| 6 | 0.37 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:
[
18
]
|
| 7 | 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:
[
18
]
|
| 8 | 0.54 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:
[
18
]
|
| 9 | 0.37 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:
[ 18 1 ] |
| 10 | 0.45 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:
[
18
]
|
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\UserStats | No errors. |
| FOS\UserBundle\Model\User | No errors. |
| App\Entity\User |
|
| App\Entity\Reserva | No errors. |
| App\Entity\Transaccion |
|
| 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\ProvinciaTranslation | No errors. |
| App\Entity\LocalidadTranslation | No errors. |
| App\Entity\Cotizaciones | 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. |