Query Metrics
9
Database Queries
8
Different statements
7.06 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.85 ms (40.34%) |
1 |
"COMMIT"
Parameters:
[] |
1.28 ms (18.05%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.thumbnail AS thumbnail_5, t0.image AS image_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8 FROM blog_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"etude-cas-client"
]
|
0.78 ms (11.02%) |
1 |
SELECT b0_.id AS id_0, b0_.public_title AS public_title_1, b0_.seo_title AS seo_title_2, b0_.body AS body_3, b0_.thumbnail AS thumbnail_4, b0_.image AS image_5, b0_.seo_description AS seo_description_6, b0_.created_at AS created_at_7, b0_.img_og AS img_og_8, b0_.last_modified AS last_modified_9, b0_.is_active AS is_active_10, b0_.slug AS slug_11, b0_.is_featured AS is_featured_12, b0_.author_id AS author_id_13 FROM blog_post b0_ INNER JOIN blog_post_blog_category b2_ ON b0_.id = b2_.blog_post_id INNER JOIN blog_category b1_ ON b1_.id = b2_.blog_category_id WHERE b1_.id = ? AND b0_.is_active = ? ORDER BY b0_.id DESC
Parameters:
[ 5 1 ] |
0.74 ms (10.51%) |
1 |
SELECT t0.id AS id_1, t0.public_title AS public_title_2, t0.seo_title AS seo_title_3, t0.body AS body_4, t0.thumbnail AS thumbnail_5, t0.image AS image_6, t0.seo_description AS seo_description_7, t0.created_at AS created_at_8, t0.img_og AS img_og_9, t0.last_modified AS last_modified_10, t0.is_active AS is_active_11, t0.slug AS slug_12, t0.is_featured AS is_featured_13, t0.author_id AS author_id_14 FROM blog_post t0 INNER JOIN blog_post_blog_category ON t0.id = blog_post_blog_category.blog_post_id WHERE blog_post_blog_category.blog_category_id = ?
Parameters:
[
5
]
|
0.49 ms (6.87%) |
1 |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2, b0_.slug AS slug_3, b0_.thumbnail AS thumbnail_4, b0_.image AS image_5, b0_.is_active AS is_active_6, b0_.created_at AS created_at_7 FROM blog_category b0_ WHERE b0_.is_active = ? ORDER BY b0_.id ASC LIMIT 3 OFFSET 1
Parameters:
[
1
]
|
0.40 ms (5.68%) |
1 |
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[ "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:50:\"App\\Messenger\\Message\\TrackingKernelRequestMessage\":1:{s:59:\"\0App\\Messenger\\Message\\TrackingKernelRequestMessage\0content\";a:12:{s:9:\"userAgent\";s:111:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36\";s:2:\"ip\";s:13:\"80.85.247.231\";s:7:\"referer\";N;s:14:\"acceptLanguage\";s:14:\"en-US,en;q=0.9\";s:3:\"uri\";s:54:\"https://grandbridge.org/blog/category/etude-cas-client\";s:7:\"cookies\";a:2:{s:6:\"EVSSID\";s:36:\"f4bda7d8-4d74-42d9-b757-f7098ef3b733\";s:9:\"PHPSESSID\";s:26:\"a483m3r7pa0ohrqlei3hqiuk8p\";}s:6:\"params\";a:0:{}s:7:\"dateAdd\";O:8:\"DateTime\":3:{s:4:\"date\";s:26:\"2025-01-30 18:58:12.200531\";s:13:\"timezone_type\";i:3;s:8:\"timezone\";s:3:\"UTC\";}s:9:\"phpsessid\";s:26:\"a483m3r7pa0ohrqlei3hqiuk8p\";s:12:\"utm_campaign\";N;s:10:\"utm_source\";N;s:6:\"EVSSID\";s:36:\"f4bda7d8-4d74-42d9-b757-f7098ef3b733\";}}}" "[]" "default" "2025-01-30 18:58:12" "2025-01-30 18:58:12" ] |
0.32 ms (4.56%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.dob AS dob_8, t0.picture AS picture_9, t0.job_id AS job_id_10 FROM employee t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.21 ms (2.97%) |
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
Second Level Cache is not enabled.