GET https://search.jues.net/search/embeds/3?q=does

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.95 ms
(83.46%)
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
  154157
  387408
  388080
  389492
  393313
  394282
  395934
  403549
  415511
  436419
  436982
  437104
  440372
  457942
  468112
  478239
  486247
  491875
  495508
  523365
  525734
  527486
  527511
  527517
  527521
  529066
  530856
  532552
  534036
  551908
  564261
  583626
  587094
  587390
  591999
  593149
  593562
  596924
  604002
  606315
  610538
  612083
  612586
  617142
  619262
  630428
  635883
  648671
  654205
  659172
  666046
  669345
  670578
  679241
  697656
  702065
  721771
  721959
  722179
  723017
  724803
  724933
  725005
  725106
  725285
  725301
  726881
  727501
  728964
  729610
  735006
  735207
  739402
  739417
  742790
  748343
  748540
  748669
  749943
  758306
  759382
  759836
  763819
  765160
  765898
  769472
  771291
  774800
  776206
  787418
  791281
  791653
  792601
  793778
  796613
  799668
  799836
  800076
  800107
  801407
  801438
  802316
  805037
  806032
  806627
  811915
  811926
  812863
  815418
  816990
  817787
  818010
  818825
  819947
  821062
  822263
  823760
]
14.35 ms
(9.90%)
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
  659172
  697656
  593562
  593149
  604002
  612586
  774800
  793778
  799836
  800076
  811926
  799668
  806627
  724803
  725213
  735207
  748540
  758306
  801407
  728964
  726881
  739417
  735006
  769574
  721771
  721959
  722179
  787418
  389492
  387408
  495508
  154157
  403549
  436982
  436419
  818010
  818825
  816990
  819947
  822263
  815418
  821062
  457942
  468112
  525734
  527517
  529066
  530856
  527511
  534036
  523365
  527521
  532552
  564261
  551908
  583626
  654205
  679241
  723017
  648671
  666046
  669345
  670578
  702065
  587390
  606315
  591999
  619262
  635883
  587094
  596924
  610538
  612083
  617142
  630428
  791281
  802316
  805037
  803361
  725005
  725106
  725285
  725301
  727501
  729610
  748669
  765160
  792601
  800107
  801438
  724933
  748343
  759382
  759836
  769472
  739402
  742790
  749943
  763819
  765898
  771291
  776206
  791653
  796613
  806032
  811915
  812863
  415511
  478239
  394282
  393313
  395934
  388080
  440372
  437104
  823760
  817787
  491875
  486247
  527486
]
2.98 ms
(2.06%)
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
  154157
  387408
  388080
  389492
  393313
  394282
  395934
  403549
  415511
  436419
  436982
  437104
  440372
  457942
  468112
  478239
  486247
  491875
  495508
  523365
  525734
  527486
  527511
  527517
  527521
  529066
  530856
  532552
  534036
  551908
  564261
  583626
  587094
  587390
  591999
  593149
  593562
  596924
  604002
  606315
  610538
  612083
  612586
  617142
  619262
  630428
  635883
  648671
  654205
  659172
  666046
  669345
  670578
  679241
  697656
  702065
  721771
  721959
  722179
  723017
  724803
  724933
  725005
  725106
  725285
  725301
  726881
  727501
  728964
  729610
  735006
  735207
  739402
  739417
  742790
  748343
  748540
  748669
  749943
  758306
  759382
  759836
  763819
  765160
  765898
  769472
  771291
  774800
  776206
  787418
  791281
  791653
  792601
  793778
  796613
  799668
  799836
  800076
  800107
  801407
  801438
  802316
  805037
  806032
  806627
  811915
  811926
  812863
  815418
  816990
  817787
  818010
  818825
  819947
  821062
  822263
  823760
]
1.87 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "does"
]
1.67 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "does"
]
1.41 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "does"
]

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.