Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.47 ms
(54.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
146.52 ms
(38.27%)
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
  396330
  405175
  407148
  409035
  410642
  410959
  411401
  412593
  413888
  414126
  414218
  417631
  418522
  418596
  419783
  421816
  421837
  421848
  424574
  425622
  425800
  425980
  426399
  426653
  428282
  429383
  429804
  430314
  430344
  431062
  431097
  431765
  432296
  432586
  433147
  433165
  433189
  433295
  433747
  434624
  435592
  439210
  439611
  439613
  439713
  440981
  444298
  446647
  447182
  448798
  448813
  449871
  450775
  451262
  452028
  452282
  452513
  454009
  454102
  455085
  456455
  456812
  457674
  457888
  458336
  458908
  465198
  466494
  468661
  468884
  468929
  469520
  471196
  472665
  472953
  475984
  476299
  476605
  477210
  485242
  486240
  486409
  492331
  492472
  492760
  493316
  494731
  496360
  499365
  502467
  504841
  506467
  513844
  516383
  517074
  518766
  519068
  522917
  525871
  525884
  527133
  529341
  531089
  541841
  555786
  555979
  556009
  572631
  580647
  586645
  587970
  592444
  592817
  599272
  603709
  615913
  617019
  625274
  667250
  792612
]
18.71 ms
(4.89%)
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
  572631
  580647
  555979
  667250
  555786
  586645
  592817
  625274
  592444
  615913
  617019
  792612
  396330
  421848
  424574
  431765
  439210
  446647
  449871
  458908
  421837
  428282
  432586
  439611
  414126
  435592
  455085
  458336
  466494
  471196
  405175
  411401
  440981
  472665
  468884
  529341
  493316
  502467
  517074
  518766
  519068
  499365
  525884
  477210
  450775
  504841
  603709
  412593
  492472
  429383
  430344
  414218
  432296
  433295
  433747
  434624
  429804
  452282
  468661
  476605
  457888
  476299
  486409
  454009
  457674
  468929
  513844
  516383
  527133
  492331
  541841
  587970
  444298
  448798
  421816
  418522
  425622
  451262
  465198
  409035
  425800
  439613
  407148
  426653
  439713
  454102
  475984
  494731
  485242
  522917
  410959
  431097
  417631
  413888
  425980
  433165
  452028
  447182
  448813
  469520
  472953
  456812
  531089
  496360
  556009
  599272
  419783
  433147
  410642
  426399
  430314
  456455
  418596
  433189
  452513
  431062
  525871
  486240
  492760
  506467
]
3.32 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature голые"
]
3.13 ms
(0.82%)
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
  396330
  405175
  407148
  409035
  410642
  410959
  411401
  412593
  413888
  414126
  414218
  417631
  418522
  418596
  419783
  421816
  421837
  421848
  424574
  425622
  425800
  425980
  426399
  426653
  428282
  429383
  429804
  430314
  430344
  431062
  431097
  431765
  432296
  432586
  433147
  433165
  433189
  433295
  433747
  434624
  435592
  439210
  439611
  439613
  439713
  440981
  444298
  446647
  447182
  448798
  448813
  449871
  450775
  451262
  452028
  452282
  452513
  454009
  454102
  455085
  456455
  456812
  457674
  457888
  458336
  458908
  465198
  466494
  468661
  468884
  468929
  469520
  471196
  472665
  472953
  475984
  476299
  476605
  477210
  485242
  486240
  486409
  492331
  492472
  492760
  493316
  494731
  496360
  499365
  502467
  504841
  506467
  513844
  516383
  517074
  518766
  519068
  522917
  525871
  525884
  527133
  529341
  531089
  541841
  555786
  555979
  556009
  572631
  580647
  586645
  587970
  592444
  592817
  599272
  603709
  615913
  617019
  625274
  667250
  792612
]
2.19 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature naked"
]
1.56 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature голые"
]

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.