Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.92 ms
(85.41%)
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
  385092
  393533
  396184
  396456
  397059
  401260
  401306
  402013
  473733
  483500
  486275
  515129
  515140
  523205
  532843
  545607
  548548
  550092
  557517
  561901
  562373
  564678
  565046
  565259
  568058
  571210
  571212
  574538
  574826
  575115
  575211
  575472
  575488
  575734
  575791
  575795
  576043
  576056
  578463
  578498
  581664
  581683
  581688
  581707
  585136
  586665
  592358
  595465
  596501
  596616
  597965
  597997
  598568
  598699
  600107
  600115
  604142
  605326
  609682
  612925
  615718
  617408
  618671
  620298
  624216
  624223
  636273
  636274
  644078
  647850
  668646
  669737
  671644
  675370
  679381
  681843
  683564
  684963
  685767
  714464
  714480
  714497
  714500
  717814
  718689
  719716
  721439
  721744
  722689
  725648
  731921
  741109
  742143
  743224
  744612
  748140
  758871
  759553
  760214
  761005
  778980
  779860
  789875
  790374
  798992
  802596
  805639
  807985
  812138
  815778
  817244
  818779
  819573
  819608
  819613
  821102
  821344
  821725
  821829
  822295
]
18.68 ms
(9.18%)
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
  486275
  393533
  397059
  821344
  817244
  821725
  515129
  561901
  669737
  679381
  717814
  719716
  668646
  671644
  675370
  685767
  718689
  721439
  721744
  618671
  624216
  595465
  597965
  605326
  612925
  644078
  790374
  778980
  779860
  748140
  760214
  802596
  805639
  725648
  759553
  743224
  744612
  789875
  812138
  483500
  683564
  798992
  592358
  473733
  576043
  548548
  647850
  714497
  575472
  565259
  615718
  596616
  385092
  585136
  565046
  575115
  575211
  575488
  575795
  581707
  550092
  557517
  575791
  576056
  578463
  578498
  581688
  545607
  571212
  581664
  581683
  684963
  714464
  722689
  681843
  714480
  564678
  568058
  574538
  574826
  575734
  586665
  598568
  598699
  620298
  597997
  600107
  600115
  617408
  624223
  604142
  636274
  596501
  609682
  636273
  807985
  731921
  741109
  742143
  714500
  515140
  571210
  761005
  401260
  562373
  758871
  532843
  523205
  396456
  396184
  401306
  402013
  818779
  815778
  819573
  819608
  819613
  822295
  821102
  821829
]
3.52 ms
(1.73%)
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
  385092
  393533
  396184
  396456
  397059
  401260
  401306
  402013
  473733
  483500
  486275
  515129
  515140
  523205
  532843
  545607
  548548
  550092
  557517
  561901
  562373
  564678
  565046
  565259
  568058
  571210
  571212
  574538
  574826
  575115
  575211
  575472
  575488
  575734
  575791
  575795
  576043
  576056
  578463
  578498
  581664
  581683
  581688
  581707
  585136
  586665
  592358
  595465
  596501
  596616
  597965
  597997
  598568
  598699
  600107
  600115
  604142
  605326
  609682
  612925
  615718
  617408
  618671
  620298
  624216
  624223
  636273
  636274
  644078
  647850
  668646
  669737
  671644
  675370
  679381
  681843
  683564
  684963
  685767
  714464
  714480
  714497
  714500
  717814
  718689
  719716
  721439
  721744
  722689
  725648
  731921
  741109
  742143
  743224
  744612
  748140
  758871
  759553
  760214
  761005
  778980
  779860
  789875
  790374
  798992
  802596
  805639
  807985
  812138
  815778
  817244
  818779
  819573
  819608
  819613
  821102
  821344
  821725
  821829
  822295
]
2.18 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen small young"
]
1.96 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen маленькая young"
]
1.73 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen маленькая young"
]

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.