Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
188.00 ms
(85.50%)
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
  393694
  402574
  412941
  419808
  423426
  442897
  443749
  444329
  445736
  447071
  451799
  454363
  455099
  455103
  455106
  456690
  460194
  460539
  461124
  461428
  461516
  461518
  461524
  461549
  461552
  461557
  462052
  465525
  466322
  467132
  467174
  467617
  467632
  468844
  471886
  472347
  474052
  476402
  478527
  478529
  480831
  482129
  487025
  487069
  487080
  487090
  491199
  491239
  500503
  507195
  508844
  511746
  512239
  512293
  512321
  512323
  512335
  512337
  513278
  513783
  513891
  515334
  515379
  517596
  517654
  522590
  524697
  524732
  527807
  533962
  544992
  547059
  548656
  549527
  552116
  552137
  552142
  558441
  558860
  560464
  560476
  566431
  573773
  573775
  574509
  574591
  575148
  575453
  575743
  575791
  575805
  576026
  576351
  576363
  592728
  597136
  605553
  632922
  650018
  650978
  651003
  653172
  654812
  656072
  657591
  658096
  658250
  658632
  659548
  660545
  660923
  663456
  705398
  715693
  732266
  742166
  759463
  782034
  793578
  818663
]
21.88 ms
(9.95%)
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
  515379
  512337
  527807
  467632
  654812
  656072
  660923
  659548
  759463
  468844
  467174
  549527
  574591
  576363
  461518
  461428
  455103
  455106
  412941
  455099
  480831
  461524
  461557
  513891
  507195
  478527
  456690
  533962
  552137
  715693
  742166
  508844
  512321
  575791
  515334
  402574
  423426
  451799
  460539
  445736
  461124
  491239
  513783
  548656
  552142
  560476
  573773
  575805
  576026
  573775
  574509
  575453
  552116
  558860
  560464
  575743
  650018
  663456
  575148
  576351
  597136
  632922
  732266
  462052
  467132
  460194
  461549
  461552
  466322
  474052
  476402
  442897
  444329
  447071
  454363
  472347
  478529
  482129
  461516
  467617
  511746
  512293
  512323
  522590
  487090
  512335
  487025
  487069
  491199
  487080
  512239
  524697
  524732
  419808
  650978
  705398
  393694
  443749
  558441
  500503
  818663
  658096
  517654
  592728
  471886
  517596
  544992
  658250
  660545
  566431
  651003
  513278
  465525
  605553
  657591
  658632
  653172
  547059
  782034
  793578
]
2.45 ms
(1.12%)
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
  393694
  402574
  412941
  419808
  423426
  442897
  443749
  444329
  445736
  447071
  451799
  454363
  455099
  455103
  455106
  456690
  460194
  460539
  461124
  461428
  461516
  461518
  461524
  461549
  461552
  461557
  462052
  465525
  466322
  467132
  467174
  467617
  467632
  468844
  471886
  472347
  474052
  476402
  478527
  478529
  480831
  482129
  487025
  487069
  487080
  487090
  491199
  491239
  500503
  507195
  508844
  511746
  512239
  512293
  512321
  512323
  512335
  512337
  513278
  513783
  513891
  515334
  515379
  517596
  517654
  522590
  524697
  524732
  527807
  533962
  544992
  547059
  548656
  549527
  552116
  552137
  552142
  558441
  558860
  560464
  560476
  566431
  573773
  573775
  574509
  574591
  575148
  575453
  575743
  575791
  575805
  576026
  576351
  576363
  592728
  597136
  605553
  632922
  650018
  650978
  651003
  653172
  654812
  656072
  657591
  658096
  658250
  658632
  659548
  660545
  660923
  663456
  705398
  715693
  732266
  742166
  759463
  782034
  793578
  818663
]
2.33 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cuckold fuck sex"
]
1.79 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куколд секс секс"
]
1.56 ms
(0.71%)
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.