Symfony Profiler

Query Metrics

39 Database Queries

11 Different statements

81.96 ms Query time

0 Invalid entities

121 Managed entities

Queries


SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.nombre AS nombre_2, c0_.enabled AS enabled_3, c0_.disabletranslation AS disabletranslation_4, c0_.descripcion_corta AS descripcion_corta_5, c0_.descripcion_larga AS descripcion_larga_6, c0_.destacada AS destacada_7, c0_.localizacion AS localizacion_8, c0_.position AS position_9, ST_AsEWKT(c0_.point) AS point_10, c0_.deleted_at AS deleted_at_11 FROM ciudad c0_ WHERE (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ciudad_translations t0 WHERE t0.object_id = ?
SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.field AS field_2, c0_.content AS content_3, c0_.object_id AS object_id_4 FROM ciudad_translations c0_ WHERE c0_.object_id = ? AND c0_.locale = ? AND c0_.field = 'descripcionCorta' ORDER BY c0_.id DESC
SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.field AS field_2, c0_.content AS content_3, c0_.object_id AS object_id_4 FROM ciudad_translations c0_ WHERE c0_.object_id = ? AND c0_.locale = ? AND c0_.field = 'descripcionLarga' ORDER BY c0_.id DESC
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.enabled AS enabled_2, c0_.asunto AS asunto_3, c0_.disabletranslation AS disabletranslation_4, c0_.fecha_inicio AS fecha_inicio_5, c0_.destacada AS destacada_6, c0_.fecha_fin AS fecha_fin_7, c0_.cuerpo AS cuerpo_8, c0_.direccion AS direccion_9, c0_.telefono AS telefono_10, c0_.web AS web_11, c0_.localizacion AS localizacion_12, c0_.ciudad_id AS ciudad_id_13, c0_.tipo AS tipo_14 FROM calendario c0_ WHERE c0_.fecha_inicio > CURRENT_TIMESTAMP
SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.enabled AS enabled_2, t0_.disabletranslation AS disabletranslation_3, t0_.nombre AS nombre_4, t0_.descripcion AS descripcion_5, t0_.ruta_archivo AS ruta_archivo_6, t0_.position AS position_7 FROM tipo_poi t0_ ORDER BY t0_.id ASC
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM tipo_poi_translations t0 WHERE t0.object_id = ?
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
SELECT f0_.id AS id_0, f0_.nombre AS nombre_1, f0_.enabled AS enabled_2, f0_.disabletranslation AS disabletranslation_3, f0_.url AS url_4, f0_.nolocal AS nolocal_5, f0_.auth AS auth_6, f0_.position AS position_7, f0_.deleted_at AS deleted_at_8, f0_.parent_id AS parent_id_9 FROM front_menu f0_ WHERE f0_.parent_id IS NULL AND f0_.enabled = true ORDER BY f0_.position ASC
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM frontmenu_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM frontmenu_translations t0 WHERE t0.object_id = ?
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM frontmenu_translations t0 WHERE t0.object_id = ?
SELECT f0_.id AS id_0, f0_.locale AS locale_1, f0_.field AS field_2, f0_.content AS content_3, f0_.object_id AS object_id_4 FROM frontmenu_translations f0_ WHERE f0_.object_id = ? AND f0_.locale = ? AND f0_.field = 'nombre' ORDER BY f0_.id DESC

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\Translation\TipoPoiTranslation	97
App\Entity\TipoPoi	14
App\Translation\CiudadTranslation	6
App\Entity\Frontmenu	3
App\Entity\Ciudad	1

Entities Mapping

Class	Mapping errors
App\Entity\Ciudad	No errors.
App\Entity\Imagen	No errors.
App\Entity\Panoramica	No errors.
App\Entity\Video	No errors.
App\Entity\Recurso	No errors.
App\Entity\Poi	No errors.
App\Entity\Qrcode	No errors.
App\Entity\Ruta	No errors.
App\Entity\VisitaVirtual	No errors.
App\Entity\RutaPersonalizada	No errors.
App\Entity\Calendario	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
App\Translation\CiudadTranslation	No errors.
App\Entity\CalendarioTipos	No errors.
App\Entity\TipoPoi	No errors.
App\Translation\TipoPoiTranslation	No errors.
App\Entity\Frontmenu	No errors.
App\Translation\FrontmenuTranslation	No errors.
App\Entity\PanoramicaPositions	No errors.
App\Translation\PoiTranslation	No errors.
App\Translation\RutaTranslation	No errors.
App\Entity\Usuarios	No errors.
App\Translation\RutaPersonalizadaTranslation	No errors.
App\Translation\CalendarioTranslation	No errors.
App\Translation\CalendarioTiposTranslation	No errors.

Symfony Profiler

GET https://demomvn.mapescador.duckdns.org/es/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping