GET https://search.jues.net/search/embeds?q=face%20sleeping

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
75.02 ms
(68.63%)
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
  385655
  434590
  435020
  440702
  457684
  464721
  474984
  475404
  488159
  497818
  501259
  514775
  517123
  525085
  525144
  531407
  544234
  553650
  560195
  564647
  567008
  572713
  579867
  585767
  595361
  597491
  601988
  609814
  612507
  613150
  614793
  622412
  623815
  668472
  674590
  701200
  714327
  740171
  758197
  762970
  769789
  780469
  783612
  793530
  796214
  801157
  817989
  825058
  827370
  827578
]
13.26 ms
(12.13%)
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
  817989
  780469
  825058
  674590
  714327
  793530
  385655
  613150
  740171
  827578
  514775
  572713
  762970
  701200
  567008
  622412
  614793
  783612
  796214
  758197
  827370
  769789
  457684
  544234
  440702
  488159
  801157
  525144
  579867
  595361
  623815
  434590
  435020
  474984
  525085
  585767
  601988
  464721
  497818
  668472
  609814
  612507
  475404
  517123
  553650
  531407
  564647
  560195
  597491
  501259
]
11.34 ms
(10.37%)
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:
[
  "face sleeping"
  "face sleeping"
  "face sleeping"
  20
]
2.14 ms
(1.96%)
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
  385655
  434590
  435020
  440702
  457684
  464721
  474984
  475404
  488159
  497818
  501259
  514775
  517123
  525085
  525144
  531407
  544234
  553650
  560195
  564647
  567008
  572713
  579867
  585767
  595361
  597491
  601988
  609814
  612507
  613150
  614793
  622412
  623815
  668472
  674590
  701200
  714327
  740171
  758197
  762970
  769789
  780469
  783612
  793530
  796214
  801157
  817989
  825058
  827370
  827578
]
2.14 ms
(1.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "face sleeping"
]
2.08 ms
(1.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "face спящ"
]
1.45 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "face спящ"
]

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.