Query Metrics
10
Database Queries
9
Different statements
9.41 ms
Query time
1
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4.10 ms (43.58%) |
1 |
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_.slug = ? AND a0_.deleted_at IS NULL AND a0_.published_at <= ? AND a0_.status = ? LIMIT 1
Parameters:
[ "reflecting-on-writing-in-2021" "2025-01-15 10:58:37" "published" ]
|
||||||||||||||||||||||||||||
1.56 ms (16.53%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||
1.15 ms (12.19%) |
2 |
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/society/reflecting-on-writing-in-2021" "published" ]
|
||||||||||||||||||||||||||||
0.68 ms (7.18%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.email AS email_2, c0_.website AS website_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.content AS content_6, c0_.status AS status_7, c0_.replyto AS replyto_8, c0_.article_id AS article_id_9 FROM COMMENT c0_ WHERE c0_.status = ? AND c0_.article_id = ? ORDER BY c0_.created_at ASC
Parameters:
[ "published" 7754 ]
|
||||||||||||||||||||||||||||
0.61 ms (6.45%) |
1 |
UPDATE article SET clicks = ? WHERE id = ?
Parameters:
[ 2815 7754 ]
|
||||||||||||||||||||||||||||
0.47 ms (5.00%) |
1 |
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.slug = ? AND t0.status = ? LIMIT 1
Parameters:
[ "society" "published" ]
|
||||||||||||||||||||||||||||
0.47 ms (4.95%) |
1 |
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.id = ?
Parameters:
[
424
]
|
||||||||||||||||||||||||||||
0.28 ms (3.00%) |
1 |
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:
[
58023
]
|
||||||||||||||||||||||||||||
0.11 ms (1.12%) |
1 |
"START TRANSACTION"
Parameters:
[]
|
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 |
|
App\Entity\File | No errors. |
App\Entity\Comment | No errors. |