Query Metrics
2
Database Queries
2
Different statements
4.03 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.79 ms (69.06%) |
1 |
SELECT DISTINCT p0_.lastModified AS lastModified_0, p0_.changed AS changed_1, p0_.locale AS locale_2, p1_.availableLocales AS availableLocales_3, r2_.slug AS slug_4, p3_.uuid AS uuid_5 FROM pa_pages p3_ INNER JOIN pa_page_dimension_contents p0_ ON p3_.uuid = p0_.pageUuid AND (p0_.locale = ? AND p0_.stage = ? AND p0_.version = ? AND p0_.seoHideInSitemap = ? AND p0_.linkProvider IS NULL) LEFT JOIN pa_page_dimension_contents p1_ ON p3_.uuid = p1_.pageUuid AND (p1_.locale IS NULL AND p1_.stage = ? AND p1_.version = ? AND p1_.seoHideInSitemap = ?) LEFT JOIN ro_routes r2_ ON p0_.route_id = r2_.id WHERE p3_.webspaceKey = ? ORDER BY r2_.slug ASC
Parameters:
[ "en" "live" 0 0 "live" 0 0 "website" ]
|
||||||||||||||||||||||||||
|
1.25 ms (30.94%) |
1 |
SELECT DISTINCT p0_.locale AS locale_0, r1_.slug AS slug_1, p2_.uuid AS uuid_2 FROM pa_pages p2_ LEFT JOIN pa_page_dimension_contents p0_ ON p2_.uuid = p0_.pageUuid AND (p0_.locale <> ? AND p0_.locale IS NOT NULL AND p0_.stage = ? AND p0_.version = ? AND p0_.seoHideInSitemap = ? AND p0_.linkProvider IS NULL) LEFT JOIN ro_routes r1_ ON p0_.route_id = r1_.id WHERE p2_.webspaceKey = ? ORDER BY r1_.slug ASC
Parameters:
[ "en" "live" 0 0 "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. |