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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
226.92 ms
(89.66%)
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
  145612
  350665
  384162
  385690
  385947
  391915
  391950
  398112
  401964
  411009
  418719
  434355
  446792
  453141
  454516
  457543
  468290
  468506
  469464
  471015
  471037
  472606
  478516
  487414
  488908
  490232
  493742
  498632
  509596
  510942
  523058
  528540
  528816
  537949
  544031
  555153
  555261
  555619
  559418
  559421
  563971
  571094
  573250
  573973
  576880
  577057
  578177
  588674
  591536
  592948
  600479
  600548
  601824
  606480
  607898
  610198
  614844
  618510
  620369
  629809
  632849
  633190
  635775
  636967
  637470
  643326
  643328
  644122
  649429
  660028
  661591
  667456
  672743
  673841
  712296
  717717
  725422
  735478
  739949
  743185
  743254
  743263
  743269
  743271
  743996
  744000
  744024
  748291
  753630
  754536
  758746
  768786
  768787
  769999
  776434
  779282
  783177
  788231
  790675
  791837
  804713
  805516
  805724
  811622
  812238
  816742
  819229
  819615
  823856
  823989
  824533
  824552
  824633
  824667
  825330
  825374
  825819
  826820
  827350
  827625
]
14.71 ms
(5.81%)
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
  577057
  743185
  758746
  812238
  743269
  743271
  743996
  753630
  754536
  717717
  783177
  811622
  418719
  384162
  453141
  493742
  510942
  571094
  578177
  660028
  592948
  633190
  635775
  804713
  614844
  457543
  488908
  391915
  411009
  824533
  824633
  469464
  471015
  468290
  576880
  637470
  776434
  391950
  398112
  588674
  528816
  591536
  350665
  823989
  824667
  825374
  819229
  825330
  827350
  471037
  544031
  667456
  672743
  649429
  673841
  600548
  606480
  610198
  644122
  636967
  643326
  643328
  607898
  620369
  629809
  791837
  790675
  805724
  743263
  744000
  748291
  768786
  739949
  769999
  743254
  744024
  768787
  618510
  632849
  712296
  779282
  788231
  805516
  826820
  827625
  816742
  819615
  823856
  824552
  825819
  559421
  555619
  559418
  563971
  725422
  434355
  573250
  555261
  600479
  735478
  573973
  498632
  555153
  145612
  401964
  472606
  454516
  478516
  601824
  487414
  523058
  661591
  385690
  385947
  490232
  446792
  468506
  537949
  509596
  528540
]
3.52 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая девушк соло"
]
2.51 ms
(0.99%)
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
  145612
  350665
  384162
  385690
  385947
  391915
  391950
  398112
  401964
  411009
  418719
  434355
  446792
  453141
  454516
  457543
  468290
  468506
  469464
  471015
  471037
  472606
  478516
  487414
  488908
  490232
  493742
  498632
  509596
  510942
  523058
  528540
  528816
  537949
  544031
  555153
  555261
  555619
  559418
  559421
  563971
  571094
  573250
  573973
  576880
  577057
  578177
  588674
  591536
  592948
  600479
  600548
  601824
  606480
  607898
  610198
  614844
  618510
  620369
  629809
  632849
  633190
  635775
  636967
  637470
  643326
  643328
  644122
  649429
  660028
  661591
  667456
  672743
  673841
  712296
  717717
  725422
  735478
  739949
  743185
  743254
  743263
  743269
  743271
  743996
  744000
  744024
  748291
  753630
  754536
  758746
  768786
  768787
  769999
  776434
  779282
  783177
  788231
  790675
  791837
  804713
  805516
  805724
  811622
  812238
  816742
  819229
  819615
  823856
  823989
  824533
  824552
  824633
  824667
  825330
  825374
  825819
  826820
  827350
  827625
]
1.95 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy girl solo"
]
1.54 ms
(0.61%)
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.