GET https://search.jues.net/search/embeds/8?q=mmf%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.33 ms
(83.06%)
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
  385491
  395981
  399824
  400162
  400191
  400932
  409024
  411725
  413972
  417738
  418559
  423375
  426009
  427177
  429912
  431762
  443733
  448674
  449011
  453352
  455225
  461771
  462292
  465525
  465951
  467316
  470074
  471008
  471347
  471941
  472445
  473739
  473968
  474642
  479100
  479108
  484718
  485648
  486451
  487339
  492259
  493192
  493260
  496540
  498033
  504136
  509403
  514589
  515187
  515206
  515717
  521928
  522832
  523727
  531989
  542757
  545602
  548538
  548570
  549176
  550705
  555948
  558128
  558601
  559120
  560408
  560429
  565172
  565471
  566991
  567829
  571680
  572763
  574410
  574596
  581096
  583622
  584073
  590256
  591110
  603622
  610676
  611616
  612399
  613832
  623203
  624468
  628117
  636593
  637086
  645822
  647343
  647906
  663461
  664583
  664834
  666804
  666875
  667288
  667320
  667496
  667695
  669752
  670490
  670507
  671726
  704235
  728446
  729635
  732559
  790015
  792648
  792663
  799971
  800570
  808621
  809932
  812795
  814814
  825039
]
15.52 ms
(10.62%)
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
  486451
  523727
  509403
  492259
  493260
  542757
  548570
  664834
  667320
  669752
  645822
  663461
  666804
  670507
  800570
  799971
  728446
  729635
  792648
  400162
  462292
  448674
  504136
  521928
  431762
  814814
  455225
  732559
  400191
  479108
  522832
  400932
  418559
  429912
  825039
  472445
  465951
  449011
  531989
  574596
  636593
  792663
  809932
  417738
  411725
  471347
  385491
  484718
  558601
  515187
  515206
  574410
  485648
  667496
  670490
  667288
  610676
  812795
  790015
  808621
  461771
  473968
  479100
  471008
  566991
  671726
  571680
  667695
  624468
  514589
  496540
  591110
  565471
  545602
  558128
  647906
  567829
  623203
  467316
  550705
  560429
  572763
  637086
  613832
  515717
  487339
  465525
  555948
  584073
  647343
  704235
  664583
  549176
  612399
  603622
  628117
  470074
  413972
  423375
  473739
  583622
  581096
  565172
  493192
  559120
  666875
  590256
  560408
  548538
  409024
  443733
  453352
  399824
  471941
  498033
  395981
  426009
  474642
  611616
  427177
]
2.47 ms
(1.69%)
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
  385491
  395981
  399824
  400162
  400191
  400932
  409024
  411725
  413972
  417738
  418559
  423375
  426009
  427177
  429912
  431762
  443733
  448674
  449011
  453352
  455225
  461771
  462292
  465525
  465951
  467316
  470074
  471008
  471347
  471941
  472445
  473739
  473968
  474642
  479100
  479108
  484718
  485648
  486451
  487339
  492259
  493192
  493260
  496540
  498033
  504136
  509403
  514589
  515187
  515206
  515717
  521928
  522832
  523727
  531989
  542757
  545602
  548538
  548570
  549176
  550705
  555948
  558128
  558601
  559120
  560408
  560429
  565172
  565471
  566991
  567829
  571680
  572763
  574410
  574596
  581096
  583622
  584073
  590256
  591110
  603622
  610676
  611616
  612399
  613832
  623203
  624468
  628117
  636593
  637086
  645822
  647343
  647906
  663461
  664583
  664834
  666804
  666875
  667288
  667320
  667496
  667695
  669752
  670490
  670507
  671726
  704235
  728446
  729635
  732559
  790015
  792648
  792663
  799971
  800570
  808621
  809932
  812795
  814814
  825039
]
1.95 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mmf young"
]
1.63 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мжм секс втро young"
]
1.39 ms
(0.95%)
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.