GET https://search.jues.net/search/embeds?q=step%20cousin

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
103.28 ms
(77.27%)
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
  398871
  439216
  442464
  448512
  459905
  461079
  476452
  479191
  486620
  516693
  525898
  527300
  532207
  532215
  532284
  533097
  533454
  533790
  534333
  534653
  535751
  535756
  535758
  542946
  543434
  547525
  557438
  562905
  571808
  589989
  591219
  603900
  610135
  619325
  621095
  622323
  626122
  626282
  632316
  635193
  642501
  645255
  650650
  667151
  698172
  699450
  705375
  707547
  713371
  718191
  735028
  750127
  758647
  765530
  769053
  782911
  787879
  810200
  810331
  810885
  820337
  826772
]
11.06 ms
(8.27%)
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:
[
  "step cousin"
  "step cousin"
  "step cousin"
  20
]
9.26 ms
(6.93%)
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
  645255
  448512
  826772
  650650
  632316
  769053
  758647
  787879
  635193
  713371
  718191
  750127
  765530
  533097
  619325
  698172
  810885
  535751
  571808
  810200
  535758
  532207
  707547
  705375
  610135
  735028
  699450
  398871
  476452
  532284
  533454
  622323
  442464
  534653
  533790
  486620
  532215
  535756
  589989
  626122
  621095
  626282
  810331
  527300
  820337
  562905
  459905
  542946
  642501
  534333
  525898
  557438
  591219
  782911
  439216
  516693
  479191
  461079
  603900
  543434
  547525
  667151
]
2.42 ms
(1.81%)
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
  398871
  439216
  442464
  448512
  459905
  461079
  476452
  479191
  486620
  516693
  525898
  527300
  532207
  532215
  532284
  533097
  533454
  533790
  534333
  534653
  535751
  535756
  535758
  542946
  543434
  547525
  557438
  562905
  571808
  589989
  591219
  603900
  610135
  619325
  621095
  622323
  626122
  626282
  632316
  635193
  642501
  645255
  650650
  667151
  698172
  699450
  705375
  707547
  713371
  718191
  735028
  750127
  758647
  765530
  769053
  782911
  787879
  810200
  810331
  810885
  820337
  826772
]
2.32 ms
(1.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step cousin"
]
1.92 ms
(1.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step cousin"
]
1.77 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step cousin"
]

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.