Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.87 ms
(82.42%)
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
  14700
  80332
  382681
  389966
  404731
  405191
  412984
  415755
  418886
  429888
  430792
  439521
  440863
  441853
  443095
  453112
  455088
  455886
  457003
  466869
  473750
  476046
  476900
  478510
  479821
  480406
  480470
  485638
  485646
  488753
  491914
  494231
  501258
  503113
  504450
  506516
  512781
  514243
  517633
  519246
  519299
  522343
  522795
  527409
  528293
  528862
  529609
  529648
  531262
  531871
  531882
  533380
  533460
  536576
  542203
  544163
  545294
  547466
  547478
  548834
  550680
  550896
  552664
  555297
  555394
  555567
  560211
  564222
  564551
  573734
  575300
  589058
  600017
  601357
  603772
  604361
  604418
  620260
  628518
  639710
  641126
  671487
  672383
  673503
  681746
  688666
  689001
  695879
  710814
  711998
  715894
  725475
  736674
  741067
  742636
  750301
  760313
  761711
  766588
  770963
  778882
  786174
  788173
  789496
  789950
  790515
  790926
  791803
  791812
  792142
  792541
  794124
  804528
  804674
  806180
  812988
  813581
  815370
  818456
  825514
]
14.94 ms
(9.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
  531871
  542203
  671487
  695879
  812988
  794124
  710814
  778882
  725475
  689001
  476046
  415755
  519246
  501258
  786174
  791812
  760313
  790515
  715894
  789496
  736674
  792541
  560211
  552664
  441853
  555567
  439521
  418886
  429888
  813581
  825514
  488753
  529648
  533460
  517633
  529609
  531882
  545294
  550896
  548834
  564222
  673503
  681746
  628518
  603772
  604418
  620260
  589058
  790926
  792142
  741067
  766588
  789950
  804528
  770963
  761711
  804674
  806180
  641126
  564551
  750301
  604361
  550680
  742636
  528862
  791803
  405191
  430792
  485638
  455088
  480406
  491914
  503113
  522795
  527409
  466869
  80332
  506516
  531262
  533380
  555297
  672383
  688666
  473750
  514243
  494231
  440863
  457003
  815370
  818456
  480470
  453112
  478510
  512781
  536576
  547466
  547478
  573734
  555394
  575300
  711998
  601357
  600017
  639710
  519299
  528293
  788173
  522343
  504450
  14700
  455886
  479821
  485646
  476900
  382681
  389966
  404731
  412984
  443095
  544163
]
4.36 ms
(2.84%)
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
  14700
  80332
  382681
  389966
  404731
  405191
  412984
  415755
  418886
  429888
  430792
  439521
  440863
  441853
  443095
  453112
  455088
  455886
  457003
  466869
  473750
  476046
  476900
  478510
  479821
  480406
  480470
  485638
  485646
  488753
  491914
  494231
  501258
  503113
  504450
  506516
  512781
  514243
  517633
  519246
  519299
  522343
  522795
  527409
  528293
  528862
  529609
  529648
  531262
  531871
  531882
  533380
  533460
  536576
  542203
  544163
  545294
  547466
  547478
  548834
  550680
  550896
  552664
  555297
  555394
  555567
  560211
  564222
  564551
  573734
  575300
  589058
  600017
  601357
  603772
  604361
  604418
  620260
  628518
  639710
  641126
  671487
  672383
  673503
  681746
  688666
  689001
  695879
  710814
  711998
  715894
  725475
  736674
  741067
  742636
  750301
  760313
  761711
  766588
  770963
  778882
  786174
  788173
  789496
  789950
  790515
  790926
  791803
  791812
  792142
  792541
  794124
  804528
  804674
  806180
  812988
  813581
  815370
  818456
  825514
]
1.98 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелую в анал с игрушками"
]
1.97 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин анал игрушк"
]
1.96 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "зрелая женщин анал игрушк"
]
1.84 ms
(1.20%)
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.