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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.31 ms
(84.79%)
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
  11385
  95943
  341596
  384524
  388449
  394754
  395919
  395970
  398347
  400126
  400857
  402378
  404273
  405000
  405940
  406646
  406913
  407650
  409682
  409886
  411237
  411547
  411948
  419524
  419529
  421070
  421494
  422504
  423375
  424411
  424428
  425048
  425582
  425799
  426653
  430072
  430095
  430839
  431242
  432869
  435496
  436933
  443741
  443773
  443799
  444141
  446112
  446629
  447163
  449886
  451250
  451826
  454709
  459141
  462515
  463773
  464129
  466262
  466369
  466915
  467004
  467025
  469071
  471406
  471522
  471628
  472142
  472235
  474147
  474661
  477580
  478546
  479149
  483141
  483440
  484559
  484739
  485037
  488301
  491790
  496832
  504386
  504456
  505691
  514841
  523335
  531531
  551579
  552281
  554513
  563844
  563865
  569682
  574235
  589752
  611616
  621965
  623476
  633528
  650793
  665317
  665448
  665875
  667196
  667532
  667859
  667878
  674378
  682129
  684265
  688055
  688575
  694181
  698284
  752563
  789690
  789968
  791361
  815745
  820529
]
18.03 ms
(9.31%)
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
  400126
  422504
  815745
  531531
  665317
  665448
  667878
  667196
  667859
  682129
  665875
  667532
  674378
  589752
  623476
  394754
  491790
  504386
  563865
  474147
  423375
  488301
  504456
  395919
  11385
  684265
  694181
  650793
  633528
  791361
  395970
  611616
  471628
  523335
  384524
  466915
  462515
  569682
  405000
  405940
  409886
  411948
  436933
  563844
  446112
  483440
  496832
  472235
  752563
  398347
  406646
  425799
  407650
  430072
  451250
  459141
  789690
  478546
  479149
  621965
  471522
  454709
  820529
  552281
  789968
  406913
  411547
  425048
  421070
  469071
  477580
  484739
  505691
  574235
  443773
  400857
  432869
  95943
  471406
  466262
  467004
  484559
  411237
  447163
  451826
  463773
  449886
  464129
  467025
  551579
  688055
  698284
  404273
  419524
  419529
  424428
  425582
  443741
  466369
  472142
  421494
  431242
  443799
  402378
  435496
  446629
  688575
  554513
  409682
  444141
  430095
  430839
  474661
  424411
  426653
  485037
  483141
  341596
  388449
  514841
]
3.46 ms
(1.79%)
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
  11385
  95943
  341596
  384524
  388449
  394754
  395919
  395970
  398347
  400126
  400857
  402378
  404273
  405000
  405940
  406646
  406913
  407650
  409682
  409886
  411237
  411547
  411948
  419524
  419529
  421070
  421494
  422504
  423375
  424411
  424428
  425048
  425582
  425799
  426653
  430072
  430095
  430839
  431242
  432869
  435496
  436933
  443741
  443773
  443799
  444141
  446112
  446629
  447163
  449886
  451250
  451826
  454709
  459141
  462515
  463773
  464129
  466262
  466369
  466915
  467004
  467025
  469071
  471406
  471522
  471628
  472142
  472235
  474147
  474661
  477580
  478546
  479149
  483141
  483440
  484559
  484739
  485037
  488301
  491790
  496832
  504386
  504456
  505691
  514841
  523335
  531531
  551579
  552281
  554513
  563844
  563865
  569682
  574235
  589752
  611616
  621965
  623476
  633528
  650793
  665317
  665448
  665875
  667196
  667532
  667859
  667878
  674378
  682129
  684265
  688055
  688575
  694181
  698284
  752563
  789690
  789968
  791361
  815745
  820529
]
2.14 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young boy threesome"
]
2.11 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young парен секс втро"
]
1.94 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young парен секс втро"
]
1.79 ms
(0.92%)
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.