Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.80 ms
(77.02%)
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
  391306
  410353
  411107
  418064
  419109
  432227
  440736
  442897
  444329
  446163
  455100
  455105
  455108
  456689
  458742
  459593
  460194
  461506
  461516
  461520
  461535
  461537
  461538
  461545
  461549
  461552
  461566
  461597
  462045
  462805
  462811
  465930
  466322
  467132
  467161
  467252
  467617
  472306
  472347
  472353
  472396
  476213
  476402
  477365
  478260
  482129
  483594
  487025
  487069
  487086
  487114
  488201
  488206
  491199
  494843
  500531
  500917
  507802
  508872
  508876
  508881
  510618
  511730
  511743
  511746
  512293
  512323
  512335
  512337
  514264
  514668
  517574
  517604
  522590
  523127
  524732
  526496
  527630
  538544
  542053
  542792
  544975
  547949
  561876
  574480
  574509
  574805
  574854
  574914
  575478
  576854
  587749
  588016
  590307
  590546
  605617
  654650
  655113
  656384
  657039
  657281
  657353
  657381
  659701
  662908
  667312
  698008
  698657
  720288
  723941
  725861
  729832
  731192
  731735
  734368
  734715
  748436
  755918
  802462
  827958
]
26.84 ms
(16.70%)
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
  458742
  462811
  467161
  460194
  461537
  467252
  472347
  459593
  467617
  472353
  511743
  512293
  512323
  487086
  511730
  494843
  510618
  523127
  487114
  512337
  524732
  698657
  723941
  729832
  734715
  725861
  731735
  657039
  657353
  657281
  657381
  547949
  576854
  542053
  542792
  590307
  588016
  472396
  574805
  590546
  659701
  731192
  655113
  654650
  656384
  827958
  667312
  446163
  456689
  574480
  461506
  507802
  527630
  488201
  538544
  488206
  500531
  514264
  720288
  605617
  483594
  734368
  748436
  755918
  544975
  561876
  574854
  574914
  662908
  575478
  587749
  698008
  500917
  391306
  410353
  418064
  411107
  419109
  517604
  574509
  802462
  467132
  476213
  472306
  455100
  461520
  461535
  461538
  461549
  461552
  461566
  461597
  462805
  466322
  476402
  477365
  478260
  432227
  440736
  442897
  444329
  455105
  455108
  462045
  482129
  461516
  461545
  465930
  508876
  511746
  522590
  512335
  514668
  517574
  526496
  487025
  487069
  491199
  508872
  508881
]
2.60 ms
(1.62%)
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
  391306
  410353
  411107
  418064
  419109
  432227
  440736
  442897
  444329
  446163
  455100
  455105
  455108
  456689
  458742
  459593
  460194
  461506
  461516
  461520
  461535
  461537
  461538
  461545
  461549
  461552
  461566
  461597
  462045
  462805
  462811
  465930
  466322
  467132
  467161
  467252
  467617
  472306
  472347
  472353
  472396
  476213
  476402
  477365
  478260
  482129
  483594
  487025
  487069
  487086
  487114
  488201
  488206
  491199
  494843
  500531
  500917
  507802
  508872
  508876
  508881
  510618
  511730
  511743
  511746
  512293
  512323
  512335
  512337
  514264
  514668
  517574
  517604
  522590
  523127
  524732
  526496
  527630
  538544
  542053
  542792
  544975
  547949
  561876
  574480
  574509
  574805
  574854
  574914
  575478
  576854
  587749
  588016
  590307
  590546
  605617
  654650
  655113
  656384
  657039
  657281
  657353
  657381
  659701
  662908
  667312
  698008
  698657
  720288
  723941
  725861
  729832
  731192
  731735
  734368
  734715
  748436
  755918
  802462
  827958
]
2.13 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cuckold big dick"
]
1.98 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куколд большой большие член"
]
1.84 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.96%)
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.