GET https://search.jues.net/search/embeds/3?q=mature%20amateur%20russian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.25 ms
(84.17%)
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
  366010
  387285
  389567
  389612
  389729
  389842
  391287
  392005
  392565
  395891
  395908
  397911
  400987
  432596
  439709
  439729
  439746
  443830
  443925
  444124
  445199
  451464
  451495
  452963
  454156
  454211
  454244
  454561
  459837
  460898
  460912
  460926
  462305
  462710
  463177
  465397
  465892
  465949
  466240
  466247
  469427
  469885
  470018
  470537
  474490
  474493
  474635
  474790
  475868
  476268
  477128
  477133
  478387
  479087
  479088
  479096
  479097
  479099
  479110
  479112
  479146
  481124
  483405
  484452
  484570
  484607
  484625
  484750
  485444
  486341
  490413
  490936
  491153
  497205
  506017
  506042
  509485
  509995
  510775
  519585
  520743
  520750
  520872
  521129
  526747
  526837
  533752
  539383
  543619
  543708
  550222
  550646
  554488
  557971
  559059
  565724
  566303
  609188
  615693
  617638
  705471
  725197
  731137
  739927
  741699
  742389
  742585
  758231
  782234
  794830
  796252
  799910
  802195
  807336
  810359
  816605
  816609
  818924
  823847
  824584
]
16.18 ms
(9.44%)
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
  470018
  474490
  481124
  460912
  479112
  484625
  497205
  491153
  479146
  816605
  392565
  475868
  466240
  479096
  506017
  474493
  509995
  469427
  460926
  816609
  823847
  818924
  739927
  742389
  479088
  566303
  485444
  520872
  483405
  741699
  615693
  460898
  465397
  476268
  454211
  509485
  521129
  490413
  389729
  391287
  543619
  565724
  454156
  454244
  474635
  479087
  479097
  479099
  439746
  463177
  466247
  484607
  520743
  519585
  465892
  486341
  465949
  462305
  462710
  484570
  506042
  451464
  387285
  484452
  477128
  520750
  824584
  557971
  794830
  807336
  478387
  474790
  439709
  397911
  366010
  389567
  389612
  395891
  539383
  533752
  799910
  484750
  782234
  705471
  490936
  725197
  810359
  443925
  543708
  617638
  443830
  609188
  796252
  731137
  742585
  802195
  392005
  452963
  510775
  469885
  479110
  451495
  459837
  439729
  526747
  395908
  444124
  477133
  550222
  554488
  550646
  559059
  758231
  389842
  454561
  400987
  432596
  445199
  470537
  526837
]
3.72 ms
(2.17%)
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
  366010
  387285
  389567
  389612
  389729
  389842
  391287
  392005
  392565
  395891
  395908
  397911
  400987
  432596
  439709
  439729
  439746
  443830
  443925
  444124
  445199
  451464
  451495
  452963
  454156
  454211
  454244
  454561
  459837
  460898
  460912
  460926
  462305
  462710
  463177
  465397
  465892
  465949
  466240
  466247
  469427
  469885
  470018
  470537
  474490
  474493
  474635
  474790
  475868
  476268
  477128
  477133
  478387
  479087
  479088
  479096
  479097
  479099
  479110
  479112
  479146
  481124
  483405
  484452
  484570
  484607
  484625
  484750
  485444
  486341
  490413
  490936
  491153
  497205
  506017
  506042
  509485
  509995
  510775
  519585
  520743
  520750
  520872
  521129
  526747
  526837
  533752
  539383
  543619
  543708
  550222
  550646
  554488
  557971
  559059
  565724
  566303
  609188
  615693
  617638
  705471
  725197
  731137
  739927
  741699
  742389
  742585
  758231
  782234
  794830
  796252
  799910
  802195
  807336
  810359
  816605
  816609
  818924
  823847
  824584
]
2.07 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature amateur russian"
]
1.91 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature любительск русск"
]
1.54 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature любительск русск"
]

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.