Query Metrics
17
Database Queries
15
Different statements
11.05 ms
Query time
7
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.51 ms (22.75%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.49 ms (13.50%) |
1 |
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:
[ "coutdqopcta79om9b4vflvtstq" Ramsey\Uuid\Lazy\LazyUuidFromString {#144 : "48dff52a-ca1d-426d-8d76-98fed358a5dd" } ] |
|
1.20 ms (10.90%) |
2 |
SELECT m0_.id AS id_0, m0_.path AS path_1, m0_.lvl AS lvl_2, m0_.position AS position_3, m0_.tipo AS tipo_4, m0_.target AS target_5, m0_.contenido AS contenido_6, m0_.activo AS activo_7, m1_.titulo AS titulo_8, m1_.url AS url_9, m1_.id AS id_10, m1_.locale AS locale_11, i2_.name AS name_12, i2_.description AS description_13, i2_.enabled AS enabled_14, i2_.provider_name AS provider_name_15, i2_.provider_status AS provider_status_16, i2_.provider_reference AS provider_reference_17, i2_.provider_metadata AS provider_metadata_18, i2_.width AS width_19, i2_.height AS height_20, i2_.length AS length_21, i2_.content_type AS content_type_22, i2_.content_size AS content_size_23, i2_.copyright AS copyright_24, i2_.author_name AS author_name_25, i2_.context AS context_26, i2_.cdn_is_flushable AS cdn_is_flushable_27, i2_.cdn_flush_identifier AS cdn_flush_identifier_28, i2_.cdn_flush_at AS cdn_flush_at_29, i2_.cdn_status AS cdn_status_30, i2_.updated_at AS updated_at_31, i2_.created_at AS created_at_32, i2_.id AS id_33 FROM menu_item m0_ INNER JOIN menu_item_translation m1_ ON m0_.id = m1_.translatable_id LEFT JOIN imagen i2_ ON m0_.imagen_id = i2_.id WHERE m0_.menu_id = '1' ORDER BY m0_.path ASC
Parameters:
[] |
|
0.84 ms (7.62%) |
2 |
SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.activo AS activo_2, m0_.zona AS zona_3 FROM menu m0_ WHERE m0_.activo = ? AND m0_.zona = ?
Parameters:
[ 1 "principal" ] |
|
0.63 ms (5.72%) |
1 |
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:
[
33
]
|
|
0.59 ms (5.35%) |
1 |
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
]
|
|
0.52 ms (4.75%) |
1 |
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, t7.id AS id_8, t7.nombre AS nombre_9, t7.peso AS peso_10, t7.slug AS slug_11, t7.provincia AS provincia_12 FROM provincia t0 LEFT JOIN localidad t7 ON t7.provincia = t0.id
Parameters:
[] |
|
0.51 ms (4.61%) |
1 |
SELECT c0_.id AS id_0, c0_.estado AS estado_1, c0_.fecha_alta AS fecha_alta_2, c0_.fecha_modificacion AS fecha_modificacion_3, c0_.fecha_publicacion AS fecha_publicacion_4, c0_.locales AS locales_5, c0_.error AS error_6, c0_.clave AS clave_7, c0_.position AS position_8, c0_.tipo AS tipo_9, c0_.imagen_id AS imagen_id_10, c0_.galeria_id AS galeria_id_11, c0_.ruta_id AS ruta_id_12 FROM contenido c0_ WHERE ((c0_.id = ? AND c0_.locales LIKE ?) AND c0_.tipo IN (?) AND c0_.estado = ?) AND c0_.tipo IN ('contenido', 'pagina', 'home', 'servicio')
Parameters:
[ 33 "%"es"%" "Pagina" 1 ] |
|
0.47 ms (4.26%) |
1 |
SELECT t0.id AS id_1, t0.ruta AS ruta_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM ruta_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
"pagina_url"
]
|
|
0.46 ms (4.21%) |
1 |
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.idioma AS idioma_4, t0.popular AS popular_5, t0.faqcategory_id AS faqcategory_id_6 FROM faq t0 WHERE t0.idioma = ? AND t0.popular = ?
Parameters:
[ "es" "1" ] |
|
0.45 ms (4.05%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.list_order AS list_order_3, t0.active AS active_4, t0.idioma AS idioma_5, t0.slug AS slug_6 FROM faq_category t0 WHERE t0.idioma = ? AND t0.active = ? ORDER BY t0.name ASC
Parameters:
[ "es" "1" ] |
|
0.43 ms (3.85%) |
1 |
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.idioma AS idioma_4, t0.popular AS popular_5, t0.faqcategory_id AS faqcategory_id_6 FROM faq t0 WHERE t0.idioma = ?
Parameters:
[
"es"
]
|
|
0.37 ms (3.35%) |
1 |
UPDATE user_stats SET last_update = ?, visited_pages = ?, locale = ? WHERE id = ?
Parameters:
[ "2025-10-31 11:10:23" "["\/cotizaciones\/from-euro-to-pound-sterling","\/en\/services\/planet-tax-free-32","\/en\/currency-exchange-offices\/almeria\/mojacar\/cambio-divisas-eurochange-mojacar-almeria","\/cms\/human-resources-33"]" "es" 1589 ] |
|
0.37 ms (3.33%) |
1 |
SELECT t0.id AS id_1 FROM ruta t0 WHERE t0.id = ?
Parameters:
[
"pagina_url"
]
|
|
0.20 ms (1.76%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\Contenido | No errors. |
| App\Entity\Pagina | No errors. |
| App\Entity\Home | 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\PaginaTranslation | No errors. |
| App\Entity\HomeTranslation | No errors. |
| App\Entity\ContenidoServicioTranslation | No errors. |
| App\Entity\TransaccionAfiliado | No errors. |
| App\Entity\Alerta | No errors. |
| App\Entity\HistorialDevolucion | No errors. |
| App\Entity\ReservaLinea | No errors. |
| App\Entity\TransaccionLinea | No errors. |
| App\Entity\Nacex | No errors. |
| App\Entity\EmailTransaccionAbandonada | 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\OficinaTranslation | No errors. |
| App\Entity\ProvinciaTranslation | No errors. |
| App\Entity\LocalidadTranslation | No errors. |
| Sonata\MediaBundle\Entity\BaseGalleryItem | No errors. |
| App\Entity\ImagenxGaleria | No errors. |
| App\Entity\RutaTranslation | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MenuItem | No errors. |
| App\Entity\MenuItemTranslation | No errors. |
| App\Entity\Divisa |
|
| App\Entity\PagoTPV | No errors. |
| App\Entity\FranjaHoras | No errors. |
| App\Entity\FranjaDiasTranslation | No errors. |
| App\Entity\ServicioTranslation | No errors. |
| App\Entity\HorarioReducido | No errors. |
| App\Entity\FaqCategory | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\DivisaConversion | No errors. |
| App\Entity\Cupon |
|
| App\Entity\DivisaTranslation | No errors. |
| App\Entity\DivisaConversionTranslation | No errors. |