GET https://search.jues.net/search/embeds?q=mature%20home%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.91 ms
(53.35%)
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
  396934
  421835
  421873
  421895
  432650
  433359
  439710
  439808
  440889
  440893
  440980
  452179
  459513
  459956
  460581
  462351
  465324
  465907
  466723
  468984
  470720
  472955
  472958
  475163
  477692
  478365
  481986
  483841
  505022
  506404
  524651
  527989
  529338
  530863
  531439
  531962
  540779
  544202
  545914
  549754
  556816
  557924
  586591
  588916
  601444
  670720
  682348
  740646
  775543
  777750
  788945
  789496
  790926
  791572
  795901
  796610
  796804
  802778
  821899
  823578
  823757
]
50.55 ms
(34.18%)
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:
[
  "mature home pov"
  "mature home pov"
  "mature home pov"
  20
]
9.47 ms
(6.40%)
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
  396934
  823578
  795901
  775543
  796610
  459513
  823757
  481986
  670720
  531962
  506404
  789496
  821899
  477692
  460581
  788945
  791572
  790926
  740646
  439808
  466723
  588916
  470720
  777750
  802778
  468984
  529338
  478365
  433359
  439710
  440889
  432650
  557924
  556816
  465907
  421873
  483841
  465324
  462351
  440893
  530863
  545914
  682348
  601444
  440980
  421835
  459956
  549754
  524651
  475163
  505022
  472958
  421895
  452179
  472955
  531439
  796804
  540779
  527989
  544202
  586591
]
2.25 ms
(1.52%)
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
  396934
  421835
  421873
  421895
  432650
  433359
  439710
  439808
  440889
  440893
  440980
  452179
  459513
  459956
  460581
  462351
  465324
  465907
  466723
  468984
  470720
  472955
  472958
  475163
  477692
  478365
  481986
  483841
  505022
  506404
  524651
  527989
  529338
  530863
  531439
  531962
  540779
  544202
  545914
  549754
  556816
  557924
  586591
  588916
  601444
  670720
  682348
  740646
  775543
  777750
  788945
  789496
  790926
  791572
  795901
  796610
  796804
  802778
  821899
  823578
  823757
]
1.93 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature home pov"
]
1.78 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature home пов"
]
1.44 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature home пов"
]

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.