Query Metrics
4
Database Queries
3
Different statements
11.31 ms
Query time
0
Invalid entities
18
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.68 ms (59.06%) |
1 |
SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id = ?
Parameters:
[
"362"
]
|
|
2.64 ms (23.36%) |
2 |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (?)
Parameters:
[
1110
]
|
|
1.99 ms (17.59%) |
1 |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.id = ?
Parameters:
[
"1110"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
18
Hits
0
Misses
0
Puts
Number of cache hits
| Region | Hits |
|---|---|
| app_entity_settings | 16 |
| app_entity_magazine | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Settings | No errors. |
| App\Entity\Magazine | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Moderator | No errors. |
| App\Entity\MagazineOwnershipRequest | No errors. |
| App\Entity\ModeratorRequest | No errors. |
| App\Entity\Entry | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\MagazineSubscription | No errors. |
| App\Entity\MagazineBan | No errors. |
| App\Entity\Report | No errors. |
| App\Entity\Badge | No errors. |
| App\Entity\MagazineLog | No errors. |
| App\Entity\Award | No errors. |
| App\Entity\CategoryMagazine | No errors. |
| App\Entity\User | No errors. |
| App\Entity\PostComment | No errors. |
| App\Entity\Vote | No errors. |
| App\Entity\PostVote | No errors. |
| App\Entity\PostReport | No errors. |
| App\Entity\Favourite | No errors. |
| App\Entity\PostFavourite | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\PostCreatedNotification | No errors. |
| App\Entity\PostCommentVote | No errors. |
| App\Entity\PostCommentReport | No errors. |
| App\Entity\PostCommentFavourite | No errors. |
| App\Entity\PostCommentCreatedNotification | No errors. |