Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.78 ms
(84.72%)
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
  397111
  420201
  446111
  451945
  454362
  457165
  460697
  462055
  467310
  467844
  468610
  480006
  487019
  491654
  491664
  503802
  508777
  509400
  511707
  511711
  512247
  512828
  513284
  515178
  518520
  519925
  522565
  522593
  524694
  524704
  527859
  529173
  533522
  533736
  538576
  538800
  549584
  550091
  554365
  556307
  560478
  562770
  569523
  571957
  574874
  574916
  575066
  575084
  575097
  575203
  575454
  575458
  575486
  575503
  575748
  575807
  576028
  576054
  576063
  576079
  576100
  576370
  576371
  576372
  576406
  576412
  576646
  577130
  578173
  579792
  583984
  584222
  587929
  588786
  592314
  594779
  595869
  596622
  597593
  597793
  598821
  599361
  601994
  605456
  606816
  607204
  609568
  610728
  618561
  624255
  626154
  626534
  635225
  637098
  641120
  644657
  644959
  649602
  649830
  653854
  654552
  655071
  655358
  655639
  656058
  657057
  657287
  657296
  658082
  659615
  660963
  661974
  662143
  698821
  705875
  705907
  708476
  720393
  742449
  788881
]
15.18 ms
(8.59%)
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
  503802
  491664
  599361
  487019
  518520
  509400
  538576
  533736
  538800
  575084
  575454
  576406
  574874
  576028
  576054
  584222
  655639
  657057
  653854
  655071
  708476
  598821
  595869
  626534
  597593
  641120
  624255
  446111
  480006
  454362
  524704
  508777
  519925
  513284
  524694
  457165
  549584
  574916
  576412
  420201
  468610
  522593
  529173
  575066
  575486
  575503
  575097
  575203
  576063
  576370
  578173
  554365
  575807
  576371
  576646
  577130
  656058
  659615
  649602
  705875
  560478
  587929
  601994
  626154
  594779
  588786
  610728
  788881
  637098
  644657
  705907
  397111
  511711
  527859
  491654
  511707
  512828
  522565
  657287
  657296
  655358
  605456
  596622
  618561
  451945
  654552
  658082
  644959
  512247
  515178
  533522
  571957
  575458
  576100
  569523
  576372
  583984
  575748
  649830
  660963
  661974
  662143
  698821
  720393
  550091
  556307
  562770
  576079
  579792
  592314
  635225
  609568
  606816
  607204
  597793
  742449
  462055
  467844
  467310
  460697
]
3.95 ms
(2.24%)
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
  397111
  420201
  446111
  451945
  454362
  457165
  460697
  462055
  467310
  467844
  468610
  480006
  487019
  491654
  491664
  503802
  508777
  509400
  511707
  511711
  512247
  512828
  513284
  515178
  518520
  519925
  522565
  522593
  524694
  524704
  527859
  529173
  533522
  533736
  538576
  538800
  549584
  550091
  554365
  556307
  560478
  562770
  569523
  571957
  574874
  574916
  575066
  575084
  575097
  575203
  575454
  575458
  575486
  575503
  575748
  575807
  576028
  576054
  576063
  576079
  576100
  576370
  576371
  576372
  576406
  576412
  576646
  577130
  578173
  579792
  583984
  584222
  587929
  588786
  592314
  594779
  595869
  596622
  597593
  597793
  598821
  599361
  601994
  605456
  606816
  607204
  609568
  610728
  618561
  624255
  626154
  626534
  635225
  637098
  641120
  644657
  644959
  649602
  649830
  653854
  654552
  655071
  655358
  655639
  656058
  657057
  657287
  657296
  658082
  659615
  660963
  661974
  662143
  698821
  705875
  705907
  708476
  720393
  742449
  788881
]
2.29 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куколд teen"
]
2.02 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cuckold teen"
]
1.93 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куколд teen"
]

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.