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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
203.83 ms
(51.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
171.50 ms
(43.51%)
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
  24855
  24993
  187903
  188064
  233641
  233710
  239109
  247381
  330715
  366050
  382184
  383241
  383338
  383722
  386189
  386686
  387296
  388724
  391518
  391520
  392563
  392679
  393441
  395142
  395901
  396424
  396970
  397222
  397873
  398244
  401807
  405411
  406073
  407533
  407797
  408245
  408365
  408380
  409942
  411333
  411338
  411386
  411390
  411397
  411430
  411715
  411773
  411946
  413989
  418910
  419051
  439572
  443178
  443719
  443728
  444001
  448727
  460759
  462307
  462531
  462557
  462709
  466136
  467537
  467541
  468927
  471053
  474398
  474843
  479081
  479084
  483362
  484417
  484634
  484725
  486350
  500795
  510889
  514369
  520920
  521721
  526675
  526701
  528198
  550647
  552071
  559060
  566303
  614514
  646208
  663987
  665508
  696309
  696316
  714909
  718549
  720599
  721498
  724293
  725165
  725363
  725401
  726544
  728237
  728445
  736408
  748128
  748234
  781648
  781752
  781930
  788151
  788229
  792660
  794802
  806959
  808040
  808456
  808558
  808649
]
11.54 ms
(2.93%)
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
  748128
  408365
  411715
  724293
  408380
  443719
  443728
  247381
  24993
  386686
  443178
  444001
  407797
  468927
  526675
  559060
  550647
  462709
  439572
  462307
  462531
  411946
  388724
  521721
  566303
  646208
  696309
  788151
  788229
  736408
  725165
  794802
  808649
  413989
  407533
  391518
  391520
  393441
  395901
  330715
  387296
  396424
  397222
  474398
  721498
  665508
  663987
  725401
  806959
  233710
  24855
  411397
  419051
  418910
  239109
  409942
  383722
  406073
  411773
  479081
  474843
  714909
  696316
  718549
  781752
  808456
  808558
  725363
  728237
  720599
  781648
  781930
  808040
  383241
  392679
  448727
  233641
  366050
  411390
  396970
  401807
  187903
  528198
  383338
  382184
  397873
  398244
  405411
  408245
  500795
  526701
  479084
  552071
  614514
  728445
  748234
  792660
  726544
  386189
  411333
  460759
  471053
  411338
  467541
  411386
  462557
  392563
  411430
  466136
  467537
  514369
  484417
  520920
  483362
  484634
  484725
  510889
  486350
  188064
  395142
]
2.49 ms
(0.63%)
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
  24855
  24993
  187903
  188064
  233641
  233710
  239109
  247381
  330715
  366050
  382184
  383241
  383338
  383722
  386189
  386686
  387296
  388724
  391518
  391520
  392563
  392679
  393441
  395142
  395901
  396424
  396970
  397222
  397873
  398244
  401807
  405411
  406073
  407533
  407797
  408245
  408365
  408380
  409942
  411333
  411338
  411386
  411390
  411397
  411430
  411715
  411773
  411946
  413989
  418910
  419051
  439572
  443178
  443719
  443728
  444001
  448727
  460759
  462307
  462531
  462557
  462709
  466136
  467537
  467541
  468927
  471053
  474398
  474843
  479081
  479084
  483362
  484417
  484634
  484725
  486350
  500795
  510889
  514369
  520920
  521721
  526675
  526701
  528198
  550647
  552071
  559060
  566303
  614514
  646208
  663987
  665508
  696309
  696316
  714909
  718549
  720599
  721498
  724293
  725165
  725363
  725401
  726544
  728237
  728445
  736408
  748128
  748234
  781648
  781752
  781930
  788151
  788229
  792660
  794802
  806959
  808040
  808456
  808558
  808649
]
1.89 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature young boy"
]
1.62 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature young парен"
]
1.27 ms
(0.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature 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.