GET https://search.jues.net/search/embeds/5?q=short%20short

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.59 ms
(83.14%)
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
  3826
  31563
  50436
  70186
  84120
  97598
  124308
  131462
  188600
  301920
  382656
  383111
  384796
  387436
  388204
  388897
  390857
  395888
  398515
  398779
  400727
  409114
  411404
  565811
  589707
  603322
  605021
  605035
  619472
  626627
  628295
  636926
  644338
  645259
  652248
  652262
  658562
  658736
  659666
  659814
  664281
  667100
  667681
  668827
  683288
  700885
  705356
  705365
  705887
  706864
  707282
  712835
  714646
  715095
  716491
  717279
  718501
  719118
  719746
  720272
  720540
  722106
  723214
  730077
  730242
  732132
  733468
  735340
  736772
  739725
  741914
  742582
  742734
  743251
  744350
  747076
  747077
  750338
  753371
  754482
  754649
  757060
  761414
  768529
  770040
  785888
  787187
  795073
  797581
  800688
  802986
  803729
  805923
  806189
  809528
  812522
  814725
  817013
  817517
  817672
  818606
  818813
  819063
  819631
  819753
  820689
  824092
  824939
  825323
  825391
  825976
  826344
  826658
  826690
  826865
  826890
  826928
  827032
  827092
  827596
]
13.31 ms
(9.49%)
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
  565811
  658736
  667100
  668827
  707282
  716491
  719118
  720272
  645259
  664281
  667681
  714646
  715095
  717279
  718501
  723214
  652248
  652262
  658562
  659666
  659814
  683288
  700885
  705887
  720540
  722106
  605021
  605035
  626627
  628295
  636926
  644338
  589707
  603322
  619472
  785888
  803729
  805923
  812522
  797581
  806189
  754482
  754649
  757060
  761414
  770040
  787187
  795073
  800688
  730242
  744350
  753371
  768529
  730077
  736772
  743251
  747076
  732132
  739725
  741914
  750338
  733468
  735340
  742582
  742734
  747077
  705356
  705365
  706864
  712835
  719746
  802986
  809528
  400727
  387436
  388897
  383111
  384796
  188600
  124308
  395888
  301920
  382656
  70186
  97598
  31563
  50436
  3826
  84120
  131462
  388204
  390857
  398515
  398779
  411404
  409114
  817517
  817672
  819063
  820689
  824092
  825323
  825391
  826658
  826690
  814725
  817013
  818606
  818813
  819631
  819753
  824939
  825976
  826344
  826865
  826890
  826928
  827032
  827092
  827596
]
2.94 ms
(2.09%)
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
  3826
  31563
  50436
  70186
  84120
  97598
  124308
  131462
  188600
  301920
  382656
  383111
  384796
  387436
  388204
  388897
  390857
  395888
  398515
  398779
  400727
  409114
  411404
  565811
  589707
  603322
  605021
  605035
  619472
  626627
  628295
  636926
  644338
  645259
  652248
  652262
  658562
  658736
  659666
  659814
  664281
  667100
  667681
  668827
  683288
  700885
  705356
  705365
  705887
  706864
  707282
  712835
  714646
  715095
  716491
  717279
  718501
  719118
  719746
  720272
  720540
  722106
  723214
  730077
  730242
  732132
  733468
  735340
  736772
  739725
  741914
  742582
  742734
  743251
  744350
  747076
  747077
  750338
  753371
  754482
  754649
  757060
  761414
  768529
  770040
  785888
  787187
  795073
  797581
  800688
  802986
  803729
  805923
  806189
  809528
  812522
  814725
  817013
  817517
  817672
  818606
  818813
  819063
  819631
  819753
  820689
  824092
  824939
  825323
  825391
  825976
  826344
  826658
  826690
  826865
  826890
  826928
  827032
  827092
  827596
]
2.13 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "short short"
]
1.91 ms
(1.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "short short"
]
1.59 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "short short"
]

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.