GET https://search.jues.net/search/embeds?q=mom%20in-law

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.29 ms
(59.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
89.81 ms
(25.44%)
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
  463094
  471806
  471807
  482253
  505494
  508450
  513146
  519578
  520001
  526226
  549956
  549958
  549960
  550003
  550007
  550017
  550044
  554897
  556647
  565986
  566015
  569955
  569973
  570150
  586672
  591313
  601724
  620746
  621540
  628423
  663929
  663941
  665188
  665492
  667555
  667660
  669448
  680702
  702456
  705257
  705298
  745183
  745751
  745785
  770006
  788222
  790018
  802642
  806720
  812930
  815309
  825327
]
36.95 ms
(10.47%)
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 in-law"
  "mom in-law"
  "mom in-law"
  20
]
8.07 ms
(2.29%)
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
  663941
  665188
  513146
  667555
  549958
  549956
  549960
  550007
  788222
  550044
  550017
  550003
  705298
  570150
  482253
  790018
  825327
  815309
  667660
  702456
  812930
  508450
  705257
  669448
  770006
  745183
  566015
  806720
  569973
  745751
  680702
  554897
  556647
  663929
  586672
  621540
  520001
  505494
  565986
  591313
  802642
  745785
  526226
  665492
  601724
  620746
  628423
  471806
  463094
  471807
  519578
  569955
]
2.89 ms
(0.82%)
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
  463094
  471806
  471807
  482253
  505494
  508450
  513146
  519578
  520001
  526226
  549956
  549958
  549960
  550003
  550007
  550017
  550044
  554897
  556647
  565986
  566015
  569955
  569973
  570150
  586672
  591313
  601724
  620746
  621540
  628423
  663929
  663941
  665188
  665492
  667555
  667660
  669448
  680702
  702456
  705257
  705298
  745183
  745751
  745785
  770006
  788222
  790018
  802642
  806720
  812930
  815309
  825327
]
1.99 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom in-law"
]
1.69 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom law"
]
1.30 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom law"
]

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.