GET https://search.jues.net/search/embeds?q=family%20teen%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
96.06 ms
(67.75%)
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
  373798
  390888
  395701
  409403
  425582
  435022
  442946
  445436
  447574
  452048
  454875
  458722
  460673
  464654
  469552
  469911
  471628
  485196
  486946
  487858
  494689
  518403
  519930
  523478
  523706
  525287
  560197
  562886
  564826
  584716
  591140
  597601
  597981
  598786
  598973
  652380
  663458
  663495
  669763
  683405
  684233
  684235
  685588
  739519
  773524
  775710
  784307
  784493
  795490
  803378
  814643
  824581
]
28.01 ms
(19.75%)
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:
[
  "family teen tits"
  "family teen tits"
  "family teen tits"
  20
]
8.78 ms
(6.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
  773524
  684235
  684233
  597981
  824581
  739519
  795490
  803378
  458722
  373798
  560197
  409403
  494689
  652380
  775710
  485196
  486946
  447574
  814643
  454875
  685588
  597601
  598973
  784307
  669763
  683405
  591140
  464654
  435022
  469911
  523478
  395701
  425582
  663495
  584716
  598786
  784493
  390888
  562886
  442946
  487858
  663458
  471628
  523706
  469552
  564826
  452048
  460673
  519930
  518403
  445436
  525287
]
2.65 ms
(1.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
  373798
  390888
  395701
  409403
  425582
  435022
  442946
  445436
  447574
  452048
  454875
  458722
  460673
  464654
  469552
  469911
  471628
  485196
  486946
  487858
  494689
  518403
  519930
  523478
  523706
  525287
  560197
  562886
  564826
  584716
  591140
  597601
  597981
  598786
  598973
  652380
  663458
  663495
  669763
  683405
  684233
  684235
  685588
  739519
  773524
  775710
  784307
  784493
  795490
  803378
  814643
  824581
]
1.63 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "family teen tits"
]
1.56 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "family teen сиськ"
]
1.50 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "family teen сиськ"
]

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.