GET https://search.jues.net/search/embeds/10?q=sex%20stepsister

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.91 ms
(88.39%)
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
  396225
  410911
  458021
  471909
  511906
  516199
  528371
  557005
  561399
  561414
  563879
  565325
  575052
  587001
  595142
  608105
  608545
  609702
  610123
  616422
  616676
  617283
  618700
  621747
  622496
  622780
  628531
  630335
  636786
  643688
  645845
  652203
  659007
  667807
  675403
  677118
  678722
  685379
  689239
  689445
  693250
  696980
  699278
  700647
  705052
  709376
  709380
  710165
  711245
  713151
  714975
  716214
  716441
  716829
  720011
  723188
  724163
  727974
  728171
  734343
  734856
  736117
  736222
  736620
  736684
  738199
  738985
  741316
  742140
  745413
  745998
  746485
  747046
  751149
  751723
  756871
  758353
  758422
  758581
  758675
  760574
  761950
  762900
  764776
  766559
  767516
  772831
  777192
  779188
  780001
  781420
  783681
  785275
  791187
  791818
  792432
  793580
  794143
  794303
  798367
  799836
  800154
  801039
  802821
  803989
  804137
  810441
  812961
  813542
  813934
  818104
  818940
  818969
  818981
  819697
  819866
  820066
  825229
  827166
  827955
]
14.50 ms
(7.01%)
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
  813542
  736117
  758675
  781420
  793580
  736684
  738199
  741316
  751723
  756871
  736620
  761950
  724163
  742140
  746485
  762900
  766559
  767516
  772831
  745998
  760574
  643688
  709376
  710165
  777192
  783681
  791818
  794303
  410911
  563879
  751149
  396225
  561414
  716829
  818969
  818981
  813934
  825229
  827166
  818104
  818940
  819697
  819866
  820066
  827955
  616676
  458021
  471909
  528371
  511906
  516199
  561399
  565325
  557005
  575052
  667807
  677118
  689239
  689445
  693250
  696980
  699278
  700647
  716214
  716441
  720011
  723188
  645845
  675403
  705052
  711245
  652203
  659007
  678722
  685379
  709380
  713151
  714975
  608545
  616422
  617283
  622496
  628531
  636786
  587001
  610123
  621747
  622780
  595142
  608105
  609702
  618700
  630335
  780001
  792432
  794143
  798367
  799836
  804137
  779188
  785275
  800154
  802821
  810441
  812961
  734343
  736222
  747046
  758353
  764776
  791187
  801039
  803989
  728171
  758422
  727974
  734856
  738985
  745413
  758581
]
2.30 ms
(1.11%)
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
  396225
  410911
  458021
  471909
  511906
  516199
  528371
  557005
  561399
  561414
  563879
  565325
  575052
  587001
  595142
  608105
  608545
  609702
  610123
  616422
  616676
  617283
  618700
  621747
  622496
  622780
  628531
  630335
  636786
  643688
  645845
  652203
  659007
  667807
  675403
  677118
  678722
  685379
  689239
  689445
  693250
  696980
  699278
  700647
  705052
  709376
  709380
  710165
  711245
  713151
  714975
  716214
  716441
  716829
  720011
  723188
  724163
  727974
  728171
  734343
  734856
  736117
  736222
  736620
  736684
  738199
  738985
  741316
  742140
  745413
  745998
  746485
  747046
  751149
  751723
  756871
  758353
  758422
  758581
  758675
  760574
  761950
  762900
  764776
  766559
  767516
  772831
  777192
  779188
  780001
  781420
  783681
  785275
  791187
  791818
  792432
  793580
  794143
  794303
  798367
  799836
  800154
  801039
  802821
  803989
  804137
  810441
  812961
  813542
  813934
  818104
  818940
  818969
  818981
  819697
  819866
  820066
  825229
  827166
  827955
]
2.06 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex stepsister"
]
1.86 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс stepsister"
]
1.65 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс stepsister"
]

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.