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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
72.34 ms
(68.33%)
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
  437988
  444916
  447941
  448504
  451476
  452363
  453507
  458407
  467588
  470359
  471780
  471951
  472467
  485147
  487370
  489486
  492972
  493426
  500699
  505155
  511807
  514847
  516059
  516669
  520954
  523171
  523209
  523809
  549726
  569312
  601630
  603953
  617613
  620757
  621171
  627089
  644056
  675429
  675435
  675726
  697006
  788264
]
13.25 ms
(12.52%)
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:
[
  "pussy doggystyle"
  "pussy doggystyle"
  "pussy doggystyle"
  20
]
10.79 ms
(10.20%)
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
  644056
  447941
  448504
  467588
  428898
  505155
  489486
  385092
  382050
  424884
  458407
  470359
  516059
  516669
  549726
  569312
  675429
  697006
  621171
  471780
  437988
  423509
  453507
  492972
  511807
  523171
  627089
  523809
  444916
  523209
  788264
  451476
  472467
  471951
  493426
  427981
  500699
  514847
  675435
  410381
  452363
  487370
  406089
  675726
  485147
  520954
  603953
  617613
  601630
  620757
]
2.93 ms
(2.77%)
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
  437988
  444916
  447941
  448504
  451476
  452363
  453507
  458407
  467588
  470359
  471780
  471951
  472467
  485147
  487370
  489486
  492972
  493426
  500699
  505155
  511807
  514847
  516059
  516669
  520954
  523171
  523209
  523809
  549726
  569312
  601630
  603953
  617613
  620757
  621171
  627089
  644056
  675429
  675435
  675726
  697006
  788264
]
2.05 ms
(1.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy doggystyle"
]
1.61 ms
(1.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy doggystyle"
]
1.55 ms
(1.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy doggystyle"
]

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.