GET https://search.jues.net/search/embeds/8?q=ass%20sport

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.38 ms
(84.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
  124308
  397026
  405760
  409114
  414329
  440664
  444994
  458111
  459694
  465437
  466753
  471173
  478609
  479264
  479485
  481362
  484070
  487775
  488769
  492225
  492230
  493483
  494406
  497485
  506861
  510189
  511503
  514731
  514795
  515465
  515522
  515652
  516369
  516793
  517370
  517957
  518974
  521841
  526289
  526649
  530089
  530664
  530802
  531009
  531011
  531666
  532411
  532724
  533237
  533432
  533561
  534045
  539456
  539881
  540517
  542164
  543904
  548219
  554098
  556256
  557657
  569801
  579570
  583570
  585437
  589508
  595982
  596044
  600465
  609081
  611116
  613715
  629367
  629423
  629845
  630281
  636071
  636125
  641172
  642086
  643436
  650204
  652291
  662910
  673973
  689688
  692104
  692405
  714065
  717717
  721003
  740466
  744189
  752494
  770536
  771590
  780125
  781392
  781488
  783770
  789990
  792808
  795570
  795775
  798733
  807614
  815407
  815528
  816987
  817134
  817504
  817793
  818271
  818329
  819081
  819108
  821663
  824110
  824470
  825749
]
14.36 ms
(9.41%)
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
  471173
  478609
  414329
  479485
  458111
  506861
  514731
  515465
  492225
  492230
  497485
  515522
  517370
  526649
  488769
  494406
  516369
  517957
  521841
  487775
  493483
  510189
  515652
  526289
  440664
  557657
  554098
  585437
  459694
  479264
  516793
  124308
  409114
  817504
  821663
  824110
  824470
  825749
  816987
  815528
  817134
  818271
  818329
  819081
  819108
  815407
  466753
  514795
  532411
  518974
  530089
  530664
  531666
  540517
  531009
  531011
  533237
  542164
  543904
  548219
  650204
  652291
  692104
  692405
  556256
  569801
  589508
  596044
  600465
  629367
  595982
  613715
  642086
  630281
  641172
  643436
  795570
  798733
  781488
  792808
  795775
  770536
  740466
  744189
  752494
  771590
  611116
  629423
  629845
  714065
  717717
  781392
  783770
  789990
  807614
  689688
  780125
  465437
  405760
  444994
  511503
  481362
  397026
  817793
  484070
  539881
  530802
  532724
  534045
  539456
  533432
  533561
  579570
  662910
  673973
  721003
  583570
  609081
  636125
  636071
]
2.74 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
  124308
  397026
  405760
  409114
  414329
  440664
  444994
  458111
  459694
  465437
  466753
  471173
  478609
  479264
  479485
  481362
  484070
  487775
  488769
  492225
  492230
  493483
  494406
  497485
  506861
  510189
  511503
  514731
  514795
  515465
  515522
  515652
  516369
  516793
  517370
  517957
  518974
  521841
  526289
  526649
  530089
  530664
  530802
  531009
  531011
  531666
  532411
  532724
  533237
  533432
  533561
  534045
  539456
  539881
  540517
  542164
  543904
  548219
  554098
  556256
  557657
  569801
  579570
  583570
  585437
  589508
  595982
  596044
  600465
  609081
  611116
  613715
  629367
  629423
  629845
  630281
  636071
  636125
  641172
  642086
  643436
  650204
  652291
  662910
  673973
  689688
  692104
  692405
  714065
  717717
  721003
  740466
  744189
  752494
  770536
  771590
  780125
  781392
  781488
  783770
  789990
  792808
  795570
  795775
  798733
  807614
  815407
  815528
  816987
  817134
  817504
  817793
  818271
  818329
  819081
  819108
  821663
  824110
  824470
  825749
]
2.05 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass sport"
]
1.79 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп спортивная"
]
1.70 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.