GET https://search.jues.net/search/embeds/10?q=compilation%202023

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.92 ms
(86.51%)
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
  554494
  561166
  567042
  567118
  569580
  570861
  571506
  582985
  587819
  588949
  594297
  599165
  600575
  604264
  604637
  605128
  606511
  606764
  608398
  608449
  609696
  620509
  620903
  621289
  628596
  629606
  635020
  643071
  645076
  647721
  649318
  656301
  660340
  660454
  668784
  669672
  672391
  674603
  677120
  678259
  679607
  681484
  682373
  691479
  694631
  695307
  697935
  698575
  699518
  701628
  703211
  705322
  708052
  708194
  708254
  708830
  710822
  710905
  711672
  714070
  715543
  717235
  717877
  718472
  718840
  718891
  718919
  719040
  721910
  725360
  727266
  728895
  732156
  732595
  739912
  743843
  752498
  756842
  758715
  761721
  769296
  772827
  772944
  775513
  777567
  777639
  777641
  778336
  779008
  779015
  779077
  780683
  781060
  781065
  782137
  782382
  783110
  783893
  784103
  784984
  786570
  791008
  792025
  793311
  793383
  793613
  793739
  793744
  795062
  796154
  798821
  799759
  800029
  800975
  801046
  801688
  809583
  809634
  811880
  813301
]
14.61 ms
(8.00%)
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
  567042
  569580
  570861
  571506
  582985
  645076
  668784
  672391
  682373
  699518
  703211
  705322
  708194
  708254
  710905
  718472
  718891
  718919
  719040
  721910
  649318
  660340
  669672
  677120
  691479
  694631
  695307
  697935
  708052
  708830
  715543
  717877
  647721
  656301
  660454
  674603
  678259
  679607
  681484
  698575
  701628
  710822
  711672
  714070
  717235
  718840
  554494
  561166
  567118
  587819
  599165
  600575
  606764
  628596
  629606
  588949
  609696
  620509
  621289
  635020
  643071
  606511
  608449
  594297
  604264
  604637
  605128
  608398
  620903
  775513
  777567
  777639
  778336
  779008
  779015
  782382
  791008
  792025
  793383
  793739
  796154
  799759
  800975
  801688
  809634
  777641
  779077
  780683
  781060
  781065
  782137
  783893
  784103
  786570
  793311
  793613
  798821
  811880
  813301
  725360
  727266
  732156
  732595
  739912
  743843
  752498
  756842
  758715
  761721
  769296
  772827
  772944
  783110
  784984
  793744
  795062
  800029
  801046
  809583
  728895
]
2.41 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation 2023"
]
2.32 ms
(1.27%)
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
  554494
  561166
  567042
  567118
  569580
  570861
  571506
  582985
  587819
  588949
  594297
  599165
  600575
  604264
  604637
  605128
  606511
  606764
  608398
  608449
  609696
  620509
  620903
  621289
  628596
  629606
  635020
  643071
  645076
  647721
  649318
  656301
  660340
  660454
  668784
  669672
  672391
  674603
  677120
  678259
  679607
  681484
  682373
  691479
  694631
  695307
  697935
  698575
  699518
  701628
  703211
  705322
  708052
  708194
  708254
  708830
  710822
  710905
  711672
  714070
  715543
  717235
  717877
  718472
  718840
  718891
  718919
  719040
  721910
  725360
  727266
  728895
  732156
  732595
  739912
  743843
  752498
  756842
  758715
  761721
  769296
  772827
  772944
  775513
  777567
  777639
  777641
  778336
  779008
  779015
  779077
  780683
  781060
  781065
  782137
  782382
  783110
  783893
  784103
  784984
  786570
  791008
  792025
  793311
  793383
  793613
  793739
  793744
  795062
  796154
  798821
  799759
  800029
  800975
  801046
  801688
  809583
  809634
  811880
  813301
]
1.87 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк"
]
1.75 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.91%)
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.