GET https://search.jues.net/search/embeds?q=cutie%20redhead

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
85.46 ms
(78.22%)
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
  402715
  415256
  443377
  445793
  448227
  467316
  472449
  494373
  502651
  509649
  510806
  516179
  522015
  524687
  545772
  548158
  561393
  564620
  570072
  580226
  594073
  608092
  608261
  624451
  627754
  659370
  659564
  660531
  676491
  676525
  676976
  677058
  677689
  725351
  730595
  741428
  747852
  753465
  760923
  773609
  777306
  778623
  788647
  797826
  799791
  800478
  803130
  809325
  810641
  810783
  819094
  821423
  821850
  825695
]
9.27 ms
(8.48%)
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
  580226
  445793
  402715
  741428
  803130
  810641
  799791
  677058
  819094
  825695
  797826
  608092
  472449
  676976
  778623
  677689
  800478
  810783
  753465
  448227
  725351
  564620
  659370
  548158
  443377
  510806
  516179
  660531
  747852
  821850
  561393
  494373
  676525
  627754
  676491
  730595
  502651
  524687
  624451
  809325
  821423
  760923
  773609
  788647
  509649
  570072
  777306
  415256
  467316
  522015
  659564
  594073
  608261
  545772
]
4.32 ms
(3.96%)
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:
[
  "cutie redhead"
  "cutie redhead"
  "cutie redhead"
  20
]
3.14 ms
(2.87%)
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
  402715
  415256
  443377
  445793
  448227
  467316
  472449
  494373
  502651
  509649
  510806
  516179
  522015
  524687
  545772
  548158
  561393
  564620
  570072
  580226
  594073
  608092
  608261
  624451
  627754
  659370
  659564
  660531
  676491
  676525
  676976
  677058
  677689
  725351
  730595
  741428
  747852
  753465
  760923
  773609
  777306
  778623
  788647
  797826
  799791
  800478
  803130
  809325
  810641
  810783
  819094
  821423
  821850
  825695
]
1.88 ms
(1.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cutie redhead"
]
1.80 ms
(1.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cutie рыжая"
]
1.78 ms
(1.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cutie рыжая"
]

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.