Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.33 ms
(81.82%)
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
  35344
  188169
  206202
  383436
  391559
  392466
  395706
  396168
  396691
  396877
  398595
  401134
  402592
  405315
  407810
  409100
  411175
  411682
  412227
  414021
  416044
  425304
  430313
  431776
  432157
  437346
  439564
  439582
  439620
  439656
  439664
  439726
  444834
  445200
  447258
  447560
  456193
  456697
  457140
  459527
  465805
  468608
  472551
  474631
  482211
  482824
  487729
  492256
  494567
  495148
  507785
  508438
  509025
  512549
  520445
  520986
  521059
  523579
  525011
  543863
  549569
  551913
  552083
  561304
  564407
  571999
  581668
  582236
  585023
  586463
  594916
  600623
  603627
  619189
  620025
  621467
  621767
  623143
  624835
  632028
  647937
  649154
  683889
  683945
  684017
  688604
  692382
  703955
  706909
  716834
  718798
  722653
  722823
  724186
  727526
  734146
  737719
  749338
  753260
  755406
  758615
  764582
  771180
  793762
  804180
  806308
  806420
  807551
  807772
  810689
  811133
  815592
  816584
  818644
  819611
  820158
  821026
  821745
  825812
  826764
]
17.12 ms
(11.55%)
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
  392466
  647937
  621467
  718798
  457140
  764582
  551913
  468608
  396168
  430313
  487729
  825812
  621767
  407810
  456697
  439620
  432157
  508438
  512549
  383436
  561304
  445200
  444834
  439582
  465805
  439656
  552083
  734146
  806308
  447560
  482211
  520445
  396877
  472551
  683889
  456193
  582236
  395706
  603627
  811133
  474631
  411682
  439564
  431776
  459527
  793762
  683945
  688604
  411175
  416044
  507785
  188169
  716834
  819611
  684017
  753260
  543863
  724186
  758615
  409100
  439726
  520986
  437346
  525011
  447258
  439664
  816584
  818644
  405315
  820158
  623143
  594916
  722823
  564407
  521059
  549569
  585023
  821026
  581668
  624835
  737719
  749338
  771180
  755406
  807551
  396691
  414021
  509025
  391559
  495148
  492256
  494567
  35344
  810689
  206202
  706909
  412227
  815592
  826764
  821745
  692382
  722653
  600623
  620025
  586463
  619189
  806420
  804180
  807772
  727526
  703955
  402592
  398595
  632028
  401134
  523579
  571999
  649154
  425304
  482824
]
2.75 ms
(1.85%)
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
  35344
  188169
  206202
  383436
  391559
  392466
  395706
  396168
  396691
  396877
  398595
  401134
  402592
  405315
  407810
  409100
  411175
  411682
  412227
  414021
  416044
  425304
  430313
  431776
  432157
  437346
  439564
  439582
  439620
  439656
  439664
  439726
  444834
  445200
  447258
  447560
  456193
  456697
  457140
  459527
  465805
  468608
  472551
  474631
  482211
  482824
  487729
  492256
  494567
  495148
  507785
  508438
  509025
  512549
  520445
  520986
  521059
  523579
  525011
  543863
  549569
  551913
  552083
  561304
  564407
  571999
  581668
  582236
  585023
  586463
  594916
  600623
  603627
  619189
  620025
  621467
  621767
  623143
  624835
  632028
  647937
  649154
  683889
  683945
  684017
  688604
  692382
  703955
  706909
  716834
  718798
  722653
  722823
  724186
  727526
  734146
  737719
  749338
  753260
  755406
  758615
  764582
  771180
  793762
  804180
  806308
  806420
  807551
  807772
  810689
  811133
  815592
  816584
  818644
  819611
  820158
  821026
  821745
  825812
  826764
]
2.16 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade young deepthroat"
]
1.81 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск young глубокийминет минет оральн секс"
]
1.51 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск young глубокийминет минет оральн секс"
]

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.