http://ylem.metamodels-playground.de/robots.txt

Query Metrics

22 Database Queries
11 Different statements
12.04 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.50 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
2 0.65 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
3 0.57 ms
SELECT * FROM tl_metamodel ORDER BY sorting ASC
Parameters:
[]
4 1.15 ms
SELECT * FROM tl_metamodel_dca_combine WHERE (fe_group IN (:groupList)) OR (fe_group=0) ORDER BY pid ASC, sorting ASC
Parameters:
[
  "groupList" => [
    -1
  ]
]
5 0.77 ms
SELECT d.* FROM tl_metamodel_dca d LEFT JOIN tl_metamodel m ON m.id=d.pid WHERE d.id IN (:idList) ORDER BY m.sorting ASC
Parameters:
[
  "idList" => [
    "mm_staff" => "11"
    "mm_division" => "12"
    "mm_handydaten" => "13"
  ]
]
6 0.67 ms
SELECT * FROM tl_metamodel WHERE tableName=:tableName LIMIT 1
Parameters:
[
  "tableName" => "mm_handydaten"
]
7 1.13 ms
SELECT * FROM tl_metamodel_attribute WHERE pid=:pid ORDER BY sorting ASC
Parameters:
[
  "pid" => "12"
]
8 1.15 ms
SELECT * FROM tl_metamodel_dcasetting WHERE (pid=:pid) AND (published=:published) ORDER BY sorting ASC
Parameters:
[
  "pid" => "13"
  "published" => 1
]
9 0.83 ms
SELECT cond.*, setting.attr_id AS setting_attr_id FROM tl_metamodel_dcasetting_condition cond LEFT JOIN tl_metamodel_dcasetting setting ON cond.settingId=setting.id LEFT JOIN tl_metamodel_dca dca ON setting.pid=dca.id WHERE (cond.enabled=1) AND (setting.published=1) AND (dca.id=:screenId) ORDER BY pid ASC, sorting ASC
Parameters:
[
  "screenId" => "13"
]
10 0.52 ms
SELECT * FROM tl_metamodel_dca_sortgroup WHERE pid=:screenId ORDER BY sorting ASC
Parameters:
[
  "screenId" => "13"
]
11 0.19 ms
SELECT * FROM tl_metamodel WHERE tableName=:tableName LIMIT 1
Parameters:
[
  "tableName" => "mm_staff"
]
12 0.35 ms
SELECT * FROM tl_metamodel_attribute WHERE pid=:pid ORDER BY sorting ASC
Parameters:
[
  "pid" => "10"
]
13 0.32 ms
SELECT * FROM tl_metamodel_dcasetting WHERE (pid=:pid) AND (published=:published) ORDER BY sorting ASC
Parameters:
[
  "pid" => "11"
  "published" => 1
]
14 0.20 ms
SELECT cond.*, setting.attr_id AS setting_attr_id FROM tl_metamodel_dcasetting_condition cond LEFT JOIN tl_metamodel_dcasetting setting ON cond.settingId=setting.id LEFT JOIN tl_metamodel_dca dca ON setting.pid=dca.id WHERE (cond.enabled=1) AND (setting.published=1) AND (dca.id=:screenId) ORDER BY pid ASC, sorting ASC
Parameters:
[
  "screenId" => "11"
]
15 0.50 ms
SELECT * FROM tl_metamodel_dca_sortgroup WHERE pid=:screenId ORDER BY sorting ASC
Parameters:
[
  "screenId" => "11"
]
16 0.18 ms
SELECT * FROM tl_metamodel WHERE tableName=:tableName LIMIT 1
Parameters:
[
  "tableName" => "mm_division"
]
17 0.25 ms
SELECT * FROM tl_metamodel_attribute WHERE pid=:pid ORDER BY sorting ASC
Parameters:
[
  "pid" => "11"
]
18 0.27 ms
SELECT * FROM tl_metamodel_dcasetting WHERE (pid=:pid) AND (published=:published) ORDER BY sorting ASC
Parameters:
[
  "pid" => "12"
  "published" => 1
]
19 0.23 ms
SELECT cond.*, setting.attr_id AS setting_attr_id FROM tl_metamodel_dcasetting_condition cond LEFT JOIN tl_metamodel_dcasetting setting ON cond.settingId=setting.id LEFT JOIN tl_metamodel_dca dca ON setting.pid=dca.id WHERE (cond.enabled=1) AND (setting.published=1) AND (dca.id=:screenId) ORDER BY pid ASC, sorting ASC
Parameters:
[
  "screenId" => "12"
]
20 0.18 ms
SELECT * FROM tl_metamodel_dca_sortgroup WHERE pid=:screenId ORDER BY sorting ASC
Parameters:
[
  "screenId" => "12"
]
21 0.73 ms
SELECT tl_page.* FROM tl_page WHERE (tl_page.dns='ylem.metamodels-playground.de' OR tl_page.dns='') AND tl_page.fallback='1' AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1745919000') AND (tl_page.stop='' OR tl_page.stop>'1745919000') LIMIT 0,1
Parameters:
[]
22 0.70 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND tl_page.dns='' AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1745919000') AND (tl_page.stop='' OR tl_page.stop>'1745919000')
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
Contao\CoreBundle\Entity\RememberMe No errors.