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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
196.03 ms
(88.68%)
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
  387562
  396704
  396725
  397505
  403162
  404459
  405054
  405176
  406308
  410657
  410955
  414342
  414681
  415155
  417421
  417482
  419378
  419600
  424628
  425320
  426032
  429763
  429766
  429770
  432661
  433553
  433863
  434492
  437855
  443232
  446394
  451527
  454122
  454844
  457755
  464599
  464704
  466691
  468530
  471832
  472647
  473225
  474714
  475486
  475778
  488721
  491271
  491684
  493657
  497901
  502703
  506143
  521897
  524704
  525819
  525942
  529116
  530492
  530851
  536618
  537670
  537896
  538300
  543919
  544858
  556911
  558601
  562391
  589232
  591623
  594280
  595421
  597253
  603475
  604295
  604553
  616336
  623204
  624190
  628089
  628116
  630526
  631193
  631200
  631972
  633793
  633796
  633798
  634116
  634207
  637025
  637077
  641999
  644066
  645858
  646242
  647638
  648871
  666876
  667747
  674927
  676101
  677671
  679728
  680127
  687257
  696579
  725601
  729894
  741527
  742203
  744978
  780637
  789013
  792569
  805300
  805438
  806377
  808406
  814991
]
16.52 ms
(7.47%)
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
  591623
  594280
  595421
  624190
  637077
  789013
  805438
  725601
  741527
  792569
  805300
  808406
  742203
  729894
  744978
  603475
  604553
  641999
  780637
  806377
  468530
  475778
  417421
  432661
  451527
  454122
  471832
  387562
  396725
  397505
  410955
  414681
  424628
  433863
  466691
  473225
  396704
  405176
  415155
  419600
  433553
  454844
  464599
  472647
  457755
  524704
  491271
  491684
  521897
  538300
  488721
  493657
  525819
  525942
  814991
  536618
  502703
  530492
  530851
  537896
  676101
  679728
  647638
  648871
  633798
  597253
  604295
  634207
  631193
  406308
  410657
  437855
  446394
  506143
  537670
  562391
  543919
  645858
  646242
  674927
  687257
  696579
  666876
  589232
  616336
  631972
  633793
  630526
  631200
  634116
  633796
  425320
  434492
  417482
  558601
  403162
  443232
  475486
  529116
  474714
  556911
  544858
  667747
  677671
  680127
  644066
  628116
  637025
  623204
  628089
  419378
  405054
  404459
  426032
  414342
  429770
  429763
  429766
  497901
  464704
]
2.44 ms
(1.11%)
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
  387562
  396704
  396725
  397505
  403162
  404459
  405054
  405176
  406308
  410657
  410955
  414342
  414681
  415155
  417421
  417482
  419378
  419600
  424628
  425320
  426032
  429763
  429766
  429770
  432661
  433553
  433863
  434492
  437855
  443232
  446394
  451527
  454122
  454844
  457755
  464599
  464704
  466691
  468530
  471832
  472647
  473225
  474714
  475486
  475778
  488721
  491271
  491684
  493657
  497901
  502703
  506143
  521897
  524704
  525819
  525942
  529116
  530492
  530851
  536618
  537670
  537896
  538300
  543919
  544858
  556911
  558601
  562391
  589232
  591623
  594280
  595421
  597253
  603475
  604295
  604553
  616336
  623204
  624190
  628089
  628116
  630526
  631193
  631200
  631972
  633793
  633796
  633798
  634116
  634207
  637025
  637077
  641999
  644066
  645858
  646242
  647638
  648871
  666876
  667747
  674927
  676101
  677671
  679728
  680127
  687257
  696579
  725601
  729894
  741527
  742203
  744978
  780637
  789013
  792569
  805300
  805438
  806377
  808406
  814991
]
1.65 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "interracial teen bbc"
]
1.52 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межрасов teen bbc"
]
1.38 ms
(0.62%)
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.