Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.29 ms
(83.09%)
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
  382419
  402896
  413544
  451946
  459867
  468721
  469069
  473505
  481173
  482679
  508236
  527689
  527988
  533601
  537698
  559602
  561771
  563522
  566971
  573938
  585668
  590190
  594955
  596692
  606417
  606684
  612188
  630479
  635138
  642659
  668401
  670111
  670190
  677133
  681134
  686035
  687505
  688106
  688567
  693256
  696165
  702050
  702947
  703437
  705120
  727451
  731623
  732562
  732938
  732953
  733029
  733128
  734728
  734730
  737066
  737089
  742709
  742902
  755388
  755464
  755466
  757071
  759580
  760763
  765147
  766698
  768420
  779663
  785361
  786510
  789502
  790387
  792608
  792754
  796219
  797009
  797664
  800110
  800541
  801465
  801609
  801646
  801839
  802101
  802450
  804477
  804494
  804583
  805015
  807930
  811085
  811428
  811493
  815173
  815256
  815397
  815462
  815484
  815518
  815768
  816083
  817312
  817323
  817443
  817718
  817852
  818123
  818133
  818281
  818333
  818402
  818422
  818495
  818822
  818882
  819054
  820875
  823563
  826349
]
15.39 ms
(9.67%)
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
  818822
  596692
  402896
  815256
  817323
  818123
  818133
  818281
  818333
  817443
  818422
  823563
  566971
  681134
  687505
  702947
  594955
  606684
  630479
  732562
  755388
  732938
  765147
  413544
  482679
  670190
  815768
  817718
  533601
  686035
  668401
  606417
  590190
  786510
  801646
  805015
  800541
  802101
  802450
  742709
  759580
  792608
  733029
  734728
  742902
  755466
  635138
  804477
  804583
  807930
  585668
  508236
  451946
  573938
  468721
  481173
  527689
  527988
  766698
  459867
  469069
  382419
  815462
  816083
  822897
  815397
  815484
  815518
  818495
  818402
  820875
  559602
  677133
  693256
  670111
  688106
  688567
  705120
  563522
  612188
  642659
  779663
  785361
  797664
  811493
  789502
  790387
  797009
  757071
  792754
  796219
  811085
  732953
  727451
  733128
  731623
  760763
  703437
  801465
  801609
  801839
  804494
  811428
  818882
  819054
  815173
  817312
  817852
  826349
  537698
  696165
  561771
  737066
  737089
  755464
  768420
  702050
  800110
  473505
  734730
]
3.53 ms
(2.22%)
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
  382419
  402896
  413544
  451946
  459867
  468721
  469069
  473505
  481173
  482679
  508236
  527689
  527988
  533601
  537698
  559602
  561771
  563522
  566971
  573938
  585668
  590190
  594955
  596692
  606417
  606684
  612188
  630479
  635138
  642659
  668401
  670111
  670190
  677133
  681134
  686035
  687505
  688106
  688567
  693256
  696165
  702050
  702947
  703437
  705120
  727451
  731623
  732562
  732938
  732953
  733029
  733128
  734728
  734730
  737066
  737089
  742709
  742902
  755388
  755464
  755466
  757071
  759580
  760763
  765147
  766698
  768420
  779663
  785361
  786510
  789502
  790387
  792608
  792754
  796219
  797009
  797664
  800110
  800541
  801465
  801609
  801646
  801839
  802101
  802450
  804477
  804494
  804583
  805015
  807930
  811085
  811428
  811493
  815173
  815256
  815397
  815462
  815484
  815518
  815768
  816083
  817312
  817323
  817443
  817718
  817852
  818123
  818133
  818281
  818333
  818402
  818422
  818495
  818822
  818882
  819054
  820875
  823563
  826349
]
2.15 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "милф куннилингус оральн секс"
]
2.04 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "милф кунилингус"
]
1.91 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "милф куннилингус оральн секс"
]
1.89 ms
(1.19%)
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.