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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.33 ms
(86.76%)
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
  7170
  11582
  308542
  373897
  388007
  395489
  396565
  397980
  402632
  410954
  415819
  420358
  421152
  421238
  421373
  421462
  423425
  423612
  426390
  429814
  431904
  431953
  433280
  433319
  433334
  437511
  437875
  445398
  447154
  448813
  449021
  451866
  452798
  459366
  461714
  472387
  478993
  483814
  487410
  492338
  494525
  499182
  500333
  509813
  510160
  512785
  512951
  518111
  519690
  521253
  522846
  524530
  541482
  542692
  549076
  550692
  568460
  569163
  574155
  588276
  600010
  600490
  601659
  604061
  614693
  616315
  619535
  629661
  630773
  656105
  656209
  671077
  671810
  674082
  675858
  688369
  691992
  694562
  696100
  697774
  707089
  710799
  711281
  712366
  712481
  715835
  716496
  718146
  720815
  722380
  728362
  738441
  738473
  739776
  740578
  744093
  750334
  750760
  756849
  757443
  767169
  768949
  776287
  776313
  777042
  786016
  794155
  799721
  799785
  800352
  805228
  808327
  813437
  813987
  814008
  814094
  817322
  822155
  825533
]
15.96 ms
(8.33%)
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
  429814
  397980
  817322
  472387
  521253
  629661
  738441
  739776
  740578
  744093
  711281
  776313
  822155
  757443
  447154
  410954
  421462
  431904
  433280
  459366
  500333
  568460
  569163
  600010
  421152
  402632
  437875
  483814
  509813
  574155
  604061
  494525
  448813
  373897
  814094
  656105
  696100
  786016
  697774
  794155
  11582
  478993
  512951
  522846
  688369
  420358
  777042
  7170
  707089
  437511
  449021
  524530
  600490
  431953
  595376
  461714
  674082
  691992
  675858
  421373
  445398
  492338
  510160
  512785
  542692
  716496
  722380
  614693
  616315
  588276
  601659
  619535
  808327
  799721
  423612
  421238
  415819
  814008
  549076
  710799
  715835
  656209
  671810
  694562
  718146
  630773
  776287
  805228
  756849
  767169
  813437
  768949
  738473
  451866
  825533
  712481
  813987
  720815
  433334
  452798
  499182
  518111
  487410
  388007
  671077
  712366
  800352
  728362
  750334
  750760
  395489
  308542
  426390
  541482
  550692
  396565
  423425
  519690
  799785
  433319
]
2.24 ms
(1.17%)
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
  7170
  11582
  308542
  373897
  388007
  395489
  396565
  397980
  402632
  410954
  415819
  420358
  421152
  421238
  421373
  421462
  423425
  423612
  426390
  429814
  431904
  431953
  433280
  433319
  433334
  437511
  437875
  445398
  447154
  448813
  449021
  451866
  452798
  459366
  461714
  472387
  478993
  483814
  487410
  492338
  494525
  499182
  500333
  509813
  510160
  512785
  512951
  518111
  519690
  521253
  522846
  524530
  541482
  542692
  549076
  550692
  568460
  569163
  574155
  588276
  600010
  600490
  601659
  604061
  614693
  616315
  619535
  629661
  630773
  656105
  656209
  671077
  671810
  674082
  675858
  688369
  691992
  694562
  696100
  697774
  707089
  710799
  711281
  712366
  712481
  715835
  716496
  718146
  720815
  722380
  728362
  738441
  738473
  739776
  740578
  744093
  750334
  750760
  756849
  757443
  767169
  768949
  776287
  776313
  777042
  786016
  794155
  799721
  799785
  800352
  805228
  808327
  813437
  813987
  814008
  814094
  817322
  822155
  825533
]
2.01 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation anal teen"
]
1.92 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк анал teen"
]
1.73 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "подборк анал teen"
]
1.52 ms
(0.79%)
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.