GET https://search.jues.net/search/embeds/2?q=girls%20have%20fun

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
256.70 ms
(89.27%)
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
  418833
  419579
  421833
  426511
  455771
  472297
  472941
  480719
  485155
  495217
  498730
  502819
  506782
  507584
  515171
  515357
  516335
  517269
  520730
  522284
  525995
  534296
  535655
  543334
  543567
  547919
  551119
  554303
  558714
  561457
  561907
  567242
  571832
  588992
  590872
  595870
  600352
  608041
  628282
  665207
  724330
  790794
]
11.01 ms
(3.83%)
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
  595870
  724330
  543567
  472297
  525995
  561457
  506782
  554303
  520730
  558714
  515357
  455771
  790794
  426511
  513476
  522284
  665207
  418833
  515171
  507584
  517269
  551119
  571832
  600352
  502819
  419579
  485155
  535655
  543334
  547919
  421833
  498730
  534296
  628282
  472941
  480719
  516335
  608041
  567242
  590872
  588992
  561907
  495217
]
9.85 ms
(3.43%)
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:
[
  "girls have fun"
  "girls have fun"
  "girls have fun"
  20
]
3.16 ms
(1.10%)
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
  418833
  419579
  421833
  426511
  455771
  472297
  472941
  480719
  485155
  495217
  498730
  502819
  506782
  507584
  515171
  515357
  516335
  517269
  520730
  522284
  525995
  534296
  535655
  543334
  543567
  547919
  551119
  554303
  558714
  561457
  561907
  567242
  571832
  588992
  590872
  595870
  600352
  608041
  628282
  665207
  724330
  790794
]
1.79 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls have fun"
]
1.75 ms
(0.61%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк have fun"
]
1.65 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк have fun"
]
1.64 ms
(0.57%)
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.