GET https://search.jues.net/search/embeds/2?q=lesbian%20big%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
79.85 ms
(53.27%)
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
  396422
  416720
  420447
  422044
  424648
  426408
  430553
  432359
  433295
  437960
  446736
  464534
  472693
  487703
  488585
  497362
  502453
  504414
  508809
  513025
  514638
  517464
  521581
  522585
  523317
  524682
  524792
  528030
  538915
  551736
  556762
  557942
  562282
  582899
  597240
  603854
  617437
  636247
  643090
  647960
  676641
  677307
  750064
]
52.39 ms
(34.95%)
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:
[
  "lesbian big ass"
  "lesbian big ass"
  "lesbian big ass"
  20
]
8.59 ms
(5.73%)
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
  426408
  750064
  472693
  538915
  557942
  643090
  464534
  497362
  508809
  617437
  433295
  504414
  432359
  488585
  502453
  517464
  556762
  424648
  437960
  416720
  524792
  396422
  420447
  514638
  636247
  446736
  521581
  523317
  647960
  422044
  582899
  524682
  551736
  513025
  676641
  562282
  603854
  430553
  677307
  528030
  522585
  487703
  597240
]
2.10 ms
(1.40%)
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
  396422
  416720
  420447
  422044
  424648
  426408
  430553
  432359
  433295
  437960
  446736
  464534
  472693
  487703
  488585
  497362
  502453
  504414
  508809
  513025
  514638
  517464
  521581
  522585
  523317
  524682
  524792
  528030
  538915
  551736
  556762
  557942
  562282
  582899
  597240
  603854
  617437
  636247
  643090
  647960
  676641
  677307
  750064
]
1.92 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "lesbian big ass"
]
1.78 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лесбиянк большая большие жоп"
]
1.77 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лесбиянк большая большие жоп"
]
1.50 ms
(1.00%)
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.