Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.78 ms
(83.14%)
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
  9021
  29661
  38261
  80916
  81869
  146508
  210052
  412554
  421491
  422264
  424903
  428783
  432573
  433323
  433596
  438056
  438062
  438324
  441850
  442010
  444607
  446003
  452616
  453259
  455273
  461631
  462657
  463074
  464868
  465310
  467380
  468982
  469399
  472574
  477067
  477498
  478949
  483472
  483855
  485511
  487185
  488885
  501378
  506891
  508101
  509532
  509580
  509772
  512832
  515263
  516473
  517374
  520200
  525678
  527036
  527697
  529663
  530395
  531927
  532110
  543928
  544639
  552369
  555600
  571044
  597150
  599681
  605261
  622972
  644984
  680664
  695759
  697769
  710453
  712135
  715908
  725465
  725652
  727803
  728297
  731126
  731225
  733417
  735461
  736378
  737085
  739762
  741088
  742578
  746169
  746447
  746553
  746603
  753515
  753673
  759889
  761278
  761403
  768636
  769475
  774511
  789160
  791673
  792546
  795750
  795927
  795947
  795987
  806343
  808870
  809789
  811383
  811801
  813628
  817536
  817556
  824115
  827214
  828435
]
16.35 ms
(10.24%)
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
  725652
  769475
  477498
  81869
  477067
  483855
  695759
  739762
  746603
  80916
  428783
  422264
  9021
  210052
  769530
  737085
  795750
  543928
  644984
  472574
  506891
  485511
  759889
  731126
  789160
  817556
  827214
  817536
  795987
  774511
  791673
  795947
  741088
  761278
  795927
  433323
  146508
  441850
  809789
  811383
  529663
  712135
  746169
  742578
  768636
  725465
  746553
  824115
  680664
  544639
  728297
  753673
  727803
  438062
  483472
  444607
  465310
  531927
  532110
  530395
  715908
  597150
  806343
  469399
  421491
  446003
  735461
  697769
  527697
  828435
  622972
  761403
  516473
  509580
  438324
  512832
  733417
  29661
  813628
  599681
  731225
  424903
  552369
  433596
  38261
  605261
  753515
  438056
  412554
  455273
  468982
  478949
  452616
  487185
  517374
  463074
  527036
  746447
  811801
  453259
  808870
  508101
  571044
  792546
  442010
  509772
  520200
  555600
  501378
  432573
  736378
  710453
  461631
  509532
  515263
  525678
  488885
  462657
  467380
  464868
]
2.90 ms
(1.81%)
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
  9021
  29661
  38261
  80916
  81869
  146508
  210052
  412554
  421491
  422264
  424903
  428783
  432573
  433323
  433596
  438056
  438062
  438324
  441850
  442010
  444607
  446003
  452616
  453259
  455273
  461631
  462657
  463074
  464868
  465310
  467380
  468982
  469399
  472574
  477067
  477498
  478949
  483472
  483855
  485511
  487185
  488885
  501378
  506891
  508101
  509532
  509580
  509772
  512832
  515263
  516473
  517374
  520200
  525678
  527036
  527697
  529663
  530395
  531927
  532110
  543928
  544639
  552369
  555600
  571044
  597150
  599681
  605261
  622972
  644984
  680664
  695759
  697769
  710453
  712135
  715908
  725465
  725652
  727803
  728297
  731126
  731225
  733417
  735461
  736378
  737085
  739762
  741088
  742578
  746169
  746447
  746553
  746603
  753515
  753673
  759889
  761278
  761403
  768636
  769475
  774511
  789160
  791673
  792546
  795750
  795927
  795947
  795987
  806343
  808870
  809789
  811383
  811801
  813628
  817536
  817556
  824115
  827214
  828435
]
2.27 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамки дрочка члена"
]
2.18 ms
(1.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин дрочк член"
]
1.74 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.94%)
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.