GET https://search.jues.net/search/embeds/9?q=double%20handjob

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.26 ms
(82.31%)
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
  436030
  437947
  444645
  460535
  471429
  484977
  486759
  531121
  531200
  531249
  531250
  537936
  545408
  551186
  559644
  568045
  569154
  573211
  577706
  581427
  589752
  591165
  600807
  601593
  603187
  604080
  604383
  607091
  608744
  611307
  614186
  628185
  630234
  630295
  632626
  633776
  634161
  636070
  640524
  640712
  641705
  644314
  644321
  644972
  647910
  647996
  649114
  649180
  651062
  653630
  656502
  661285
  665317
  665448
  665457
  665921
  666532
  667196
  667636
  668527
  670098
  670965
  672984
  673357
  673578
  676095
  678915
  679798
  680202
  683301
  684029
  692293
  692314
  693596
  695125
  696998
  697025
  705540
  707275
  709295
  712006
  720050
  720112
  720340
  720394
  729881
  736798
  736881
  743782
  744306
  748354
  755759
  770732
  770795
  770882
  775758
  775834
  775862
  775897
  775982
  775989
  780655
  788582
  792560
  795593
  798684
  801941
  801954
  801975
  805275
  806804
  811164
  814556
  815347
  815875
  816905
  817115
  817288
  817346
  818160
]
17.04 ms
(10.69%)
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
  818160
  815875
  531200
  537936
  573211
  680202
  683301
  720340
  673578
  676095
  679798
  720112
  661285
  705540
  720394
  581427
  611307
  641705
  601593
  607091
  775834
  801975
  755759
  736881
  770732
  604383
  707275
  712006
  775982
  775989
  806804
  436030
  471429
  437947
  604080
  460535
  569154
  816905
  817115
  644972
  814556
  815347
  817288
  817346
  531250
  531121
  531249
  551186
  545408
  559644
  651062
  665317
  665448
  665457
  666532
  667636
  672984
  647910
  647996
  649114
  649180
  656502
  665921
  667196
  670098
  670965
  678915
  684029
  693596
  696998
  653630
  668527
  673357
  692293
  692314
  695125
  697025
  720050
  628185
  640712
  600807
  634161
  589752
  591165
  603187
  608744
  614186
  633776
  644314
  644321
  630234
  630295
  632626
  775758
  795593
  805275
  811164
  775862
  780655
  736798
  788582
  792560
  729881
  743782
  744306
  770882
  748354
  770795
  636070
  640524
  709295
  775897
  801941
  801954
  444645
  486759
  798684
  577706
  568045
  484977
]
3.53 ms
(2.21%)
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
  436030
  437947
  444645
  460535
  471429
  484977
  486759
  531121
  531200
  531249
  531250
  537936
  545408
  551186
  559644
  568045
  569154
  573211
  577706
  581427
  589752
  591165
  600807
  601593
  603187
  604080
  604383
  607091
  608744
  611307
  614186
  628185
  630234
  630295
  632626
  633776
  634161
  636070
  640524
  640712
  641705
  644314
  644321
  644972
  647910
  647996
  649114
  649180
  651062
  653630
  656502
  661285
  665317
  665448
  665457
  665921
  666532
  667196
  667636
  668527
  670098
  670965
  672984
  673357
  673578
  676095
  678915
  679798
  680202
  683301
  684029
  692293
  692314
  693596
  695125
  696998
  697025
  705540
  707275
  709295
  712006
  720050
  720112
  720340
  720394
  729881
  736798
  736881
  743782
  744306
  748354
  755759
  770732
  770795
  770882
  775758
  775834
  775862
  775897
  775982
  775989
  780655
  788582
  792560
  795593
  798684
  801941
  801954
  801975
  805275
  806804
  811164
  814556
  815347
  815875
  816905
  817115
  817288
  817346
  818160
]
2.02 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double дрочк член"
]
1.92 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double handjob"
]
1.91 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double дрочк член"
]
1.80 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.