GET https://search.jues.net/search/embeds?q=a%20wife%20katy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.30 ms
(60.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
  476765
  479286
  498936
  498937
  503653
  506253
  508419
  529113
  535937
  563334
  577343
  581571
  584636
  584637
  584644
  584646
  616012
  636264
  659204
  686368
  693284
  731376
  757598
  757602
  772714
  777035
  777870
  779949
  788335
  791067
  804926
  805209
  807310
  809906
  814971
  814985
  814986
  814990
  814995
  816118
  819259
  819262
  819267
  819268
  819270
  819960
  825700
  825872
  826016
  826414
  827534
]
19.57 ms
(19.56%)
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:
[
  "a wife katy"
  "a wife katy"
  "a wife katy"
  20
]
9.32 ms
(9.32%)
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
  779949
  777035
  757598
  757602
  791067
  731376
  563334
  476765
  503653
  616012
  659204
  498936
  479286
  636264
  508419
  506253
  498937
  804926
  535937
  581571
  584646
  577343
  772714
  814990
  807310
  814986
  814985
  529113
  809906
  814995
  814971
  826016
  584644
  819960
  825872
  826414
  819259
  805209
  827534
  819262
  819267
  686368
  819270
  819268
  825700
  816118
  788335
  693284
  777870
  584636
  584637
]
2.81 ms
(2.81%)
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
  476765
  479286
  498936
  498937
  503653
  506253
  508419
  529113
  535937
  563334
  577343
  581571
  584636
  584637
  584644
  584646
  616012
  636264
  659204
  686368
  693284
  731376
  757598
  757602
  772714
  777035
  777870
  779949
  788335
  791067
  804926
  805209
  807310
  809906
  814971
  814985
  814986
  814990
  814995
  816118
  819259
  819262
  819267
  819268
  819270
  819960
  825700
  825872
  826016
  826414
  827534
]
2.37 ms
(2.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "a wife katy"
]
2.01 ms
(2.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен katy"
]
1.91 ms
(1.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен katy"
]

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.