GET https://search.jues.net/search/embeds/4?q=hairy%20ass%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.91 ms
(83.34%)
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
  3561
  145280
  387667
  391371
  391915
  397997
  398965
  401790
  415762
  416038
  427112
  429879
  445787
  446772
  446776
  465595
  465672
  465990
  466863
  469770
  471015
  474847
  475639
  478027
  484277
  488989
  493734
  510948
  515472
  522702
  525355
  527122
  527258
  528560
  532885
  542707
  542982
  547520
  550451
  552036
  553876
  554712
  555175
  557720
  558174
  558314
  558315
  570938
  571050
  575008
  578169
  578196
  584072
  586950
  587567
  590720
  591013
  592690
  592945
  592975
  592985
  595975
  596792
  601071
  602347
  611210
  614797
  614865
  623276
  628751
  629815
  630453
  632949
  637245
  641337
  660397
  664498
  664504
  667463
  668628
  674279
  674493
  700947
  705452
  715965
  719504
  722294
  728047
  736041
  736339
  736410
  740368
  742324
  743212
  743241
  744183
  744215
  751030
  752495
  752584
  752914
  753772
  754647
  758583
  781792
  783350
  785042
  785817
  786723
  795933
  803490
  804391
  804456
  812548
  817964
  818561
  819244
  821964
  824868
  827100
]
14.73 ms
(9.83%)
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
  740368
  743241
  751030
  736041
  804391
  145280
  664504
  550451
  558314
  3561
  387667
  397997
  824868
  475639
  446772
  446776
  465595
  664498
  398965
  786723
  465672
  752584
  752495
  728047
  674279
  601071
  578196
  522702
  465990
  474847
  510948
  528560
  532885
  488989
  558174
  558315
  552036
  668628
  591013
  592975
  586950
  592690
  614865
  587567
  592945
  596792
  781792
  614797
  525355
  527258
  557720
  592985
  637245
  629815
  416038
  391915
  401790
  471015
  571050
  445787
  527122
  466863
  578169
  391371
  429879
  427112
  484277
  493734
  542707
  478027
  590720
  415762
  818561
  611210
  817964
  821964
  827100
  819244
  515472
  469770
  575008
  542982
  547520
  553876
  570938
  660397
  667463
  674493
  700947
  715965
  719504
  705452
  722294
  554712
  555175
  584072
  628751
  632949
  623276
  630453
  641337
  595975
  785817
  795933
  803490
  736410
  744183
  744215
  752914
  758583
  783350
  785042
  804456
  812548
  742324
  753772
  736339
  743212
  754647
  602347
]
2.93 ms
(1.95%)
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
  3561
  145280
  387667
  391371
  391915
  397997
  398965
  401790
  415762
  416038
  427112
  429879
  445787
  446772
  446776
  465595
  465672
  465990
  466863
  469770
  471015
  474847
  475639
  478027
  484277
  488989
  493734
  510948
  515472
  522702
  525355
  527122
  527258
  528560
  532885
  542707
  542982
  547520
  550451
  552036
  553876
  554712
  555175
  557720
  558174
  558314
  558315
  570938
  571050
  575008
  578169
  578196
  584072
  586950
  587567
  590720
  591013
  592690
  592945
  592975
  592985
  595975
  596792
  601071
  602347
  611210
  614797
  614865
  623276
  628751
  629815
  630453
  632949
  637245
  641337
  660397
  664498
  664504
  667463
  668628
  674279
  674493
  700947
  705452
  715965
  719504
  722294
  728047
  736041
  736339
  736410
  740368
  742324
  743212
  743241
  744183
  744215
  751030
  752495
  752584
  752914
  753772
  754647
  758583
  781792
  783350
  785042
  785817
  786723
  795933
  803490
  804391
  804456
  812548
  817964
  818561
  819244
  821964
  824868
  827100
]
2.17 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy ass solo"
]
1.95 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая жоп соло"
]
1.44 ms
(0.96%)
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.