GET https://search.jues.net/search/embeds/6?q=body%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
116.37 ms
(78.64%)
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
  313892
  385854
  397099
  397714
  403272
  408024
  413535
  418083
  419330
  420186
  421009
  422953
  445046
  446691
  447090
  447092
  447641
  454753
  456070
  457710
  460635
  461201
  467169
  468217
  468857
  471090
  473040
  473763
  474755
  478208
  480240
  480242
  482731
  482896
  483908
  488888
  491215
  492205
  498374
  498526
  498832
  499721
  499959
  502045
  505762
  508828
  511218
  512148
  523645
  523944
  525158
  526724
  540019
  548621
  551980
  552565
  556948
  558812
  559584
  564659
  567178
  580357
  584661
  586900
  589390
  589876
  589889
  589898
  589899
  589987
  596402
  597861
  598311
  602052
  613309
  628346
  628667
  633240
  634956
  637388
  647403
  649132
  650603
  665930
  687299
  697166
  708800
  709131
  709181
  714378
  715566
  715711
  720712
  721427
  741278
  741427
  748149
  749609
  750729
  760994
  773206
  777676
  782094
  790200
  796538
  798171
  798720
  802716
  804498
  809317
  809354
  810042
  812229
  814046
  814691
  815466
  816691
  824067
  824370
  826117
]
21.45 ms
(14.49%)
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
  589899
  790200
  741278
  804498
  809317
  313892
  447641
  461201
  483908
  491215
  502045
  584661
  649132
  650603
  720712
  697166
  721427
  589876
  798720
  809354
  741427
  709181
  420186
  525158
  422953
  814691
  816691
  468857
  473763
  482731
  499721
  540019
  474755
  567178
  556948
  714378
  597861
  598311
  628346
  633240
  709131
  715711
  798171
  413535
  480242
  480240
  457710
  478208
  499959
  498832
  488888
  523645
  445046
  815466
  824067
  814046
  468217
  446691
  512148
  498374
  511218
  460635
  551980
  558812
  580357
  559584
  665930
  687299
  647403
  548621
  552565
  564659
  586900
  589898
  602052
  589390
  589889
  802716
  777676
  796538
  812229
  760994
  748149
  750729
  773206
  749609
  708800
  715566
  408024
  467169
  418083
  471090
  397099
  397714
  447090
  456070
  385854
  403272
  454753
  473040
  421009
  526724
  482896
  498526
  508828
  523944
  492205
  505762
  419330
  826117
  824370
  447092
  589987
  596402
  613309
  628667
  637388
  810042
  634956
  782094
]
2.63 ms
(1.78%)
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
  313892
  385854
  397099
  397714
  403272
  408024
  413535
  418083
  419330
  420186
  421009
  422953
  445046
  446691
  447090
  447092
  447641
  454753
  456070
  457710
  460635
  461201
  467169
  468217
  468857
  471090
  473040
  473763
  474755
  478208
  480240
  480242
  482731
  482896
  483908
  488888
  491215
  492205
  498374
  498526
  498832
  499721
  499959
  502045
  505762
  508828
  511218
  512148
  523645
  523944
  525158
  526724
  540019
  548621
  551980
  552565
  556948
  558812
  559584
  564659
  567178
  580357
  584661
  586900
  589390
  589876
  589889
  589898
  589899
  589987
  596402
  597861
  598311
  602052
  613309
  628346
  628667
  633240
  634956
  637388
  647403
  649132
  650603
  665930
  687299
  697166
  708800
  709131
  709181
  714378
  715566
  715711
  720712
  721427
  741278
  741427
  748149
  749609
  750729
  760994
  773206
  777676
  782094
  790200
  796538
  798171
  798720
  802716
  804498
  809317
  809354
  810042
  812229
  814046
  814691
  815466
  816691
  824067
  824370
  826117
]
2.04 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "body секс"
]
2.01 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "body sex"
]
1.75 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "body секс"
]

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.