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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
94.89 ms
(60.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
  419455
  429026
  434576
  435171
  435355
  443219
  450599
  451654
  452923
  461088
  463426
  483583
  485297
  493849
  502630
  505317
  505328
  510170
  514845
  514986
  516568
  516603
  518227
  519760
  523393
  527922
  530950
  538977
  544404
  544990
  545442
  548157
  548167
  548966
  563325
  563368
  568111
  576170
  584351
  586810
  588228
  590702
  594053
  597545
  597750
  598503
  598756
  602255
  604056
  611172
  624271
  627420
  642022
  661421
  684906
  738625
  777847
  787438
  788524
  806668
]
41.37 ms
(26.59%)
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:
[
  "solo wet teen"
  "solo wet teen"
  "solo wet teen"
  20
]
9.38 ms
(6.03%)
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
  576170
  661421
  568111
  594053
  598503
  590702
  604056
  777847
  787438
  788524
  434576
  429026
  502630
  514845
  514986
  523393
  505328
  452923
  451654
  530950
  510170
  516568
  538977
  516603
  548157
  544404
  544990
  548966
  548167
  563325
  563368
  586810
  597545
  611172
  627420
  738625
  602255
  624271
  419455
  435355
  435171
  461088
  493849
  505317
  483583
  527922
  584351
  684906
  806668
  450599
  463426
  485297
  545442
  588228
  597750
  642022
  443219
  518227
  598756
  519760
]
3.04 ms
(1.96%)
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
  419455
  429026
  434576
  435171
  435355
  443219
  450599
  451654
  452923
  461088
  463426
  483583
  485297
  493849
  502630
  505317
  505328
  510170
  514845
  514986
  516568
  516603
  518227
  519760
  523393
  527922
  530950
  538977
  544404
  544990
  545442
  548157
  548167
  548966
  563325
  563368
  568111
  576170
  584351
  586810
  588228
  590702
  594053
  597545
  597750
  598503
  598756
  602255
  604056
  611172
  624271
  627420
  642022
  661421
  684906
  738625
  777847
  787438
  788524
  806668
]
1.90 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo wet teen"
]
1.72 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло мокрые teen"
]
1.65 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло мокрые teen"
]
1.63 ms
(1.05%)
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.