Query Metrics
5
Database Queries
4
Different statements
1.01 ms
Query time
0
Invalid entities
79
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.45 ms (44.41%) |
2 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_prefix AS name_prefix_2, c0_.access_authenticated AS access_authenticated_3, c0_.slug AS slug_4, c0_.public AS public_5, c0_.description AS description_6, c0_.menus AS menus_7, c0_.template AS template_8, c0_.position AS position_9, c0_.nofollow AS nofollow_10, c0_.data AS data_11, c0_.type AS type_12, c0_.content_type AS content_type_13, c0_.url AS url_14, c0_.arguments AS arguments_15, c0_.content_options AS content_options_16, c0_.deleted_at AS deleted_at_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.root AS root_20, c0_.lvl AS lvl_21, c0_.lft AS lft_22, c0_.rgt AS rgt_23, c1_.id AS id_24, c1_.name AS name_25, c1_.name_prefix AS name_prefix_26, c1_.access_authenticated AS access_authenticated_27, c1_.slug AS slug_28, c1_.public AS public_29, c1_.description AS description_30, c1_.menus AS menus_31, c1_.template AS template_32, c1_.position AS position_33, c1_.nofollow AS nofollow_34, c1_.data AS data_35, c1_.type AS type_36, c1_.content_type AS content_type_37, c1_.url AS url_38, c1_.arguments AS arguments_39, c1_.content_options AS content_options_40, c1_.deleted_at AS deleted_at_41, c1_.created_at AS created_at_42, c1_.updated_at AS updated_at_43, c1_.root AS root_44, c1_.lvl AS lvl_45, c1_.lft AS lft_46, c1_.rgt AS rgt_47, c2_.id AS id_48, c2_.name AS name_49, c2_.name_prefix AS name_prefix_50, c2_.access_authenticated AS access_authenticated_51, c2_.slug AS slug_52, c2_.public AS public_53, c2_.description AS description_54, c2_.menus AS menus_55, c2_.template AS template_56, c2_.position AS position_57, c2_.nofollow AS nofollow_58, c2_.data AS data_59, c2_.type AS type_60, c2_.content_type AS content_type_61, c2_.url AS url_62, c2_.arguments AS arguments_63, c2_.content_options AS content_options_64, c2_.deleted_at AS deleted_at_65, c2_.created_at AS created_at_66, c2_.updated_at AS updated_at_67, c2_.root AS root_68, c2_.lvl AS lvl_69, c2_.lft AS lft_70, c2_.rgt AS rgt_71, c0_.parent_id AS parent_id_72, c0_.user_id AS user_id_73, c1_.parent_id AS parent_id_74, c1_.user_id AS user_id_75, c2_.parent_id AS parent_id_76, c2_.user_id AS user_id_77 FROM content_page c0_ LEFT JOIN content_page c1_ ON c0_.id = c1_.parent_id LEFT JOIN content_page c2_ ON c1_.id = c2_.parent_id WHERE c0_.public = ? AND c0_.menus LIKE ? AND c0_.parent_id IS NULL ORDER BY c0_.position ASC, c1_.lft ASC, c2_.lft ASC
Parameters:
[ 1 "%main%" ] |
|
0.29 ms (28.69%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_prefix AS name_prefix_2, c0_.access_authenticated AS access_authenticated_3, c0_.slug AS slug_4, c0_.public AS public_5, c0_.description AS description_6, c0_.menus AS menus_7, c0_.template AS template_8, c0_.position AS position_9, c0_.nofollow AS nofollow_10, c0_.data AS data_11, c0_.type AS type_12, c0_.content_type AS content_type_13, c0_.url AS url_14, c0_.arguments AS arguments_15, c0_.content_options AS content_options_16, c0_.deleted_at AS deleted_at_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.root AS root_20, c0_.lvl AS lvl_21, c0_.lft AS lft_22, c0_.rgt AS rgt_23, c0_.parent_id AS parent_id_24, c0_.user_id AS user_id_25 FROM content_page c0_ WHERE c0_.public = ? ORDER BY c0_.lft ASC LIMIT 1
Parameters:
[
1
]
|
|
0.14 ms (13.65%) |
1 |
SELECT c0_.content AS content_0, c0_.field AS field_1, c0_.locale AS locale_2 FROM content_page_translations c0_ WHERE c0_.foreign_key = ? AND c0_.object_class = ? ORDER BY c0_.locale ASC
Parameters:
[ 1 "Tigris\ContentBundle\Entity\Page" ] |
|
0.13 ms (13.25%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.bundle AS bundle_2, c0_.value AS value_3, c0_.type AS type_4 FROM config c0_ ORDER BY c0_.name ASC
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Tigris\BaseBundle\Entity\Config | 71 |
| Tigris\ContentBundle\Entity\Page | 7 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Tigris\ContentBundle\Entity\Page | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Group | No errors. |
| Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
| Gedmo\Translatable\Entity\Translation | No errors. |
| Tigris\ContentBundle\Entity\Translation\PageTranslation | No errors. |
| Tigris\BaseBundle\Entity\Config | No errors. |
| Tigris\ContentBundle\Entity\Category | No errors. |