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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
65.87 ms
(60.67%)
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
  34593
  390218
  391950
  393504
  407168
  409313
  410979
  427543
  439620
  439733
  443946
  446284
  448680
  457963
  461859
  465952
  467975
  469552
  471612
  495198
  505885
  511009
  516727
  523032
  526039
  528921
  533426
  535318
  549638
  550377
  553269
  559430
  589634
  593003
  597240
  625172
  631607
  641687
  664498
  698124
  714297
  714380
  726467
  726510
  726513
  726521
  726753
  733012
  733812
  740824
  741310
  750776
  760505
  796129
  799020
  802185
  824735
]
22.02 ms
(20.28%)
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:
[
  "very young milf"
  "very young milf"
  "very young milf"
  20
]
11.59 ms
(10.68%)
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
  631607
  641687
  535318
  664498
  726467
  393504
  410979
  391950
  741310
  34593
  733012
  409313
  824735
  714297
  733812
  799020
  740824
  461859
  726521
  760505
  446284
  550377
  802185
  528921
  714380
  726510
  726513
  750776
  796129
  726753
  559430
  448680
  593003
  390218
  443946
  505885
  457963
  465952
  439733
  467975
  549638
  439620
  523032
  511009
  427543
  471612
  469552
  495198
  589634
  407168
  553269
  533426
  516727
  698124
  625172
  526039
  597240
]
2.60 ms
(2.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
  34593
  390218
  391950
  393504
  407168
  409313
  410979
  427543
  439620
  439733
  443946
  446284
  448680
  457963
  461859
  465952
  467975
  469552
  471612
  495198
  505885
  511009
  516727
  523032
  526039
  528921
  533426
  535318
  549638
  550377
  553269
  559430
  589634
  593003
  597240
  625172
  631607
  641687
  664498
  698124
  714297
  714380
  726467
  726510
  726513
  726521
  726753
  733012
  733812
  740824
  741310
  750776
  760505
  796129
  799020
  802185
  824735
]
1.87 ms
(1.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "very young milf"
]
1.65 ms
(1.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "very young milf"
]
1.49 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "very young milf"
]

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.