GET https://search.jues.net/search/embeds?q=tall%20casting

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
68.56 ms
(65.21%)
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
  4169
  414344
  417469
  422565
  445279
  446033
  452245
  453551
  457077
  468498
  469619
  473925
  474393
  474714
  480373
  485175
  494786
  501529
  504335
  527779
  529794
  530384
  538473
  578234
  580185
  580646
  598116
  606714
  622938
  630887
  633120
  642012
  642662
  643112
  680200
  703833
  720434
  737734
  738295
  784276
  800224
]
13.73 ms
(13.06%)
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:
[
  "tall casting"
  "tall casting"
  "tall casting"
  20
]
11.36 ms
(10.81%)
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
  800224
  738295
  4169
  598116
  737734
  417469
  784276
  445279
  474393
  468498
  606714
  642012
  504335
  720434
  633120
  580185
  446033
  453551
  578234
  630887
  469619
  485175
  527779
  473925
  452245
  474714
  457077
  422565
  501529
  643112
  480373
  414344
  530384
  680200
  703833
  538473
  580646
  494786
  622938
  529794
  642662
]
3.02 ms
(2.87%)
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
  4169
  414344
  417469
  422565
  445279
  446033
  452245
  453551
  457077
  468498
  469619
  473925
  474393
  474714
  480373
  485175
  494786
  501529
  504335
  527779
  529794
  530384
  538473
  578234
  580185
  580646
  598116
  606714
  622938
  630887
  633120
  642012
  642662
  643112
  680200
  703833
  720434
  737734
  738295
  784276
  800224
]
2.38 ms
(2.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tall casting"
]
2.33 ms
(2.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "высокие кастинг"
]
2.07 ms
(1.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "высокие кастинг"
]
1.69 ms
(1.61%)
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.