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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
559.13 ms
(94.48%)
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
  407357
  407827
  409933
  412738
  417198
  424303
  428328
  432353
  434728
  434792
  437462
  441439
  446940
  447718
  448083
  452916
  455730
  455752
  455972
  456531
  456708
  459332
  459362
  460067
  461613
  463712
  464305
  464306
  468027
  469071
  471341
  473915
  474301
  484249
  486426
  488077
  488081
  490467
  493102
  493310
  497026
  501710
  507591
  508425
  513222
  517373
  517968
  519180
  520205
  520489
  521048
  521758
  523819
  524743
  525784
  527660
  528076
  530499
  531117
  531136
  531139
  532022
  532029
  532245
  532762
  533773
  534000
  540573
  542907
  552415
  561338
  567405
  569131
  569176
  571775
  572296
  580180
  586518
  592776
  600029
  600825
  602631
  603610
  603652
  604409
  605918
  615812
  621270
  623202
  632571
  632599
  632659
  633124
  633818
  637001
  639253
  640784
  641698
  643105
  644065
  644986
  646029
  646771
  646899
  646904
  653447
  670117
  674118
  677097
  678089
  678517
  679465
  702675
  702679
  702680
  703833
  703841
  704531
  707703
  752588
]
20.98 ms
(3.55%)
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
  528076
  572296
  580180
  561338
  569131
  567405
  571775
  670117
  674118
  677097
  633818
  592776
  602631
  605918
  623202
  600825
  603610
  639253
  586518
  603652
  615812
  621270
  752588
  702675
  702679
  703841
  463712
  428328
  434728
  446940
  455752
  464305
  474301
  407357
  437462
  434792
  456708
  461613
  488081
  490467
  488077
  497026
  519180
  521048
  517373
  527660
  407827
  424303
  455730
  456531
  459332
  459362
  469071
  473915
  493310
  532029
  517968
  531139
  678517
  702680
  653447
  707703
  646904
  552415
  644065
  604409
  640784
  412738
  409933
  464306
  432353
  455972
  471341
  448083
  460067
  520489
  521758
  468027
  530499
  508425
  532022
  569176
  542907
  678089
  679465
  646771
  646029
  633124
  632599
  632659
  703833
  417198
  447718
  525784
  524743
  513222
  507591
  523819
  441439
  486426
  452916
  531136
  532762
  533773
  534000
  493102
  646899
  600029
  641698
  643105
  632571
  704531
  484249
  520205
  531117
  532245
  501710
  637001
  644986
  540573
]
4.35 ms
(0.73%)
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
  407357
  407827
  409933
  412738
  417198
  424303
  428328
  432353
  434728
  434792
  437462
  441439
  446940
  447718
  448083
  452916
  455730
  455752
  455972
  456531
  456708
  459332
  459362
  460067
  461613
  463712
  464305
  464306
  468027
  469071
  471341
  473915
  474301
  484249
  486426
  488077
  488081
  490467
  493102
  493310
  497026
  501710
  507591
  508425
  513222
  517373
  517968
  519180
  520205
  520489
  521048
  521758
  523819
  524743
  525784
  527660
  528076
  530499
  531117
  531136
  531139
  532022
  532029
  532245
  532762
  533773
  534000
  540573
  542907
  552415
  561338
  567405
  569131
  569176
  571775
  572296
  580180
  586518
  592776
  600029
  600825
  602631
  603610
  603652
  604409
  605918
  615812
  621270
  623202
  632571
  632599
  632659
  633124
  633818
  637001
  639253
  640784
  641698
  643105
  644065
  644986
  646029
  646771
  646899
  646904
  653447
  670117
  674118
  677097
  678089
  678517
  679465
  702675
  702679
  702680
  703833
  703841
  704531
  707703
  752588
]
2.22 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boobs facial"
]
2.00 ms
(0.34%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "boobs facial"
]
1.44 ms
(0.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "boobs facial"
]

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.