Query Metrics
2
Database Queries
2
Different statements
7.42 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
6.32 ms (85.20%) |
1 |
SELECT DISTINCT a0_.lastModified AS lastModified_0, a0_.changed AS changed_1, a0_.locale AS locale_2, a1_.availableLocales AS availableLocales_3, r2_.slug AS slug_4, a3_.uuid AS uuid_5 FROM ar_articles a3_ INNER JOIN ar_article_dimension_contents a0_ ON a3_.uuid = a0_.articleUuid AND (a0_.locale = ? AND a0_.stage = ? AND a0_.version = ? AND a0_.seoHideInSitemap = ?) LEFT JOIN ar_article_dimension_content_additional_webspaces a4_ ON a0_.id = a4_.article_dimension_content_id LEFT JOIN ar_article_dimension_contents a1_ ON a3_.uuid = a1_.articleUuid AND (a1_.locale IS NULL AND a1_.stage = ? AND a1_.version = ? AND a1_.seoHideInSitemap = ?) LEFT JOIN ro_routes r2_ ON a0_.route_id = r2_.id WHERE a0_.mainWebspace = ? OR a4_.name = ? ORDER BY r2_.slug ASC
Parameters:
[ "en" "live" 0 0 "live" 0 0 "website" "website" ]
|
||||||||||||||||||||||||||
|
1.10 ms (14.80%) |
1 |
SELECT DISTINCT a0_.locale AS locale_0, r1_.slug AS slug_1, a2_.uuid AS uuid_2 FROM ar_articles a2_ LEFT JOIN ar_article_dimension_contents a0_ ON a2_.uuid = a0_.articleUuid AND (a0_.locale <> ? AND a0_.locale IS NOT NULL AND a0_.stage = ? AND a0_.version = ? AND a0_.seoHideInSitemap = ?) LEFT JOIN ar_article_dimension_content_additional_webspaces a3_ ON a0_.id = a3_.article_dimension_content_id LEFT JOIN ro_routes r1_ ON a0_.route_id = r1_.id WHERE a0_.mainWebspace = ? OR a3_.name = ? ORDER BY r1_.slug ASC
Parameters:
[ "en" "live" 0 0 "website" "website" ]
|
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| Sulu\Article\Domain\Model\Article | No errors. |
| Sulu\Page\Domain\Model\Page | No errors. |
| Sulu\Bundle\ReferenceBundle\Domain\Model\Reference | 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\TagBundle\Entity\Tag | No errors. |
| Sulu\Bundle\CategoryBundle\Entity\Category | No errors. |
| Sulu\Route\Domain\Model\Route | No errors. |
| Sulu\Bundle\ContactBundle\Entity\Contact | No errors. |
| Sulu\Article\Domain\Model\ArticleDimensionContent | No errors. |
| Sulu\Page\Domain\Model\PageDimensionContent | No errors. |
| Sulu\Snippet\Domain\Model\Snippet | No errors. |
| Sulu\Snippet\Domain\Model\SnippetDimensionContent | No errors. |
| Sulu\Snippet\Domain\Model\SnippetArea | No errors. |
| Sulu\Article\Domain\Model\ArticleDimensionContentAdditionalWebspace | No errors. |