GET https://search.jues.net/search/embeds?q=ass%20jeans%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
216.61 ms
(65.51%)
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
  827554
  787633
  608769
  768529
  544416
  757267
  772953
  382101
  799708
  397971
  589525
  534148
  785248
  801621
  387132
  591964
  383378
  408875
  649300
  784137
  581015
  777756
  759087
  397985
  807408
  457090
  435872
  458564
  806611
  580387
  588533
  598587
  601762
  473065
  806144
  525596
  614842
  562203
  452808
  627442
  421161
  561754
  601738
  529769
  134210
  558624
  567116
  638870
  772700
  525785
  614831
  524956
  526436
  584942
  467118
  541465
  576128
  605864
  605774
]
73.48 ms
(22.22%)
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
  134210
  382101
  383378
  387132
  397971
  397985
  408875
  421161
  435872
  452808
  457090
  458564
  467118
  473065
  524956
  525596
  525785
  526436
  529769
  534148
  541465
  544416
  558624
  561754
  562203
  567116
  576128
  580387
  581015
  584942
  588533
  589525
  591964
  598587
  601738
  601762
  605774
  605864
  608769
  614831
  614842
  627442
  638870
  649300
  757267
  759087
  768529
  772700
  772953
  777756
  784137
  785248
  787633
  799708
  801621
  806144
  806611
  807408
  827554
]
30.47 ms
(9.21%)
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:
[
  "ass jeans solo"
  "ass jeans solo"
  "ass jeans solo"
  20
]
3.11 ms
(0.94%)
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
  134210
  382101
  383378
  387132
  397971
  397985
  408875
  421161
  435872
  452808
  457090
  458564
  467118
  473065
  524956
  525596
  525785
  526436
  529769
  534148
  541465
  544416
  558624
  561754
  562203
  567116
  576128
  580387
  581015
  584942
  588533
  589525
  591964
  598587
  601738
  601762
  605774
  605864
  608769
  614831
  614842
  627442
  638870
  649300
  757267
  759087
  768529
  772700
  772953
  777756
  784137
  785248
  787633
  799708
  801621
  806144
  806611
  807408
  827554
]
1.88 ms
(0.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп jeans соло"
]
1.77 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп jeans соло"
]
1.71 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass jeans solo"
]
1.65 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.