GET https://search.jues.net/search/embeds/5?q=amateurs%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
111.35 ms
(84.41%)
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
  493945
  500821
  507848
  525299
  534868
  539317
  545872
  546367
  547087
  554882
  558400
  560895
  567772
  578166
  582729
  590652
  591246
  601639
  603940
  604892
  605978
  609194
  612888
  614001
  617229
  623745
  626613
  626678
  629549
  632892
  638157
  640252
  641222
  641322
  648655
  649633
  652750
  653894
  655603
  660455
  660826
  662076
  663301
  671239
  674894
  676659
  678921
  681941
  682413
  682854
  685250
  685398
  685411
  687452
  687644
  689994
  691149
  692164
  694846
  699156
  699902
  701207
  707616
  708081
  708329
  710554
  713352
  715407
  716290
  723279
  725043
  725538
  728511
  732264
  733764
  734097
  738541
  741064
  741860
  743892
  745554
  745873
  745933
  750132
  750169
  751967
  752135
  757887
  761501
  761990
  766167
  767973
  768400
  768570
  769193
  772763
  773184
  775543
  775739
  777335
  778083
  778217
  778696
  778710
  782308
  782782
  786753
  788352
  789451
  795335
  796233
  797123
  801266
  803985
  804482
  806680
  809672
  825381
]
10.83 ms
(8.21%)
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
  809672
  734097
  752135
  733764
  761501
  778217
  778696
  590652
  640252
  507848
  554882
  660826
  681941
  687644
  671239
  674894
  682413
  685398
  653894
  663301
  676659
  678921
  685411
  708081
  710554
  546367
  626613
  605978
  591246
  601639
  617229
  641322
  751967
  612888
  629549
  632892
  638157
  699156
  708329
  713352
  743892
  500821
  757887
  767973
  725024
  803985
  745873
  707616
  825381
  578166
  689994
  692164
  682854
  648655
  623745
  558400
  652750
  694846
  525299
  493945
  567772
  649633
  691149
  715407
  655603
  662076
  685250
  687452
  604892
  614001
  603940
  626678
  641222
  741860
  699902
  777335
  801266
  539317
  534868
  716290
  582729
  796233
  725043
  773184
  728511
  745554
  750169
  732264
  738541
  750132
  723279
  775739
  797123
  609194
  772763
  701207
  741064
  560895
  660455
  782308
  547087
  545872
  782782
  788352
  768400
  745933
  772129
  778083
  778710
  804482
  775543
  786753
  806680
  769193
  795335
  761990
  766167
  725538
  768570
  789451
]
2.31 ms
(1.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateurs homemade"
]
2.27 ms
(1.72%)
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
  493945
  500821
  507848
  525299
  534868
  539317
  545872
  546367
  547087
  554882
  558400
  560895
  567772
  578166
  582729
  590652
  591246
  601639
  603940
  604892
  605978
  609194
  612888
  614001
  617229
  623745
  626613
  626678
  629549
  632892
  638157
  640252
  641222
  641322
  648655
  649633
  652750
  653894
  655603
  660455
  660826
  662076
  663301
  671239
  674894
  676659
  678921
  681941
  682413
  682854
  685250
  685398
  685411
  687452
  687644
  689994
  691149
  692164
  694846
  699156
  699902
  701207
  707616
  708081
  708329
  710554
  713352
  715407
  716290
  723279
  725043
  725538
  728511
  732264
  733764
  734097
  738541
  741064
  741860
  743892
  745554
  745873
  745933
  750132
  750169
  751967
  752135
  757887
  761501
  761990
  766167
  767973
  768400
  768570
  769193
  772763
  773184
  775543
  775739
  777335
  778083
  778217
  778696
  778710
  782308
  782782
  786753
  788352
  789451
  795335
  796233
  797123
  801266
  803985
  804482
  806680
  809672
  825381
]
1.89 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск домашн любительск"
]
1.66 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск домашн любительск"
]
1.60 ms
(1.21%)
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.