GET https://search.jues.net/search/embeds?q=girlfriend%20group%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
77.47 ms
(46.14%)
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:
[
  "girlfriend group sex"
  "girlfriend group sex"
  "girlfriend group sex"
  20
]
73.41 ms
(43.71%)
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
  384158
  387195
  393027
  396600
  400946
  417542
  447735
  453088
  456688
  459565
  462830
  473919
  475020
  509400
  509404
  510480
  516644
  532919
  532998
  537933
  539047
  539053
  540497
  562773
  595743
  595821
  598846
  613333
  622249
  623202
  644397
  663448
  675930
  676850
  683598
  741152
  784254
  790679
  801942
  813759
  817464
  818527
  827858
  827881
]
7.04 ms
(4.19%)
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
  623202
  532998
  532919
  817464
  741152
  827881
  595743
  393027
  540497
  384158
  675930
  827858
  453088
  676850
  387195
  473919
  510480
  509400
  790679
  818527
  613333
  475020
  784254
  447735
  622249
  644397
  801942
  509404
  417542
  516644
  562773
  539053
  539047
  462830
  537933
  595821
  813759
  663448
  598846
  400946
  683598
  396600
  459565
  456688
]
2.21 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girlfriend group sex"
]
2.09 ms
(1.24%)
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
  384158
  387195
  393027
  396600
  400946
  417542
  447735
  453088
  456688
  459565
  462830
  473919
  475020
  509400
  509404
  510480
  516644
  532919
  532998
  537933
  539047
  539053
  540497
  562773
  595743
  595821
  598846
  613333
  622249
  623202
  644397
  663448
  675930
  676850
  683598
  741152
  784254
  790679
  801942
  813759
  817464
  818527
  827858
  827881
]
1.99 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "girlfriend group секс"
]
1.75 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "girlfriend group секс"
]

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.