GET https://search.jues.net/search/embeds?q=webcam%20couple%20creampie

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.95 ms
(62.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
93.54 ms
(27.52%)
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
  387883
  391956
  398239
  398449
  417556
  426352
  436542
  438735
  446833
  455245
  459995
  460917
  480737
  481612
  501677
  506486
  514945
  525793
  546746
  552697
  591201
  595137
  623961
  624592
  659956
  670915
  675495
  680342
  710094
  715407
  726942
  733176
  734620
  762739
  791809
  793860
  794715
  794914
  799968
  800975
  819334
  820028
  820749
]
19.27 ms
(5.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:
[
  "webcam couple creampie"
  "webcam couple creampie"
  "webcam couple creampie"
  20
]
8.26 ms
(2.43%)
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
  820028
  820749
  793860
  398239
  391956
  680342
  715407
  624592
  794715
  794914
  799968
  398449
  417556
  734620
  506486
  819334
  675495
  710094
  659956
  670915
  595137
  800975
  733176
  762739
  446833
  501677
  546746
  387883
  426352
  480737
  514945
  591201
  623961
  726942
  791809
  438735
  460917
  436542
  552697
  459995
  481612
  525793
  455245
]
2.62 ms
(0.77%)
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
  387883
  391956
  398239
  398449
  417556
  426352
  436542
  438735
  446833
  455245
  459995
  460917
  480737
  481612
  501677
  506486
  514945
  525793
  546746
  552697
  591201
  595137
  623961
  624592
  659956
  670915
  675495
  680342
  710094
  715407
  726942
  733176
  734620
  762739
  791809
  793860
  794715
  794914
  799968
  800975
  819334
  820028
  820749
]
1.92 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam couple creampie"
]
1.88 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер couple creampie"
]
1.49 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер couple 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.