Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.17 ms
(83.56%)
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
  387106
  396172
  400864
  422557
  423019
  424582
  446634
  469905
  493192
  495152
  504386
  509473
  515090
  528340
  530814
  539520
  540175
  540211
  542976
  557964
  565042
  578158
  580088
  581380
  581697
  586185
  591720
  592426
  593379
  607175
  611349
  612207
  612925
  618919
  619271
  623338
  624394
  626733
  632682
  652667
  653300
  654438
  658225
  671523
  671832
  703110
  707881
  708102
  708459
  708823
  715123
  715860
  716164
  716792
  717848
  718708
  720786
  720802
  721574
  726082
  727620
  728008
  728290
  728431
  728799
  730475
  730492
  730508
  731432
  732420
  733176
  735570
  736918
  740500
  743303
  744984
  747568
  747839
  749733
  753134
  753684
  754778
  755255
  755696
  757151
  757891
  758032
  760466
  760586
  761592
  762248
  762702
  765798
  767155
  767962
  768120
  770981
  771254
  773084
  773578
  779913
  792698
  792722
  792765
  798359
  798585
  804903
  804972
  805197
  806277
  807698
  807703
  807709
  808236
  809652
  809705
  812105
  813904
  813905
  814144
]
13.39 ms
(8.86%)
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
  806277
  809652
  733176
  740500
  762702
  771254
  728008
  730475
  753684
  755255
  755696
  767962
  728431
  728799
  730508
  743303
  747568
  768120
  726082
  736918
  744984
  754778
  757891
  758032
  760586
  762248
  765798
  770981
  773084
  773578
  611349
  618919
  703110
  715860
  716164
  717848
  798585
  804903
  396172
  387106
  423019
  446634
  814144
  540211
  528340
  557964
  654438
  671832
  708459
  652667
  580088
  607175
  624394
  612207
  612925
  807709
  792765
  761592
  798359
  804972
  808236
  809705
  749733
  732420
  753134
  623338
  792722
  805197
  469905
  424582
  539520
  542976
  721574
  792698
  760466
  728290
  735570
  504386
  493192
  400864
  422557
  813904
  813905
  495152
  509473
  530814
  540175
  515090
  578158
  581697
  565042
  581380
  671523
  707881
  653300
  715123
  718708
  720786
  658225
  708102
  708823
  716792
  720802
  592426
  626733
  586185
  591720
  619271
  632682
  593379
  779913
  807703
  727620
  757151
  767155
  807698
  812105
  731432
  747839
  730492
]
3.54 ms
(2.35%)
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
  387106
  396172
  400864
  422557
  423019
  424582
  446634
  469905
  493192
  495152
  504386
  509473
  515090
  528340
  530814
  539520
  540175
  540211
  542976
  557964
  565042
  578158
  580088
  581380
  581697
  586185
  591720
  592426
  593379
  607175
  611349
  612207
  612925
  618919
  619271
  623338
  624394
  626733
  632682
  652667
  653300
  654438
  658225
  671523
  671832
  703110
  707881
  708102
  708459
  708823
  715123
  715860
  716164
  716792
  717848
  718708
  720786
  720802
  721574
  726082
  727620
  728008
  728290
  728431
  728799
  730475
  730492
  730508
  731432
  732420
  733176
  735570
  736918
  740500
  743303
  744984
  747568
  747839
  749733
  753134
  753684
  754778
  755255
  755696
  757151
  757891
  758032
  760466
  760586
  761592
  762248
  762702
  765798
  767155
  767962
  768120
  770981
  771254
  773084
  773578
  779913
  792698
  792722
  792765
  798359
  798585
  804903
  804972
  805197
  806277
  807698
  807703
  807709
  808236
  809652
  809705
  812105
  813904
  813905
  814144
]
2.31 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дедушка кончил"
]
2.00 ms
(1.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старый сперм"
]
1.95 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.