Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.30 ms
(84.67%)
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
  392981
  414929
  418139
  418832
  420295
  423708
  427027
  434286
  434364
  435008
  435550
  439531
  440710
  440833
  441742
  445401
  445443
  446028
  446386
  446709
  449323
  450343
  452637
  454518
  455991
  457764
  460338
  460860
  463384
  466772
  466960
  469830
  471081
  474425
  476887
  478597
  480197
  485321
  485527
  489868
  492714
  492958
  492959
  494815
  497030
  497667
  500335
  505480
  507503
  508209
  509861
  516362
  516889
  517493
  519686
  524047
  526372
  531635
  532778
  539857
  539875
  546042
  547534
  550777
  550920
  560264
  562973
  563613
  564901
  579499
  581163
  582574
  587506
  588532
  588569
  592702
  592862
  593812
  597884
  601529
  602631
  603286
  606601
  607879
  617082
  617803
  619396
  624480
  628685
  636471
  638190
  645418
  657136
  665094
  667257
  679909
  694637
  700947
  715022
  727486
  729265
  740850
  740895
  742919
  744019
  745484
  746480
  746939
  750701
  751572
  753953
  758780
  758881
  769096
  769495
  774399
  785614
  787813
  790544
  796034
]
13.76 ms
(9.08%)
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
  547534
  460860
  597884
  446386
  517493
  427027
  435008
  500335
  516889
  497667
  455991
  758780
  729265
  560264
  617803
  745484
  746939
  526372
  440833
  790544
  420295
  476887
  469830
  497030
  508209
  532778
  617082
  742919
  679909
  564901
  463384
  524047
  519686
  494815
  492958
  562973
  457764
  449323
  434364
  392981
  418139
  452637
  454518
  509861
  582574
  657136
  785614
  434286
  446709
  435550
  440710
  539875
  581163
  485321
  489868
  774399
  787813
  746480
  753953
  588532
  740895
  769096
  740850
  744019
  638190
  607879
  474425
  602631
  418832
  445443
  466772
  606601
  619396
  579499
  769495
  546042
  750701
  423708
  441742
  796034
  531635
  445401
  446028
  539857
  478597
  587506
  751572
  492714
  550920
  516362
  485527
  439531
  460338
  471081
  603286
  715022
  758881
  507503
  700947
  628685
  645418
  665094
  592702
  636471
  624480
  480197
  466960
  593812
  492959
  550777
  667257
  694637
  450343
  588569
  414929
  727486
  592862
  563613
  601529
  505480
]
2.83 ms
(1.87%)
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
  392981
  414929
  418139
  418832
  420295
  423708
  427027
  434286
  434364
  435008
  435550
  439531
  440710
  440833
  441742
  445401
  445443
  446028
  446386
  446709
  449323
  450343
  452637
  454518
  455991
  457764
  460338
  460860
  463384
  466772
  466960
  469830
  471081
  474425
  476887
  478597
  480197
  485321
  485527
  489868
  492714
  492958
  492959
  494815
  497030
  497667
  500335
  505480
  507503
  508209
  509861
  516362
  516889
  517493
  519686
  524047
  526372
  531635
  532778
  539857
  539875
  546042
  547534
  550777
  550920
  560264
  562973
  563613
  564901
  579499
  581163
  582574
  587506
  588532
  588569
  592702
  592862
  593812
  597884
  601529
  602631
  603286
  606601
  607879
  617082
  617803
  619396
  624480
  628685
  636471
  638190
  645418
  657136
  665094
  667257
  679909
  694637
  700947
  715022
  727486
  729265
  740850
  740895
  742919
  744019
  745484
  746480
  746939
  750701
  751572
  753953
  758780
  758881
  769096
  769495
  774399
  785614
  787813
  790544
  796034
]
1.84 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "реальные оргазмы в пизду"
]
1.74 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск оргазм в вагин"
]
1.54 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.01%)
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.