Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.41 ms
(82.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
  366354
  387258
  390180
  396450
  403519
  404451
  413175
  414845
  418073
  418079
  418270
  418939
  418948
  420231
  422735
  427897
  428104
  428334
  430748
  437463
  443573
  445499
  446173
  450814
  452079
  452206
  458001
  458106
  458341
  460071
  462436
  472151
  472831
  475262
  476340
  476578
  477338
  482780
  483251
  488936
  493197
  494720
  497428
  502284
  503683
  506762
  509373
  510463
  512781
  513005
  513331
  514130
  523316
  530729
  532484
  538276
  538653
  539786
  542224
  543920
  544834
  549270
  554315
  554927
  557851
  563858
  564342
  564719
  565152
  565700
  568546
  575762
  576698
  576721
  586398
  590501
  596973
  598177
  600258
  603134
  606838
  608620
  610666
  615636
  624802
  624803
  630612
  633937
  637694
  639334
  642665
  662143
  671208
  674414
  681189
  713565
  720245
  726512
  726537
  726546
  726587
  746774
  759724
  761208
  770402
  771649
  789525
  789692
  792606
  792652
  796105
  810765
  810978
  814743
  814891
  815883
  815885
  815960
  820767
  823303
]
18.87 ms
(10.82%)
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
  624803
  796105
  761208
  770402
  726546
  771649
  610666
  637694
  789692
  810978
  414845
  428104
  396450
  403519
  418270
  418948
  445499
  390180
  418073
  420231
  458106
  502284
  494720
  523316
  639334
  446173
  510463
  366354
  387258
  404451
  413175
  418939
  437463
  428334
  418079
  823303
  815960
  820767
  477338
  483251
  458341
  472151
  476340
  452206
  482780
  488936
  506762
  538653
  512781
  513005
  497428
  503683
  532484
  460071
  542224
  575762
  564342
  565152
  568546
  713565
  662143
  681189
  549270
  557851
  624802
  590501
  603134
  615636
  633937
  789525
  792606
  726512
  726537
  746774
  726587
  759724
  606838
  608620
  792652
  450814
  430748
  509373
  514130
  422735
  427897
  443573
  814743
  814891
  815885
  815883
  452079
  458001
  472831
  462436
  475262
  476578
  493197
  530729
  539786
  538276
  513331
  565700
  576698
  576721
  543920
  554315
  554927
  563858
  564719
  671208
  720245
  674414
  544834
  600258
  642665
  586398
  596973
  598177
  630612
  810765
]
3.28 ms
(1.88%)
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
  366354
  387258
  390180
  396450
  403519
  404451
  413175
  414845
  418073
  418079
  418270
  418939
  418948
  420231
  422735
  427897
  428104
  428334
  430748
  437463
  443573
  445499
  446173
  450814
  452079
  452206
  458001
  458106
  458341
  460071
  462436
  472151
  472831
  475262
  476340
  476578
  477338
  482780
  483251
  488936
  493197
  494720
  497428
  502284
  503683
  506762
  509373
  510463
  512781
  513005
  513331
  514130
  523316
  530729
  532484
  538276
  538653
  539786
  542224
  543920
  544834
  549270
  554315
  554927
  557851
  563858
  564342
  564719
  565152
  565700
  568546
  575762
  576698
  576721
  586398
  590501
  596973
  598177
  600258
  603134
  606838
  608620
  610666
  615636
  624802
  624803
  630612
  633937
  637694
  639334
  642665
  662143
  671208
  674414
  681189
  713565
  720245
  726512
  726537
  726546
  726587
  746774
  759724
  761208
  770402
  771649
  789525
  789692
  792606
  792652
  796105
  810765
  810978
  814743
  814891
  815883
  815885
  815960
  820767
  823303
]
2.09 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "housewife interracial"
]
2.04 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "housewife межрасов"
]
1.96 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "housewife межрасов"
]
1.70 ms
(0.98%)
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.