GET https://staging.rikudamerica.org/sitemaps/pages-1.xml

Query Metrics

2 Database Queries
2 Different statements
4.03 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

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