GET https://search.jues.net/search/embeds/4?q=anal%20close-up

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.26 ms
(88.88%)
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
  202902
  392225
  392236
  396464
  416397
  446709
  468363
  471352
  493223
  506283
  530584
  530987
  535384
  535765
  536995
  538899
  544161
  544809
  545175
  546417
  547609
  549073
  559401
  559661
  565440
  566846
  567994
  576906
  586736
  590828
  590845
  604260
  604655
  616598
  619050
  619347
  627362
  629686
  631106
  645342
  647689
  660466
  662015
  675607
  680233
  688939
  689456
  690973
  691662
  698840
  707102
  713022
  715562
  717204
  717837
  718154
  718240
  720703
  721974
  724142
  728393
  729074
  733796
  736228
  736242
  738591
  740107
  740865
  743944
  747100
  749891
  750222
  750269
  752720
  757111
  761080
  761538
  762301
  762779
  764130
  765058
  765072
  765073
  765105
  765248
  765437
  766673
  766905
  767203
  767212
  777034
  777575
  778850
  779005
  780799
  782294
  783089
  784266
  790141
  792806
  793330
  793331
  793867
  794915
  796528
  796884
  798804
  803848
  804810
  805310
  813828
  814647
  817237
  821005
  825414
  825733
  826294
  826731
  827381
  828595
]
10.19 ms
(5.83%)
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
  805310
  826294
  536995
  794915
  765105
  689456
  559661
  396464
  750222
  825414
  827381
  733796
  790141
  825733
  817237
  765248
  747100
  757111
  576906
  803848
  784266
  736228
  750269
  740865
  631106
  202902
  416397
  813828
  821005
  468363
  535765
  530584
  546417
  565440
  547609
  567994
  544161
  549073
  559401
  566846
  647689
  662015
  675607
  688939
  690973
  707102
  713022
  715562
  718240
  720703
  660466
  691662
  645342
  680233
  717204
  718154
  721974
  586736
  604655
  604260
  629686
  590828
  590845
  616598
  783089
  793330
  793331
  793867
  777034
  777575
  779005
  792806
  796528
  796884
  804810
  740107
  765058
  765072
  767203
  736242
  765437
  728393
  729074
  765073
  724142
  738591
  743944
  749891
  762779
  766905
  752720
  761538
  762301
  766673
  619050
  619347
  698840
  782294
  798804
  392236
  446709
  392225
  826731
  538899
  544809
  767212
  471352
  828595
  506283
  530987
  545175
  778850
  761080
  764130
  814647
  493223
  717837
  780799
  535384
  627362
]
2.54 ms
(1.46%)
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
  202902
  392225
  392236
  396464
  416397
  446709
  468363
  471352
  493223
  506283
  530584
  530987
  535384
  535765
  536995
  538899
  544161
  544809
  545175
  546417
  547609
  549073
  559401
  559661
  565440
  566846
  567994
  576906
  586736
  590828
  590845
  604260
  604655
  616598
  619050
  619347
  627362
  629686
  631106
  645342
  647689
  660466
  662015
  675607
  680233
  688939
  689456
  690973
  691662
  698840
  707102
  713022
  715562
  717204
  717837
  718154
  718240
  720703
  721974
  724142
  728393
  729074
  733796
  736228
  736242
  738591
  740107
  740865
  743944
  747100
  749891
  750222
  750269
  752720
  757111
  761080
  761538
  762301
  762779
  764130
  765058
  765072
  765073
  765105
  765248
  765437
  766673
  766905
  767203
  767212
  777034
  777575
  778850
  779005
  780799
  782294
  783089
  784266
  790141
  792806
  793330
  793331
  793867
  794915
  796528
  796884
  798804
  803848
  804810
  805310
  813828
  814647
  817237
  821005
  825414
  825733
  826294
  826731
  827381
  828595
]
1.88 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal close-up"
]
1.62 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал close up"
]
1.62 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал close up"
]

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.