Query Metrics

7 Database Queries
7 Different statements
141.19 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
119.46 ms
(84.60%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  73289
  91248
  351182
  382249
  384337
  386531
  387664
  388685
  391380
  395236
  395984
  396101
  397300
  398270
  401646
  409942
  419668
  425022
  429042
  444158
  457459
  457472
  459382
  459866
  460770
  470118
  471475
  474579
  484638
  491286
  493986
  496818
  500674
  514386
  547220
  547417
  566871
  568929
  578734
  582514
  585998
  596198
  598723
  604309
  605328
  605886
  620246
  640537
  643516
  645912
  649585
  669298
  671597
  690346
  690517
  694324
  695631
  696522
  698704
  699400
  701850
  702633
  706254
  717066
  718755
  719002
  719431
  719898
  720682
  722609
  725176
  726923
  727689
  727798
  728432
  731595
  732000
  739934
  742461
  743378
  747576
  748973
  752717
  756106
  756418
  758991
  758997
  760192
  760971
  765441
  766688
  766812
  769829
  769892
  778347
  784277
  789253
  790203
  790857
  793677
  797428
  799815
  799981
  805996
  811148
  811946
  812076
  813377
  813553
  813947
  818209
  818531
  818867
  820899
  820921
  821197
  821937
  823136
  827592
]
12.11 ms
(8.58%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  474579
  769829
  568929
  598723
  457459
  457472
  459382
  514386
  491286
  813947
  820921
  821937
  547417
  695631
  699400
  702633
  649585
  696522
  690517
  719431
  585998
  643516
  797428
  731595
  747576
  765441
  727798
  748973
  756418
  758991
  728432
  769892
  727689
  732000
  743378
  766812
  756106
  760971
  640537
  718755
  382249
  395236
  827592
  818209
  818531
  566871
  719002
  722609
  671597
  694324
  690346
  547220
  605886
  596198
  812076
  760192
  766688
  811946
  725176
  770352
  739934
  758997
  742461
  701850
  717066
  778347
  790203
  790857
  793677
  799981
  419668
  789253
  386531
  91248
  387664
  429042
  459866
  493986
  388685
  397300
  460770
  578734
  719898
  726923
  813377
  391380
  484638
  500674
  706254
  669298
  401646
  384337
  398270
  720682
  799815
  811148
  752717
  470118
  582514
  605328
  396101
  620246
  425022
  821197
  823136
  698704
  604309
  784277
  351182
  444158
  813553
  805996
  471475
  395984
  496818
  73289
  409942
  818867
  820899
  645912
]
2.86 ms
(2.03%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  73289
  91248
  351182
  382249
  384337
  386531
  387664
  388685
  391380
  395236
  395984
  396101
  397300
  398270
  401646
  409942
  419668
  425022
  429042
  444158
  457459
  457472
  459382
  459866
  460770
  470118
  471475
  474579
  484638
  491286
  493986
  496818
  500674
  514386
  547220
  547417
  566871
  568929
  578734
  582514
  585998
  596198
  598723
  604309
  605328
  605886
  620246
  640537
  643516
  645912
  649585
  669298
  671597
  690346
  690517
  694324
  695631
  696522
  698704
  699400
  701850
  702633
  706254
  717066
  718755
  719002
  719431
  719898
  720682
  722609
  725176
  726923
  727689
  727798
  728432
  731595
  732000
  739934
  742461
  743378
  747576
  748973
  752717
  756106
  756418
  758991
  758997
  760192
  760971
  765441
  766688
  766812
  769829
  769892
  778347
  784277
  789253
  790203
  790857
  793677
  797428
  799815
  799981
  805996
  811148
  811946
  812076
  813377
  813553
  813947
  818209
  818531
  818867
  820899
  820921
  821197
  821937
  823136
  827592
]
1.86 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебет типа в жопу"
]
1.79 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс анал"
]
1.60 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс анал"
]
1.53 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.

Entities Mapping

No loaded entities.