GET https://search.jues.net/search/embeds/4?q=teacher%20big%20boobs

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
55.47 ms
(57.54%)
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
  409886
  430451
  432531
  451639
  455923
  462606
  462999
  465353
  465524
  466151
  476588
  478981
  486581
  486963
  489373
  503967
  506142
  512384
  518940
  520800
  527442
  530513
  531431
  534316
  535022
  542051
  549244
  556027
  560197
  561936
  563884
  586590
  589573
  590288
  601324
  602668
  603629
  604003
  607630
  615929
  621317
  623365
  630766
  633130
]
24.19 ms
(25.09%)
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:
[
  "teacher big boobs"
  "teacher big boobs"
  "teacher big boobs"
  20
]
7.63 ms
(7.91%)
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
  520800
  603629
  462999
  489373
  549244
  589573
  602668
  630766
  432531
  451639
  486581
  409886
  615929
  586590
  633130
  455923
  465353
  527442
  478981
  506142
  534316
  535022
  518940
  462606
  590288
  430451
  531431
  503967
  465524
  556027
  476588
  466151
  486963
  607630
  530513
  542051
  563884
  621317
  512384
  623365
  604003
  560197
  561936
  601324
]
2.49 ms
(2.59%)
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
  409886
  430451
  432531
  451639
  455923
  462606
  462999
  465353
  465524
  466151
  476588
  478981
  486581
  486963
  489373
  503967
  506142
  512384
  518940
  520800
  527442
  530513
  531431
  534316
  535022
  542051
  549244
  556027
  560197
  561936
  563884
  586590
  589573
  590288
  601324
  602668
  603629
  604003
  607630
  615929
  621317
  623365
  630766
  633130
]
1.94 ms
(2.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teacher большие boobs"
]
1.63 ms
(1.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teacher большие boobs"
]
1.54 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teacher big boobs"
]
1.52 ms
(1.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.