GET https://search.jues.net/search/embeds/4?q=doggystyle%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
89.38 ms
(69.93%)
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
  382050
  385092
  406089
  410381
  423509
  424884
  427981
  428898
  429892
  437988
  444916
  451476
  452363
  453507
  458407
  470359
  471780
  471951
  472467
  485147
  487370
  489486
  492972
  493426
  495669
  500699
  505155
  511807
  514847
  516059
  516669
  520954
  523171
  523209
  523809
  549726
  569312
  601630
  603953
  617613
  618711
  620757
  621171
  627089
  663212
  675429
  675435
  675726
  697006
  788264
]
18.81 ms
(14.71%)
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:
[
  "doggystyle pussy"
  "doggystyle pussy"
  "doggystyle pussy"
  20
]
10.36 ms
(8.11%)
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
  428898
  429892
  505155
  489486
  385092
  382050
  424884
  458407
  470359
  495669
  516059
  516669
  549726
  569312
  675429
  697006
  618711
  621171
  471780
  437988
  423509
  453507
  492972
  511807
  523171
  627089
  523809
  444916
  523209
  788264
  451476
  472467
  471951
  493426
  427981
  500699
  514847
  663212
  675435
  410381
  452363
  487370
  406089
  675726
  485147
  520954
  603953
  617613
  601630
  620757
]
2.71 ms
(2.12%)
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
  382050
  385092
  406089
  410381
  423509
  424884
  427981
  428898
  429892
  437988
  444916
  451476
  452363
  453507
  458407
  470359
  471780
  471951
  472467
  485147
  487370
  489486
  492972
  493426
  495669
  500699
  505155
  511807
  514847
  516059
  516669
  520954
  523171
  523209
  523809
  549726
  569312
  601630
  603953
  617613
  618711
  620757
  621171
  627089
  663212
  675429
  675435
  675726
  697006
  788264
]
1.78 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggystyle pussy"
]
1.74 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "doggystyle pussy"
]
1.66 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "doggystyle pussy"
]

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.