GET https://search.jues.net/search/embeds/3?q=hairy%20group

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.57 ms
(87.40%)
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
  123029
  383389
  384490
  384532
  385889
  388411
  389899
  390950
  396368
  396606
  400946
  400956
  401262
  404415
  408969
  409084
  413905
  420629
  421556
  425958
  428113
  430088
  430209
  442987
  443743
  446972
  451547
  451896
  452269
  454298
  455821
  457387
  457812
  465633
  466382
  469415
  475817
  478445
  482237
  482961
  486699
  486805
  487005
  492727
  494748
  495243
  500467
  505804
  519234
  522409
  524955
  531507
  534236
  534786
  536886
  538895
  540187
  540195
  540508
  541321
  541893
  542831
  548517
  548628
  550010
  551976
  552935
  556409
  556416
  559910
  560083
  562844
  563533
  566329
  567396
  572599
  572744
  573761
  581323
  581334
  581664
  581688
  584004
  584731
  595765
  595772
  595817
  595819
  598903
  601829
  603242
  605334
  606537
  622652
  622655
  623510
  624239
  644264
  644296
  644922
  644968
  645235
  651199
  670773
  676895
  682198
  699584
  720239
  748154
  748245
  748695
  775803
  776008
  782518
  789998
  809525
  810823
  817349
  817841
  820331
]
15.77 ms
(7.72%)
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
  817349
  820331
  457812
  475817
  457387
  469415
  478445
  524955
  540187
  536886
  540195
  494748
  519234
  492727
  552935
  567396
  572599
  572744
  548517
  548628
  581323
  581334
  584731
  550010
  670773
  645235
  651199
  682198
  699584
  676895
  720239
  556416
  562844
  598903
  603242
  622652
  644264
  595765
  601829
  606537
  622655
  624239
  595817
  595772
  595819
  605334
  789998
  809525
  775803
  810823
  782518
  748154
  748245
  748695
  623510
  644296
  776008
  425958
  396368
  413905
  388411
  400956
  451547
  487005
  522409
  500467
  389899
  390950
  400946
  455821
  581688
  581664
  584004
  443743
  454298
  385889
  383389
  384532
  384490
  123029
  396606
  401262
  404415
  408969
  421556
  428113
  442987
  430209
  409084
  420629
  430088
  644922
  644968
  817841
  452269
  486805
  446972
  451896
  466382
  482961
  534786
  495243
  505804
  531507
  534236
  538895
  540508
  465633
  482237
  486699
  541321
  541893
  542831
  559910
  560083
  551976
  556409
  563533
  566329
  573761
]
3.21 ms
(1.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.30 ms
(1.12%)
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
  123029
  383389
  384490
  384532
  385889
  388411
  389899
  390950
  396368
  396606
  400946
  400956
  401262
  404415
  408969
  409084
  413905
  420629
  421556
  425958
  428113
  430088
  430209
  442987
  443743
  446972
  451547
  451896
  452269
  454298
  455821
  457387
  457812
  465633
  466382
  469415
  475817
  478445
  482237
  482961
  486699
  486805
  487005
  492727
  494748
  495243
  500467
  505804
  519234
  522409
  524955
  531507
  534236
  534786
  536886
  538895
  540187
  540195
  540508
  541321
  541893
  542831
  548517
  548628
  550010
  551976
  552935
  556409
  556416
  559910
  560083
  562844
  563533
  566329
  567396
  572599
  572744
  573761
  581323
  581334
  581664
  581688
  584004
  584731
  595765
  595772
  595817
  595819
  598903
  601829
  603242
  605334
  606537
  622652
  622655
  623510
  624239
  644264
  644296
  644922
  644968
  645235
  651199
  670773
  676895
  682198
  699584
  720239
  748154
  748245
  748695
  775803
  776008
  782518
  789998
  809525
  810823
  817349
  817841
  820331
]
1.81 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy group"
]
1.36 ms
(0.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая group"
]
1.31 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая 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.