GET https://search.jues.net/search/embeds?q=milf%20tumanova

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
65.82 ms
(60.51%)
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
  439488
  439518
  439520
  439522
  439525
  439544
  439552
  439604
  439607
  439611
  439652
  439655
  439658
  439664
  439688
  439717
  439718
  445200
  450901
  455909
  455922
  455923
  458199
  459222
  465334
  465345
  466260
  472148
  475960
  477451
  477454
  486569
  486576
  486581
  486583
  486587
  486588
  486590
  493164
  495325
  495326
  502745
  502750
  502753
  509995
  513338
  522343
  522363
  522690
  523023
  523032
  619508
]
22.30 ms
(20.50%)
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:
[
  "milf tumanova"
  "milf tumanova"
  "milf tumanova"
  20
]
10.92 ms
(10.04%)
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
  466260
  455922
  522690
  439488
  455923
  472148
  477451
  486576
  493164
  522363
  439718
  450901
  455909
  495325
  486569
  495326
  439655
  465334
  486588
  439604
  439522
  502753
  439520
  459222
  439717
  439652
  439552
  458199
  486590
  439611
  439658
  475960
  439525
  486587
  523023
  619508
  439688
  465345
  445200
  477454
  502750
  486581
  439544
  439607
  439664
  523032
  486583
  502745
  522343
  513338
  439518
  509995
]
2.69 ms
(2.47%)
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
  439488
  439518
  439520
  439522
  439525
  439544
  439552
  439604
  439607
  439611
  439652
  439655
  439658
  439664
  439688
  439717
  439718
  445200
  450901
  455909
  455922
  455923
  458199
  459222
  465334
  465345
  466260
  472148
  475960
  477451
  477454
  486569
  486576
  486581
  486583
  486587
  486588
  486590
  493164
  495325
  495326
  502745
  502750
  502753
  509995
  513338
  522343
  522363
  522690
  523023
  523032
  619508
]
2.04 ms
(1.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf tumanova"
]
1.81 ms
(1.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf tumanova"
]
1.49 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf tumanova"
]

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.