GET https://search.jues.net/search/embeds/8?q=threesome%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.77 ms
(86.63%)
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
  11718
  21506
  96944
  97047
  100616
  163133
  263296
  341889
  386883
  388066
  388647
  390518
  391508
  393039
  395937
  396692
  398689
  401309
  403067
  405176
  406091
  417486
  423609
  438761
  477319
  522861
  538563
  540076
  546840
  548607
  584014
  606489
  619445
  631934
  633070
  637437
  645964
  649187
  652245
  652853
  652877
  652895
  661247
  670097
  670761
  671721
  671724
  672490
  672579
  673554
  674430
  678557
  679050
  679349
  683291
  683963
  685621
  685626
  685686
  687232
  687249
  689645
  692815
  694201
  694221
  694554
  698537
  699606
  699608
  699658
  701051
  703537
  705537
  705813
  705828
  708103
  708826
  717899
  718655
  719102
  720273
  720281
  720774
  720778
  720819
  721116
  721405
  721569
  722692
  722792
  723481
  723527
  725312
  728768
  732004
  741125
  741537
  742158
  742459
  751618
  752566
  754205
  756210
  758201
  767287
  770313
  771560
  772708
  775892
  778366
  780637
  788443
  793441
  793472
  795525
  805307
  817444
  817617
  819597
  820953
]
14.86 ms
(8.01%)
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
  692815
  584014
  756210
  728768
  396692
  263296
  388647
  386883
  403067
  417486
  817617
  652853
  703537
  720774
  670097
  721405
  722692
  652877
  671724
  619445
  793472
  795525
  742459
  751618
  754205
  701051
  721569
  793441
  11718
  406091
  388066
  393039
  395937
  96944
  21506
  817444
  820953
  540076
  546840
  683291
  687249
  699608
  723481
  649187
  673554
  674430
  683963
  685621
  689645
  694554
  699658
  705813
  720281
  720778
  645964
  652245
  685626
  694221
  698537
  705537
  705828
  708826
  718655
  722792
  606489
  631934
  633070
  637437
  778366
  788443
  767287
  772708
  805307
  732004
  741125
  742158
  771560
  725312
  752566
  758201
  741537
  770313
  775892
  780637
  341889
  398689
  100616
  390518
  401309
  163133
  405176
  97047
  391508
  423609
  438761
  723527
  819597
  477319
  522861
  538563
  548607
  661247
  672490
  678557
  694201
  708103
  717899
  719102
  670761
  671721
  679050
  679349
  685686
  699606
  652895
  672579
  687232
  720273
  720819
  721116
]
2.36 ms
(1.27%)
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
  11718
  21506
  96944
  97047
  100616
  163133
  263296
  341889
  386883
  388066
  388647
  390518
  391508
  393039
  395937
  396692
  398689
  401309
  403067
  405176
  406091
  417486
  423609
  438761
  477319
  522861
  538563
  540076
  546840
  548607
  584014
  606489
  619445
  631934
  633070
  637437
  645964
  649187
  652245
  652853
  652877
  652895
  661247
  670097
  670761
  671721
  671724
  672490
  672579
  673554
  674430
  678557
  679050
  679349
  683291
  683963
  685621
  685626
  685686
  687232
  687249
  689645
  692815
  694201
  694221
  694554
  698537
  699606
  699608
  699658
  701051
  703537
  705537
  705813
  705828
  708103
  708826
  717899
  718655
  719102
  720273
  720281
  720774
  720778
  720819
  721116
  721405
  721569
  722692
  722792
  723481
  723527
  725312
  728768
  732004
  741125
  741537
  742158
  742459
  751618
  752566
  754205
  756210
  758201
  767287
  770313
  771560
  772708
  775892
  778366
  780637
  788443
  793441
  793472
  795525
  805307
  817444
  817617
  819597
  820953
]
2.16 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "threesome teen"
]
1.88 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс втро teen"
]
1.79 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс втро teen"
]

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.