GET https://search.jues.net/search/embeds/9?q=anal%20russian%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.35 ms
(80.12%)
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
  389098
  390568
  390571
  390582
  391651
  391655
  391911
  397850
  397853
  397863
  398964
  400479
  400494
  400807
  400808
  400842
  400849
  400852
  400865
  401006
  410937
  411863
  418125
  419517
  419522
  419531
  419539
  421945
  422183
  422358
  424325
  424430
  424436
  424446
  424452
  424462
  428136
  428142
  428817
  439320
  439529
  439591
  439609
  439806
  440707
  440991
  443407
  443771
  443773
  443790
  446740
  447350
  447751
  450368
  450901
  451480
  451488
  452677
  461441
  462305
  465892
  465949
  466208
  466213
  466267
  466877
  466893
  468097
  470166
  470189
  470275
  470971
  472148
  474635
  474648
  474678
  474693
  477961
  479049
  479126
  480059
  481918
  484608
  484626
  484644
  484673
  484704
  484746
  485246
  486341
  486344
  490085
  491114
  491910
  498491
  501797
  503411
  505023
  508003
  514436
  518264
  534028
  547622
  549799
  550219
  551226
  558131
  561692
  563413
  590398
  601338
  602653
  636026
  650155
  651841
  699625
  788767
  798680
  807326
  808691
]
20.34 ms
(12.90%)
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
  547622
  561692
  651841
  590398
  808691
  422183
  424452
  447751
  466893
  390568
  390582
  440707
  451488
  470189
  470971
  397853
  418125
  477961
  400842
  466267
  428817
  450368
  465949
  468097
  490085
  484608
  391651
  411863
  443773
  400807
  472148
  479049
  400808
  424446
  439591
  452677
  474648
  419522
  505023
  439806
  397863
  391655
  400852
  474635
  397850
  470166
  470275
  443407
  422358
  439529
  424325
  465892
  481918
  440991
  443790
  474678
  484704
  486341
  391911
  563413
  550219
  601338
  400865
  419539
  424436
  428136
  400494
  400849
  424430
  428142
  466877
  401006
  419517
  421945
  439609
  451480
  461441
  508003
  518264
  498491
  446740
  558131
  484644
  486344
  503411
  534028
  551226
  390571
  466213
  400479
  480059
  514436
  484673
  474693
  443771
  466208
  462305
  450901
  479126
  501797
  484746
  650155
  699625
  636026
  602653
  798680
  807326
  788767
  424462
  398964
  389098
  439320
  447350
  410937
  419531
  484626
  491114
  491910
  485246
  549799
]
3.35 ms
(2.13%)
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
  389098
  390568
  390571
  390582
  391651
  391655
  391911
  397850
  397853
  397863
  398964
  400479
  400494
  400807
  400808
  400842
  400849
  400852
  400865
  401006
  410937
  411863
  418125
  419517
  419522
  419531
  419539
  421945
  422183
  422358
  424325
  424430
  424436
  424446
  424452
  424462
  428136
  428142
  428817
  439320
  439529
  439591
  439609
  439806
  440707
  440991
  443407
  443771
  443773
  443790
  446740
  447350
  447751
  450368
  450901
  451480
  451488
  452677
  461441
  462305
  465892
  465949
  466208
  466213
  466267
  466877
  466893
  468097
  470166
  470189
  470275
  470971
  472148
  474635
  474648
  474678
  474693
  477961
  479049
  479126
  480059
  481918
  484608
  484626
  484644
  484673
  484704
  484746
  485246
  486341
  486344
  490085
  491114
  491910
  498491
  501797
  503411
  505023
  508003
  514436
  518264
  534028
  547622
  549799
  550219
  551226
  558131
  561692
  563413
  590398
  601338
  602653
  636026
  650155
  651841
  699625
  788767
  798680
  807326
  808691
]
2.28 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal russian young"
]
1.86 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал русск young"
]
1.76 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.