GET https://search.jues.net/search/embeds/2?q=standing%20ass

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
101.49 ms
(67.53%)
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
  406089
  435008
  435069
  447604
  451115
  453799
  455657
  471481
  473351
  482909
  484086
  484551
  486052
  488461
  490515
  495897
  505548
  509667
  510873
  511124
  511282
  512615
  513214
  515604
  517708
  527576
  533213
  537278
  541575
  555984
  558316
  558654
  559546
  560731
  562456
  564342
  564657
  566422
  572195
  594467
  602227
  604425
  604645
  605902
  611324
  617056
  624142
  624834
  630919
  640614
  663547
  670750
  719857
  778820
  801143
  810710
]
26.33 ms
(17.52%)
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:
[
  "standing ass"
  "standing ass"
  "standing ass"
  20
]
11.65 ms
(7.75%)
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
  594467
  471481
  564657
  604425
  602227
  488461
  486052
  490515
  473351
  495897
  562456
  663547
  604645
  778820
  511282
  572195
  435069
  670750
  511124
  558316
  455657
  533213
  558654
  810710
  453799
  482909
  509667
  484551
  505548
  513214
  564342
  559546
  719857
  611324
  605902
  801143
  447604
  484086
  537278
  555984
  541575
  435008
  517708
  527576
  510873
  566422
  451115
  512615
  630919
  624142
  515604
  406089
  624834
  640614
  560731
  617056
]
2.82 ms
(1.88%)
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
  406089
  435008
  435069
  447604
  451115
  453799
  455657
  471481
  473351
  482909
  484086
  484551
  486052
  488461
  490515
  495897
  505548
  509667
  510873
  511124
  511282
  512615
  513214
  515604
  517708
  527576
  533213
  537278
  541575
  555984
  558316
  558654
  559546
  560731
  562456
  564342
  564657
  566422
  572195
  594467
  602227
  604425
  604645
  605902
  611324
  617056
  624142
  624834
  630919
  640614
  663547
  670750
  719857
  778820
  801143
  810710
]
2.17 ms
(1.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.06 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "standing ass"
]
1.94 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "standing жоп"
]
1.83 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "standing жоп"
]

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.