GET https://search.jues.net/search/embeds/2?q=cute%20teen%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.23 ms
(58.91%)
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
  420700
  420804
  429155
  430366
  435398
  439151
  439301
  444204
  446986
  448572
  451695
  456397
  459334
  459339
  473738
  473838
  478514
  480207
  483478
  483737
  485297
  488797
  489067
  495163
  495550
  497690
  502630
  510573
  514986
  527832
  532370
  532442
  533917
  537319
  538354
  541409
  542706
  567334
  576951
  583027
  585826
  595572
  595646
  595871
  598504
  598616
  600242
  602268
  606076
  616013
  616315
  675378
  687318
  701292
  712433
  740407
  750426
  750637
  770382
  789002
  791385
]
27.56 ms
(23.12%)
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:
[
  "cute teen solo"
  "cute teen solo"
  "cute teen solo"
  20
]
11.38 ms
(9.54%)
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
  675378
  712433
  701292
  687318
  598504
  598616
  750637
  750426
  740407
  791385
  448572
  451695
  420700
  444204
  456397
  459334
  502630
  489067
  495550
  514986
  483478
  527832
  497690
  430366
  429155
  595572
  473838
  537319
  532442
  542706
  583027
  595646
  600242
  420804
  446986
  488797
  616013
  459339
  538354
  510573
  473738
  541409
  567334
  606076
  485297
  478514
  483737
  533917
  532370
  616315
  789002
  435398
  439151
  480207
  770382
  439301
  495163
  576951
  585826
  602268
  595871
]
2.78 ms
(2.33%)
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
  420700
  420804
  429155
  430366
  435398
  439151
  439301
  444204
  446986
  448572
  451695
  456397
  459334
  459339
  473738
  473838
  478514
  480207
  483478
  483737
  485297
  488797
  489067
  495163
  495550
  497690
  502630
  510573
  514986
  527832
  532370
  532442
  533917
  537319
  538354
  541409
  542706
  567334
  576951
  583027
  585826
  595572
  595646
  595871
  598504
  598616
  600242
  602268
  606076
  616013
  616315
  675378
  687318
  701292
  712433
  740407
  750426
  750637
  770382
  789002
  791385
]
2.37 ms
(1.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cute teen solo"
]
1.80 ms
(1.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cute teen соло"
]
1.37 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cute teen соло"
]

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.