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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
227.42 ms
(36.84%)
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
  711528
  780440
  418647
  419027
  533516
  536674
  472921
  474295
  562513
  574089
  557745
  566307
  597264
  605315
  622509
  597267
  755743
  747648
  772095
  384285
  462306
  472426
  464580
  472908
  524185
  491193
  229361
  429024
  821369
  814019
  822142
  825691
  821798
  446405
  531588
  558655
  544209
  678799
  667268
  671077
  697298
  675807
  718662
  603145
  605329
  608091
  590830
  598508
  622540
  623960
  799375
  800553
  786458
  786768
  799785
  744276
  744852
  749116
  753890
  757098
  795120
  804915
  746935
  752722
  735602
  759543
  732167
  753448
  757643
  741113
  760968
  723368
  429353
  396564
  532982
  647850
  81588
  826942
  813677
  813941
  819550
  817335
  539519
  532188
  527536
  530392
  537525
  538668
  531019
  491814
  549912
  566681
  572932
  577161
  544301
  556061
  556359
  564823
  565830
  657730
  658066
  676983
  648729
  655691
  657949
  658419
  673985
  676513
  684965
  690214
  701297
  702656
  655685
  656381
  659601
  671819
  675737
  676483
  676518
  677039
]
210.95 ms
(34.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
170.20 ms
(27.57%)
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
  81588
  229361
  384285
  396564
  418647
  419027
  429024
  429353
  446405
  462306
  464580
  472426
  472908
  472921
  474295
  491193
  491814
  524185
  527536
  530392
  531019
  531588
  532188
  532982
  533516
  536674
  537525
  538668
  539519
  544209
  544301
  549912
  556061
  556359
  557745
  558655
  562513
  564823
  565830
  566307
  566681
  572932
  574089
  577161
  590830
  597264
  597267
  598508
  603145
  605315
  605329
  608091
  622509
  622540
  623960
  647850
  648729
  655685
  655691
  656381
  657730
  657949
  658066
  658419
  659601
  667268
  671077
  671819
  673985
  675737
  675807
  676483
  676513
  676518
  676983
  677039
  678799
  684965
  690214
  697298
  701297
  702656
  711528
  723368
  732167
  735602
  741113
  744276
  744852
  746935
  747648
  749116
  752722
  753448
  753890
  755743
  757098
  757643
  759543
  760968
  772095
  780440
  786458
  786768
  795120
  799375
  799785
  800553
  804915
  813677
  813941
  814019
  817335
  819550
  821369
  821798
  822142
  825691
  826942
]
3.72 ms
(0.60%)
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
  81588
  229361
  384285
  396564
  418647
  419027
  429024
  429353
  446405
  462306
  464580
  472426
  472908
  472921
  474295
  491193
  491814
  524185
  527536
  530392
  531019
  531588
  532188
  532982
  533516
  536674
  537525
  538668
  539519
  544209
  544301
  549912
  556061
  556359
  557745
  558655
  562513
  564823
  565830
  566307
  566681
  572932
  574089
  577161
  590830
  597264
  597267
  598508
  603145
  605315
  605329
  608091
  622509
  622540
  623960
  647850
  648729
  655685
  655691
  656381
  657730
  657949
  658066
  658419
  659601
  667268
  671077
  671819
  673985
  675737
  675807
  676483
  676513
  676518
  676983
  677039
  678799
  684965
  690214
  697298
  701297
  702656
  711528
  723368
  732167
  735602
  741113
  744276
  744852
  746935
  747648
  749116
  752722
  753448
  753890
  755743
  757098
  757643
  759543
  760968
  772095
  780440
  786458
  786768
  795120
  799375
  799785
  800553
  804915
  813677
  813941
  814019
  817335
  819550
  821369
  821798
  822142
  825691
  826942
]
2.07 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "2024 18"
]
1.53 ms
(0.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18"
]
1.43 ms
(0.23%)
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.