GET https://search.jues.net/search/embeds/9?q=young%20group

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.46 ms
(81.65%)
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
  98543
  386142
  390994
  391079
  395137
  395143
  400185
  404175
  404368
  404582
  407800
  411608
  426131
  443743
  446024
  452084
  452095
  454261
  457779
  464327
  468650
  469434
  474025
  484090
  485621
  485773
  486795
  486878
  487517
  493128
  502305
  505642
  505687
  511780
  514724
  516826
  519245
  520418
  520731
  522353
  522696
  524856
  527664
  529548
  530447
  531175
  532804
  535581
  536688
  537933
  540484
  541769
  541853
  545363
  545389
  545409
  545410
  545488
  546682
  548549
  548735
  549225
  550232
  550434
  553272
  554301
  560450
  561997
  565276
  566694
  566786
  568061
  574884
  575461
  575494
  575733
  576052
  576061
  576364
  577331
  579113
  588244
  588265
  595769
  597230
  597963
  599835
  608756
  625423
  627806
  627812
  631968
  632688
  632706
  633449
  634187
  637026
  637650
  639739
  641127
  641702
  663984
  665110
  666868
  668464
  675006
  680127
  680176
  680207
  687461
  695127
  696941
  696997
  707391
  728336
  748230
  752163
  790019
  790794
  813759
]
22.83 ms
(12.22%)
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
  527664
  549225
  550434
  452084
  545363
  545389
  577331
  579113
  541853
  545409
  545410
  548549
  560450
  541769
  545488
  553272
  554301
  565276
  566786
  675006
  707391
  666868
  680176
  680207
  695127
  561997
  568061
  634187
  588244
  625423
  631968
  639739
  597963
  588265
  599835
  627812
  608756
  627806
  632706
  633449
  641127
  464327
  520731
  386142
  98543
  395137
  395143
  391079
  390994
  400185
  404368
  404175
  404582
  407800
  426131
  411608
  813759
  469434
  474025
  485773
  493128
  446024
  486795
  457779
  468650
  485621
  487517
  514724
  519245
  522696
  532804
  536688
  511780
  522353
  524856
  531175
  502305
  505642
  505687
  520418
  529548
  530447
  535581
  540484
  516826
  537933
  484090
  486878
  566694
  576061
  576364
  546682
  576052
  574884
  575733
  665110
  663984
  680127
  668464
  687461
  548735
  550232
  575461
  575494
  597230
  641702
  637026
  595769
  637650
  790019
  790794
  748230
  728336
  752163
  632688
  696941
  696997
  443743
  452095
  454261
]
4.14 ms
(2.22%)
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
  98543
  386142
  390994
  391079
  395137
  395143
  400185
  404175
  404368
  404582
  407800
  411608
  426131
  443743
  446024
  452084
  452095
  454261
  457779
  464327
  468650
  469434
  474025
  484090
  485621
  485773
  486795
  486878
  487517
  493128
  502305
  505642
  505687
  511780
  514724
  516826
  519245
  520418
  520731
  522353
  522696
  524856
  527664
  529548
  530447
  531175
  532804
  535581
  536688
  537933
  540484
  541769
  541853
  545363
  545389
  545409
  545410
  545488
  546682
  548549
  548735
  549225
  550232
  550434
  553272
  554301
  560450
  561997
  565276
  566694
  566786
  568061
  574884
  575461
  575494
  575733
  576052
  576061
  576364
  577331
  579113
  588244
  588265
  595769
  597230
  597963
  599835
  608756
  625423
  627806
  627812
  631968
  632688
  632706
  633449
  634187
  637026
  637650
  639739
  641127
  641702
  663984
  665110
  666868
  668464
  675006
  680127
  680176
  680207
  687461
  695127
  696941
  696997
  707391
  728336
  748230
  752163
  790019
  790794
  813759
]
2.07 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young group"
]
1.81 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young group"
]
1.69 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young group"
]

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.