Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
189.37 ms
(88.98%)
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
  398965
  398972
  407616
  423703
  427634
  428932
  432716
  434008
  439223
  446789
  448328
  450845
  456509
  457413
  462242
  468357
  471461
  486175
  504017
  511937
  513017
  514073
  525198
  525998
  526187
  533599
  538972
  542043
  547543
  550451
  564191
  567602
  568992
  574050
  577805
  579725
  579734
  580129
  581594
  588334
  589820
  591320
  597746
  598469
  599653
  609644
  614831
  614852
  617949
  619856
  627822
  629990
  637494
  641593
  642571
  648437
  653987
  659192
  659401
  662213
  666473
  669665
  671560
  678992
  685106
  685509
  694751
  696115
  700965
  701237
  709654
  710571
  714348
  715175
  719443
  725448
  725500
  726805
  727037
  732787
  736020
  738001
  739675
  740986
  741523
  742319
  743479
  745072
  746135
  750579
  751012
  752913
  754321
  755343
  755878
  756289
  768884
  769380
  772609
  782404
  784916
  784969
  785309
  789054
  793494
  793877
  801364
  804696
  809064
  809548
  810635
  810646
  811068
  813136
  814378
  818117
  818686
  819058
  824371
  827968
]
14.26 ms
(6.70%)
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
  427634
  432716
  818117
  818686
  819058
  533599
  525198
  525998
  468357
  568992
  542043
  653987
  694751
  648437
  666473
  659192
  662213
  685106
  700965
  579725
  619856
  591320
  589820
  614852
  789054
  801364
  810646
  784969
  793494
  809548
  725448
  732787
  740986
  746135
  772609
  804696
  751012
  745072
  754321
  739675
  755343
  736020
  741523
  609644
  715175
  782404
  810635
  398965
  423703
  448328
  814378
  446789
  471461
  538972
  567602
  726805
  428932
  513017
  809064
  678992
  617949
  769380
  725500
  709654
  669665
  547543
  574050
  577805
  685509
  701237
  793877
  755878
  742319
  550451
  614831
  462242
  457413
  824371
  456509
  504017
  514073
  526187
  511937
  564191
  579734
  597746
  598469
  629990
  727037
  811068
  434008
  398972
  439223
  486175
  827968
  450845
  581594
  659401
  671560
  719443
  714348
  696115
  580129
  641593
  642571
  588334
  599653
  637494
  785309
  743479
  752913
  768884
  738001
  750579
  756289
  627822
  710571
  784916
  813136
  407616
]
2.98 ms
(1.40%)
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
  398965
  398972
  407616
  423703
  427634
  428932
  432716
  434008
  439223
  446789
  448328
  450845
  456509
  457413
  462242
  468357
  471461
  486175
  504017
  511937
  513017
  514073
  525198
  525998
  526187
  533599
  538972
  542043
  547543
  550451
  564191
  567602
  568992
  574050
  577805
  579725
  579734
  580129
  581594
  588334
  589820
  591320
  597746
  598469
  599653
  609644
  614831
  614852
  617949
  619856
  627822
  629990
  637494
  641593
  642571
  648437
  653987
  659192
  659401
  662213
  666473
  669665
  671560
  678992
  685106
  685509
  694751
  696115
  700965
  701237
  709654
  710571
  714348
  715175
  719443
  725448
  725500
  726805
  727037
  732787
  736020
  738001
  739675
  740986
  741523
  742319
  743479
  745072
  746135
  750579
  751012
  752913
  754321
  755343
  755878
  756289
  768884
  769380
  772609
  782404
  784916
  784969
  785309
  789054
  793494
  793877
  801364
  804696
  809064
  809548
  810635
  810646
  811068
  813136
  814378
  818117
  818686
  819058
  824371
  827968
]
1.80 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "masturbating большая большие жоп"
]
1.62 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbating big ass"
]
1.58 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.22 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "masturbating большая большие жоп"
]

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.