GET https://search.jues.net/search/embeds?q=cuckold%20hunter

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
80.81 ms
(70.81%)
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
  467289
  475997
  476501
  482697
  487020
  488219
  495915
  497996
  500469
  501875
  508766
  508804
  508823
  511685
  556312
  573359
  578078
  578080
  578086
  578118
  582356
  594779
  596417
  607195
  611880
  704852
  704864
  704878
  704900
  725889
  725950
  725955
  725975
  727351
  727355
  727367
  727376
  729587
  729589
  729593
  729601
  731720
  731723
  731724
  731735
  731736
  731738
  731743
  731748
  757990
  819571
]
13.88 ms
(12.16%)
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:
[
  "cuckold hunter"
  "cuckold hunter"
  "cuckold hunter"
  20
]
9.23 ms
(8.09%)
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
  731735
  704864
  757990
  725955
  727367
  731720
  731738
  729587
  727351
  729601
  725975
  729593
  508823
  727355
  731748
  725889
  729589
  727376
  731724
  482697
  704878
  582356
  725950
  731743
  467289
  476501
  475997
  578086
  573359
  704852
  704900
  731736
  578078
  578080
  731723
  487020
  511685
  501875
  819571
  578118
  556312
  594779
  508766
  495915
  611880
  508804
  497996
  488219
  500469
  596417
  607195
]
2.90 ms
(2.54%)
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
  467289
  475997
  476501
  482697
  487020
  488219
  495915
  497996
  500469
  501875
  508766
  508804
  508823
  511685
  556312
  573359
  578078
  578080
  578086
  578118
  582356
  594779
  596417
  607195
  611880
  704852
  704864
  704878
  704900
  725889
  725950
  725955
  725975
  727351
  727355
  727367
  727376
  729587
  729589
  729593
  729601
  731720
  731723
  731724
  731735
  731736
  731738
  731743
  731748
  757990
  819571
]
2.15 ms
(1.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cuckold hunter"
]
1.78 ms
(1.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куколд hunter"
]
1.77 ms
(1.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куколд hunter"
]

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.