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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.79 ms
(86.66%)
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
  491814
  519639
  530392
  537525
  538668
  539519
  542976
  543822
  544270
  544301
  544356
  547340
  547345
  547642
  548562
  549912
  550612
  552900
  559705
  563877
  566681
  572575
  572578
  577161
  580664
  585169
  602573
  612842
  619430
  622178
  626543
  626755
  628300
  635897
  644696
  648487
  652600
  652991
  655685
  655691
  656381
  657730
  657949
  658066
  658419
  659601
  665247
  665512
  666810
  667244
  670074
  673985
  675729
  675737
  677459
  677543
  681862
  682091
  683505
  683524
  684224
  684238
  684943
  684965
  685632
  685891
  686794
  688370
  688591
  694536
  695921
  696508
  701297
  701384
  701444
  702656
  702683
  702958
  708101
  711894
  712829
  712906
  712913
  712923
  715832
  716391
  717649
  718627
  719989
  721434
  721574
  734715
  739478
  741019
  743158
  751500
  755735
  787951
  788448
  788963
  792698
  799760
  802824
  807724
  812119
  813941
  814074
  814915
  815259
  817309
  817335
  818821
  819191
  819550
  819595
  820087
  820427
  821625
  823024
  824012
]
12.22 ms
(7.52%)
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
  813941
  814074
  815259
  819550
  823024
  824012
  814915
  817309
  817335
  818821
  819191
  819595
  820087
  820427
  821625
  539519
  519639
  530392
  537525
  538668
  491814
  542976
  543822
  550612
  572578
  547642
  548562
  549912
  566681
  577161
  544270
  544301
  544356
  563877
  580664
  648487
  652600
  657730
  658066
  665512
  666810
  677459
  677543
  681862
  682091
  688370
  696508
  701384
  701444
  708101
  655691
  657949
  658419
  667244
  673985
  675729
  684965
  685632
  686794
  694536
  695921
  701297
  702656
  702958
  711894
  712829
  712913
  715832
  716391
  717649
  652991
  655685
  656381
  659601
  665247
  670074
  675737
  683505
  683524
  684224
  684238
  684943
  685891
  688591
  702683
  712906
  712923
  718627
  719989
  721434
  721574
  547340
  547345
  552900
  559705
  572575
  628300
  635897
  644696
  585169
  602573
  612842
  619430
  622178
  626543
  626755
  787951
  788448
  799760
  807724
  812119
  788963
  792698
  802824
  734715
  739478
  741019
  743158
  751500
  755735
]
2.65 ms
(1.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
  491814
  519639
  530392
  537525
  538668
  539519
  542976
  543822
  544270
  544301
  544356
  547340
  547345
  547642
  548562
  549912
  550612
  552900
  559705
  563877
  566681
  572575
  572578
  577161
  580664
  585169
  602573
  612842
  619430
  622178
  626543
  626755
  628300
  635897
  644696
  648487
  652600
  652991
  655685
  655691
  656381
  657730
  657949
  658066
  658419
  659601
  665247
  665512
  666810
  667244
  670074
  673985
  675729
  675737
  677459
  677543
  681862
  682091
  683505
  683524
  684224
  684238
  684943
  684965
  685632
  685891
  686794
  688370
  688591
  694536
  695921
  696508
  701297
  701384
  701444
  702656
  702683
  702958
  708101
  711894
  712829
  712906
  712913
  712923
  715832
  716391
  717649
  718627
  719989
  721434
  721574
  734715
  739478
  741019
  743158
  751500
  755735
  787951
  788448
  788963
  792698
  799760
  802824
  807724
  812119
  813941
  814074
  814915
  815259
  817309
  817335
  818821
  819191
  819550
  819595
  820087
  820427
  821625
  823024
  824012
]
1.95 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young teen boy"
]
1.88 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young молодой"
]
1.54 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young молодой"
]
1.44 ms
(0.88%)
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.