GET https://search.jues.net/search/embeds?q=fake%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
101.92 ms
(60.66%)
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
  384809
  388347
  399187
  399563
  399587
  399591
  404308
  409046
  415882
  428238
  473505
  482251
  487072
  492267
  494797
  513901
  520695
  522016
  525663
  534685
  558414
  559953
  560141
  560143
  560150
  560153
  560196
  560203
  560204
  560209
  560211
  560212
  560227
  565539
  565541
  572034
  572886
  580198
  580695
  581708
  591122
  593444
  595768
  598861
  601309
  604151
  607123
  613052
  617680
  620779
  625167
  689300
  689345
  689614
  749825
  770530
  805917
  807181
  814825
]
43.66 ms
(25.99%)
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:
[
  "fake mom"
  "fake mom"
  "fake mom"
  20
]
11.75 ms
(6.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
  617680
  607123
  560141
  560143
  604151
  560227
  620779
  560209
  805917
  749825
  560196
  560150
  689300
  689345
  560203
  572034
  807181
  770530
  399563
  613052
  593444
  399187
  565541
  580695
  591122
  409046
  494797
  580198
  581708
  598861
  482251
  388347
  814825
  560153
  601309
  525663
  428238
  520695
  534685
  559953
  560204
  399587
  415882
  513901
  558414
  565539
  689614
  560211
  595768
  522016
  399591
  560212
  384809
  404308
  625167
  487072
  492267
  572886
  473505
]
2.70 ms
(1.60%)
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
  384809
  388347
  399187
  399563
  399587
  399591
  404308
  409046
  415882
  428238
  473505
  482251
  487072
  492267
  494797
  513901
  520695
  522016
  525663
  534685
  558414
  559953
  560141
  560143
  560150
  560153
  560196
  560203
  560204
  560209
  560211
  560212
  560227
  565539
  565541
  572034
  572886
  580198
  580695
  581708
  591122
  593444
  595768
  598861
  601309
  604151
  607123
  613052
  617680
  620779
  625167
  689300
  689345
  689614
  749825
  770530
  805917
  807181
  814825
]
2.19 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fake mom"
]
2.09 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fake mom"
]
1.89 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fake mom"
]
1.82 ms
(1.09%)
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.