Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.52 ms
(86.80%)
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
  390615
  392100
  394006
  413151
  418912
  420317
  421777
  425312
  426797
  435816
  435883
  455099
  461381
  461697
  461807
  462044
  466083
  466830
  469114
  470062
  472577
  472600
  489786
  494561
  506136
  506786
  511420
  522285
  523606
  528058
  529931
  532449
  535037
  537472
  539875
  546975
  549740
  551674
  551834
  552501
  555458
  556141
  558872
  559656
  564908
  570403
  573592
  574151
  576509
  578739
  579330
  579405
  579451
  583304
  583574
  584241
  585397
  587745
  595258
  597763
  600500
  609962
  611164
  612421
  619230
  625326
  630913
  630924
  636936
  641554
  653755
  654658
  655050
  657325
  662429
  682803
  689042
  695330
  696982
  696986
  697738
  705696
  712795
  713583
  719131
  724878
  725987
  726506
  726516
  729589
  732635
  732829
  736017
  736021
  749401
  750601
  755924
  757776
  765384
  768085
  768142
  768575
  768586
  769378
  769960
  777860
  781928
  783053
  784005
  787713
  788969
  789613
  791013
  801094
  801535
  802005
  803142
  806403
  806421
  812180
]
15.88 ms
(8.43%)
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
  469114
  470062
  472600
  551674
  558872
  574151
  583574
  549740
  551834
  556141
  564908
  570403
  583304
  552501
  555458
  576509
  653755
  705696
  655050
  657325
  682803
  689042
  695330
  654658
  662429
  696982
  697738
  712795
  713583
  559656
  578739
  584241
  625326
  587745
  600500
  612421
  641554
  585397
  597763
  619230
  636936
  595258
  609962
  630913
  630924
  777860
  787713
  791013
  801094
  806403
  788969
  806421
  726506
  726516
  736021
  768575
  801535
  802005
  736017
  749401
  768586
  769960
  724878
  729589
  732829
  768085
  768142
  732635
  755924
  765384
  769378
  725987
  750601
  757776
  611164
  696986
  719131
  781928
  783053
  784005
  789613
  803142
  812180
  390615
  392100
  418912
  461697
  394006
  413151
  420317
  435816
  435883
  461807
  455099
  461381
  462044
  425312
  426797
  466083
  466830
  506786
  523606
  494561
  511420
  421777
  472577
  489786
  522285
  532449
  539875
  529931
  506136
  528058
  535037
  537472
  579330
  579405
  579451
  546975
  573592
]
2.08 ms
(1.10%)
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
  390615
  392100
  394006
  413151
  418912
  420317
  421777
  425312
  426797
  435816
  435883
  455099
  461381
  461697
  461807
  462044
  466083
  466830
  469114
  470062
  472577
  472600
  489786
  494561
  506136
  506786
  511420
  522285
  523606
  528058
  529931
  532449
  535037
  537472
  539875
  546975
  549740
  551674
  551834
  552501
  555458
  556141
  558872
  559656
  564908
  570403
  573592
  574151
  576509
  578739
  579330
  579405
  579451
  583304
  583574
  584241
  585397
  587745
  595258
  597763
  600500
  609962
  611164
  612421
  619230
  625326
  630913
  630924
  636936
  641554
  653755
  654658
  655050
  657325
  662429
  682803
  689042
  695330
  696982
  696986
  697738
  705696
  712795
  713583
  719131
  724878
  725987
  726506
  726516
  729589
  732635
  732829
  736017
  736021
  749401
  750601
  755924
  757776
  765384
  768085
  768142
  768575
  768586
  769378
  769960
  777860
  781928
  783053
  784005
  787713
  788969
  789613
  791013
  801094
  801535
  802005
  803142
  806403
  806421
  812180
]
1.78 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "порно смотрит"
]
1.69 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "порн смотр"
]
1.66 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.