GET https://search.jues.net/search/embeds/3?q=anal%20gape%20hard

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.00 ms
(84.64%)
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
  95673
  249009
  390587
  397508
  398909
  400681
  411643
  414103
  417243
  418551
  419998
  424115
  424199
  428900
  430262
  432776
  433066
  434334
  435352
  437635
  443236
  445530
  445538
  446639
  452300
  455408
  456232
  456236
  459638
  462777
  469759
  470403
  483742
  486506
  494448
  495758
  502242
  505382
  506115
  510126
  511455
  513158
  518264
  519722
  519765
  522468
  526195
  543275
  545325
  545366
  555091
  555109
  556476
  562585
  571726
  595396
  597243
  597834
  613375
  618908
  623154
  628391
  628394
  628397
  628404
  628416
  630830
  631919
  633474
  633763
  636958
  637007
  647162
  647891
  649218
  656932
  665742
  666968
  668523
  669298
  680179
  720614
  722392
  723153
  725583
  728345
  733845
  735554
  736741
  741310
  741541
  743286
  751433
  752661
  756082
  761189
  764242
  781998
  782091
  784158
  786512
  788767
  795538
  798635
  802379
  803244
  807918
  807945
  809050
  809935
  810689
  811007
  812824
  814178
  815299
  818278
  819588
  819920
  820771
  826130
]
17.40 ms
(9.63%)
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
  419998
  752661
  433066
  618908
  786512
  470403
  597834
  722392
  764242
  814178
  519722
  506115
  665742
  623154
  630830
  633763
  795538
  807945
  733845
  741541
  756082
  809050
  469759
  459638
  455408
  456236
  414103
  417243
  826130
  815299
  555091
  743286
  781998
  811007
  812824
  411643
  656932
  647891
  633474
  510126
  435352
  456232
  511455
  571726
  628397
  751433
  818278
  545325
  723153
  720614
  494448
  761189
  398909
  519765
  249009
  428900
  434334
  483742
  819588
  647162
  628416
  595396
  636958
  522468
  432776
  545366
  400681
  430262
  445530
  505382
  513158
  649218
  666968
  782091
  424115
  446639
  628404
  736741
  628391
  390587
  820771
  562585
  555109
  613375
  798635
  728345
  735554
  803244
  807918
  556476
  680179
  810689
  741310
  809935
  495758
  526195
  669298
  668523
  462777
  95673
  397508
  445538
  628394
  637007
  784158
  452300
  424199
  437635
  518264
  502242
  631919
  443236
  819920
  597243
  802379
  725583
  788767
  486506
  418551
  543275
]
2.70 ms
(1.49%)
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
  95673
  249009
  390587
  397508
  398909
  400681
  411643
  414103
  417243
  418551
  419998
  424115
  424199
  428900
  430262
  432776
  433066
  434334
  435352
  437635
  443236
  445530
  445538
  446639
  452300
  455408
  456232
  456236
  459638
  462777
  469759
  470403
  483742
  486506
  494448
  495758
  502242
  505382
  506115
  510126
  511455
  513158
  518264
  519722
  519765
  522468
  526195
  543275
  545325
  545366
  555091
  555109
  556476
  562585
  571726
  595396
  597243
  597834
  613375
  618908
  623154
  628391
  628394
  628397
  628404
  628416
  630830
  631919
  633474
  633763
  636958
  637007
  647162
  647891
  649218
  656932
  665742
  666968
  668523
  669298
  680179
  720614
  722392
  723153
  725583
  728345
  733845
  735554
  736741
  741310
  741541
  743286
  751433
  752661
  756082
  761189
  764242
  781998
  782091
  784158
  786512
  788767
  795538
  798635
  802379
  803244
  807918
  807945
  809050
  809935
  810689
  811007
  812824
  814178
  815299
  818278
  819588
  819920
  820771
  826130
]
2.50 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal gape hard"
]
1.86 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал большая большие дырк hard"
]
1.72 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал большая большие дырк hard"
]
1.59 ms
(0.88%)
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.