GET https://search.jues.net/search/embeds/3?q=big%20pants

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
238.52 ms
(73.26%)
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 pants"
  "big pants"
  "big pants"
  20
]
68.84 ms
(21.14%)
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
  418361
  424254
  439783
  440623
  444617
  449499
  453723
  459016
  463544
  463561
  463597
  481362
  481925
  482622
  483039
  493019
  498033
  500506
  506590
  509712
  509747
  510194
  516496
  516874
  516991
  522105
  524753
  529306
  533965
  546320
  555832
  560505
  565013
  577931
  580223
  581730
  592619
  598763
  600466
  615679
  659407
  666438
  675703
  675725
  714380
  761136
]
8.84 ms
(2.71%)
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
  516496
  546320
  560505
  581730
  675703
  592619
  615679
  761136
  449499
  493019
  424254
  463544
  463561
  481925
  509747
  463597
  481362
  500506
  529306
  555832
  459016
  483039
  524753
  533965
  444617
  498033
  541345
  714380
  675725
  598763
  600466
  439783
  580223
  516874
  453723
  510194
  516991
  440623
  565013
  659407
  506590
  418361
  522105
  482622
  509712
  666438
  577931
]
2.44 ms
(0.75%)
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
  418361
  424254
  439783
  440623
  444617
  449499
  453723
  459016
  463544
  463561
  463597
  481362
  481925
  482622
  483039
  493019
  498033
  500506
  506590
  509712
  509747
  510194
  516496
  516874
  516991
  522105
  524753
  529306
  533965
  546320
  555832
  560505
  565013
  577931
  580223
  581730
  592619
  598763
  600466
  615679
  659407
  666438
  675703
  675725
  714380
  761136
]
1.87 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big pants"
]
1.83 ms
(0.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие pants"
]
1.70 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие pants"
]

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.