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

Query Metrics

8 Database Queries
8 Different statements
113.28 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
55.21 ms
(48.74%)
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
  282010
  382190
  400936
  411320
  413944
  414344
  417787
  425351
  430786
  433747
  434001
  443476
  445733
  445751
  452139
  456120
  461624
  463842
  465613
  468009
  476120
  476143
  480420
  496900
  497885
  499817
  502890
  510270
  517743
  522147
  530625
  530637
  531230
  545614
  545698
  559389
  576717
  598026
  604478
  637003
  644262
  667748
  677296
  678109
  679803
  707391
]
37.68 ms
(33.27%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "bbc blonde teen"
  "bbc blonde teen"
  "bbc blonde teen"
  20
]
11.19 ms
(9.88%)
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
  430786
  456120
  476143
  445733
  468009
  678109
  679803
  480420
  461624
  411320
  445751
  510270
  677296
  413944
  433747
  531230
  502890
  465613
  476120
  443476
  452139
  497885
  496900
  463842
  530637
  400936
  414344
  530625
  559389
  644262
  434001
  425351
  499817
  282010
  417787
  522147
  545698
  382190
  517743
  667748
  707391
  598026
  637003
  576717
  545614
  604478
]
2.18 ms
(1.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc blonde teen"
]
2.06 ms
(1.82%)
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
  282010
  382190
  400936
  411320
  413944
  414344
  417787
  425351
  430786
  433747
  434001
  443476
  445733
  445751
  452139
  456120
  461624
  463842
  465613
  468009
  476120
  476143
  480420
  496900
  497885
  499817
  502890
  510270
  517743
  522147
  530625
  530637
  531230
  545614
  545698
  559389
  576717
  598026
  604478
  637003
  644262
  667748
  677296
  678109
  679803
  707391
]
1.84 ms
(1.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbc беловолосая teen"
]
1.40 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbc беловолосая 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.