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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.43 ms
(57.19%)
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
  402092
  446443
  446967
  454858
  466368
  467121
  479629
  482140
  482230
  483187
  493158
  497388
  505973
  506227
  506335
  508744
  523933
  525526
  527174
  532130
  537020
  551908
  559958
  561597
  565017
  567007
  584168
  602959
  606032
  609524
  621096
  636554
  639152
  649940
  689379
  702312
  703492
  736130
  741620
  745002
  752869
  756443
  757976
  768163
  783980
  786451
  790759
  792522
  793665
  803377
  807542
  814770
  814782
  815386
  815583
  815735
  815773
  815781
  818215
]
41.60 ms
(30.33%)
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 resist"
  "mom resist"
  "mom resist"
  20
]
8.35 ms
(6.09%)
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
  745002
  446967
  483187
  741620
  482230
  818215
  803377
  815781
  768163
  757976
  815583
  551908
  790759
  792522
  736130
  783980
  814770
  702312
  756443
  815773
  815386
  649940
  752869
  602959
  454858
  532130
  561597
  609524
  807542
  527174
  508744
  467121
  567007
  559958
  565017
  606032
  621096
  639152
  466368
  523933
  505973
  814782
  482140
  793665
  636554
  703492
  786451
  446443
  402092
  506227
  537020
  506335
  493158
  525526
  497388
  815735
  584168
  689379
  479629
]
2.40 ms
(1.75%)
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
  402092
  446443
  446967
  454858
  466368
  467121
  479629
  482140
  482230
  483187
  493158
  497388
  505973
  506227
  506335
  508744
  523933
  525526
  527174
  532130
  537020
  551908
  559958
  561597
  565017
  567007
  584168
  602959
  606032
  609524
  621096
  636554
  639152
  649940
  689379
  702312
  703492
  736130
  741620
  745002
  752869
  756443
  757976
  768163
  783980
  786451
  790759
  792522
  793665
  803377
  807542
  814770
  814782
  815386
  815583
  815735
  815773
  815781
  818215
]
2.07 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom resist"
]
1.59 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom resist"
]
1.27 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom resist"
]

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.