GET https://search.jues.net/search/embeds?q=pov%20young%20creampie

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.36 ms
(60.18%)
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
  417238
  417949
  418640
  418646
  418684
  419095
  419277
  422380
  428933
  429500
  432732
  435236
  443357
  448981
  454378
  456477
  458985
  459378
  461323
  461598
  461751
  461859
  468814
  509312
  509324
  509325
  520826
  526155
  526819
  533278
  541068
  549080
  569146
  584111
  584779
  585668
  588818
  595925
  598646
  608425
  608765
  631607
  651977
  680251
  718614
  776521
  795836
  805184
  808239
  826182
]
21.07 ms
(21.01%)
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:
[
  "pov young creampie"
  "pov young creampie"
  "pov young creampie"
  20
]
9.10 ms
(9.07%)
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
  718614
  595925
  418646
  417238
  418640
  651977
  608425
  608765
  795836
  461751
  419277
  680251
  429500
  461859
  549080
  805184
  417949
  631607
  428933
  459378
  826182
  456477
  541068
  808239
  418684
  458985
  432732
  461323
  526155
  584111
  776521
  419095
  509325
  435236
  598646
  468814
  454378
  569146
  448981
  461598
  533278
  584779
  422380
  509324
  443357
  526819
  509312
  588818
  520826
  585668
]
2.62 ms
(2.61%)
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
  417238
  417949
  418640
  418646
  418684
  419095
  419277
  422380
  428933
  429500
  432732
  435236
  443357
  448981
  454378
  456477
  458985
  459378
  461323
  461598
  461751
  461859
  468814
  509312
  509324
  509325
  520826
  526155
  526819
  533278
  541068
  549080
  569146
  584111
  584779
  585668
  588818
  595925
  598646
  608425
  608765
  631607
  651977
  680251
  718614
  776521
  795836
  805184
  808239
  826182
]
2.08 ms
(2.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov young creampie"
]
1.81 ms
(1.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов young creampie"
]
1.77 ms
(1.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов young creampie"
]

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.