http://lasseharm.space/2018/04/10/household-props-challenge-day-5-computer/

Query Metrics

4 Database Queries
4 Different statements
6.04 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.68 ms
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
  "default_live"
]
2 0.79 ms
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[]
3 0.63 ms
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters:
[
  "/cmf/lasseharm/routes/de/2018/04/10/household-props-challenge-day-5-computer"
  "default_live"
]
4 0.95 ms
SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target_id AS target_id_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target_id AS target_id_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target_id = r1_.id WHERE r0_.path = ? AND r0_.locale = ?
Parameters:
[
  "/2018/04/10/household-props-challenge-day-5-computer"
  "de"
]

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
Sulu\Bundle\SecurityBundle\Entity\Group No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Bundle\RouteBundle\Entity\Route No errors.
Sulu\Bundle\SecurityBundle\Entity\User No errors.