GET https://search.jues.net/search/embeds/3?q=skinny%20russian%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.70 ms
(89.10%)
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
  426635
  426687
  459772
  463161
  468597
  471554
  476420
  476421
  477925
  481451
  489050
  496235
  497067
  501752
  507356
  509426
  510380
  534393
  536173
  540698
  541726
  542669
  543639
  543664
  543721
  545980
  547604
  547666
  547984
  560874
  566397
  573996
  575244
  575765
  578013
  594093
  595464
  596172
  598607
  599101
  601781
  602833
  610797
  615059
  617209
  618819
  619274
  628130
  630252
  636149
  636760
  647244
  648615
  648697
  648973
  652863
  652961
  653322
  661519
  661526
  661546
  664982
  670014
  670728
  671221
  671234
  678625
  679248
  685388
  690878
  690933
  691474
  691953
  699515
  707111
  713591
  722350
  729405
  731575
  734621
  735527
  736990
  759371
  763956
  763965
  764731
  767743
  768377
  778232
  778292
  778875
  779809
  782730
  785176
  789482
  789890
  791032
  791660
  793998
  795108
  795109
  799921
  799922
  808828
  808904
  810729
  818027
  818034
  818043
  818199
  819883
  824426
  827681
  828028
  828325
  828361
  828447
  828777
]
10.35 ms
(5.71%)
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
  573996
  547666
  652961
  691474
  652863
  618819
  778232
  782730
  791660
  778292
  731575
  736990
  763956
  763965
  785176
  808828
  808904
  729405
  768377
  764731
  630252
  779809
  793998
  540698
  543664
  679248
  690933
  648615
  653322
  828325
  828361
  566397
  799922
  791032
  477925
  496235
  509426
  670728
  615059
  501752
  426635
  678625
  598607
  426687
  510380
  471554
  543721
  543639
  791945
  459772
  534393
  507356
  536173
  560874
  541726
  542669
  547984
  648697
  661526
  664982
  671234
  685388
  661519
  661546
  670014
  690878
  691953
  647244
  648973
  671221
  707111
  713591
  545980
  610797
  619274
  636149
  636760
  596172
  599101
  595464
  602833
  617209
  628130
  699515
  778875
  575765
  497067
  489050
  594093
  476421
  463161
  481451
  468597
  578013
  790440
  476420
  818034
  819883
  818043
  818199
  818027
  824426
  828028
  828777
  827681
  828447
  575244
  547604
  722350
  601781
  789890
  810729
  789482
  795108
  795109
  734621
  735527
  759371
  767743
  799921
]
2.66 ms
(1.47%)
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
  426635
  426687
  459772
  463161
  468597
  471554
  476420
  476421
  477925
  481451
  489050
  496235
  497067
  501752
  507356
  509426
  510380
  534393
  536173
  540698
  541726
  542669
  543639
  543664
  543721
  545980
  547604
  547666
  547984
  560874
  566397
  573996
  575244
  575765
  578013
  594093
  595464
  596172
  598607
  599101
  601781
  602833
  610797
  615059
  617209
  618819
  619274
  628130
  630252
  636149
  636760
  647244
  648615
  648697
  648973
  652863
  652961
  653322
  661519
  661526
  661546
  664982
  670014
  670728
  671221
  671234
  678625
  679248
  685388
  690878
  690933
  691474
  691953
  699515
  707111
  713591
  722350
  729405
  731575
  734621
  735527
  736990
  759371
  763956
  763965
  764731
  767743
  768377
  778232
  778292
  778875
  779809
  782730
  785176
  789482
  789890
  791032
  791660
  793998
  795108
  795109
  799921
  799922
  808828
  808904
  810729
  818027
  818034
  818043
  818199
  819883
  824426
  827681
  828028
  828325
  828361
  828447
  828777
]
1.80 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые русск любительск"
]
1.67 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые русск любительск"
]
1.67 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny russian amateur"
]

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.