GET https://search.jues.net/search/embeds/2?q=anal%20black%20dildo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
102.56 ms
(46.05%)
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 black dildo"
  "anal black dildo"
  "anal black dildo"
  20
]
99.19 ms
(44.54%)
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
  402876
  417441
  420116
  439301
  444924
  445738
  455898
  460328
  467568
  468012
  471035
  492064
  498830
  510394
  512447
  521089
  522284
  529202
  530483
  532760
  533746
  533928
  534381
  536645
  537203
  539232
  545611
  566786
  571194
  592046
  604387
  617420
  617422
  628082
  631193
  632635
  634780
  637121
  637123
  639335
  639716
  639798
  643112
  646771
  647972
  666865
  674983
  810822
  810832
]
10.38 ms
(4.66%)
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
  420116
  417441
  460328
  592046
  639798
  639716
  492064
  604387
  467568
  532760
  533928
  666865
  471035
  639335
  536645
  628082
  545611
  810822
  647972
  455898
  634780
  643112
  810832
  530483
  534381
  522284
  468012
  533746
  646771
  571194
  631193
  510394
  521089
  537203
  637121
  402876
  566786
  444924
  539232
  632635
  617422
  617420
  674983
  445738
  529202
  637123
  498830
  439301
  512447
]
3.12 ms
(1.40%)
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
  402876
  417441
  420116
  439301
  444924
  445738
  455898
  460328
  467568
  468012
  471035
  492064
  498830
  510394
  512447
  521089
  522284
  529202
  530483
  532760
  533746
  533928
  534381
  536645
  537203
  539232
  545611
  566786
  571194
  592046
  604387
  617420
  617422
  628082
  631193
  632635
  634780
  637121
  637123
  639335
  639716
  639798
  643112
  646771
  647972
  666865
  674983
  810822
  810832
]
2.06 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal black dildo"
]
1.99 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал black дилд"
]
1.63 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал black дилд"
]

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.