GET https://search.jues.net/search/embeds/2?q=fucking%20my%20girlfriend

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.68 ms
(72.77%)
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
  424995
  448260
  453486
  458486
  462597
  470008
  470443
  473258
  476632
  484123
  488829
  503013
  512345
  512844
  516387
  522103
  522668
  525542
  525787
  535279
  549458
  560703
  564088
  567409
  573334
  584094
  589135
  590319
  598184
  603468
  605603
  618188
  628558
  635667
  636124
  640149
  643488
  645994
  659349
  676542
  744958
  747194
  747195
  747222
  747223
  747228
  747231
  747236
  749871
  750115
  750788
  750790
  753654
  763437
  796763
]
10.44 ms
(10.75%)
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
  676542
  636124
  640149
  796763
  753654
  749871
  643488
  470008
  560703
  659349
  628558
  564088
  645994
  589135
  618188
  747222
  424995
  453486
  525787
  584094
  549458
  635667
  750790
  750115
  750788
  744958
  603468
  605603
  462597
  503013
  567409
  590319
  747223
  747194
  516387
  476632
  522103
  747195
  747228
  747231
  763437
  470443
  473258
  484123
  488829
  458486
  512345
  512844
  522668
  573334
  598184
  747236
  525542
  535279
  448260
]
7.01 ms
(7.21%)
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:
[
  "fucking my girlfriend"
  "fucking my girlfriend"
  "fucking my girlfriend"
  20
]
2.43 ms
(2.50%)
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
  424995
  448260
  453486
  458486
  462597
  470008
  470443
  473258
  476632
  484123
  488829
  503013
  512345
  512844
  516387
  522103
  522668
  525542
  525787
  535279
  549458
  560703
  564088
  567409
  573334
  584094
  589135
  590319
  598184
  603468
  605603
  618188
  628558
  635667
  636124
  640149
  643488
  645994
  659349
  676542
  744958
  747194
  747195
  747222
  747223
  747228
  747231
  747236
  749871
  750115
  750788
  750790
  753654
  763437
  796763
]
1.91 ms
(1.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucking my girlfriend"
]
1.65 ms
(1.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucking my girlfriend"
]
1.49 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucking my girlfriend"
]

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.