GET https://search.jues.net/search/embeds?q=%D1%82%D1%8F%D0%BD%D0%B5%D1%82

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
80.55 ms
(78.12%)
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
  33795
  390230
  403968
  428066
  442299
  452174
  459400
  464983
  473694
  480029
  490874
  499035
  500626
  507168
  511544
  518862
  520339
  539956
  539968
  540143
  554764
  569828
  570077
  584724
  593180
  607432
  619686
  625752
  648552
  650540
  676208
  700208
  701967
  709490
  723656
  726978
  730625
  730948
  731063
  744235
  756978
  760784
  790952
  800502
  815106
]
7.66 ms
(7.43%)
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
  619686
  815106
  730625
  33795
  648552
  730948
  726978
  760784
  700208
  723656
  744235
  790952
  709490
  500626
  539968
  569828
  390230
  464983
  701967
  539956
  650540
  676208
  800502
  756978
  428066
  459400
  403968
  554764
  442299
  480029
  540143
  607432
  625752
  731063
  518862
  499035
  507168
  473694
  511544
  520339
  570077
  452174
  490874
  584724
  593180
]
4.41 ms
(4.28%)
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:
[
  "тянет"
  "тянет"
  "тянет"
  20
]
2.72 ms
(2.64%)
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
  33795
  390230
  403968
  428066
  442299
  452174
  459400
  464983
  473694
  480029
  490874
  499035
  500626
  507168
  511544
  518862
  520339
  539956
  539968
  540143
  554764
  569828
  570077
  584724
  593180
  607432
  619686
  625752
  648552
  650540
  676208
  700208
  701967
  709490
  723656
  726978
  730625
  730948
  731063
  744235
  756978
  760784
  790952
  800502
  815106
]
2.19 ms
(2.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тянет"
]
2.03 ms
(1.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "тянет"
]
1.90 ms
(1.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "тянет"
]
1.64 ms
(1.59%)
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.