GET https://rct.dev.bbntimes.com/himanshu-goel

Query Metrics

41 Database Queries
9 Different statements
35.15 ms Query time
2 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 1.03 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/himanshu-goel"
  "published"
]
2 0.59 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.email AS email_7, t0.name AS name_8, t0.require_reset AS require_reset_9, t0.description AS description_10, t0.is_active AS is_active_11, t0.disabled_scroll AS disabled_scroll_12, t0.networks AS networks_13, t0.slug AS slug_14, t0.job_title AS job_title_15, t0.last_login AS last_login_16, t0.ordering AS ordering_17, t0.canonical AS canonical_18, t0.image_profile_id AS image_profile_id_19 FROM user t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "himanshu-goel"
]
3 0.89 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_.user_id = ? AND a0_.status = ? AND a0_.published_at <= ? ORDER BY a0_.published_at DESC LIMIT 10
Parameters:
[
  651
  "published"
  "2025-01-15 06:59:36"
]
4 0.56 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/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderAnalysis"
  "published"
]
5 0.58 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/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderHeader"
  "published"
]
6 0.40 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 = ? ORDER BY c0_.orders ASC
Parameters:
[
  "published"
]
7 0.27 ms
SELECT p0_.title AS title_0, p0_.slug AS slug_1 FROM PAGE p0_ WHERE p0_.status = ? ORDER BY p0_.orders ASC
Parameters:
[
  "published"
]
8 0.26 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "facebook"
  "general"
]
9 0.17 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "twitter"
  "general"
]
10 0.21 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "linkedin"
  "general"
]
11 0.23 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "youtube"
  "general"
]
12 0.30 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:
[
  57177
]
13 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.website AS website_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7, t0.status AS status_8, t0.replyto AS replyto_9, t0.article_id AS article_id_10 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
  6866
]
14 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:
[
  55946
]
15 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.website AS website_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7, t0.status AS status_8, t0.replyto AS replyto_9, t0.article_id AS article_id_10 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
  5555
]
16 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:
[
  55203
]
17 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.website AS website_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7, t0.status AS status_8, t0.replyto AS replyto_9, t0.article_id AS article_id_10 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
  4785
]
18 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:
[
  54963
]
19 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.website AS website_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7, t0.status AS status_8, t0.replyto AS replyto_9, t0.article_id AS article_id_10 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
  4537
]
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:
[
  54914
]
21 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.website AS website_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7, t0.status AS status_8, t0.replyto AS replyto_9, t0.article_id AS article_id_10 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
  4485
]
22 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:
[
  54908
]
23 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.website AS website_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7, t0.status AS status_8, t0.replyto AS replyto_9, t0.article_id AS article_id_10 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
  4479
]
24 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:
[
  54893
]
25 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.website AS website_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7, t0.status AS status_8, t0.replyto AS replyto_9, t0.article_id AS article_id_10 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
  4464
]
26 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:
[
  54542
]
27 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.website AS website_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7, t0.status AS status_8, t0.replyto AS replyto_9, t0.article_id AS article_id_10 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
  4108
]
28 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:
[
  54448
]
29 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.website AS website_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7, t0.status AS status_8, t0.replyto AS replyto_9, t0.article_id AS article_id_10 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
  4011
]
30 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:
[
  54435
]
31 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.website AS website_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.content AS content_7, t0.status AS status_8, t0.replyto AS replyto_9, t0.article_id AS article_id_10 FROM COMMENT t0 WHERE t0.article_id = ?
Parameters:
[
  3998
]
32 0.29 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/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAppController%253A%253ArenderFooter"
  "published"
]
33 0.25 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "footer_description"
  "general"
]
34 20.39 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 LIMIT 5
Parameters:
[
  "published"
  "2025-01-15 06:59:36"
]
35 0.44 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 = ? ORDER BY c0_.orders ASC
Parameters:
[
  "published"
]
36 0.29 ms
SELECT p0_.title AS title_0, p0_.slug AS slug_1 FROM PAGE p0_ WHERE p0_.status = ? ORDER BY p0_.orders ASC
Parameters:
[
  "published"
]
37 0.25 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "facebook"
  "general"
]
38 0.20 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "twitter"
  "general"
]
39 0.23 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "linkedin"
  "general"
]
40 0.21 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.type AS type_3 FROM setting s0_ WHERE s0_.name = ? AND s0_.type = ?
Parameters:
[
  "youtube"
  "general"
]
41 0.29 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/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CCookieController%253A%253ArenderCookie"
  "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\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\Article No errors.
App\Entity\Category 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.
App\Entity\Setting No errors.