GET https://search.jues.net/search/embeds/2?q=mom%20beautiful%20mouth

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.92 ms
(49.80%)
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
  391147
  428761
  441458
  459535
  469566
  472237
  486536
  486887
  488132
  489343
  489353
  497409
  500221
  510108
  511564
  512985
  513020
  513838
  516904
  518364
  519034
  519251
  520815
  526545
  529792
  530495
  542746
  544123
  556778
  568455
  579754
  588329
  591135
  624875
  630552
  631194
  633491
  638298
  647859
  666892
  782516
]
43.71 ms
(35.73%)
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:
[
  "mom beautiful mouth"
  "mom beautiful mouth"
  "mom beautiful mouth"
  20
]
8.55 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
  513020
  489353
  588329
  459535
  513838
  500221
  512985
  518364
  542746
  624875
  782516
  441458
  486887
  510108
  520815
  472237
  519251
  526545
  488132
  469566
  489343
  519034
  568455
  647859
  666892
  633491
  631194
  497409
  391147
  428761
  511564
  530495
  579754
  556778
  638298
  544123
  630552
  486536
  516904
  529792
  591135
]
2.36 ms
(1.93%)
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
  391147
  428761
  441458
  459535
  469566
  472237
  486536
  486887
  488132
  489343
  489353
  497409
  500221
  510108
  511564
  512985
  513020
  513838
  516904
  518364
  519034
  519251
  520815
  526545
  529792
  530495
  542746
  544123
  556778
  568455
  579754
  588329
  591135
  624875
  630552
  631194
  633491
  638298
  647859
  666892
  782516
]
1.79 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom beautiful mouth"
]
1.78 ms
(1.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom красивая mouth"
]
1.55 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom красивая mouth"
]

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.