Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.75 ms
(87.66%)
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
  384514
  384838
  386283
  388769
  395508
  412620
  413089
  415425
  416407
  417854
  420322
  424388
  426934
  427045
  428443
  428466
  430486
  434193
  437338
  439441
  440702
  440741
  442415
  442443
  443818
  447687
  447813
  449346
  449853
  450855
  454046
  454398
  454862
  454863
  454869
  457186
  459371
  459685
  464480
  467354
  478948
  482485
  493188
  493217
  499326
  506186
  515009
  515772
  521361
  530347
  543638
  547518
  550616
  552905
  554248
  556508
  557484
  559535
  563112
  563680
  565650
  579921
  580266
  591119
  593873
  596704
  603014
  604698
  609423
  610275
  613239
  622412
  623147
  623230
  623358
  625100
  627626
  644664
  663375
  663512
  664831
  664854
  665342
  687441
  693396
  697650
  705070
  707876
  715387
  726470
  726561
  726598
  728271
  728455
  728927
  738013
  739612
  742862
  742956
  748337
  775155
  776703
  795287
  799556
  800942
  801950
  803719
  805283
  805819
  807284
  807728
  809493
  810521
  810831
  811219
  812566
  812785
  817974
  825328
]
12.27 ms
(6.95%)
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
  416407
  426934
  454862
  493188
  554248
  427045
  412620
  552905
  687441
  663375
  697650
  563680
  604698
  622412
  609423
  610275
  805283
  807284
  812785
  739612
  774140
  728455
  742956
  728927
  805819
  467354
  430486
  559535
  424388
  428466
  384838
  825328
  817974
  449853
  515772
  665342
  693396
  579921
  596704
  623147
  625100
  812566
  803719
  726598
  420322
  454863
  440741
  565650
  493217
  439441
  482485
  563112
  664831
  707876
  663512
  623230
  603014
  810521
  795287
  644664
  417854
  591119
  454046
  447687
  521361
  428443
  395508
  413089
  415425
  434193
  440702
  442415
  447813
  464480
  530347
  515009
  547518
  580266
  543638
  557484
  705070
  664854
  715387
  550616
  627626
  613239
  593873
  799556
  801950
  807728
  809493
  810831
  775155
  748337
  726470
  726561
  728271
  742862
  738013
  623358
  776703
  459371
  442443
  454398
  459685
  443818
  388769
  449346
  506186
  386283
  800942
  811219
  384514
  556508
  437338
  457186
  499326
  450855
  454869
  478948
]
3.09 ms
(1.75%)
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
  384514
  384838
  386283
  388769
  395508
  412620
  413089
  415425
  416407
  417854
  420322
  424388
  426934
  427045
  428443
  428466
  430486
  434193
  437338
  439441
  440702
  440741
  442415
  442443
  443818
  447687
  447813
  449346
  449853
  450855
  454046
  454398
  454862
  454863
  454869
  457186
  459371
  459685
  464480
  467354
  478948
  482485
  493188
  493217
  499326
  506186
  515009
  515772
  521361
  530347
  543638
  547518
  550616
  552905
  554248
  556508
  557484
  559535
  563112
  563680
  565650
  579921
  580266
  591119
  593873
  596704
  603014
  604698
  609423
  610275
  613239
  622412
  623147
  623230
  623358
  625100
  627626
  644664
  663375
  663512
  664831
  664854
  665342
  687441
  693396
  697650
  705070
  707876
  715387
  726470
  726561
  726598
  728271
  728455
  728927
  738013
  739612
  742862
  742956
  748337
  775155
  776703
  795287
  799556
  800942
  801950
  803719
  805283
  805819
  807284
  807728
  809493
  810521
  810831
  811219
  812566
  812785
  817974
  825328
]
1.99 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дрочит во сне"
]
1.45 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк спящ"
]
1.28 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.