Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.70 ms
(81.88%)
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
  311697
  396823
  403417
  404072
  446388
  452862
  477703
  483423
  485855
  500538
  504516
  527459
  528513
  528884
  529344
  530197
  530240
  534716
  536115
  536151
  547225
  550521
  553887
  568789
  572195
  572713
  577705
  581139
  582944
  583314
  585767
  585787
  587329
  588018
  588043
  590276
  594623
  595027
  596675
  598345
  598980
  600404
  600747
  601955
  603842
  603967
  605678
  606200
  607793
  609774
  618462
  619700
  620489
  625480
  625685
  627143
  640356
  640442
  641434
  643327
  643765
  647027
  661058
  664241
  674524
  682866
  688699
  692679
  695051
  696135
  698025
  706379
  706542
  706693
  707489
  707766
  708073
  716876
  719938
  719972
  720848
  727381
  727388
  727915
  728144
  728722
  728814
  728853
  729842
  730341
  733594
  733946
  734197
  734620
  735192
  735358
  738233
  739332
  739686
  741672
  742590
  743769
  745216
  746117
  748714
  748954
  749138
  749176
  757274
  772504
  787888
  789063
  792615
  795765
  803351
  818134
  824775
  825108
  826730
]
18.31 ms
(11.30%)
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
  587329
  588018
  596675
  598345
  600404
  600747
  606200
  618462
  620489
  746117
  733594
  446388
  452862
  485855
  483423
  403417
  735192
  743769
  396823
  404072
  530240
  534716
  530197
  528513
  527459
  572713
  674524
  692679
  695051
  698025
  720848
  688699
  706379
  661058
  696135
  706693
  708073
  719972
  547225
  553887
  583314
  605678
  640442
  643327
  590276
  607793
  619700
  641434
  595027
  627143
  795765
  789063
  803351
  727915
  734197
  745216
  749176
  757274
  733946
  734620
  766431
  727388
  741672
  742590
  748714
  728814
  728853
  729842
  730341
  738233
  739686
  748954
  749138
  728722
  601955
  625480
  643765
  706542
  707489
  707766
  716876
  719938
  787888
  792615
  311697
  568789
  581139
  735358
  739332
  818134
  826730
  825108
  824775
  529344
  550521
  728144
  727381
  772504
  477703
  500538
  504516
  536115
  536151
  528884
  577705
  582944
  664241
  647027
  682866
  572195
  585767
  585787
  594623
  598980
  603842
  603967
  588043
  609774
  640356
  625685
]
3.45 ms
(2.13%)
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
  311697
  396823
  403417
  404072
  446388
  452862
  477703
  483423
  485855
  500538
  504516
  527459
  528513
  528884
  529344
  530197
  530240
  534716
  536115
  536151
  547225
  550521
  553887
  568789
  572195
  572713
  577705
  581139
  582944
  583314
  585767
  585787
  587329
  588018
  588043
  590276
  594623
  595027
  596675
  598345
  598980
  600404
  600747
  601955
  603842
  603967
  605678
  606200
  607793
  609774
  618462
  619700
  620489
  625480
  625685
  627143
  640356
  640442
  641434
  643327
  643765
  647027
  661058
  664241
  674524
  682866
  688699
  692679
  695051
  696135
  698025
  706379
  706542
  706693
  707489
  707766
  708073
  716876
  719938
  719972
  720848
  727381
  727388
  727915
  728144
  728722
  728814
  728853
  729842
  730341
  733594
  733946
  734197
  734620
  735192
  735358
  738233
  739332
  739686
  741672
  742590
  743769
  745216
  746117
  748714
  748954
  749138
  749176
  757274
  772504
  787888
  789063
  792615
  795765
  803351
  818134
  824775
  825108
  826730
]
2.34 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock sperm"
]
2.03 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock сперм"
]
1.63 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cock сперм"
]

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.