Query Metrics
11
Database Queries
8
Different statements
116.44 ms
Query time
0
Invalid entities
18
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 5.13 ms |
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id = ?
Parameters:
[
"24264"
]
|
2 | 17.59 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.id = ?
Parameters:
[
"246592"
]
|
3 | 1.33 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?)
Parameters:
[
246592
]
|
4 | 6.04 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 246739 246843 246695 247553 246741 246787 248621 246822 ] |
5 | 6.19 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 246750 246791 246955 246781 247114 246957 246818 246929 247623 246941 246961 248121 247724 249576 ] |
6 | 14.92 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 246837 247384 248119 247478 247672 248798 249616 247028 248668 247138 247129 247433 250044 248987 ] |
7 | 0.93 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 247667 248762 247166 247181 247619 247380 247158 247686 249483 250023 248118 248124 271379 249470 ] |
8 | 0.67 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[ 247275 247913 247303 247915 249623 250688 ] |
9 | 0.56 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?, ?)
Parameters:
[ 247438 248196 249683 ] |
10 | 38.86 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?, ?)
Parameters:
[ 249457 249697 ] |
11 | 24.25 ms |
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.parent_id IN (?)
Parameters:
[
249881
]
|
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 |