GET https://search.jues.net/search/embeds?q=arab%20dildo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
50.05 ms
(58.15%)
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
  95673
  461086
  466316
  478985
  478986
  538567
  542578
  543002
  543061
  543444
  543893
  552473
  562342
  567597
  567600
  567604
  567826
  575011
  576925
  577062
  580848
  585964
  585999
  587951
  588387
  591578
  591669
  598310
  620047
  629806
  630081
  632304
  644219
  660008
  660807
  668461
  680428
  782334
  788819
  789497
  789518
  796049
  825366
  825404
]
19.60 ms
(22.78%)
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:
[
  "arab dildo"
  "arab dildo"
  "arab dildo"
  20
]
6.99 ms
(8.13%)
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
  580848
  660008
  478985
  567600
  543444
  789518
  789497
  567604
  629806
  825404
  543002
  552473
  478986
  680428
  587951
  825366
  543061
  567597
  660807
  782334
  577062
  644219
  95673
  461086
  543893
  598310
  466316
  575011
  630081
  796049
  585964
  591669
  788819
  538567
  576925
  588387
  620047
  591578
  585999
  542578
  562342
  567826
  632304
  668461
]
2.16 ms
(2.51%)
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
  95673
  461086
  466316
  478985
  478986
  538567
  542578
  543002
  543061
  543444
  543893
  552473
  562342
  567597
  567600
  567604
  567826
  575011
  576925
  577062
  580848
  585964
  585999
  587951
  588387
  591578
  591669
  598310
  620047
  629806
  630081
  632304
  644219
  660008
  660807
  668461
  680428
  782334
  788819
  789497
  789518
  796049
  825366
  825404
]
2.07 ms
(2.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "arab dildo"
]
1.83 ms
(2.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(2.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "араб дилд"
]
1.61 ms
(1.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.