GET https://search.jues.net/search/embeds?q=reality%20kings%20%D0%B0%D0%BD%D0%B0%D0%BB

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.95 ms
(57.04%)
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:
[
  "reality kings анал"
  "reality kings анал"
  "reality kings анал"
  20
]
68.35 ms
(30.96%)
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
  398389
  409143
  420344
  426369
  427254
  444815
  452526
  454774
  464621
  469066
  487344
  491569
  513761
  556027
  556830
  568055
  580335
  591357
  591620
  603178
  607093
  626337
  659408
  699516
  718991
  721116
  721937
  738274
  742143
  747335
  748982
  751722
  758201
  761475
  775919
  776054
  787500
  787511
  792624
  800876
  804619
  811077
  811654
]
10.74 ms
(4.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
8.08 ms
(3.66%)
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
  811077
  748982
  721937
  603178
  556830
  738274
  747335
  469066
  659408
  591620
  556027
  811654
  775919
  758201
  718991
  721116
  751722
  699516
  591357
  761475
  776054
  800876
  804619
  742143
  792624
  513761
  626337
  491569
  787511
  452526
  398389
  464621
  607093
  409143
  427254
  787500
  454774
  444815
  420344
  580335
  426369
  568055
  487344
]
3.06 ms
(1.38%)
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
  398389
  409143
  420344
  426369
  427254
  444815
  452526
  454774
  464621
  469066
  487344
  491569
  513761
  556027
  556830
  568055
  580335
  591357
  591620
  603178
  607093
  626337
  659408
  699516
  718991
  721116
  721937
  738274
  742143
  747335
  748982
  751722
  758201
  761475
  775919
  776054
  787500
  787511
  792624
  800876
  804619
  811077
  811654
]
1.94 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "reality kings анал"
]
1.42 ms
(0.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "realitykings анал"
]
1.26 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "realitykings анал"
]

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.