GET https://search.jues.net/search/embeds/6?q=young%20boy%20threesome

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
161.03 ms
(85.07%)
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
  7981
  62175
  249637
  260940
  280073
  358566
  384016
  385491
  385946
  389863
  390813
  390922
  395433
  395639
  395661
  395707
  395720
  395733
  395824
  398164
  400166
  400169
  400550
  401673
  403464
  405527
  406983
  407089
  407148
  407505
  408306
  408437
  412363
  413889
  413904
  413993
  421340
  425633
  425800
  425834
  425945
  425957
  426025
  430241
  431022
  433656
  434624
  438001
  443802
  445500
  446278
  446624
  453149
  458327
  461599
  463171
  466075
  466959
  468774
  469288
  471008
  471941
  474029
  477080
  479100
  484416
  484485
  484660
  484695
  484703
  484718
  484738
  490923
  490933
  491078
  492108
  494731
  496540
  497953
  502512
  505023
  505693
  505811
  506580
  520473
  523803
  524351
  554004
  559386
  564648
  570700
  574596
  579938
  590627
  591294
  598911
  599610
  665207
  665284
  665288
  669736
  670489
  714864
  718836
  724133
  724328
  728288
  728452
  758617
  770196
  790015
  790022
  792663
  796078
  813913
  815417
  817413
  817463
  817917
  823622
]
17.19 ms
(9.08%)
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
  815417
  468774
  574596
  564648
  792663
  790022
  280073
  395661
  260940
  403464
  443802
  7981
  249637
  385491
  524351
  484718
  570700
  728288
  813913
  523803
  790015
  474029
  479100
  430241
  471008
  389863
  579938
  559386
  591294
  433656
  665207
  426025
  718836
  599610
  384016
  453149
  431022
  497953
  458327
  496540
  62175
  395824
  390922
  554004
  395733
  724328
  395433
  502512
  400169
  395639
  817917
  714864
  770196
  724133
  400550
  408437
  390813
  407148
  505811
  796078
  425834
  407505
  446278
  494731
  823622
  665288
  665284
  669736
  758617
  401673
  358566
  413993
  425945
  408306
  412363
  466959
  461599
  728452
  463171
  425800
  505693
  484695
  484738
  484485
  490923
  425633
  405527
  425957
  395720
  421340
  466075
  484703
  484660
  407089
  438001
  471941
  491078
  490933
  520473
  469288
  413889
  484416
  505023
  477080
  598911
  492108
  406983
  817463
  590627
  395707
  506580
  400166
  413904
  434624
  446624
  445500
  385946
  398164
  817413
  670489
]
3.06 ms
(1.62%)
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
  7981
  62175
  249637
  260940
  280073
  358566
  384016
  385491
  385946
  389863
  390813
  390922
  395433
  395639
  395661
  395707
  395720
  395733
  395824
  398164
  400166
  400169
  400550
  401673
  403464
  405527
  406983
  407089
  407148
  407505
  408306
  408437
  412363
  413889
  413904
  413993
  421340
  425633
  425800
  425834
  425945
  425957
  426025
  430241
  431022
  433656
  434624
  438001
  443802
  445500
  446278
  446624
  453149
  458327
  461599
  463171
  466075
  466959
  468774
  469288
  471008
  471941
  474029
  477080
  479100
  484416
  484485
  484660
  484695
  484703
  484718
  484738
  490923
  490933
  491078
  492108
  494731
  496540
  497953
  502512
  505023
  505693
  505811
  506580
  520473
  523803
  524351
  554004
  559386
  564648
  570700
  574596
  579938
  590627
  591294
  598911
  599610
  665207
  665284
  665288
  669736
  670489
  714864
  718836
  724133
  724328
  728288
  728452
  758617
  770196
  790015
  790022
  792663
  796078
  813913
  815417
  817413
  817463
  817917
  823622
]
2.70 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young boy threesome"
]
1.84 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young парен секс втро"
]
1.75 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young парен секс втро"
]

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.