GET https://search.jues.net/search/embeds?q=ejaculation%20teens

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.10 ms
(68.42%)
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
  388202
  402997
  441877
  453947
  475467
  504908
  507800
  524788
  525541
  529683
  530237
  531600
  533762
  537174
  547373
  550724
  588176
  588503
  621521
  624834
  628950
  633228
  635424
  638680
  648195
  682911
  696299
  701447
  701448
  707611
  717222
  721593
  724938
  726131
  730161
  730676
  730972
  735520
  736725
  737525
  738618
  739500
  739567
  750413
  762578
  767441
  769215
  774157
  792827
  799309
  826461
  826667
]
8.87 ms
(9.93%)
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:
[
  "ejaculation teens"
  "ejaculation teens"
  "ejaculation teens"
  20
]
8.59 ms
(9.62%)
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
  826667
  621521
  730161
  547373
  769215
  792827
  682911
  635424
  588503
  628950
  736725
  726131
  633228
  826461
  550724
  696299
  721593
  638680
  730972
  724938
  762578
  737525
  648195
  701447
  730676
  735520
  774157
  739567
  529683
  738618
  767441
  531600
  701448
  588176
  799309
  717222
  453947
  530237
  707611
  750413
  533762
  388202
  441877
  475467
  739500
  525541
  524788
  402997
  507800
  537174
  624834
  504908
]
2.52 ms
(2.82%)
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
  388202
  402997
  441877
  453947
  475467
  504908
  507800
  524788
  525541
  529683
  530237
  531600
  533762
  537174
  547373
  550724
  588176
  588503
  621521
  624834
  628950
  633228
  635424
  638680
  648195
  682911
  696299
  701447
  701448
  707611
  717222
  721593
  724938
  726131
  730161
  730676
  730972
  735520
  736725
  737525
  738618
  739500
  739567
  750413
  762578
  767441
  769215
  774157
  792827
  799309
  826461
  826667
]
2.41 ms
(2.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ejaculation teens"
]
2.20 ms
(2.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ejaculation teens"
]
1.99 ms
(2.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "ejaculation teens"
]
1.62 ms
(1.82%)
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.