GET https://search.jues.net/search/embeds?q=female%20domina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
69.61 ms
(77.14%)
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
  392978
  440711
  444027
  448059
  451304
  464957
  484218
  486695
  499182
  501228
  503632
  521233
  525193
  525439
  540360
  548575
  550063
  552372
  556844
  560281
  572011
  573230
  588265
  598105
  638956
  679245
  716135
  718107
  718232
  720130
  735493
  735504
  750622
  760511
  778655
  782776
  785484
  787983
  788867
  801593
  811264
  811508
  814964
  820142
]
7.07 ms
(7.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
  588265
  598105
  820142
  782776
  788867
  787983
  801593
  735504
  785484
  811508
  720130
  718107
  716135
  778655
  484218
  638956
  718232
  814964
  735493
  521233
  540360
  760511
  811264
  750622
  392978
  448059
  548575
  679245
  556844
  440711
  486695
  525193
  503632
  560281
  573230
  572011
  444027
  525439
  552372
  451304
  550063
  501228
  464957
  499182
]
4.16 ms
(4.62%)
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:
[
  "female domina"
  "female domina"
  "female domina"
  20
]
3.06 ms
(3.39%)
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
  392978
  440711
  444027
  448059
  451304
  464957
  484218
  486695
  499182
  501228
  503632
  521233
  525193
  525439
  540360
  548575
  550063
  552372
  556844
  560281
  572011
  573230
  588265
  598105
  638956
  679245
  716135
  718107
  718232
  720130
  735493
  735504
  750622
  760511
  778655
  782776
  785484
  787983
  788867
  801593
  811264
  811508
  814964
  820142
]
1.86 ms
(2.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "female domina"
]
1.49 ms
(1.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "female доминирован"
]
1.26 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "female доминирован"
]

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.