Query Metrics
22
Database Queries
11
Different statements
11.63 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.47 ms |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
2 | 0.46 ms |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
3 | 0.51 ms |
SELECT * FROM tl_metamodel ORDER BY sorting ASC
Parameters:
[] |
4 | 1.00 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.70 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.61 ms |
SELECT * FROM tl_metamodel WHERE tableName=:tableName LIMIT 1
Parameters:
[ "tableName" => "mm_handydaten" ] |
7 | 1.52 ms |
SELECT * FROM tl_metamodel_attribute WHERE pid=:pid ORDER BY sorting ASC
Parameters:
[ "pid" => "12" ] |
8 | 0.99 ms |
SELECT * FROM tl_metamodel_dcasetting WHERE (pid=:pid) AND (published=:published) ORDER BY sorting ASC
Parameters:
[ "pid" => "13" "published" => 1 ] |
9 | 0.89 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.57 ms |
SELECT * FROM tl_metamodel_dca_sortgroup WHERE pid=:screenId ORDER BY sorting ASC
Parameters:
[ "screenId" => "13" ] |
11 | 0.17 ms |
SELECT * FROM tl_metamodel WHERE tableName=:tableName LIMIT 1
Parameters:
[ "tableName" => "mm_staff" ] |
12 | 0.30 ms |
SELECT * FROM tl_metamodel_attribute WHERE pid=:pid ORDER BY sorting ASC
Parameters:
[ "pid" => "10" ] |
13 | 0.31 ms |
SELECT * FROM tl_metamodel_dcasetting WHERE (pid=:pid) AND (published=:published) ORDER BY sorting ASC
Parameters:
[ "pid" => "11" "published" => 1 ] |
14 | 0.24 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.51 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.26 ms |
SELECT * FROM tl_metamodel_attribute WHERE pid=:pid ORDER BY sorting ASC
Parameters:
[ "pid" => "11" ] |
18 | 0.24 ms |
SELECT * FROM tl_metamodel_dcasetting WHERE (pid=:pid) AND (published=:published) ORDER BY sorting ASC
Parameters:
[ "pid" => "12" "published" => 1 ] |
19 | 0.21 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.22 ms |
SELECT * FROM tl_metamodel_dca_sortgroup WHERE pid=:screenId ORDER BY sorting ASC
Parameters:
[ "screenId" => "12" ] |
21 | 0.69 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<='1745951820') AND (tl_page.stop='' OR tl_page.stop>'1745951820') LIMIT 0,1
Parameters:
[] |
22 | 0.58 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<='1745951820') AND (tl_page.stop='' OR tl_page.stop>'1745951820')
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. |