GET https://search.jues.net/search/embeds/7?q=2024%2018

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.88 ms
(81.22%)
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
  391677
  393445
  397329
  402027
  417428
  445040
  453488
  456400
  457479
  461973
  462035
  469673
  471915
  474060
  474719
  476155
  501845
  512679
  522699
  526027
  527538
  527578
  538431
  562119
  566519
  568578
  571214
  571219
  579001
  581652
  581700
  591393
  596585
  597561
  598679
  605325
  605331
  605727
  609878
  610504
  618970
  619375
  620770
  621309
  624273
  626535
  628197
  628310
  643396
  644291
  644654
  644698
  655827
  679385
  680260
  687431
  688579
  689442
  692880
  696969
  702624
  703193
  709636
  717708
  717713
  717834
  718705
  718708
  720802
  721369
  721699
  722199
  722462
  722514
  723932
  723935
  725115
  725141
  729256
  730367
  736911
  739318
  740505
  740597
  740704
  742226
  743345
  744300
  747439
  748416
  748685
  749688
  751722
  752132
  752685
  757367
  757442
  758560
  758956
  759435
  761474
  762984
  764875
  766913
  774512
  777084
  778550
  778955
  787931
  788805
  790249
  794702
  799002
  799793
  801305
  804862
  805242
  810533
  811128
  812025
]
22.01 ms
(13.25%)
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
  692880
  696969
  709636
  718708
  655827
  679385
  680260
  687431
  688579
  689442
  703193
  718705
  720802
  721699
  722199
  722462
  562119
  566519
  568578
  571214
  571219
  579001
  581652
  581700
  605727
  609878
  628310
  644291
  596585
  598679
  605325
  621309
  643396
  644698
  605331
  610504
  620770
  624273
  626535
  591393
  597561
  618970
  628197
  790249
  799793
  805242
  810533
  774512
  777084
  787931
  788805
  801305
  804862
  725141
  730367
  740704
  743345
  749688
  752132
  757367
  758560
  762984
  794702
  725115
  747439
  752685
  757442
  723932
  723935
  729256
  740505
  748685
  759435
  764875
  740597
  742226
  751722
  766913
  736911
  739318
  744300
  748416
  758956
  761474
  619375
  644654
  702624
  717708
  717713
  717834
  721369
  722514
  778550
  778955
  799002
  811128
  812025
  461973
  462035
  469673
  474060
  402027
  445040
  457479
  397329
  391677
  393445
  456400
  471915
  474719
  417428
  453488
  476155
  527578
  538431
  501845
  512679
  522699
  526027
  527538
]
2.21 ms
(1.33%)
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
  391677
  393445
  397329
  402027
  417428
  445040
  453488
  456400
  457479
  461973
  462035
  469673
  471915
  474060
  474719
  476155
  501845
  512679
  522699
  526027
  527538
  527578
  538431
  562119
  566519
  568578
  571214
  571219
  579001
  581652
  581700
  591393
  596585
  597561
  598679
  605325
  605331
  605727
  609878
  610504
  618970
  619375
  620770
  621309
  624273
  626535
  628197
  628310
  643396
  644291
  644654
  644698
  655827
  679385
  680260
  687431
  688579
  689442
  692880
  696969
  702624
  703193
  709636
  717708
  717713
  717834
  718705
  718708
  720802
  721369
  721699
  722199
  722462
  722514
  723932
  723935
  725115
  725141
  729256
  730367
  736911
  739318
  740505
  740597
  740704
  742226
  743345
  744300
  747439
  748416
  748685
  749688
  751722
  752132
  752685
  757367
  757442
  758560
  758956
  759435
  761474
  762984
  764875
  766913
  774512
  777084
  778550
  778955
  787931
  788805
  790249
  794702
  799002
  799793
  801305
  804862
  805242
  810533
  811128
  812025
]
2.16 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "2024 18"
]
1.71 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18"
]
1.62 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18"
]

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.