GET https://search.jues.net/search/embeds/6?q=interracial%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.94 ms
(84.80%)
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
  189230
  359067
  386041
  398864
  404272
  413130
  415591
  432813
  462390
  465710
  468655
  468694
  497886
  508426
  530593
  531144
  531530
  532632
  534055
  534056
  534989
  535545
  536251
  536597
  537837
  538035
  538789
  540521
  540530
  540942
  543869
  544682
  554257
  558784
  561443
  563280
  563281
  564249
  564270
  567207
  580322
  584966
  585383
  587124
  592225
  593588
  599912
  604172
  604451
  606524
  609891
  615291
  615335
  623183
  624175
  624466
  633595
  637121
  642624
  645605
  646173
  647515
  647520
  647702
  648393
  648817
  652419
  653793
  653812
  654977
  656562
  656622
  656638
  657920
  658192
  660057
  662910
  667392
  668510
  669216
  673468
  673924
  678128
  708589
  711255
  712779
  716887
  716904
  719842
  719848
  720205
  733571
  738241
  739752
  764448
  775532
  797417
  801332
  802293
  804494
  804688
  815424
  815891
  816296
  816806
  817052
  817862
  818439
  818874
  819013
  819642
  821916
  823565
  823639
  824276
  824444
  826711
  827913
  828539
  828761
]
14.72 ms
(8.98%)
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
  584966
  648393
  712779
  662910
  669216
  719848
  593588
  623183
  587124
  797417
  801332
  738241
  802293
  764448
  733571
  739752
  606524
  615291
  775532
  359067
  415591
  432813
  818439
  468694
  462390
  604451
  465710
  497886
  508426
  537837
  804688
  804494
  468655
  536251
  531144
  648817
  678128
  637121
  604172
  599912
  624175
  716887
  386041
  189230
  398864
  404272
  413130
  815424
  817052
  817862
  819013
  823565
  823639
  826711
  815891
  824444
  824276
  816296
  816806
  818874
  819642
  821916
  828761
  827913
  828539
  531530
  534055
  535545
  530593
  532632
  534056
  534989
  538035
  540530
  536597
  538789
  540521
  544682
  563281
  540942
  561443
  580322
  543869
  564270
  567207
  646173
  647702
  657920
  658192
  660057
  673924
  708589
  711255
  645605
  652419
  653793
  667392
  716904
  720205
  647515
  647520
  653812
  654977
  656562
  656622
  656638
  668510
  673468
  719842
  554257
  558784
  563280
  564249
  592225
  609891
  615335
  624466
  633595
  642624
  585383
]
2.63 ms
(1.61%)
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
  189230
  359067
  386041
  398864
  404272
  413130
  415591
  432813
  462390
  465710
  468655
  468694
  497886
  508426
  530593
  531144
  531530
  532632
  534055
  534056
  534989
  535545
  536251
  536597
  537837
  538035
  538789
  540521
  540530
  540942
  543869
  544682
  554257
  558784
  561443
  563280
  563281
  564249
  564270
  567207
  580322
  584966
  585383
  587124
  592225
  593588
  599912
  604172
  604451
  606524
  609891
  615291
  615335
  623183
  624175
  624466
  633595
  637121
  642624
  645605
  646173
  647515
  647520
  647702
  648393
  648817
  652419
  653793
  653812
  654977
  656562
  656622
  656638
  657920
  658192
  660057
  662910
  667392
  668510
  669216
  673468
  673924
  678128
  708589
  711255
  712779
  716887
  716904
  719842
  719848
  720205
  733571
  738241
  739752
  764448
  775532
  797417
  801332
  802293
  804494
  804688
  815424
  815891
  816296
  816806
  817052
  817862
  818439
  818874
  819013
  819642
  821916
  823565
  823639
  824276
  824444
  826711
  827913
  828539
  828761
]
2.10 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "interracial ass"
]
1.92 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межрасов жоп"
]
1.91 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.