GET https://search.jues.net/search/embeds?q=actress%20porn

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
68.63 ms
(53.99%)
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
  439508
  467361
  478065
  479352
  483184
  511217
  512964
  521344
  521739
  522056
  524365
  540688
  545500
  554167
  562890
  568973
  570170
  586403
  586483
  603004
  603823
  605963
  613345
  623485
  649124
  673513
  698860
  713684
  723263
  726022
  743380
  744704
  750509
  750830
  750851
  757950
  759422
  766082
  766090
  766534
  768179
  773259
  777973
  781216
  785507
  789285
  790401
  790402
  794688
  812497
]
37.46 ms
(29.47%)
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:
[
  "actress porn"
  "actress porn"
  "actress porn"
  20
]
13.01 ms
(10.23%)
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
  766090
  790402
  757950
  781216
  766534
  789285
  613345
  766082
  554167
  790401
  723263
  673513
  570170
  773259
  768179
  726022
  649124
  713684
  750509
  777944
  605963
  785507
  794688
  759422
  812497
  750830
  750851
  777973
  603004
  545500
  603823
  467361
  743380
  698860
  439508
  521344
  512964
  586403
  623485
  511217
  586483
  479352
  483184
  524365
  568973
  744704
  562890
  522056
  540688
  478065
  521739
]
1.88 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "actress porn"
]
1.72 ms
(1.35%)
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
  439508
  467361
  478065
  479352
  483184
  511217
  512964
  521344
  521739
  522056
  524365
  540688
  545500
  554167
  562890
  568973
  570170
  586403
  586483
  603004
  603823
  605963
  613345
  623485
  649124
  673513
  698860
  713684
  723263
  726022
  743380
  744704
  750509
  750830
  750851
  757950
  759422
  766082
  766090
  766534
  768179
  773259
  777973
  781216
  785507
  789285
  790401
  790402
  794688
  812497
]
1.61 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "actress porn"
]
1.28 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "actress porn"
]

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.