GET https://search.jues.net/search/embeds?q=chubby%20anal%20skirt

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.02 ms
(46.47%)
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
  320525
  358592
  383985
  390571
  392754
  396526
  400483
  405042
  406012
  407551
  419619
  421847
  424432
  424436
  429861
  438054
  439736
  443292
  445429
  451497
  453409
  459830
  462346
  464006
  464835
  466015
  466928
  474104
  478365
  491348
  493175
  495227
  495228
  496554
  511205
  516477
  518922
  519341
  521843
  523832
  526454
  526752
  528347
  536938
  542247
  549698
  552809
  563098
  563450
  564363
  570169
  570747
  581929
  583729
  583892
  599710
  604631
  605096
  615978
  678097
  678804
]
59.11 ms
(38.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:
[
  "chubby anal skirt"
  "chubby anal skirt"
  "chubby anal skirt"
  20
]
11.93 ms
(7.80%)
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
  478365
  405042
  445429
  320525
  599710
  358592
  552809
  383985
  400483
  518922
  523832
  526752
  542247
  421847
  495228
  495227
  583892
  528347
  474104
  493175
  407551
  549698
  424436
  516477
  604631
  564363
  605096
  443292
  424432
  429861
  392754
  406012
  390571
  563098
  462346
  464835
  466015
  570169
  396526
  526454
  451497
  496554
  439736
  536938
  570747
  563450
  453409
  511205
  678804
  459830
  491348
  615978
  438054
  419619
  466928
  678097
  583729
  464006
  581929
  521843
  519341
]
2.72 ms
(1.78%)
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
  320525
  358592
  383985
  390571
  392754
  396526
  400483
  405042
  406012
  407551
  419619
  421847
  424432
  424436
  429861
  438054
  439736
  443292
  445429
  451497
  453409
  459830
  462346
  464006
  464835
  466015
  466928
  474104
  478365
  491348
  493175
  495227
  495228
  496554
  511205
  516477
  518922
  519341
  521843
  523832
  526454
  526752
  528347
  536938
  542247
  549698
  552809
  563098
  563450
  564363
  570169
  570747
  581929
  583729
  583892
  599710
  604631
  605096
  615978
  678097
  678804
]
2.30 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby anal skirt"
]
2.03 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby анал юбк"
]
1.82 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby анал юбк"
]

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.