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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
79.16 ms
(50.90%)
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
  488011
  515317
  516741
  543773
  548489
  549739
  588485
  605560
  609827
  612089
  612601
  679709
  689002
  696567
  697909
  699604
  702239
  709760
  711341
  716566
  716915
  716921
  716927
  719912
  723945
  723955
  724045
  724456
  726390
  727891
  730904
  743431
  743463
  744563
  746497
  753148
  753205
  753764
  754229
  755695
  756209
  763845
  769487
  769490
  769503
  769536
  769547
  769550
  772444
  772446
  772466
  773797
  773814
  775270
  775271
  788158
  788160
  795360
  798763
  802075
  803944
  804329
  818602
  820187
]
56.96 ms
(36.62%)
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 helps cum"
  "mom helps cum"
  "mom helps cum"
  20
]
9.38 ms
(6.03%)
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
  788160
  754229
  605560
  795360
  802075
  773814
  723107
  515317
  548489
  775270
  772446
  818602
  716915
  798763
  772466
  769490
  763845
  716921
  775271
  730904
  726390
  769550
  772444
  773797
  711341
  803944
  804329
  820187
  696567
  702239
  755695
  743463
  736517
  746497
  612089
  697943
  543773
  716927
  769547
  709760
  716936
  689002
  788158
  723955
  724045
  727891
  724456
  743431
  744563
  769536
  723945
  753148
  769503
  753764
  612601
  699604
  716566
  719912
  697909
  609827
  753205
  769487
  549739
  756209
  679709
  588485
  488011
  516741
]
2.70 ms
(1.73%)
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
  488011
  515317
  516741
  543773
  548489
  549739
  588485
  605560
  609827
  612089
  612601
  679709
  689002
  696567
  697909
  699604
  702239
  709760
  711341
  716566
  716915
  716921
  716927
  719912
  723945
  723955
  724045
  724456
  726390
  727891
  730904
  743431
  743463
  744563
  746497
  753148
  753205
  753764
  754229
  755695
  756209
  763845
  769487
  769490
  769503
  769536
  769547
  769550
  772444
  772446
  772466
  773797
  773814
  775270
  775271
  788158
  788160
  795360
  798763
  802075
  803944
  804329
  818602
  820187
]
1.95 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom helps cum"
]
1.92 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom helps cum"
]
1.90 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom helps cum"
]
1.56 ms
(1.00%)
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.