GET https://search.jues.net/search/embeds/7?q=big%20dildo%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.37 ms
(86.05%)
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
  65811
  397568
  400638
  414277
  416000
  416446
  425895
  426511
  427364
  427457
  435530
  438181
  438619
  440708
  442064
  443317
  448257
  450277
  450845
  454793
  455078
  459339
  466601
  467560
  479037
  479867
  498110
  502242
  505138
  511856
  513972
  514339
  514994
  522757
  529696
  531891
  534443
  534828
  541850
  541851
  545390
  545434
  554549
  555075
  559360
  564291
  567245
  568646
  576848
  587214
  590977
  601071
  601698
  602283
  603407
  605074
  605096
  607142
  613000
  614623
  617473
  623280
  624893
  626588
  633119
  634180
  638737
  639791
  660399
  666736
  668620
  669056
  673942
  674077
  674087
  680562
  689508
  697457
  703644
  709316
  710357
  720140
  723461
  724993
  728540
  728567
  739146
  739814
  742359
  751410
  752799
  753124
  753190
  756233
  757232
  758787
  758789
  758822
  760862
  772230
  777051
  778266
  778864
  779765
  782515
  783036
  783818
  785868
  788113
  798473
  802644
  806995
  807902
  808235
  808968
  810776
  813206
  813801
  825432
  826278
]
15.42 ms
(8.43%)
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
  587214
  798473
  742359
  416446
  479867
  443317
  427457
  454793
  576848
  397568
  614623
  808235
  782515
  785868
  807902
  633119
  414277
  514339
  511856
  505138
  513972
  660399
  626588
  605096
  426511
  502242
  498110
  826278
  590977
  777051
  466601
  448257
  669056
  65811
  674077
  723461
  783036
  756233
  758789
  623280
  479037
  400638
  459339
  541850
  697457
  758787
  709316
  545390
  603407
  435530
  440708
  605074
  455078
  467560
  427364
  438619
  541851
  442064
  813801
  450277
  666736
  668620
  680562
  545434
  613000
  607142
  639791
  601071
  638737
  806995
  724993
  753124
  728567
  728540
  752799
  760862
  751410
  757232
  624893
  710357
  802644
  425895
  416000
  825432
  438181
  534828
  522757
  529696
  531891
  534443
  567245
  673942
  617473
  634180
  779765
  808968
  810776
  739814
  753190
  783818
  813206
  739146
  758822
  772230
  703644
  778864
  450845
  514994
  559360
  564291
  554549
  568646
  674087
  689508
  720140
  555075
  601698
  602283
  788113
  778266
]
2.48 ms
(1.36%)
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
  65811
  397568
  400638
  414277
  416000
  416446
  425895
  426511
  427364
  427457
  435530
  438181
  438619
  440708
  442064
  443317
  448257
  450277
  450845
  454793
  455078
  459339
  466601
  467560
  479037
  479867
  498110
  502242
  505138
  511856
  513972
  514339
  514994
  522757
  529696
  531891
  534443
  534828
  541850
  541851
  545390
  545434
  554549
  555075
  559360
  564291
  567245
  568646
  576848
  587214
  590977
  601071
  601698
  602283
  603407
  605074
  605096
  607142
  613000
  614623
  617473
  623280
  624893
  626588
  633119
  634180
  638737
  639791
  660399
  666736
  668620
  669056
  673942
  674077
  674087
  680562
  689508
  697457
  703644
  709316
  710357
  720140
  723461
  724993
  728540
  728567
  739146
  739814
  742359
  751410
  752799
  753124
  753190
  756233
  757232
  758787
  758789
  758822
  760862
  772230
  777051
  778266
  778864
  779765
  782515
  783036
  783818
  785868
  788113
  798473
  802644
  806995
  807902
  808235
  808968
  810776
  813206
  813801
  825432
  826278
]
2.18 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big dildo ass"
]
1.93 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие дилд жоп"
]
1.83 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие дилд жоп"
]
1.68 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.