GET https://search.jues.net/search/embeds/4?q=big%20ride%20riding

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
103.99 ms
(58.56%)
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
  419417
  426789
  438619
  450829
  451780
  458975
  459046
  461159
  463152
  467939
  480161
  495778
  504693
  505138
  510814
  512733
  513425
  514456
  520320
  521091
  524345
  525116
  525546
  531468
  535537
  552997
  562142
  567123
  567775
  571773
  580768
  585945
  586290
  590851
  593689
  596063
  597126
  604667
  606571
  614853
  615575
  618394
  624742
  634312
  638380
  641370
  641764
  681570
  681584
  758891
]
50.40 ms
(28.38%)
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:
[
  "big ride riding"
  "big ride riding"
  "big ride riding"
  20
]
11.38 ms
(6.41%)
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
  459046
  438619
  596063
  450829
  458975
  638380
  510814
  461159
  580768
  634312
  480161
  463152
  451780
  505138
  586290
  604667
  758891
  419417
  514456
  513425
  524345
  535537
  512733
  567123
  552997
  567775
  618394
  585945
  615575
  641764
  525546
  467939
  562142
  641370
  521091
  681570
  426789
  520320
  495778
  531468
  624742
  681584
  571773
  606571
  597126
  590851
  525116
  614853
  504693
  593689
]
4.13 ms
(2.33%)
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
  419417
  426789
  438619
  450829
  451780
  458975
  459046
  461159
  463152
  467939
  480161
  495778
  504693
  505138
  510814
  512733
  513425
  514456
  520320
  521091
  524345
  525116
  525546
  531468
  535537
  552997
  562142
  567123
  567775
  571773
  580768
  585945
  586290
  590851
  593689
  596063
  597126
  604667
  606571
  614853
  615575
  618394
  624742
  634312
  638380
  641370
  641764
  681570
  681584
  758891
]
2.18 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ride riding"
]
1.97 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие ride riding"
]
1.84 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие ride riding"
]
1.70 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.