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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.73 ms
(84.41%)
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
  388724
  395667
  395892
  396242
  400426
  401260
  401296
  401985
  426159
  443729
  453597
  455841
  456201
  458305
  461733
  463809
  463927
  472179
  473766
  476808
  482087
  486275
  487205
  491286
  521588
  523544
  529854
  536252
  539938
  540677
  544209
  544749
  556911
  565159
  565198
  566516
  566807
  566981
  571210
  574897
  587858
  596991
  597066
  597246
  598067
  598675
  598723
  603077
  603304
  603584
  603951
  605323
  605335
  612861
  614095
  620300
  620990
  623200
  624299
  628441
  629398
  630266
  633533
  634499
  636277
  645980
  648583
  649569
  657070
  664808
  667268
  671626
  676924
  678799
  678802
  696219
  696995
  699624
  706311
  712162
  716027
  718532
  718670
  720506
  720813
  721298
  721325
  722443
  722889
  722897
  735602
  740596
  741113
  741539
  741889
  742197
  744852
  747401
  752722
  753448
  758496
  760991
  761576
  770582
  771203
  775962
  779135
  786768
  790989
  791000
  799785
  800553
  800619
  805668
  807497
  809652
  810701
  812351
  812922
  817623
]
20.70 ms
(10.42%)
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
  720506
  676924
  401985
  426159
  458305
  556911
  587858
  597066
  603584
  614095
  629398
  597246
  605323
  623200
  633533
  603951
  634499
  620990
  812922
  453597
  463927
  473766
  476808
  486275
  521588
  529854
  648583
  401296
  678802
  628441
  800619
  809652
  718670
  790989
  395667
  612861
  565159
  544209
  566981
  678799
  667268
  699624
  645980
  636277
  779135
  800553
  786768
  812351
  744852
  770582
  752722
  761576
  735602
  742197
  747401
  753448
  741113
  760991
  720813
  817623
  664808
  657070
  706311
  722443
  544749
  791000
  771203
  741889
  712162
  718532
  396242
  566807
  722897
  799785
  388724
  805668
  400426
  456201
  472179
  539938
  565198
  574897
  598723
  598067
  603077
  463809
  491286
  523544
  443729
  566516
  671626
  696219
  649569
  716027
  598675
  596991
  605335
  620300
  810701
  775962
  758496
  741539
  740596
  630266
  721298
  721325
  487205
  540677
  571210
  696995
  603304
  624299
  722889
  401260
  395892
  807497
  455841
  482087
  536252
  461733
]
3.59 ms
(1.81%)
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
  388724
  395667
  395892
  396242
  400426
  401260
  401296
  401985
  426159
  443729
  453597
  455841
  456201
  458305
  461733
  463809
  463927
  472179
  473766
  476808
  482087
  486275
  487205
  491286
  521588
  523544
  529854
  536252
  539938
  540677
  544209
  544749
  556911
  565159
  565198
  566516
  566807
  566981
  571210
  574897
  587858
  596991
  597066
  597246
  598067
  598675
  598723
  603077
  603304
  603584
  603951
  605323
  605335
  612861
  614095
  620300
  620990
  623200
  624299
  628441
  629398
  630266
  633533
  634499
  636277
  645980
  648583
  649569
  657070
  664808
  667268
  671626
  676924
  678799
  678802
  696219
  696995
  699624
  706311
  712162
  716027
  718532
  718670
  720506
  720813
  721298
  721325
  722443
  722889
  722897
  735602
  740596
  741113
  741539
  741889
  742197
  744852
  747401
  752722
  753448
  758496
  760991
  761576
  770582
  771203
  775962
  779135
  786768
  790989
  791000
  799785
  800553
  800619
  805668
  807497
  809652
  810701
  812351
  812922
  817623
]
2.20 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young anal teen"
]
1.65 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young анал teen"
]
1.25 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young анал 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.