GET https://search.jues.net/search/embeds/8?q=room%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.40 ms
(59.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "room sex"
]
119.71 ms
(33.84%)
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
  152508
  348275
  382793
  382960
  383482
  398247
  408701
  412507
  419987
  424937
  425305
  427634
  448358
  451712
  453191
  458009
  459438
  460477
  461851
  471385
  472172
  478260
  483880
  494931
  496192
  511045
  511140
  512144
  519535
  534943
  536352
  539700
  543384
  544959
  547653
  553171
  554360
  557539
  559072
  561989
  564093
  582568
  586186
  590223
  593598
  602405
  608202
  608828
  614587
  614631
  624079
  625233
  628125
  636471
  636599
  639330
  642571
  643319
  650648
  663921
  672380
  672765
  680682
  681381
  683416
  689169
  696077
  703554
  704837
  708237
  708433
  712122
  718790
  719716
  721068
  722591
  724102
  724601
  725624
  726687
  726694
  734794
  739529
  739675
  741082
  747682
  750724
  758028
  762487
  765168
  770313
  775541
  782301
  783267
  785184
  786635
  788799
  790016
  792581
  794921
  795033
  796953
  797874
  798207
  799864
  801329
  801526
  801552
  801786
  807486
  810521
  811898
  812286
  814769
  820652
  821527
  821891
  823504
  827648
]
16.11 ms
(4.55%)
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
  821891
  471385
  608202
  586186
  783267
  799864
  412507
  348275
  424937
  823504
  534943
  557539
  672380
  689169
  672765
  590223
  801526
  795033
  425305
  453191
  519535
  511045
  582568
  547653
  683416
  704837
  681381
  680682
  602405
  643319
  775541
  794921
  811898
  739529
  724601
  750724
  708237
  722591
  382960
  398247
  408701
  820652
  821527
  448358
  483880
  494931
  721068
  696077
  663921
  703554
  712122
  642571
  628125
  624079
  625233
  786635
  790016
  725624
  734794
  807486
  758028
  741082
  801329
  451712
  461851
  427634
  827648
  458009
  512144
  544959
  593598
  798207
  726694
  801552
  812286
  724102
  739675
  788799
  792581
  801786
  496192
  770313
  543384
  782301
  762487
  718790
  472172
  553171
  554360
  708433
  639330
  478260
  419987
  814769
  460477
  511140
  536352
  539700
  561989
  559072
  564093
  699417
  719716
  650648
  608828
  614587
  614631
  636471
  636599
  810521
  796953
  785184
  747682
  765168
  726687
  797874
  152508
  459438
  382793
  383482
]
3.12 ms
(0.88%)
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
  152508
  348275
  382793
  382960
  383482
  398247
  408701
  412507
  419987
  424937
  425305
  427634
  448358
  451712
  453191
  458009
  459438
  460477
  461851
  471385
  472172
  478260
  483880
  494931
  496192
  511045
  511140
  512144
  519535
  534943
  536352
  539700
  543384
  544959
  547653
  553171
  554360
  557539
  559072
  561989
  564093
  582568
  586186
  590223
  593598
  602405
  608202
  608828
  614587
  614631
  624079
  625233
  628125
  636471
  636599
  639330
  642571
  643319
  650648
  663921
  672380
  672765
  680682
  681381
  683416
  689169
  696077
  703554
  704837
  708237
  708433
  712122
  718790
  719716
  721068
  722591
  724102
  724601
  725624
  726687
  726694
  734794
  739529
  739675
  741082
  747682
  750724
  758028
  762487
  765168
  770313
  775541
  782301
  783267
  785184
  786635
  788799
  790016
  792581
  794921
  795033
  796953
  797874
  798207
  799864
  801329
  801526
  801552
  801786
  807486
  810521
  811898
  812286
  814769
  820652
  821527
  821891
  823504
  827648
]
1.91 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "room секс"
]
1.80 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "room секс"
]

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.