GET https://search.jues.net/search/embeds?q=slow%20blowjob%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
72.96 ms
(68.28%)
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
  434411
  435922
  452423
  452709
  461245
  492162
  529255
  552545
  556553
  561389
  595226
  602998
  662370
  667169
  684093
  686200
  688190
  723293
  725055
  733918
  754861
  763758
  767606
  775224
  781441
  781625
  783191
  784682
  786939
  790504
  793983
  793993
  795800
  799060
  799873
  806251
  807671
  810027
  820641
  821495
]
16.71 ms
(15.64%)
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:
[
  "slow blowjob pov"
  "slow blowjob pov"
  "slow blowjob pov"
  20
]
7.37 ms
(6.90%)
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
  763758
  784682
  799873
  793983
  793993
  684093
  602998
  733918
  688190
  807671
  786939
  783191
  781625
  767606
  781441
  821495
  552545
  795800
  775224
  810027
  806251
  754861
  667169
  662370
  820641
  529255
  723293
  461245
  725055
  556553
  452423
  452709
  790504
  492162
  434411
  799060
  435922
  686200
  595226
  561389
]
2.64 ms
(2.47%)
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
  434411
  435922
  452423
  452709
  461245
  492162
  529255
  552545
  556553
  561389
  595226
  602998
  662370
  667169
  684093
  686200
  688190
  723293
  725055
  733918
  754861
  763758
  767606
  775224
  781441
  781625
  783191
  784682
  786939
  790504
  793983
  793993
  795800
  799060
  799873
  806251
  807671
  810027
  820641
  821495
]
2.03 ms
(1.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "slow минет оральн секс пов"
]
1.93 ms
(1.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "slow blowjob pov"
]
1.66 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "slow минет оральн секс пов"
]
1.56 ms
(1.46%)
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.