GET https://search.jues.net/search/embeds?q=keisha%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.48 ms
(48.20%)
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
  383089
  383633
  388886
  391015
  391134
  395639
  396686
  396697
  399415
  402546
  405014
  405028
  405088
  405105
  405287
  409452
  414301
  415112
  416355
  422328
  425910
  429909
  440694
  444455
  445581
  449115
  475931
  477744
  491712
  495400
  495401
  517836
  525246
  534212
  562002
  574298
  575890
  582810
  594237
  645322
  663566
  804101
  807952
  808408
  808418
  815762
  818715
  820472
  820576
  821013
  821176
  825304
]
49.00 ms
(36.63%)
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:
[
  "keisha sex"
  "keisha sex"
  "keisha sex"
  20
]
9.71 ms
(7.26%)
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
  416355
  804101
  582810
  807952
  808418
  444455
  808408
  645322
  383633
  422328
  594237
  405105
  562002
  534212
  475931
  574298
  477744
  575890
  820576
  818715
  821013
  820472
  517836
  821176
  409452
  396697
  815762
  440694
  405014
  383089
  825304
  388886
  399415
  663566
  391134
  405088
  391015
  396686
  491712
  402546
  395639
  445581
  429909
  525246
  425910
  495401
  405028
  415112
  449115
  414301
  495400
  405287
]
2.63 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
  383089
  383633
  388886
  391015
  391134
  395639
  396686
  396697
  399415
  402546
  405014
  405028
  405088
  405105
  405287
  409452
  414301
  415112
  416355
  422328
  425910
  429909
  440694
  444455
  445581
  449115
  475931
  477744
  491712
  495400
  495401
  517836
  525246
  534212
  562002
  574298
  575890
  582810
  594237
  645322
  663566
  804101
  807952
  808408
  808418
  815762
  818715
  820472
  820576
  821013
  821176
  825304
]
2.36 ms
(1.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "keisha sex"
]
2.05 ms
(1.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "keisha секс"
]
1.72 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "keisha секс"
]

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.