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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.08 ms
(86.24%)
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
  14967
  15162
  25053
  97401
  130054
  282265
  308542
  378035
  386271
  389640
  391086
  395423
  395578
  396334
  396507
  396699
  396728
  396732
  398317
  399378
  399722
  400642
  401153
  401930
  402574
  403195
  403197
  408443
  410096
  410311
  420231
  433762
  433990
  434701
  437118
  446198
  446897
  447507
  449679
  459668
  462222
  463818
  464147
  465575
  465652
  468469
  468704
  469001
  479844
  480137
  503423
  507219
  513126
  516426
  523573
  530272
  533370
  533374
  535793
  537661
  538773
  540301
  540305
  545801
  545803
  564392
  566300
  573927
  590794
  600995
  604341
  604466
  604510
  605449
  612182
  619780
  632562
  632618
  632635
  632707
  633451
  633458
  633755
  637021
  637501
  644059
  644246
  645276
  645990
  648809
  649187
  649857
  651209
  652683
  655113
  674043
  674945
  676097
  696204
  708923
  711685
  715371
  715682
  716892
  718934
  720030
  720306
  720872
  725599
  725622
  727597
  744248
  744601
  752683
  756106
  771649
  788402
  789516
  804756
  805307
]
16.10 ms
(8.41%)
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
  25053
  389640
  396507
  399378
  401153
  402574
  468469
  540301
  523573
  468704
  469001
  564392
  645990
  649857
  649187
  708923
  674043
  715371
  720306
  590794
  604466
  633755
  604510
  612182
  727597
  789516
  805307
  744601
  720030
  788402
  15162
  395578
  459668
  401930
  465652
  480137
  434701
  462222
  516426
  282265
  403195
  535793
  533374
  545803
  545801
  651209
  696204
  648809
  637021
  600995
  632618
  716892
  446198
  530272
  676097
  633458
  718934
  644246
  756106
  386271
  130054
  395423
  308542
  378035
  97401
  396699
  400642
  403197
  410311
  437118
  433762
  433990
  449679
  446897
  463818
  538773
  540305
  503423
  464147
  573927
  711685
  652683
  715682
  720872
  674945
  644059
  604341
  632562
  752683
  804756
  725599
  725622
  771649
  637501
  410096
  447507
  398317
  391086
  396732
  396334
  396728
  399722
  408443
  420231
  465575
  479844
  507219
  566300
  655113
  744248
  513126
  537661
  533370
  645276
  632707
  633451
  605449
  632635
  619780
  14967
]
2.50 ms
(1.31%)
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
  14967
  15162
  25053
  97401
  130054
  282265
  308542
  378035
  386271
  389640
  391086
  395423
  395578
  396334
  396507
  396699
  396728
  396732
  398317
  399378
  399722
  400642
  401153
  401930
  402574
  403195
  403197
  408443
  410096
  410311
  420231
  433762
  433990
  434701
  437118
  446198
  446897
  447507
  449679
  459668
  462222
  463818
  464147
  465575
  465652
  468469
  468704
  469001
  479844
  480137
  503423
  507219
  513126
  516426
  523573
  530272
  533370
  533374
  535793
  537661
  538773
  540301
  540305
  545801
  545803
  564392
  566300
  573927
  590794
  600995
  604341
  604466
  604510
  605449
  612182
  619780
  632562
  632618
  632635
  632707
  633451
  633458
  633755
  637021
  637501
  644059
  644246
  645276
  645990
  648809
  649187
  649857
  651209
  652683
  655113
  674043
  674945
  676097
  696204
  708923
  711685
  715371
  715682
  716892
  718934
  720030
  720306
  720872
  725599
  725622
  727597
  744248
  744601
  752683
  756106
  771649
  788402
  789516
  804756
  805307
]
2.20 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen and bbc"
]
2.11 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen bbc"
]
1.85 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.83%)
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.