GET https://search.jues.net/search/embeds?q=eating%20cum%20pussy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
68.36 ms
(59.49%)
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
  417547
  440830
  448039
  456685
  458986
  459828
  461168
  462844
  467573
  468853
  472128
  490665
  502086
  504125
  504774
  514668
  542082
  587125
  587257
  595069
  596856
  604704
  632440
  633853
  647359
  654596
  707692
  708050
  708399
  710007
  714548
  719139
  724247
  727723
  748588
  750627
  761480
  767474
  773885
  775644
  785953
  788257
  793826
  795028
  796480
  804081
  810970
  816113
  819024
  824904
  828726
  828835
]
26.06 ms
(22.68%)
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:
[
  "eating cum pussy"
  "eating cum pussy"
  "eating cum pussy"
  20
]
8.96 ms
(7.79%)
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
  604704
  796480
  595069
  761480
  828726
  775644
  714548
  793826
  502086
  710007
  795028
  819024
  804081
  708399
  767474
  828835
  750627
  773885
  448039
  468853
  727723
  785953
  647359
  632440
  824904
  417547
  816113
  456685
  504774
  708050
  748588
  440830
  654596
  719139
  587125
  788257
  461168
  810970
  514668
  490665
  633853
  472128
  542082
  467573
  724247
  462844
  504125
  459828
  707692
  458986
  587257
  596856
]
3.63 ms
(3.16%)
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
  417547
  440830
  448039
  456685
  458986
  459828
  461168
  462844
  467573
  468853
  472128
  490665
  502086
  504125
  504774
  514668
  542082
  587125
  587257
  595069
  596856
  604704
  632440
  633853
  647359
  654596
  707692
  708050
  708399
  710007
  714548
  719139
  724247
  727723
  748588
  750627
  761480
  767474
  773885
  775644
  785953
  788257
  793826
  795028
  796480
  804081
  810970
  816113
  819024
  824904
  828726
  828835
]
2.22 ms
(1.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "eating cum pussy"
]
2.07 ms
(1.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "eating cum pussy"
]
1.82 ms
(1.58%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "eating cum pussy"
]

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.