GET https://search.jues.net/search/embeds/10?q=stepson%20big%20dick

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.88 ms
(83.89%)
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
  391092
  401626
  407124
  407158
  407527
  418747
  418967
  426408
  443163
  445836
  452575
  455077
  457058
  458698
  459908
  460144
  461100
  466063
  466165
  467527
  467843
  469061
  470461
  471608
  471619
  471633
  472173
  481923
  482334
  482394
  485682
  488073
  488128
  489399
  490001
  490769
  493270
  494516
  499910
  500458
  503172
  504423
  509256
  511178
  513953
  517010
  517077
  517874
  519512
  522627
  525332
  527905
  529252
  529332
  531423
  532097
  534177
  539407
  539742
  539755
  539758
  541691
  543180
  549686
  549708
  549748
  549749
  554315
  556021
  556559
  558622
  561591
  561904
  563641
  566228
  566338
  569425
  570090
  570879
  573760
  580744
  581626
  582801
  583644
  586527
  588015
  589692
  591010
  591130
  591664
  600394
  600642
  603440
  604044
  605453
  612178
  614376
  618969
  621492
  624139
  625221
  625594
  626866
  633529
  649156
  667917
  673992
  674291
  678734
  687561
  691626
  696565
  716354
  745487
  749936
  798684
  813250
  813956
  820330
  820337
]
19.96 ms
(10.04%)
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
  467843
  482334
  554315
  563641
  600394
  591130
  605453
  452575
  466165
  481923
  469061
  471608
  401626
  407158
  407527
  459908
  466063
  467527
  470461
  493270
  517874
  488128
  490001
  490769
  503172
  531423
  504423
  517010
  519512
  529332
  499910
  457058
  539407
  798684
  525332
  549748
  561591
  566228
  569425
  573760
  582801
  583644
  588015
  624139
  618969
  625594
  745487
  749936
  813250
  541691
  418967
  455077
  458698
  500458
  539755
  539742
  534177
  460144
  472173
  482394
  445836
  511178
  509256
  494516
  600642
  813956
  580744
  649156
  426408
  443163
  418747
  471633
  488073
  489399
  517077
  532097
  529252
  522627
  539758
  471619
  485682
  558622
  391092
  461100
  407124
  513953
  527905
  820330
  820337
  549686
  549708
  556559
  543180
  549749
  570879
  566338
  687561
  678734
  667917
  673992
  674291
  691626
  696565
  716354
  556021
  561904
  570090
  581626
  625221
  626866
  633529
  586527
  591010
  591664
  603440
  604044
  614376
  621492
  612178
  589692
]
3.46 ms
(1.74%)
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
  391092
  401626
  407124
  407158
  407527
  418747
  418967
  426408
  443163
  445836
  452575
  455077
  457058
  458698
  459908
  460144
  461100
  466063
  466165
  467527
  467843
  469061
  470461
  471608
  471619
  471633
  472173
  481923
  482334
  482394
  485682
  488073
  488128
  489399
  490001
  490769
  493270
  494516
  499910
  500458
  503172
  504423
  509256
  511178
  513953
  517010
  517077
  517874
  519512
  522627
  525332
  527905
  529252
  529332
  531423
  532097
  534177
  539407
  539742
  539755
  539758
  541691
  543180
  549686
  549708
  549748
  549749
  554315
  556021
  556559
  558622
  561591
  561904
  563641
  566228
  566338
  569425
  570090
  570879
  573760
  580744
  581626
  582801
  583644
  586527
  588015
  589692
  591010
  591130
  591664
  600394
  600642
  603440
  604044
  605453
  612178
  614376
  618969
  621492
  624139
  625221
  625594
  626866
  633529
  649156
  667917
  673992
  674291
  678734
  687561
  691626
  696565
  716354
  745487
  749936
  798684
  813250
  813956
  820330
  820337
]
2.53 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stepson big dick"
]
2.23 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "stepson большой большие член"
]
2.04 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "stepson большой большие член"
]

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.