Query Metrics
5
Database Queries
4
Different statements
3.47 ms
Query time
0
Invalid entities
7
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.16 ms (33.33%) |
1 |
SELECT a0_.uuid AS uuid_0, a0_.created AS created_1, a0_.changed AS changed_2, a1_.title AS title_3, a1_.customizeWebspaceSettings AS customizeWebspaceSettings_4, a1_.id AS id_5, a1_.stage AS stage_6, a1_.locale AS locale_7, a1_.ghostLocale AS ghostLocale_8, a1_.availableLocales AS availableLocales_9, a1_.version AS version_10, a1_.shadowLocale AS shadowLocale_11, a1_.shadowLocales AS shadowLocales_12, a1_.templateKey AS templateKey_13, a1_.templateData AS templateData_14, a1_.seoData AS seoData_15, a1_.seoNoIndex AS seoNoIndex_16, a1_.seoNoFollow AS seoNoFollow_17, a1_.seoHideInSitemap AS seoHideInSitemap_18, a1_.excerptData AS excerptData_19, a1_.excerptSegment AS excerptSegment_20, a1_.mainWebspace AS mainWebspace_21, a1_.authored AS authored_22, a1_.lastModified AS lastModified_23, a1_.workflowPlace AS workflowPlace_24, a1_.workflowPublished AS workflowPublished_25, a1_.created AS created_26, a1_.changed AS changed_27, t2_.name AS name_28, t2_.id AS id_29, t2_.created AS created_30, t2_.changed AS changed_31, c3_.category_key AS category_key_32, c3_.default_locale AS default_locale_33, c3_.lft AS lft_34, c3_.rgt AS rgt_35, c3_.depth AS depth_36, c3_.id AS id_37, c3_.created AS created_38, c3_.changed AS changed_39, c4_.translation AS translation_40, c4_.locale AS locale_41, c4_.description AS description_42, c4_.id AS id_43, c4_.created AS created_44, c4_.changed AS changed_45, a0_.idUsersCreator AS idUsersCreator_46, a0_.idUsersChanger AS idUsersChanger_47, a1_.route_id AS route_id_48, a1_.articleUuid AS articleUuid_49, a1_.author_id AS author_id_50, a1_.idUsersCreator AS idUsersCreator_51, a1_.idUsersChanger AS idUsersChanger_52, t2_.idUsersCreator AS idUsersCreator_53, t2_.idUsersChanger AS idUsersChanger_54, c3_.idCategoriesParent AS idCategoriesParent_55, c3_.idUsersCreator AS idUsersCreator_56, c3_.idUsersChanger AS idUsersChanger_57, c4_.idCategories AS idCategories_58, c4_.idUsersCreator AS idUsersCreator_59, c4_.idUsersChanger AS idUsersChanger_60 FROM ar_articles a0_ LEFT JOIN ar_article_dimension_contents a1_ ON a0_.uuid = a1_.articleUuid LEFT JOIN ar_article_dimension_content_excerpt_tags a5_ ON a1_.id = a5_.article_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = a5_.tag_id LEFT JOIN ar_article_dimension_content_excerpt_categories a6_ ON a1_.id = a6_.article_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = a6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN (?)) WHERE a0_.uuid = ? AND (((a1_.locale IS NULL OR a1_.locale IN (?)) AND (a1_.stage IS NULL OR a1_.stage IN (?))) AND (a1_.version IS NULL OR a1_.version IN (?)))
Parameters:
[ "bg" "019e87c7-3606-76fa-b81b-6c72fa705cbf" "bg" "live" 0 ] |
||||||||||||||||||||||||||||||
|
0.89 ms (25.75%) |
1 |
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Parameters:
[ "tuhlla.fxrm.eu" "dev" "tuhlla" ]
|
||||||||||||||||||||||||||||||
|
0.74 ms (21.28%) |
2 |
SELECT t0.name AS name_1, t0.id AS id_2, t0.article_dimension_content_id AS article_dimension_content_id_3 FROM ar_article_dimension_content_additional_webspaces t0 WHERE t0.article_dimension_content_id = ?
Parameters:
[
11
]
|
||||||||||||||||||||||||||||||
|
0.68 ms (19.64%) |
1 |
SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE ((r0_.webspace = ? OR r0_.webspace IS NULL)) AND r0_.locale = ? AND r0_.slug = ? ORDER BY r0_.webspace DESC LIMIT 1
Parameters:
[ "tuhlla" "bg" "/kukhni/baaaaaaa" ] |
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 |
|---|---|
| Sulu\Route\Domain\Model\Route | 2 |
| Sulu\Article\Domain\Model\ArticleDimensionContent | 2 |
| Sulu\Article\Domain\Model\Article | 1 |
| Sulu\Bundle\SecurityBundle\Entity\User | 1 |
| Sulu\Bundle\ContactBundle\Entity\Contact | 1 |