Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.58 ms
(82.91%)
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
  412604
  413735
  414183
  419100
  419320
  420232
  426658
  430308
  437835
  441320
  442993
  442998
  443177
  445874
  448634
  448963
  450786
  451502
  453992
  454959
  455981
  457551
  464089
  464405
  468516
  480424
  481390
  483088
  487051
  489096
  491589
  495822
  502690
  504937
  508773
  510876
  515455
  517527
  522946
  524623
  524813
  529145
  530882
  536886
  540383
  542916
  551977
  555461
  563684
  581158
  583352
  585970
  586389
  588887
  591629
  591966
  592256
  592608
  597769
  598837
  600987
  602920
  606345
  607401
  607557
  610209
  625434
  639259
  639260
  640334
  650196
  651043
  664380
  665790
  666062
  668373
  680519
  695958
  709506
  730357
  732884
  736436
  739400
  761527
  763599
  764258
  769113
  772141
  772564
  772678
  773200
  775282
  788218
  791864
  793976
  799254
  799572
  800466
  800671
  803789
  805777
  806297
  807409
  807442
  807470
  810130
  812314
  815111
  818541
  819150
  819401
  821087
  821458
  821890
  821953
  823244
  824279
  824692
  825055
  825497
]
14.78 ms
(10.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
  807442
  800671
  807409
  769113
  788218
  800466
  807470
  730357
  772141
  772678
  464405
  666062
  610209
  464089
  606345
  481390
  764258
  445874
  502690
  489096
  600987
  450786
  510876
  588887
  420232
  515455
  775282
  413735
  821458
  480424
  563684
  799572
  468516
  412604
  487051
  529145
  536886
  524623
  665790
  586389
  592608
  598837
  625434
  805777
  414183
  815111
  592256
  437835
  824279
  824692
  825497
  821087
  821890
  821953
  823244
  495822
  540383
  517527
  530882
  555461
  542916
  583352
  650196
  664380
  668373
  651043
  695958
  709506
  680519
  551977
  591629
  607557
  640334
  602920
  639259
  639260
  585970
  597769
  810130
  812314
  799254
  732884
  761527
  773200
  736436
  772564
  763599
  791864
  793976
  803789
  806297
  442998
  430308
  441320
  443177
  455981
  448634
  453992
  457551
  504937
  524813
  442993
  426658
  454959
  522946
  451502
  419100
  419320
  491589
  739400
  591966
  825055
  818541
  819150
  607401
  581158
  819401
  448963
  508773
  483088
]
2.83 ms
(1.93%)
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
  412604
  413735
  414183
  419100
  419320
  420232
  426658
  430308
  437835
  441320
  442993
  442998
  443177
  445874
  448634
  448963
  450786
  451502
  453992
  454959
  455981
  457551
  464089
  464405
  468516
  480424
  481390
  483088
  487051
  489096
  491589
  495822
  502690
  504937
  508773
  510876
  515455
  517527
  522946
  524623
  524813
  529145
  530882
  536886
  540383
  542916
  551977
  555461
  563684
  581158
  583352
  585970
  586389
  588887
  591629
  591966
  592256
  592608
  597769
  598837
  600987
  602920
  606345
  607401
  607557
  610209
  625434
  639259
  639260
  640334
  650196
  651043
  664380
  665790
  666062
  668373
  680519
  695958
  709506
  730357
  732884
  736436
  739400
  761527
  763599
  764258
  769113
  772141
  772564
  772678
  773200
  775282
  788218
  791864
  793976
  799254
  799572
  800466
  800671
  803789
  805777
  806297
  807409
  807442
  807470
  810130
  812314
  815111
  818541
  819150
  819401
  821087
  821458
  821890
  821953
  823244
  824279
  824692
  825055
  825497
]
2.14 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy ass pov"
]
1.93 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая жоп пов"
]
1.53 ms
(1.04%)
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.