GET https://search.jues.net/search/embeds?q=cute%20facial

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
91.79 ms
(75.02%)
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
  6696
  397412
  401858
  417616
  425366
  427755
  428870
  448083
  455109
  460107
  471754
  481357
  502190
  505285
  505905
  510851
  513346
  515300
  515847
  523598
  545729
  552115
  564080
  577718
  579944
  585790
  585838
  595396
  596286
  603044
  621566
  624759
  629637
  639375
  644004
  650177
  654413
  657758
  662374
  698482
  707276
  719124
  724200
  736139
  740508
  764675
  768089
  782578
  807275
  813308
]
13.54 ms
(11.07%)
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:
[
  "cute facial"
  "cute facial"
  "cute facial"
  20
]
7.33 ms
(5.99%)
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
  523598
  782578
  698482
  629637
  427755
  707276
  657758
  807275
  813308
  736139
  481357
  515300
  654413
  585790
  768089
  397412
  417616
  577718
  740508
  719124
  401858
  455109
  6696
  505285
  639375
  624759
  425366
  460107
  552115
  564080
  579944
  585838
  596286
  644004
  603044
  764675
  428870
  662374
  724200
  545729
  650177
  595396
  471754
  505905
  502190
  510851
  515847
  621566
  513346
  448083
]
2.30 ms
(1.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cute facial"
]
2.03 ms
(1.66%)
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
  6696
  397412
  401858
  417616
  425366
  427755
  428870
  448083
  455109
  460107
  471754
  481357
  502190
  505285
  505905
  510851
  513346
  515300
  515847
  523598
  545729
  552115
  564080
  577718
  579944
  585790
  585838
  595396
  596286
  603044
  621566
  624759
  629637
  639375
  644004
  650177
  654413
  657758
  662374
  698482
  707276
  719124
  724200
  736139
  740508
  764675
  768089
  782578
  807275
  813308
]
1.92 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cute facial"
]
1.79 ms
(1.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cute facial"
]

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.