Query Metrics
5
Database Queries
3
Different statements
1.52 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.48 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ LEFT JOIN categories c1_ ON (c0_.root = c1_.id), categories c2_ WHERE c0_.alias = ? AND c0_.lvl = ? AND c1_.alias = ? LIMIT 1
Parameters:
[ "amstelveen" 1 "amsterdam" ] |
| 2 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.root AS root_7, t0.text AS text_8, t0.addtext AS addtext_9, t0.image AS image_10, t0.seotitle AS seotitle_11, t0.seodescription AS seodescription_12, t0.seokeywords AS seokeywords_13, t0.showorder AS showorder_14, t0.created AS created_15, t0.updated AS updated_16, t0.order_field AS order_field_17, t0.order_direction AS order_direction_18, t0.uuid AS uuid_19, t0.ctype_id AS ctype_id_20, t0.parent_id AS parent_id_21 FROM categories t0 WHERE t0.alias = ? AND t0.lvl = ? LIMIT 1
Parameters:
[ "amsterdam" 0 ] |
| 3 | 0.30 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.alias AS alias_2, c0_.lft AS lft_3, c0_.lvl AS lvl_4, c0_.rgt AS rgt_5, c0_.root AS root_6, c0_.text AS text_7, c0_.addtext AS addtext_8, c0_.image AS image_9, c0_.seotitle AS seotitle_10, c0_.seodescription AS seodescription_11, c0_.seokeywords AS seokeywords_12, c0_.showorder AS showorder_13, c0_.created AS created_14, c0_.updated AS updated_15, c0_.order_field AS order_field_16, c0_.order_direction AS order_direction_17, c0_.uuid AS uuid_18, c0_.ctype_id AS ctype_id_19, c0_.parent_id AS parent_id_20 FROM categories c0_ LEFT JOIN categories c1_ ON (c0_.root = c1_.id), categories c2_ WHERE c0_.alias = ? AND c0_.lvl = ? AND c1_.alias = ? LIMIT 1
Parameters:
[ "amstelveen" 1 "amsterdam" ] |
| 4 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.lft AS lft_4, t0.lvl AS lvl_5, t0.rgt AS rgt_6, t0.root AS root_7, t0.text AS text_8, t0.addtext AS addtext_9, t0.image AS image_10, t0.seotitle AS seotitle_11, t0.seodescription AS seodescription_12, t0.seokeywords AS seokeywords_13, t0.showorder AS showorder_14, t0.created AS created_15, t0.updated AS updated_16, t0.order_field AS order_field_17, t0.order_direction AS order_direction_18, t0.uuid AS uuid_19, t0.ctype_id AS ctype_id_20, t0.parent_id AS parent_id_21 FROM categories t0 WHERE t0.alias = ? AND t0.lvl = ? LIMIT 1
Parameters:
[ "amsterdam" 0 ] |
| 5 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.value2 AS value2_4 FROM setting t0
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 |
|---|---|
| Wart\CmsBundle\Entity\Category | No errors. |
| Wart\CmsBundle\Entity\ContentType | No errors. |
| Wart\CmsBundle\Entity\Setting | No errors. |