GET https://search.jues.net/search/embeds/7?q=anal%20sex%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
244.10 ms
(91.38%)
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
  159380
  177385
  382555
  383493
  396814
  397277
  401926
  402222
  405995
  531331
  531892
  533667
  534092
  536597
  538272
  540942
  578884
  599572
  604279
  604390
  609565
  610420
  624209
  632223
  633561
  636884
  639385
  645744
  646138
  649069
  651114
  652614
  654911
  656615
  656616
  657175
  658788
  668111
  673813
  675150
  676441
  681524
  691212
  697994
  700327
  712272
  712397
  715657
  720282
  720662
  720952
  722669
  723667
  725142
  726978
  727503
  732215
  733233
  736201
  736348
  736793
  736853
  737643
  742870
  746692
  747104
  750358
  755662
  757599
  759933
  761038
  762253
  762271
  764245
  764850
  765057
  765273
  765412
  765788
  766601
  766638
  766670
  769388
  770306
  773914
  774188
  776999
  777953
  783618
  786782
  787323
  788981
  791493
  794344
  794641
  797186
  797367
  797521
  798728
  800308
  800567
  800797
  801269
  802152
  805523
  808317
  810434
  811332
  811536
  811649
  816538
  817246
  817308
  818760
  819729
  821482
  823817
  823831
  824865
  828761
]
12.48 ms
(4.67%)
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
  766670
  810434
  654911
  712272
  720952
  649069
  624209
  791493
  797367
  727503
  733233
  737643
  726978
  746692
  700327
  712397
  736348
  402222
  720662
  656615
  645744
  656616
  764850
  757599
  765412
  764245
  776999
  821482
  383493
  697994
  396814
  817246
  794641
  787323
  401926
  599572
  633561
  736853
  766638
  783618
  405995
  816538
  817308
  652614
  720282
  668111
  675150
  604279
  604390
  609565
  797521
  774188
  766601
  755662
  770306
  732215
  759933
  761038
  765788
  794344
  802152
  811536
  159380
  765273
  397277
  382555
  715657
  673813
  691212
  811332
  800797
  797186
  762271
  747104
  177385
  805523
  788981
  800308
  824865
  723667
  818760
  819729
  823817
  823831
  828761
  531331
  533667
  534092
  531892
  536597
  538272
  578884
  540942
  646138
  722669
  651114
  657175
  676441
  681524
  658788
  636884
  632223
  610420
  639385
  777953
  786782
  798728
  801269
  811649
  725142
  736201
  742870
  750358
  769388
  800567
  808317
  736793
  762253
  765057
  773914
]
3.02 ms
(1.13%)
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
  159380
  177385
  382555
  383493
  396814
  397277
  401926
  402222
  405995
  531331
  531892
  533667
  534092
  536597
  538272
  540942
  578884
  599572
  604279
  604390
  609565
  610420
  624209
  632223
  633561
  636884
  639385
  645744
  646138
  649069
  651114
  652614
  654911
  656615
  656616
  657175
  658788
  668111
  673813
  675150
  676441
  681524
  691212
  697994
  700327
  712272
  712397
  715657
  720282
  720662
  720952
  722669
  723667
  725142
  726978
  727503
  732215
  733233
  736201
  736348
  736793
  736853
  737643
  742870
  746692
  747104
  750358
  755662
  757599
  759933
  761038
  762253
  762271
  764245
  764850
  765057
  765273
  765412
  765788
  766601
  766638
  766670
  769388
  770306
  773914
  774188
  776999
  777953
  783618
  786782
  787323
  788981
  791493
  794344
  794641
  797186
  797367
  797521
  798728
  800308
  800567
  800797
  801269
  802152
  805523
  808317
  810434
  811332
  811536
  811649
  816538
  817246
  817308
  818760
  819729
  821482
  823817
  823831
  824865
  828761
]
2.11 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal sex ass"
]
1.97 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал секс жоп"
]
1.83 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.61%)
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.