GET https://search.jues.net/search/embeds?q=pawg%20anal%20beautiful

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.22 ms
(46.92%)
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
  382670
  393848
  401742
  401927
  402715
  402723
  402834
  402905
  403986
  413836
  419308
  420530
  420793
  421519
  421743
  426475
  445536
  455085
  455411
  464861
  469568
  471148
  475000
  482751
  494492
  503406
  508542
  517405
  535611
  542544
  545836
  558821
  559952
  579701
  596196
  609839
  629510
  649970
  650488
  661298
  717869
  772809
  776964
  777055
]
52.21 ms
(40.01%)
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:
[
  "pawg anal beautiful"
  "pawg anal beautiful"
  "pawg anal beautiful"
  20
]
7.59 ms
(5.82%)
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
  776964
  772809
  629510
  661298
  777055
  403986
  421743
  393848
  426475
  535611
  542544
  717869
  420793
  445536
  421519
  419308
  382670
  482751
  508542
  469568
  558821
  401927
  650488
  401742
  402834
  503406
  402715
  559952
  455085
  579701
  517405
  464861
  596196
  545836
  475000
  420530
  402723
  413836
  471148
  649970
  455411
  609839
  402905
  494492
]
2.43 ms
(1.86%)
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
  382670
  393848
  401742
  401927
  402715
  402723
  402834
  402905
  403986
  413836
  419308
  420530
  420793
  421519
  421743
  426475
  445536
  455085
  455411
  464861
  469568
  471148
  475000
  482751
  494492
  503406
  508542
  517405
  535611
  542544
  545836
  558821
  559952
  579701
  596196
  609839
  629510
  649970
  650488
  661298
  717869
  772809
  776964
  777055
]
2.03 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pawg anal beautiful"
]
1.82 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pawg анал красивая"
]
1.49 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pawg анал красивая"
]

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.