GET https://search.jues.net/search/embeds?q=all%20over%2030

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
63.81 ms
(73.20%)
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
  383390
  396313
  400093
  403042
  416998
  417456
  418449
  422515
  444579
  464456
  464460
  482999
  483134
  491255
  495396
  505288
  515750
  520232
  534376
  537849
  551013
  567432
  568507
  589553
  596360
  604811
  606508
  684177
  718708
  726446
  729731
  730317
  731939
  747839
  753815
  781308
  786715
  798980
  804192
  804464
  807536
  814128
  818072
  820003
  828219
]
8.23 ms
(9.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
  551013
  729731
  828219
  798980
  820003
  753815
  781308
  807536
  684177
  730317
  403042
  814128
  464456
  537849
  718708
  786715
  747839
  804192
  396313
  818072
  515750
  726446
  400093
  418449
  444579
  417456
  482999
  464460
  731939
  383390
  491255
  495396
  567432
  568507
  604811
  596360
  483134
  422515
  589553
  505288
  606508
  804464
  416998
  520232
  534376
]
5.45 ms
(6.25%)
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:
[
  "all over 30"
  "all over 30"
  "all over 30"
  20
]
2.53 ms
(2.90%)
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
  383390
  396313
  400093
  403042
  416998
  417456
  418449
  422515
  444579
  464456
  464460
  482999
  483134
  491255
  495396
  505288
  515750
  520232
  534376
  537849
  551013
  567432
  568507
  589553
  596360
  604811
  606508
  684177
  718708
  726446
  729731
  730317
  731939
  747839
  753815
  781308
  786715
  798980
  804192
  804464
  807536
  814128
  818072
  820003
  828219
]
2.12 ms
(2.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "all over 30"
]
1.81 ms
(2.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "all over 30"
]
1.63 ms
(1.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "all over 30"
]

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.