https://sklad.pernicka.cz/en/robots.txt

Query Metrics

24 Database Queries
6 Different statements
2.54 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.91 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:
[]
2 0.12 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:
[]
3 0.06 ms
PRAGMA table_info('migration_versions')
Parameters:
[]
4 0.14 ms
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "migration_versions"
]
5 0.06 ms
PRAGMA index_list('migration_versions')
Parameters:
[]
6 0.03 ms
PRAGMA TABLE_INFO ('migration_versions')
Parameters:
[]
7 0.09 ms
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "migration_versions"
]
8 0.07 ms
SELECT * FROM migration_versions
Parameters:
[]
9 0.13 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:
[]
10 0.08 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:
[]
11 0.04 ms
PRAGMA table_info('migration_versions')
Parameters:
[]
12 0.09 ms
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "migration_versions"
]
13 0.05 ms
PRAGMA index_list('migration_versions')
Parameters:
[]
14 0.03 ms
PRAGMA TABLE_INFO ('migration_versions')
Parameters:
[]
15 0.09 ms
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "migration_versions"
]
16 0.04 ms
SELECT * FROM migration_versions
Parameters:
[]
17 0.09 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:
[]
18 0.08 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:
[]
19 0.05 ms
PRAGMA table_info('migration_versions')
Parameters:
[]
20 0.08 ms
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "migration_versions"
]
21 0.05 ms
PRAGMA index_list('migration_versions')
Parameters:
[]
22 0.03 ms
PRAGMA TABLE_INFO ('migration_versions')
Parameters:
[]
23 0.08 ms
SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = ?
Parameters:
[
  "migration_versions"
]
24 0.04 ms
SELECT * FROM migration_versions
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\Base\AbstractDBElement No errors.
App\Entity\LogSystem\AbstractLogEntry No errors.
App\Entity\Base\AbstractNamedDBElement No errors.
App\Entity\Attachments\AttachmentContainingDBElement No errors.
App\Entity\UserSystem\PermissionsEmbed No errors.
App\Entity\UserSystem\User No errors.