GET https://rct.dev.bbntimes.com/sitemap?format=xml

Query Metrics

6 Database Queries
5 Different statements
1794.62 ms Query time
2 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.93 ms
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters:
[
  "https://rct.dev.bbntimes.com/sitemap?format=xml"
  "published"
]
2 0.33 ms
SELECT t0.id AS id_1, t0.original_url AS original_url_2, t0.redirection_url AS redirection_url_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM redirection t0 WHERE t0.original_url = ? AND t0.status = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters:
[
  "https://rct.dev.bbntimes.com/sitemap?format=xml"
  "published"
]
3 1789.15 ms
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.introtext AS introtext_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.deleted_at AS deleted_at_7, a0_.status AS status_8, a0_.featured AS featured_9, a0_.main_view AS main_view_10, a0_.clicks AS clicks_11, a0_.reviewed_at AS reviewed_at_12, a0_.metakey AS metakey_13, a0_.metadesc AS metadesc_14, a0_.robots AS robots_15, a0_.published_at AS published_at_16, a0_.canonical AS canonical_17, a0_.super_tag AS super_tag_18, a0_.user_id AS user_id_19, a0_.category_id AS category_id_20, a0_.image_card_id AS image_card_id_21, a0_.image_header_id AS image_header_id_22 FROM article a0_ WHERE a0_.reviewed_at IS NOT NULL AND a0_.category_id IS NOT NULL AND a0_.status = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC
Parameters:
[
  "published"
  "2025-02-22 16:53:07"
]
4 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.description AS description_8, t0.main_view AS main_view_9, t0.theme AS theme_10, t0.orders AS orders_11, t0.metakey AS metakey_12, t0.metadesc AS metadesc_13, t0.canonical AS canonical_14 FROM category t0 WHERE t0.status = ? ORDER BY t0.orders ASC
Parameters:
[
  "published"
]
5 2.24 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5, u0_.email AS email_6, u0_.name AS name_7, u0_.require_reset AS require_reset_8, u0_.description AS description_9, u0_.is_active AS is_active_10, u0_.disabled_scroll AS disabled_scroll_11, u0_.networks AS networks_12, u0_.slug AS slug_13, u0_.job_title AS job_title_14, u0_.last_login AS last_login_15, u0_.ordering AS ordering_16, u0_.canonical AS canonical_17, u0_.image_profile_id AS image_profile_id_18 FROM user u0_ WHERE u0_.is_active = ? AND u0_.ordering > 0 ORDER BY u0_.ordering ASC
Parameters:
[
  1
]
6 1.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.orders AS orders_8, t0.metakey AS metakey_9, t0.metadesc AS metadesc_10, t0.canonical AS canonical_11, t0.image_id AS image_id_12 FROM PAGE t0 WHERE t0.status = ?
Parameters:
[
  "published"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

Class Mapping errors
App\Entity\Redirection No errors.
App\Entity\Article No errors.
App\Entity\User
  • The association App\Entity\User#files refers to the owning side field App\Entity\File#user which does not exist.
App\Entity\Category No errors.
App\Entity\File No errors.
App\Entity\Comment No errors.
App\Entity\Page
  • The association App\Entity\Page#image refers to the inverse side field App\Entity\File#pages which does not exist.