Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.86 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.86 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob with cumshot"
]
3 12.66 ms
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
  794590
  448749
  413257
  703432
  80900
  455244
  383119
  399893
  820347
  826683
  826590
  819309
  819690
  823749
  825319
  820006
  819711
  825355
  533710
  529691
  537401
  554464
  710085
  717089
  718856
  719153
  662195
  711723
  665952
  667235
  685233
  687403
  634585
  629623
  606641
  784466
  792166
  807849
  782134
  786096
  810560
  788091
  793357
  794587
  801987
  803436
  808448
  744424
  747739
  769902
  749538
  750224
  752499
  764585
  724375
  732663
  749171
  763223
  768370
  614740
  797286
  800063
  803448
  808258
  810001
  810993
  401854
  786763
  400519
  650098
  683334
  714749
  613868
  745360
  826470
  630984
  475802
  796024
  517110
  390375
  436809
  544491
  564059
  577976
  667158
  456425
  433490
  805991
  753887
  388333
  400569
  523598
  668971
  682226
  592830
  593189
  779088
  803444
  757913
  764319
  734044
  763120
  764536
  731294
  739986
  602367
  800367
  791528
  393027
  591015
  791679
  777472
  741484
  736748
  773498
  494890
  686583
  664468
  602547
  568728
]
4 3.47 ms
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
  80900
  383119
  388333
  390375
  393027
  399893
  400519
  400569
  401854
  413257
  433490
  436809
  448749
  455244
  456425
  475802
  494890
  517110
  523598
  529691
  533710
  537401
  544491
  554464
  564059
  568728
  577976
  591015
  592830
  593189
  602367
  602547
  606641
  613868
  614740
  629623
  630984
  634585
  650098
  662195
  664468
  665952
  667158
  667235
  668971
  682226
  683334
  685233
  686583
  687403
  703432
  710085
  711723
  714749
  717089
  718856
  719153
  724375
  731294
  732663
  734044
  736748
  739986
  741484
  744424
  745360
  747739
  749171
  749538
  750224
  752499
  753887
  757913
  763120
  763223
  764319
  764536
  764585
  768370
  773498
  777472
  779088
  782134
  784466
  786096
  786763
  788091
  791528
  791679
  792166
  793357
  794587
  794590
  796024
  797286
  800063
  800367
  801987
  803436
  803444
  803448
  805991
  807849
  808258
  808448
  810001
  810560
  810993
  819309
  819690
  819711
  820006
  820347
  823749
  825319
  825355
  826470
  826590
  826683
]
5 139.25 ms
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
  80900
  383119
  388333
  390375
  393027
  399893
  400519
  400569
  401854
  413257
  433490
  436809
  448749
  455244
  456425
  475802
  494890
  517110
  523598
  529691
  533710
  537401
  544491
  554464
  564059
  568728
  577976
  591015
  592830
  593189
  602367
  602547
  606641
  613868
  614740
  629623
  630984
  634585
  650098
  662195
  664468
  665952
  667158
  667235
  668971
  682226
  683334
  685233
  686583
  687403
  703432
  710085
  711723
  714749
  717089
  718856
  719153
  724375
  731294
  732663
  734044
  736748
  739986
  741484
  744424
  745360
  747739
  749171
  749538
  750224
  752499
  753887
  757913
  763120
  763223
  764319
  764536
  764585
  768370
  773498
  777472
  779088
  782134
  784466
  786096
  786763
  788091
  791528
  791679
  792166
  793357
  794587
  794590
  796024
  797286
  800063
  800367
  801987
  803436
  803444
  803448
  805991
  807849
  808258
  808448
  810001
  810560
  810993
  819309
  819690
  819711
  820006
  820347
  823749
  825319
  825355
  826470
  826590
  826683
]
6 1.72 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс cumshot"
]
7 1.61 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс cumshot"
]

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.