GET https://search.jues.net/search/embeds/2?q=teen%20redhead%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.00 ms
(54.90%)
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
  413432
  417674
  432288
  432363
  439960
  441027
  449173
  450357
  452436
  453583
  463689
  466624
  469054
  484533
  497696
  502559
  508564
  529001
  534839
  541442
  545702
  550942
  558324
  579677
  580174
  587143
  594283
  594534
  595517
  595588
  607549
  610193
  616315
  620731
  620891
  623333
  657467
  666355
  674177
  683446
  695464
  708202
  714305
  744947
  749243
  749694
  750121
  750756
  751428
  757566
  765628
  767103
  782512
  803120
  805033
  806583
  816094
  819862
]
37.51 ms
(29.00%)
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:
[
  "teen redhead solo"
  "teen redhead solo"
  "teen redhead solo"
  20
]
10.84 ms
(8.38%)
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
  594283
  803120
  749694
  529001
  502559
  439960
  450357
  819862
  508564
  558324
  657467
  674177
  714305
  695464
  708202
  595517
  610193
  594534
  782512
  757566
  767103
  750756
  749243
  806583
  466624
  595588
  413432
  816094
  469054
  484533
  550942
  545702
  620891
  587143
  607549
  805033
  751428
  765628
  744947
  449173
  534839
  580174
  666355
  623333
  750121
  620731
  441027
  497696
  541442
  616315
  432363
  463689
  452436
  453583
  579677
  683446
  432288
  417674
]
2.62 ms
(2.02%)
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
  413432
  417674
  432288
  432363
  439960
  441027
  449173
  450357
  452436
  453583
  463689
  466624
  469054
  484533
  497696
  502559
  508564
  529001
  534839
  541442
  545702
  550942
  558324
  579677
  580174
  587143
  594283
  594534
  595517
  595588
  607549
  610193
  616315
  620731
  620891
  623333
  657467
  666355
  674177
  683446
  695464
  708202
  714305
  744947
  749243
  749694
  750121
  750756
  751428
  757566
  765628
  767103
  782512
  803120
  805033
  806583
  816094
  819862
]
2.07 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen redhead solo"
]
1.81 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen рыжая соло"
]
1.79 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen рыжая соло"
]
1.69 ms
(1.31%)
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.