GET https://search.jues.net/search/embeds/10?q=long%20girls

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
266.96 ms
(64.37%)
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
  547206
  596164
  642666
  790421
  777093
  785216
  774055
  744555
  766432
  741224
  743148
  754400
  768848
  774113
  744125
  738100
  708639
  709125
  723364
  786186
  790758
  717686
  787768
  422475
  459012
  450583
  529986
  516680
  563826
  550495
  668476
  704912
  720388
  596126
  602635
  589820
  776222
  813009
  772433
  807869
  809661
  435579
  446215
  418224
  433878
  493035
  513203
  498954
  519332
  437118
  420662
  419496
  425365
  585097
  449079
  516344
  513110
  513561
  536089
  538071
  529426
  461686
  469743
  480774
  543310
  548098
  551229
  560088
  573428
  580194
  542535
  566064
  559436
  561269
  565896
  567160
  584320
  648370
  651080
  669665
  686130
  695868
  661430
  660943
  670368
  675375
  549041
  551903
  552251
  595057
  622464
  588676
  589775
  597071
  601216
  589676
  595493
  601396
  602711
  626850
  631641
  639311
  798770
  806879
  150495
  428988
  444912
  447749
  453644
  462663
  465042
  475462
  416724
  434182
  460366
  471359
  447529
  452647
  454039
  461577
]
138.88 ms
(33.49%)
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
  150495
  416724
  418224
  419496
  420662
  422475
  425365
  428988
  433878
  434182
  435579
  437118
  444912
  446215
  447529
  447749
  449079
  450583
  452647
  453644
  454039
  459012
  460366
  461577
  461686
  462663
  465042
  469743
  471359
  475462
  480774
  493035
  498954
  513110
  513203
  513561
  516344
  516680
  519332
  529426
  529986
  536089
  538071
  542535
  543310
  547206
  548098
  549041
  550495
  551229
  551903
  552251
  559436
  560088
  561269
  563826
  565896
  566064
  567160
  573428
  580194
  584320
  585097
  588676
  589676
  589775
  589820
  595057
  595493
  596126
  596164
  597071
  601216
  601396
  602635
  602711
  622464
  626850
  631641
  639311
  642666
  648370
  651080
  660943
  661430
  668476
  669665
  670368
  675375
  686130
  695868
  704912
  708639
  709125
  717686
  720388
  723364
  738100
  741224
  743148
  744125
  744555
  754400
  766432
  768848
  772433
  774055
  774113
  776222
  777093
  785216
  786186
  787768
  790421
  790758
  798770
  806879
  807869
  809661
  813009
]
2.37 ms
(0.57%)
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
  150495
  416724
  418224
  419496
  420662
  422475
  425365
  428988
  433878
  434182
  435579
  437118
  444912
  446215
  447529
  447749
  449079
  450583
  452647
  453644
  454039
  459012
  460366
  461577
  461686
  462663
  465042
  469743
  471359
  475462
  480774
  493035
  498954
  513110
  513203
  513561
  516344
  516680
  519332
  529426
  529986
  536089
  538071
  542535
  543310
  547206
  548098
  549041
  550495
  551229
  551903
  552251
  559436
  560088
  561269
  563826
  565896
  566064
  567160
  573428
  580194
  584320
  585097
  588676
  589676
  589775
  589820
  595057
  595493
  596126
  596164
  597071
  601216
  601396
  602635
  602711
  622464
  626850
  631641
  639311
  642666
  648370
  651080
  660943
  661430
  668476
  669665
  670368
  675375
  686130
  695868
  704912
  708639
  709125
  717686
  720388
  723364
  738100
  741224
  743148
  744125
  744555
  754400
  766432
  768848
  772433
  774055
  774113
  776222
  777093
  785216
  786186
  787768
  790421
  790758
  798770
  806879
  807869
  809661
  813009
]
1.88 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "длинные девушк"
]
1.64 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "long girls"
]
1.51 ms
(0.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.