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

Query Metrics

59 Database Queries
4 Different statements
37.82 ms Query time
1 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.74 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=images"
  "published"
]
2 0.30 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=images"
  "published"
]
3 3.92 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.deleted_at AS deleted_at_5, c0_.status AS status_6, c0_.description AS description_7, c0_.main_view AS main_view_8, c0_.theme AS theme_9, c0_.orders AS orders_10, c0_.metakey AS metakey_11, c0_.metadesc AS metadesc_12, c0_.canonical AS canonical_13 FROM category c0_ WHERE c0_.status = ? AND c0_.orders >= ? AND c0_.name <> ? ORDER BY c0_.orders ASC
Parameters:
[
  "published"
  0
  "Uncategorized"
]
4 5.50 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_.status = ? AND a0_.category_id = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 6
Parameters:
[
  "published"
  118
  "2025-02-23 16:08:56"
]
5 0.50 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90861
]
6 0.18 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90815
]
7 0.53 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68223
]
8 0.21 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68220
]
9 0.49 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  65318
]
10 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68198
]
11 0.98 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_.status = ? AND a0_.category_id = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 6
Parameters:
[
  "published"
  106
  "2025-02-23 16:08:56"
]
12 0.28 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90863
]
13 0.37 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90856
]
14 0.19 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90826
]
15 0.24 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90800
]
16 0.24 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90771
]
17 0.51 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68259
]
18 0.74 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_.status = ? AND a0_.category_id = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 6
Parameters:
[
  "published"
  105
  "2025-02-23 16:08:56"
]
19 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68256
]
20 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68250
]
21 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68247
]
22 0.25 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68241
]
23 0.22 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68236
]
24 0.19 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68234
]
25 0.90 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_.status = ? AND a0_.category_id = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 6
Parameters:
[
  "published"
  119
  "2025-02-23 16:08:56"
]
26 0.24 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90787
]
27 0.25 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68249
]
28 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68225
]
29 0.51 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  64859
]
30 6.46 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  67949
]
31 0.62 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  65059
]
32 0.85 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_.status = ? AND a0_.category_id = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 6
Parameters:
[
  "published"
  103
  "2025-02-23 16:08:56"
]
33 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90854
]
34 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90748
]
35 0.19 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68253
]
36 0.16 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68252
]
37 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68218
]
38 0.16 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68209
]
39 1.46 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_.status = ? AND a0_.category_id = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 6
Parameters:
[
  "published"
  107
  "2025-02-23 16:08:56"
]
40 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68233
]
41 0.45 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  65227
]
42 0.24 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68204
]
43 0.41 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  65731
]
44 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68196
]
45 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68182
]
46 0.63 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_.status = ? AND a0_.category_id = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 6
Parameters:
[
  "published"
  104
  "2025-02-23 16:08:56"
]
47 0.18 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  90859
]
48 0.16 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68258
]
49 0.17 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68257
]
50 0.45 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68251
]
51 0.25 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68238
]
52 0.18 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68230
]
53 1.02 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_.status = ? AND a0_.category_id = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 6
Parameters:
[
  "published"
  108
  "2025-02-23 16:08:56"
]
54 0.23 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68260
]
55 0.24 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68255
]
56 0.19 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68248
]
57 1.81 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68239
]
58 0.16 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68237
]
59 0.14 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.url AS url_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM FILE t0 WHERE t0.id = ?
Parameters:
[
  68229
]

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\Category 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\File No errors.
App\Entity\Comment No errors.