GET https://search.jues.net/search/embeds/4?q=old%20young%20porn

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
50.61 ms
(48.40%)
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
  395144
  427981
  428017
  434601
  443855
  445200
  448687
  449717
  452617
  457789
  462074
  465824
  470309
  470441
  482350
  484370
  484724
  492097
  492098
  497921
  507666
  507680
  511749
  517246
  518270
  518470
  521135
  524165
  524951
  528146
  538234
  538290
  540483
  540688
  544455
  562890
  566243
  575197
  577362
  598724
  609880
  619519
  621691
  623616
  624215
  645918
  659025
  718798
  810976
]
33.70 ms
(32.23%)
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:
[
  "old young porn"
  "old young porn"
  "old young porn"
  20
]
11.28 ms
(10.79%)
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
  428017
  448687
  449717
  562890
  718798
  810976
  462074
  445200
  452617
  518470
  577362
  598724
  623616
  621691
  427981
  518270
  538290
  395144
  492098
  528146
  484370
  566243
  659025
  465824
  511749
  538234
  575197
  624215
  609880
  517246
  492097
  507666
  540483
  524951
  540688
  544455
  470309
  482350
  443855
  457789
  484724
  470441
  645918
  524165
  507680
  619519
  521135
  497921
  434601
]
2.18 ms
(2.09%)
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
  395144
  427981
  428017
  434601
  443855
  445200
  448687
  449717
  452617
  457789
  462074
  465824
  470309
  470441
  482350
  484370
  484724
  492097
  492098
  497921
  507666
  507680
  511749
  517246
  518270
  518470
  521135
  524165
  524951
  528146
  538234
  538290
  540483
  540688
  544455
  562890
  566243
  575197
  577362
  598724
  609880
  619519
  621691
  623616
  624215
  645918
  659025
  718798
  810976
]
1.85 ms
(1.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old young porn"
]
1.67 ms
(1.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old young porn"
]
1.62 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old young 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.