GET https://search.jues.net/search/embeds/3?q=hair%20play

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.03 ms
(56.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hair play"
]
142.46 ms
(37.47%)
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
  96259
  385606
  417279
  418460
  423239
  428682
  433827
  439683
  444550
  445428
  450777
  452848
  459325
  472074
  472329
  474486
  487978
  490004
  492435
  496661
  504727
  514150
  515443
  517532
  530705
  533748
  554935
  557496
  564749
  575041
  580133
  583408
  587433
  602179
  603747
  605065
  607235
  607993
  617465
  617487
  617796
  620903
  624688
  627505
  630476
  631762
  642271
  643755
  648061
  656197
  662022
  664318
  665854
  666834
  670813
  672987
  679051
  679095
  682724
  682763
  693384
  698834
  703650
  708989
  713145
  714181
  716719
  722369
  729466
  733020
  734589
  743748
  744035
  746523
  747933
  749680
  754086
  758246
  760396
  765605
  766357
  768490
  769885
  769897
  773532
  776964
  777821
  778636
  778965
  779570
  780703
  783095
  784747
  787706
  792510
  792658
  793884
  795061
  797000
  797878
  798836
  799862
  803357
  803807
  804682
  804983
  806958
  807050
  807869
  809922
  809974
  813909
  813921
  814352
  815078
  816124
  819157
  819759
  819903
  825514
]
14.41 ms
(3.79%)
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
  423239
  807869
  418460
  417279
  819157
  815078
  813921
  450777
  459325
  557496
  564749
  575041
  682724
  708989
  713145
  714181
  670813
  672987
  603747
  605065
  607993
  624688
  587433
  620903
  643755
  776964
  778636
  787706
  778965
  780703
  795061
  797878
  809974
  729466
  760396
  765605
  768490
  769885
  769897
  792510
  792658
  749680
  733020
  734589
  754086
  743748
  617465
  627505
  716719
  777821
  96259
  452848
  472329
  492435
  515443
  385606
  428682
  816124
  819903
  813909
  825514
  472074
  517532
  533748
  554935
  580133
  665854
  666834
  679051
  682763
  703650
  722369
  693384
  698834
  648061
  656197
  662022
  664318
  679095
  630476
  642271
  602179
  607235
  617487
  631762
  784747
  803357
  793884
  799862
  804682
  809922
  766357
  773532
  806958
  807050
  746523
  758246
  744035
  747933
  617796
  779570
  783095
  797000
  798836
  803807
  804983
  439683
  445428
  433827
  444550
  583408
  814352
  819759
  487978
  490004
  474486
  514150
  530705
  496661
  504727
]
2.70 ms
(0.71%)
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
  96259
  385606
  417279
  418460
  423239
  428682
  433827
  439683
  444550
  445428
  450777
  452848
  459325
  472074
  472329
  474486
  487978
  490004
  492435
  496661
  504727
  514150
  515443
  517532
  530705
  533748
  554935
  557496
  564749
  575041
  580133
  583408
  587433
  602179
  603747
  605065
  607235
  607993
  617465
  617487
  617796
  620903
  624688
  627505
  630476
  631762
  642271
  643755
  648061
  656197
  662022
  664318
  665854
  666834
  670813
  672987
  679051
  679095
  682724
  682763
  693384
  698834
  703650
  708989
  713145
  714181
  716719
  722369
  729466
  733020
  734589
  743748
  744035
  746523
  747933
  749680
  754086
  758246
  760396
  765605
  766357
  768490
  769885
  769897
  773532
  776964
  777821
  778636
  778965
  779570
  780703
  783095
  784747
  787706
  792510
  792658
  793884
  795061
  797000
  797878
  798836
  799862
  803357
  803807
  804682
  804983
  806958
  807050
  807869
  809922
  809974
  813909
  813921
  814352
  815078
  816124
  819157
  819759
  819903
  825514
]
1.97 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hair play"
]
1.88 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hair play"
]
1.73 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.