GET https://search.jues.net/search/embeds/5?q=him%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.40 ms
(84.99%)
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
  55349
  398690
  421027
  435213
  441258
  443955
  444964
  451165
  459783
  463623
  463624
  463630
  463691
  479568
  481777
  485776
  489444
  494066
  496326
  496853
  506065
  516741
  516885
  519624
  520310
  524466
  524783
  529170
  534722
  534929
  536089
  540071
  543773
  546187
  548489
  553887
  564378
  565626
  571129
  575375
  586745
  588729
  592933
  593008
  594037
  594338
  602790
  605194
  605261
  605996
  610114
  616879
  618411
  625649
  650992
  659052
  663347
  675492
  676591
  680267
  687942
  714050
  716935
  718360
  720522
  725221
  725663
  727739
  729018
  730312
  731183
  733404
  734005
  734540
  739080
  744486
  753686
  755670
  756797
  759939
  767491
  768869
  769513
  769587
  770777
  771333
  772445
  776960
  778312
  778953
  786127
  787055
  791631
  791704
  792292
  793488
  796222
  798521
  801770
  801922
  802281
  802348
  802756
  809669
  809916
  810187
  813578
  816600
  816616
  818015
  818570
  825149
  826223
  827067
]
15.16 ms
(8.98%)
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
  786127
  516885
  602790
  520310
  443955
  826223
  553887
  759939
  778953
  516741
  663347
  593008
  494066
  496853
  519624
  546187
  714050
  798521
  809669
  730312
  768869
  769587
  55349
  605996
  687942
  659052
  716935
  720522
  592933
  810187
  756797
  776960
  802756
  727739
  444964
  813578
  451165
  616879
  610114
  809916
  787055
  769513
  771333
  769530
  441258
  463691
  534722
  534929
  548489
  571129
  594338
  605261
  755670
  753686
  459783
  485776
  524783
  510295
  527201
  536089
  675492
  676582
  625649
  791704
  697939
  479568
  421027
  506065
  543773
  575375
  680267
  594037
  588729
  605194
  463624
  463623
  524466
  529170
  565626
  559076
  564378
  463630
  481777
  489444
  435213
  676591
  540071
  650992
  729018
  825149
  816600
  725663
  744486
  725221
  767491
  718360
  802348
  816616
  818570
  496326
  618411
  778312
  801922
  733404
  734005
  770777
  796222
  586745
  739080
  398690
  827067
  818015
  792292
  802281
  791631
  793488
  731183
  772445
  801770
  734540
]
3.02 ms
(1.79%)
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
  55349
  398690
  421027
  435213
  441258
  443955
  444964
  451165
  459783
  463623
  463624
  463630
  463691
  479568
  481777
  485776
  489444
  494066
  496326
  496853
  506065
  516741
  516885
  519624
  520310
  524466
  524783
  529170
  534722
  534929
  536089
  540071
  543773
  546187
  548489
  553887
  564378
  565626
  571129
  575375
  586745
  588729
  592933
  593008
  594037
  594338
  602790
  605194
  605261
  605996
  610114
  616879
  618411
  625649
  650992
  659052
  663347
  675492
  676591
  680267
  687942
  714050
  716935
  718360
  720522
  725221
  725663
  727739
  729018
  730312
  731183
  733404
  734005
  734540
  739080
  744486
  753686
  755670
  756797
  759939
  767491
  768869
  769513
  769587
  770777
  771333
  772445
  776960
  778312
  778953
  786127
  787055
  791631
  791704
  792292
  793488
  796222
  798521
  801770
  801922
  802281
  802348
  802756
  809669
  809916
  810187
  813578
  816600
  816616
  818015
  818570
  825149
  826223
  827067
]
2.22 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "him cum"
]
1.79 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "him cum"
]
1.66 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "him cum"
]

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.