GET https://search.jues.net/search/embeds/2?q=mature%20casting%20creampie

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
76.88 ms
(59.58%)
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
  529794
  532751
  532812
  533746
  534372
  534387
  537863
  537864
  544843
  545460
  599862
  599865
  599867
  599880
  599913
  599927
  599955
  599965
  600019
  600021
  600171
  600249
  600252
  600289
  600296
  601578
  601613
  615716
  632663
  632678
  633123
  635275
  636300
  636306
  636315
  639751
  641978
  642063
  642660
  642774
  643098
  644986
  647860
  647948
  666850
  667748
]
33.12 ms
(25.67%)
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:
[
  "mature casting creampie"
  "mature casting creampie"
  "mature casting creampie"
  20
]
10.12 ms
(7.85%)
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
  599867
  600171
  600296
  642063
  599913
  599955
  599862
  599965
  600249
  600289
  615716
  633123
  643098
  600019
  601613
  632663
  647860
  532751
  534372
  537863
  534387
  537864
  667748
  544843
  632678
  644986
  532812
  647948
  599880
  599927
  600252
  636306
  642660
  600021
  599865
  636300
  601578
  529794
  635275
  636315
  533746
  545460
  666850
  642774
  639751
  641978
]
2.39 ms
(1.85%)
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
  529794
  532751
  532812
  533746
  534372
  534387
  537863
  537864
  544843
  545460
  599862
  599865
  599867
  599880
  599913
  599927
  599955
  599965
  600019
  600021
  600171
  600249
  600252
  600289
  600296
  601578
  601613
  615716
  632663
  632678
  633123
  635275
  636300
  636306
  636315
  639751
  641978
  642063
  642660
  642774
  643098
  644986
  647860
  647948
  666850
  667748
]
1.76 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature casting creampie"
]
1.64 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature кастинг creampie"
]
1.63 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature кастинг creampie"
]

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.