GET https://search.jues.net/search/embeds/5?q=teen%20hardcore%20bbc

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.83 ms
(84.75%)
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
  33459
  130105
  341675
  396358
  396600
  400965
  401629
  407357
  408460
  408601
  413944
  416351
  416819
  417999
  420139
  420768
  421003
  421093
  429943
  432243
  437519
  443480
  447152
  447560
  457077
  457163
  457293
  464188
  478033
  480420
  488551
  491263
  494620
  497776
  500913
  502703
  509805
  510270
  512453
  522130
  522133
  522858
  527428
  528886
  530492
  530650
  530851
  531157
  531194
  531225
  531230
  531257
  532960
  532984
  534987
  536616
  536618
  536631
  536650
  537675
  537896
  537908
  537928
  537988
  540404
  542975
  543872
  563992
  578406
  583960
  586587
  600194
  601623
  617410
  628082
  628087
  630542
  632687
  633747
  633749
  634122
  634207
  634556
  636286
  637125
  638576
  642000
  644273
  644962
  647322
  647638
  648499
  648846
  649579
  650333
  651051
  651147
  666872
  674975
  676022
  676025
  676066
  676107
  676111
  677307
  677781
  677801
  678028
  678073
  678127
  678161
  679728
  679744
  679816
  696203
  704526
  720340
  723620
  732262
  805288
]
18.13 ms
(10.12%)
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
  563992
  648846
  650333
  676111
  679744
  651051
  676066
  637125
  636286
  601623
  632687
  805288
  396358
  457077
  417999
  478033
  480420
  401629
  407357
  457293
  512453
  488551
  497776
  510270
  674975
  421093
  630542
  720340
  732262
  537675
  537928
  583960
  677781
  678127
  617410
  633749
  628087
  628082
  676022
  677307
  586587
  130105
  341675
  33459
  396600
  400965
  408460
  408601
  413944
  432243
  437519
  420768
  421003
  443480
  420139
  429943
  416351
  416819
  723620
  644962
  447152
  457163
  464188
  491263
  522858
  531157
  531225
  531230
  531257
  536618
  537908
  500913
  502703
  522130
  528886
  530650
  532960
  534987
  522133
  530492
  536631
  536650
  494620
  509805
  527428
  530851
  531194
  532984
  536616
  537896
  537988
  540404
  542975
  543872
  578406
  666872
  678161
  679728
  648499
  649579
  676025
  677801
  678028
  678073
  679816
  696203
  704526
  647322
  647638
  651147
  676107
  633747
  644273
  638576
  642000
  634122
  600194
  634207
  634556
  447560
]
2.90 ms
(1.62%)
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
  33459
  130105
  341675
  396358
  396600
  400965
  401629
  407357
  408460
  408601
  413944
  416351
  416819
  417999
  420139
  420768
  421003
  421093
  429943
  432243
  437519
  443480
  447152
  447560
  457077
  457163
  457293
  464188
  478033
  480420
  488551
  491263
  494620
  497776
  500913
  502703
  509805
  510270
  512453
  522130
  522133
  522858
  527428
  528886
  530492
  530650
  530851
  531157
  531194
  531225
  531230
  531257
  532960
  532984
  534987
  536616
  536618
  536631
  536650
  537675
  537896
  537908
  537928
  537988
  540404
  542975
  543872
  563992
  578406
  583960
  586587
  600194
  601623
  617410
  628082
  628087
  630542
  632687
  633747
  633749
  634122
  634207
  634556
  636286
  637125
  638576
  642000
  644273
  644962
  647322
  647638
  648499
  648846
  649579
  650333
  651051
  651147
  666872
  674975
  676022
  676025
  676066
  676107
  676111
  677307
  677781
  677801
  678028
  678073
  678127
  678161
  679728
  679744
  679816
  696203
  704526
  720340
  723620
  732262
  805288
]
2.11 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen hardcore bbc"
]
1.57 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen хардкор bbc"
]
1.14 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen хардкор bbc"
]

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.