GET https://search.jues.net/search/embeds?q=anal%20oops

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.36 ms
(44.98%)
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
  398820
  437724
  450669
  457451
  467982
  473325
  491232
  510926
  511542
  521205
  521210
  543764
  549178
  558738
  560969
  564252
  573357
  587988
  593768
  602706
  603057
  610589
  644738
  661556
  668370
  680275
  695912
  696923
  707540
  709873
  711699
  713927
  715887
  720157
  720192
  720737
  723167
  727576
  728373
  734314
  735685
  735696
  756392
  761495
  761496
  762328
  770292
  776968
  791318
  795523
  796164
  803255
  817279
  823830
  825557
]
68.24 ms
(43.62%)
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:
[
  "anal oops"
  "anal oops"
  "anal oops"
  20
]
8.51 ms
(5.44%)
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
  602706
  457451
  823830
  762328
  720737
  715887
  728373
  521210
  756392
  817279
  825557
  803255
  795523
  696923
  668370
  720192
  711699
  695912
  661556
  644738
  707540
  564252
  709873
  723167
  587988
  776968
  770292
  720157
  437724
  727576
  398820
  713927
  603057
  761496
  543764
  796164
  467982
  473325
  549178
  761495
  610589
  735696
  593768
  791318
  511542
  450669
  680275
  734314
  735685
  558738
  521205
  560969
  573357
  491232
  510926
]
2.69 ms
(1.72%)
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
  398820
  437724
  450669
  457451
  467982
  473325
  491232
  510926
  511542
  521205
  521210
  543764
  549178
  558738
  560969
  564252
  573357
  587988
  593768
  602706
  603057
  610589
  644738
  661556
  668370
  680275
  695912
  696923
  707540
  709873
  711699
  713927
  715887
  720157
  720192
  720737
  723167
  727576
  728373
  734314
  735685
  735696
  756392
  761495
  761496
  762328
  770292
  776968
  791318
  795523
  796164
  803255
  817279
  823830
  825557
]
1.92 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal oops"
]
1.69 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал oops"
]
1.56 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал oops"
]

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.