Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.42 ms
(84.43%)
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
  7170
  388007
  397503
  419300
  423568
  429768
  429909
  431385
  433319
  433339
  433498
  433601
  437504
  445323
  446257
  447466
  447640
  448813
  449115
  451866
  452612
  452727
  453368
  458907
  463798
  464427
  464651
  465205
  472464
  476828
  478993
  483220
  486589
  488234
  488235
  489489
  490577
  491248
  495397
  495401
  497269
  497545
  500748
  503105
  511067
  517780
  517855
  520215
  523793
  524675
  527507
  527523
  527580
  528947
  528950
  528966
  528990
  529003
  532705
  537307
  539157
  540241
  549092
  558912
  567777
  568509
  574149
  574727
  576980
  579580
  580123
  597170
  600490
  603057
  609909
  613515
  618761
  620292
  624194
  626403
  637537
  644363
  648503
  651957
  652544
  652898
  652939
  653209
  662899
  671085
  671374
  681691
  692357
  694498
  694553
  697828
  697987
  700011
  707089
  710794
  712366
  719651
  720450
  723980
  727052
  728362
  729957
  738689
  739139
  744938
  750334
  750760
  761801
  766992
  772901
  774495
  800352
  805164
  814347
  818992
]
17.22 ms
(10.21%)
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
  529003
  527507
  527523
  527580
  528990
  558912
  720450
  712366
  429768
  476828
  448813
  537307
  600490
  453368
  458907
  463798
  574727
  579580
  489489
  580123
  495397
  433339
  472464
  524675
  549092
  568509
  648503
  609909
  618761
  750760
  644363
  465205
  488235
  451866
  433601
  423568
  491248
  446257
  517855
  503105
  464651
  567777
  452612
  520215
  497269
  528950
  486589
  637537
  528947
  464427
  433319
  419300
  431385
  433498
  814347
  447466
  447640
  511067
  445323
  437504
  597170
  7170
  388007
  397503
  818992
  488234
  697828
  707089
  662899
  694498
  700011
  624194
  626403
  774495
  723980
  729957
  800352
  738689
  772901
  728362
  750334
  766992
  697987
  497545
  528966
  540241
  651957
  652939
  694553
  652898
  805164
  739139
  517780
  483220
  532705
  539157
  671374
  692357
  620292
  744938
  613515
  478993
  452727
  490577
  429909
  576980
  495401
  500748
  449115
  574149
  652544
  681691
  710794
  523793
  671085
  719651
  653209
  603057
  727052
  761801
]
2.13 ms
(1.27%)
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
  7170
  388007
  397503
  419300
  423568
  429768
  429909
  431385
  433319
  433339
  433498
  433601
  437504
  445323
  446257
  447466
  447640
  448813
  449115
  451866
  452612
  452727
  453368
  458907
  463798
  464427
  464651
  465205
  472464
  476828
  478993
  483220
  486589
  488234
  488235
  489489
  490577
  491248
  495397
  495401
  497269
  497545
  500748
  503105
  511067
  517780
  517855
  520215
  523793
  524675
  527507
  527523
  527580
  528947
  528950
  528966
  528990
  529003
  532705
  537307
  539157
  540241
  549092
  558912
  567777
  568509
  574149
  574727
  576980
  579580
  580123
  597170
  600490
  603057
  609909
  613515
  618761
  620292
  624194
  626403
  637537
  644363
  648503
  651957
  652544
  652898
  652939
  653209
  662899
  671085
  671374
  681691
  692357
  694498
  694553
  697828
  697987
  700011
  707089
  710794
  712366
  719651
  720450
  723980
  727052
  728362
  729957
  738689
  739139
  744938
  750334
  750760
  761801
  766992
  772901
  774495
  800352
  805164
  814347
  818992
]
2.01 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen girls compilation"
]
1.65 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen девушк подборк"
]
1.65 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen девушк подборк"
]
1.60 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.