GET https://search.jues.net/search/embeds/5?q=christmas

Query Metrics

8 Database Queries
8 Different statements
134.13 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
105.63 ms
(78.75%)
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
  416015
  416233
  417828
  426544
  432243
  437920
  440440
  440532
  450889
  451042
  451132
  451303
  451655
  452300
  453434
  453499
  459382
  459406
  460444
  463657
  468773
  475295
  475487
  498440
  501154
  501875
  502695
  507047
  507640
  507643
  507658
  507697
  507880
  507916
  507928
  510032
  510886
  510913
  517464
  518028
  518747
  522297
  522794
  523026
  527006
  527007
  529849
  530017
  531187
  539759
  575810
  580289
  581128
  581777
  581781
  581791
  581809
  581816
  581843
  581852
  581855
  581873
  581882
  582137
  582179
  582227
  582229
  582234
  582258
  582269
  582332
  582334
  582342
  582372
  582376
  582538
  582540
  582590
  582617
  582680
  582915
  582935
  583003
  583033
  583039
  584503
  585725
  587421
  591997
  595907
  597231
  635900
  647635
  649185
  689001
  788264
]
16.67 ms
(12.43%)
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
  581777
  582372
  582590
  582680
  582935
  581781
  582538
  582332
  582342
  453434
  463657
  452300
  460444
  437920
  453499
  475487
  451655
  468773
  518028
  501875
  416015
  417828
  426544
  432243
  459406
  522794
  498440
  501154
  507643
  507928
  507697
  517464
  518747
  539759
  475295
  581843
  581852
  581882
  689001
  581816
  581855
  582334
  582617
  591997
  595907
  587421
  788264
  459382
  510032
  527006
  507640
  510886
  507047
  510913
  529849
  507658
  581809
  581128
  581873
  583003
  647635
  575810
  582227
  440532
  450889
  451303
  416233
  527007
  507916
  530017
  582915
  582234
  583033
  583039
  581791
  582376
  582540
  597231
  635900
  451132
  440440
  523026
  580289
  584503
  582179
  451042
  507880
  531187
  582258
  582137
  582269
  522297
  502695
  585725
  649185
  582229
]
2.59 ms
(1.93%)
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
  416015
  416233
  417828
  426544
  432243
  437920
  440440
  440532
  450889
  451042
  451132
  451303
  451655
  452300
  453434
  453499
  459382
  459406
  460444
  463657
  468773
  475295
  475487
  498440
  501154
  501875
  502695
  507047
  507640
  507643
  507658
  507697
  507880
  507916
  507928
  510032
  510886
  510913
  517464
  518028
  518747
  522297
  522794
  523026
  527006
  527007
  529849
  530017
  531187
  539759
  575810
  580289
  581128
  581777
  581781
  581791
  581809
  581816
  581843
  581852
  581855
  581873
  581882
  582137
  582179
  582227
  582229
  582234
  582258
  582269
  582332
  582334
  582342
  582372
  582376
  582538
  582540
  582590
  582617
  582680
  582915
  582935
  583003
  583033
  583039
  584503
  585725
  587421
  591997
  595907
  597231
  635900
  647635
  649185
  689001
  788264
]
2.31 ms
(1.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "christmas"
]
2.24 ms
(1.67%)
1
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
  b"\x01ö\tNþ■p┘üó\x18W")Ö3"
]
1.71 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "christmas"
]
1.63 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.35 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "christmas"
]

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.