Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.79 ms
(88.71%)
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
  124361
  187775
  203995
  373998
  381956
  387651
  391715
  395935
  396003
  401103
  405024
  413277
  424524
  426864
  429775
  435700
  446165
  448325
  448345
  455866
  456736
  457704
  459398
  468391
  468880
  474848
  476375
  478038
  478044
  479669
  483443
  488546
  498516
  499050
  500911
  500964
  501748
  505041
  506093
  506762
  507695
  513256
  517017
  517106
  517391
  517640
  519091
  520404
  522020
  525120
  527378
  527850
  527856
  528942
  534612
  535667
  535736
  536394
  555108
  557517
  557992
  574559
  576715
  580239
  582542
  583724
  585158
  588315
  601996
  604767
  610552
  617152
  620254
  620622
  623458
  632660
  633533
  634789
  640939
  641375
  643011
  667975
  673633
  675858
  692711
  697124
  705325
  705528
  708424
  710933
  712230
  717835
  720720
  721399
  722384
  722460
  723932
  724841
  726847
  741752
  755921
  758674
  758794
  760792
  767021
  776988
  786874
  787287
  790501
  790861
  790882
  799127
  802789
  804006
  804700
  810826
  814152
  814265
  817346
]
17.82 ms
(7.29%)
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
  787287
  724841
  604767
  373998
  448345
  535667
  623458
  726847
  387651
  124361
  203995
  479669
  582542
  708424
  588315
  776988
  804700
  755921
  804006
  760792
  723932
  758674
  758794
  721399
  459398
  507695
  500964
  722384
  722460
  643011
  786874
  741752
  424524
  426864
  483443
  401103
  528942
  381956
  468391
  517106
  527856
  817346
  580239
  675858
  692711
  790882
  790501
  767021
  634789
  705528
  710933
  717835
  513256
  697124
  802789
  790861
  395935
  506762
  536394
  525120
  632660
  617152
  468880
  396003
  478038
  527850
  506093
  522020
  446165
  456736
  457704
  471695
  517017
  500911
  583724
  633533
  640939
  501748
  527378
  187775
  814265
  814152
  474848
  520404
  534612
  673633
  705325
  585158
  641375
  810826
  601996
  712230
  620254
  391715
  488546
  517640
  519091
  557992
  576715
  555108
  799127
  405024
  429775
  448325
  535736
  498516
  499050
  505041
  478044
  574559
  667975
  720720
  435700
  517391
  557517
  620622
  610552
  455866
  476375
  413277
]
2.82 ms
(1.15%)
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
  124361
  187775
  203995
  373998
  381956
  387651
  391715
  395935
  396003
  401103
  405024
  413277
  424524
  426864
  429775
  435700
  446165
  448325
  448345
  455866
  456736
  457704
  459398
  468391
  468880
  474848
  476375
  478038
  478044
  479669
  483443
  488546
  498516
  499050
  500911
  500964
  501748
  505041
  506093
  506762
  507695
  513256
  517017
  517106
  517391
  517640
  519091
  520404
  522020
  525120
  527378
  527850
  527856
  528942
  534612
  535667
  535736
  536394
  555108
  557517
  557992
  574559
  576715
  580239
  582542
  583724
  585158
  588315
  601996
  604767
  610552
  617152
  620254
  620622
  623458
  632660
  633533
  634789
  640939
  641375
  643011
  667975
  673633
  675858
  692711
  697124
  705325
  705528
  708424
  710933
  712230
  717835
  720720
  721399
  722384
  722460
  723932
  724841
  726847
  741752
  755921
  758674
  758794
  760792
  767021
  776988
  786874
  787287
  790501
  790861
  790882
  799127
  802789
  804006
  804700
  810826
  814152
  814265
  817346
]
2.14 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "naughty anal"
]
1.72 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "naughty анал"
]
1.59 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "naughty анал"
]
1.52 ms
(0.62%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.