GET https://search.jues.net/search/embeds/2?q=stranger%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
85.26 ms
(46.39%)
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
  415784
  415785
  424237
  425473
  427087
  428142
  445733
  447045
  448121
  448215
  451850
  455207
  456687
  458244
  465447
  476430
  476937
  480069
  481419
  483636
  484924
  485320
  491689
  499805
  500904
  502250
  502253
  515777
  516756
  517881
  521581
  521916
  524706
  532499
  544668
  545537
  550680
  589786
  590460
  600302
  609516
  609568
  610311
  621267
  673325
  733239
  752148
  770225
  782533
  783987
  796523
]
76.24 ms
(41.48%)
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:
[
  "stranger anal"
  "stranger anal"
  "stranger anal"
  20
]
11.87 ms
(6.46%)
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
  428142
  609516
  609568
  600302
  476937
  521916
  445733
  424237
  476430
  491689
  752148
  782533
  448121
  550680
  610311
  481419
  425473
  415785
  483636
  456687
  502253
  499805
  415784
  448215
  502250
  485320
  465447
  590460
  770225
  427087
  621267
  480069
  783987
  796523
  532499
  545537
  544668
  589786
  447045
  521581
  673325
  733239
  515777
  484924
  500904
  455207
  458244
  516756
  524706
  451850
  517881
]
2.99 ms
(1.63%)
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
  415784
  415785
  424237
  425473
  427087
  428142
  445733
  447045
  448121
  448215
  451850
  455207
  456687
  458244
  465447
  476430
  476937
  480069
  481419
  483636
  484924
  485320
  491689
  499805
  500904
  502250
  502253
  515777
  516756
  517881
  521581
  521916
  524706
  532499
  544668
  545537
  550680
  589786
  590460
  600302
  609516
  609568
  610311
  621267
  673325
  733239
  752148
  770225
  782533
  783987
  796523
]
1.96 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "stranger anal"
]
1.80 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "stranger анал"
]
1.78 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "stranger анал"
]

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.