GET https://search.jues.net/search/embeds/10?q=2022%20best

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.86 ms
(84.44%)
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
  454629
  454786
  456113
  457205
  475762
  482418
  485029
  501057
  508102
  511266
  533262
  533281
  534489
  535059
  538753
  541680
  546096
  547103
  547417
  549119
  552927
  553679
  560762
  562901
  567560
  572756
  574689
  575625
  577537
  578579
  578592
  588121
  588136
  589757
  592271
  595020
  596182
  603021
  603617
  606137
  606939
  608545
  613813
  616585
  618208
  626226
  636472
  636483
  637562
  638875
  640269
  648984
  650062
  650602
  650683
  651928
  652964
  654411
  654599
  655805
  658869
  660784
  661051
  661589
  661637
  662920
  663851
  664597
  665966
  665980
  665983
  665989
  666009
  666148
  666468
  667933
  669703
  670645
  677053
  678268
  679660
  680846
  682851
  683106
  688911
  689440
  689894
  692596
  695191
  698147
  698480
  698885
  700853
  702280
  702439
  705177
  707604
  709700
  710798
  712226
  713833
  713931
  714331
  715787
  716669
  718875
  719547
  722232
  723288
  723425
  814008
  818091
  819844
  819870
  821925
  827588
  827836
  827857
  827887
  828460
]
12.72 ms
(8.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
  814008
  819870
  818091
  819844
  821925
  827836
  827588
  827857
  827887
  828460
  457205
  475762
  482418
  485029
  454629
  454786
  456113
  501057
  533281
  508102
  533262
  535059
  534489
  538753
  511266
  547417
  552927
  553679
  572756
  575625
  541680
  562901
  574689
  546096
  560762
  567560
  650062
  650602
  652964
  654599
  655805
  661051
  665983
  666148
  677053
  679660
  682851
  692596
  698885
  702439
  705177
  710798
  718875
  719547
  722232
  723288
  723425
  648984
  651928
  658869
  661589
  661637
  662920
  665966
  665989
  666009
  669703
  683106
  689894
  698147
  698480
  700853
  702280
  712226
  713833
  713931
  715787
  650683
  654411
  660784
  663851
  664597
  665980
  666468
  667933
  670645
  678268
  680846
  688911
  689440
  695191
  707604
  709700
  714331
  716669
  547103
  549119
  577537
  578579
  578592
  588121
  588136
  596182
  606137
  608545
  616585
  626226
  636483
  640269
  589757
  595020
  613813
  618208
  636472
  637562
  592271
  603617
  638875
  603021
  606939
]
2.92 ms
(1.99%)
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
  454629
  454786
  456113
  457205
  475762
  482418
  485029
  501057
  508102
  511266
  533262
  533281
  534489
  535059
  538753
  541680
  546096
  547103
  547417
  549119
  552927
  553679
  560762
  562901
  567560
  572756
  574689
  575625
  577537
  578579
  578592
  588121
  588136
  589757
  592271
  595020
  596182
  603021
  603617
  606137
  606939
  608545
  613813
  616585
  618208
  626226
  636472
  636483
  637562
  638875
  640269
  648984
  650062
  650602
  650683
  651928
  652964
  654411
  654599
  655805
  658869
  660784
  661051
  661589
  661637
  662920
  663851
  664597
  665966
  665980
  665983
  665989
  666009
  666148
  666468
  667933
  669703
  670645
  677053
  678268
  679660
  680846
  682851
  683106
  688911
  689440
  689894
  692596
  695191
  698147
  698480
  698885
  700853
  702280
  702439
  705177
  707604
  709700
  710798
  712226
  713833
  713931
  714331
  715787
  716669
  718875
  719547
  722232
  723288
  723425
  814008
  818091
  819844
  819870
  821925
  827588
  827836
  827857
  827887
  828460
]
1.98 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "2022 best"
]
1.81 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "best"
]
1.81 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "best"
]
1.57 ms
(1.07%)
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.