GET https://search.jues.net/search/embeds/8?q=real%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.80 ms
(58.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real девушк"
]
132.94 ms
(35.79%)
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
  322090
  384162
  390907
  410292
  441808
  446345
  448925
  458116
  474816
  479324
  487804
  514606
  517661
  533395
  533771
  534885
  535152
  541071
  553671
  559314
  565291
  574964
  585334
  590071
  596372
  597903
  608545
  609107
  615137
  615509
  616604
  620707
  620938
  622869
  623745
  625492
  625937
  626579
  636623
  640348
  641153
  642992
  648693
  663839
  664698
  668034
  668131
  677104
  677981
  680825
  687140
  687147
  687835
  689040
  691149
  693420
  696374
  704943
  707753
  714799
  715407
  715435
  719225
  719457
  722253
  722709
  728551
  733356
  733651
  734330
  734401
  736252
  736361
  736933
  737126
  737425
  737856
  740181
  747368
  748304
  761634
  761733
  765518
  767722
  768657
  771424
  775606
  775656
  776042
  776372
  777862
  779289
  782387
  784292
  784735
  787498
  790145
  790972
  791246
  792258
  794713
  795772
  796916
  799659
  803026
  807505
  808964
  809004
  809706
  809976
  810856
  810924
  813836
  819872
  821122
  824881
  824997
  825581
  825829
]
13.95 ms
(3.76%)
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
  597903
  608545
  640348
  641153
  609107
  626579
  616604
  620938
  777862
  779289
  794713
  796916
  809976
  784292
  784735
  791246
  734330
  761634
  765518
  799659
  803026
  734401
  736252
  737856
  768657
  737126
  748304
  762399
  733651
  737425
  747368
  625937
  642992
  704943
  722709
  775606
  776042
  782387
  787498
  807505
  810856
  441808
  474816
  410292
  384162
  446345
  479324
  559314
  677104
  719225
  585334
  790972
  808964
  809004
  767722
  736361
  809706
  390907
  448925
  322090
  824881
  824997
  819872
  825829
  813836
  821122
  825581
  458116
  487804
  514606
  535152
  533395
  533771
  534885
  517661
  574964
  541071
  565291
  648693
  687140
  687835
  691149
  696374
  714799
  715407
  719457
  663839
  664698
  668034
  668131
  680825
  689040
  693420
  722253
  677981
  687147
  707753
  715435
  553671
  615137
  625492
  636623
  615509
  620707
  622869
  596372
  590071
  623745
  776372
  790145
  795772
  775656
  792258
  810924
  728551
  733356
  736933
  740181
  761733
  771424
]
2.98 ms
(0.80%)
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
  322090
  384162
  390907
  410292
  441808
  446345
  448925
  458116
  474816
  479324
  487804
  514606
  517661
  533395
  533771
  534885
  535152
  541071
  553671
  559314
  565291
  574964
  585334
  590071
  596372
  597903
  608545
  609107
  615137
  615509
  616604
  620707
  620938
  622869
  623745
  625492
  625937
  626579
  636623
  640348
  641153
  642992
  648693
  663839
  664698
  668034
  668131
  677104
  677981
  680825
  687140
  687147
  687835
  689040
  691149
  693420
  696374
  704943
  707753
  714799
  715407
  715435
  719225
  719457
  722253
  722709
  728551
  733356
  733651
  734330
  734401
  736252
  736361
  736933
  737126
  737425
  737856
  740181
  747368
  748304
  761634
  761733
  765518
  767722
  768657
  771424
  775606
  775656
  776042
  776372
  777862
  779289
  782387
  784292
  784735
  787498
  790145
  790972
  791246
  792258
  794713
  795772
  796916
  799659
  803026
  807505
  808964
  809004
  809706
  809976
  810856
  810924
  813836
  819872
  821122
  824881
  824997
  825581
  825829
]
2.13 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real girls"
]
1.84 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real девушк"
]
1.79 ms
(0.48%)
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.