GET https://search.jues.net/search/embeds/2?q=all%20girl%20threesome

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.21 ms
(62.83%)
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
  12594
  414131
  425829
  427259
  450775
  451372
  452474
  454984
  467553
  471636
  478049
  479016
  482484
  489310
  490198
  491250
  494694
  501480
  504231
  505129
  510576
  515896
  518549
  518592
  518593
  526353
  532504
  546669
  550662
  551763
  562060
  565783
  581433
  583723
  600478
  601324
  613169
  617137
  624247
  625183
  634856
  670951
  678569
  718695
  733204
  821262
]
23.15 ms
(18.60%)
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:
[
  "all girl threesome"
  "all girl threesome"
  "all girl threesome"
  20
]
12.39 ms
(9.95%)
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
  562060
  467553
  451372
  821262
  718695
  452474
  490198
  505129
  489310
  532504
  471636
  733204
  479016
  425829
  414131
  526353
  482484
  518549
  515896
  625183
  504231
  546669
  510576
  427259
  454984
  518592
  494694
  617137
  634856
  478049
  501480
  670951
  624247
  678569
  550662
  581433
  551763
  450775
  518593
  583723
  600478
  12594
  565783
  613169
  491250
  601324
]
3.01 ms
(2.42%)
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
  12594
  414131
  425829
  427259
  450775
  451372
  452474
  454984
  467553
  471636
  478049
  479016
  482484
  489310
  490198
  491250
  494694
  501480
  504231
  505129
  510576
  515896
  518549
  518592
  518593
  526353
  532504
  546669
  550662
  551763
  562060
  565783
  581433
  583723
  600478
  601324
  613169
  617137
  624247
  625183
  634856
  670951
  678569
  718695
  733204
  821262
]
2.14 ms
(1.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "all girl threesome"
]
2.12 ms
(1.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "all девушк секс втро"
]
1.72 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "all девушк секс втро"
]

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.