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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 6.32 ms
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"
]
2 1.10 ms
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