GET https://search.jues.net/search/embeds/3?q=riding%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
328.23 ms
(93.99%)
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
  188613
  361679
  384480
  385434
  396807
  493578
  525182
  533188
  536978
  538538
  540753
  541107
  548197
  554153
  558887
  588790
  595166
  595186
  597277
  600660
  601506
  601521
  602595
  618080
  629256
  635303
  635536
  637798
  640085
  641263
  641473
  645529
  645606
  648931
  660383
  665986
  667174
  670902
  692703
  697484
  697585
  700177
  715276
  715627
  716155
  720356
  721712
  723724
  723749
  723750
  724014
  729086
  730128
  732999
  733505
  733530
  734660
  735275
  735297
  738317
  739533
  739636
  739878
  744379
  745244
  748958
  749641
  751504
  755644
  757278
  757287
  757315
  762660
  764279
  766283
  768706
  768866
  771052
  772261
  775678
  778281
  778601
  778673
  779263
  779294
  780705
  781245
  782044
  785738
  786015
  787264
  789515
  791770
  793017
  794715
  795777
  795917
  796689
  799809
  800481
  800493
  800818
  801166
  804693
  804975
  806129
  807161
  808991
  809343
  809660
  811603
  813211
  813946
  816183
  819960
  826165
  827296
  827395
  827494
]
11.55 ms
(3.31%)
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
  723749
  739533
  789515
  795917
  800493
  809660
  732999
  757278
  757315
  771052
  730128
  735275
  738317
  744379
  733505
  748958
  734660
  745244
  765782
  768866
  635536
  637798
  697585
  700177
  779263
  782044
  787264
  800818
  809343
  811603
  384480
  618080
  641473
  361679
  813946
  396807
  721712
  385434
  188613
  819960
  827296
  827395
  827494
  816183
  826165
  493578
  525182
  538538
  536978
  540753
  533188
  541107
  645606
  667174
  715627
  645529
  660383
  670902
  692703
  720356
  648931
  665986
  548197
  554153
  558887
  601521
  629256
  595166
  597277
  600660
  588790
  601506
  602595
  641263
  595186
  775678
  779294
  780705
  786015
  794715
  804693
  804975
  778281
  778601
  781245
  807161
  808991
  723724
  729086
  749641
  755644
  757287
  764279
  768706
  772261
  785738
  791770
  793017
  800481
  801166
  806129
  813211
  739636
  762660
  723750
  724014
  739878
  733530
  735297
  751504
  766283
  635303
  640085
  697484
  715276
  716155
  778673
  795777
  796689
  799809
]
3.14 ms
(0.90%)
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
  188613
  361679
  384480
  385434
  396807
  493578
  525182
  533188
  536978
  538538
  540753
  541107
  548197
  554153
  558887
  588790
  595166
  595186
  597277
  600660
  601506
  601521
  602595
  618080
  629256
  635303
  635536
  637798
  640085
  641263
  641473
  645529
  645606
  648931
  660383
  665986
  667174
  670902
  692703
  697484
  697585
  700177
  715276
  715627
  716155
  720356
  721712
  723724
  723749
  723750
  724014
  729086
  730128
  732999
  733505
  733530
  734660
  735275
  735297
  738317
  739533
  739636
  739878
  744379
  745244
  748958
  749641
  751504
  755644
  757278
  757287
  757315
  762660
  764279
  766283
  768706
  768866
  771052
  772261
  775678
  778281
  778601
  778673
  779263
  779294
  780705
  781245
  782044
  785738
  786015
  787264
  789515
  791770
  793017
  794715
  795777
  795917
  796689
  799809
  800481
  800493
  800818
  801166
  804693
  804975
  806129
  807161
  808991
  809343
  809660
  811603
  813211
  813946
  816183
  819960
  826165
  827296
  827395
  827494
]
1.98 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding wife"
]
1.65 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding жен"
]
1.47 ms
(0.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.22 ms
(0.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "riding жен"
]

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.