Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.42 ms
(85.13%)
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
  396670
  399140
  410924
  413246
  425005
  430437
  438487
  450372
  455677
  467383
  479558
  480294
  481346
  488145
  490624
  491167
  492779
  496758
  506893
  510220
  514033
  517631
  518411
  518520
  518795
  520951
  521993
  525600
  527026
  541365
  545172
  548698
  548850
  549783
  551803
  552395
  554254
  558548
  560468
  562080
  562108
  562409
  565730
  566101
  567990
  569278
  571387
  572291
  574930
  574955
  575298
  578584
  578611
  579303
  580470
  581625
  586619
  587251
  587661
  587791
  588139
  598918
  599953
  614602
  615908
  617060
  618736
  618849
  619885
  624365
  624768
  625689
  627137
  628864
  630609
  631993
  632818
  641901
  645852
  645918
  652689
  660075
  663265
  663318
  663801
  682945
  687995
  688110
  699628
  702075
  712281
  714463
  724217
  728802
  728879
  732070
  739060
  767165
  769971
  771918
  773562
  774287
  775195
  776259
  781511
  784511
  786230
  787957
  791745
  793431
  793757
  797574
  797797
  798677
  799459
  805687
  807707
  809872
  813051
  814889
]
15.82 ms
(8.96%)
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
  518520
  554254
  551803
  562409
  574955
  580470
  614602
  625689
  618736
  799459
  784511
  797797
  728802
  450372
  506893
  517631
  575298
  628864
  739060
  775195
  527026
  776259
  797574
  728879
  574930
  699628
  805687
  652689
  702075
  645852
  732070
  773562
  688110
  624365
  774287
  769971
  724217
  430437
  518795
  579303
  660075
  687995
  558548
  425005
  480294
  552395
  578584
  572291
  560468
  571387
  663318
  588139
  587661
  781511
  813051
  488145
  548850
  545172
  714463
  569278
  624768
  787957
  809872
  767165
  615908
  712281
  518411
  541365
  562080
  682945
  565730
  578611
  627137
  496758
  645918
  438487
  520951
  663801
  514033
  586619
  617060
  521993
  793431
  413246
  814889
  567990
  631993
  467383
  455677
  548698
  549783
  587791
  786230
  510220
  479558
  490624
  581625
  525600
  562108
  663265
  771918
  619885
  798677
  491167
  492779
  566101
  618849
  791745
  632818
  807707
  598918
  410924
  399140
  587251
  630609
  641901
  396670
  481346
  599953
  793757
]
4.10 ms
(2.32%)
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
  396670
  399140
  410924
  413246
  425005
  430437
  438487
  450372
  455677
  467383
  479558
  480294
  481346
  488145
  490624
  491167
  492779
  496758
  506893
  510220
  514033
  517631
  518411
  518520
  518795
  520951
  521993
  525600
  527026
  541365
  545172
  548698
  548850
  549783
  551803
  552395
  554254
  558548
  560468
  562080
  562108
  562409
  565730
  566101
  567990
  569278
  571387
  572291
  574930
  574955
  575298
  578584
  578611
  579303
  580470
  581625
  586619
  587251
  587661
  587791
  588139
  598918
  599953
  614602
  615908
  617060
  618736
  618849
  619885
  624365
  624768
  625689
  627137
  628864
  630609
  631993
  632818
  641901
  645852
  645918
  652689
  660075
  663265
  663318
  663801
  682945
  687995
  688110
  699628
  702075
  712281
  714463
  724217
  728802
  728879
  732070
  739060
  767165
  769971
  771918
  773562
  774287
  775195
  776259
  781511
  784511
  786230
  787957
  791745
  793431
  793757
  797574
  797797
  798677
  799459
  805687
  807707
  809872
  813051
  814889
]
2.08 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"выебал лучшую подругÑ%…"
]
1.46 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс лучш подружк"
]
1.38 ms
(0.78%)
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.