Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.81 ms
(79.32%)
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
  420418
  420504
  420664
  424873
  427631
  429817
  437537
  440700
  442262
  442918
  443440
  446587
  447722
  449666
  449688
  449847
  450913
  451156
  451163
  452456
  452462
  452545
  452622
  453425
  456811
  457089
  457887
  460860
  465301
  467746
  468396
  478563
  479457
  483279
  485939
  487872
  489434
  490559
  492528
  494627
  494820
  499043
  501358
  506599
  507966
  508836
  511358
  511361
  511581
  511882
  512844
  513228
  514721
  517337
  519213
  524577
  525207
  527135
  527678
  528123
  528125
  533256
  537180
  543399
  543906
  548866
  551025
  551086
  551886
  552628
  553774
  554240
  555325
  555510
  555987
  556922
  558358
  559109
  561521
  565866
  571134
  573405
  578610
  580532
  581625
  582417
  586263
  590423
  592643
  593742
  593876
  595081
  597920
  598195
  598355
  600459
  600990
  604344
  607277
  607666
  608037
  608613
  615823
  623212
  631859
  632551
  632818
  641901
  650983
  670183
  701397
  723629
  729344
  729398
  749725
  771918
  791943
  798677
  801742
  810119
]
21.19 ms
(13.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
  492528
  723629
  533256
  553774
  650983
  801742
  749725
  608037
  701397
  420504
  437537
  427631
  442262
  450913
  452622
  479457
  489434
  446587
  465301
  452462
  452545
  467746
  511358
  528123
  517337
  528125
  485939
  559109
  578610
  543399
  551086
  552628
  555987
  558358
  573405
  582417
  565866
  670183
  548866
  551025
  556922
  561521
  581625
  593876
  598195
  600459
  607277
  607666
  592643
  631859
  586263
  590423
  595081
  598355
  791943
  810119
  771918
  615823
  632551
  632818
  798677
  453425
  468396
  478563
  420418
  457089
  440700
  443440
  420664
  451156
  449847
  451163
  501358
  507966
  511361
  524577
  527678
  511882
  514721
  519213
  494627
  494820
  525207
  487872
  490559
  508836
  511581
  513228
  527135
  424873
  554240
  729398
  571134
  729344
  580532
  447722
  449666
  452456
  457887
  460860
  456811
  449688
  499043
  506599
  512844
  537180
  483279
  543906
  551886
  555510
  555325
  597920
  623212
  600990
  593742
  608613
  604344
  641901
  429817
  442918
]
3.10 ms
(1.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.48 ms
(1.59%)
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
  420418
  420504
  420664
  424873
  427631
  429817
  437537
  440700
  442262
  442918
  443440
  446587
  447722
  449666
  449688
  449847
  450913
  451156
  451163
  452456
  452462
  452545
  452622
  453425
  456811
  457089
  457887
  460860
  465301
  467746
  468396
  478563
  479457
  483279
  485939
  487872
  489434
  490559
  492528
  494627
  494820
  499043
  501358
  506599
  507966
  508836
  511358
  511361
  511581
  511882
  512844
  513228
  514721
  517337
  519213
  524577
  525207
  527135
  527678
  528123
  528125
  533256
  537180
  543399
  543906
  548866
  551025
  551086
  551886
  552628
  553774
  554240
  555325
  555510
  555987
  556922
  558358
  559109
  561521
  565866
  571134
  573405
  578610
  580532
  581625
  582417
  586263
  590423
  592643
  593742
  593876
  595081
  597920
  598195
  598355
  600459
  600990
  604344
  607277
  607666
  608037
  608613
  615823
  623212
  631859
  632551
  632818
  641901
  650983
  670183
  701397
  723629
  729344
  729398
  749725
  771918
  791943
  798677
  801742
  810119
]
1.87 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "best of pov"
]
1.84 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "best пов"
]
1.81 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "best пов"
]

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.