https://heavenwavesmedia.com/posts/assets/imgs/page/blog/2/user-4.png

Query Metrics

13 Database Queries
9 Different statements
2.34 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.07 ms
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.value AS value_3, t0.type AS type_4, t0.required AS required_5 FROM fbeen_settings t0
Parameters:
[]
2 0.26 ms
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.slug AS slug_2, r0_.path AS path_3, r0_.position AS position_4, r0_.date_created AS date_created_5, r0_.visibility AS visibility_6, r0_.parent_id AS parent_id_7, r0_.route_name AS route_name_8, r0_.template AS template_9, r0_.layout_type AS layout_type_10, r0_.controller AS controller_11, r0_.content_type AS content_type_12, r0_.controller AS controller_13, r0_.content_type AS content_type_14, r0_.url AS url_15, r0_.permanent AS permanent_16, r0_.route_type AS route_type_17 FROM route r0_ WHERE r0_.route_type IN ('list', 'post', 'page', 'taxon', 'url') ORDER BY r0_.position ASC
Parameters:
[]
3 0.19 ms
SELECT name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name
Parameters:
[]
4 0.07 ms
SELECT name FROM sqlite_master WHERE type = 'table' AND name != 'sqlite_sequence' AND name != 'geometry_columns' AND name != 'spatial_ref_sys' UNION ALL SELECT name FROM sqlite_temp_master WHERE type = 'table' ORDER BY name
Parameters:
[]
5 0.02 ms
SELECT ''
Parameters:
[]
6 0.04 ms
PRAGMA table_info('doctrine_migration_versions')
Parameters:
[]
7 0.32 ms
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "doctrine_migration_versions"
]
8 0.01 ms
SELECT ''
Parameters:
[]
9 0.04 ms
PRAGMA index_list('doctrine_migration_versions')
Parameters:
[]
10 0.10 ms
SELECT * FROM PRAGMA_TABLE_INFO (?)
Parameters:
[
  "doctrine_migration_versions"
]
11 0.06 ms
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "doctrine_migration_versions"
]
12 0.16 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
13 0.01 ms
SELECT ''
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
Boab\CmsBundle\Entity\Route No errors.
Boab\CmsBundle\Entity\Content No errors.
Boab\CmsBundle\Entity\Event No errors.
Boab\CmsBundle\Entity\Block No errors.
Fbeen\SettingsBundle\Entity\Setting No errors.
Boab\CmsBundle\Entity\ListRoute No errors.
Boab\CmsBundle\Entity\PostRoute No errors.
Boab\CmsBundle\Entity\PageRoute No errors.
Boab\CmsBundle\Entity\TermRoute No errors.
Boab\CmsBundle\Entity\UrlRoute No errors.
Boab\CmsBundle\Entity\User No errors.
Boab\CmsBundle\Entity\Term No errors.
Boab\CmsBundle\Entity\Photo No errors.
Boab\CmsBundle\Entity\Media No errors.
Boab\CmsBundle\Entity\ViewCounter No errors.