GET https://search.jues.net/search/embeds/3?q=brunette%20fuck%20machine

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.22 ms
(54.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette fuck machine"
]
136.81 ms
(35.85%)
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
  182118
  403439
  413398
  414064
  414350
  415855
  418101
  418102
  418112
  418122
  418139
  418144
  421052
  429596
  432296
  434286
  434293
  434313
  434337
  434338
  434355
  434364
  434365
  437605
  444924
  458761
  458770
  460813
  493839
  496340
  497905
  499789
  504723
  511376
  521429
  532746
  534381
  540348
  543864
  548550
  560405
  560427
  561061
  570978
  584564
  588755
  593504
  593513
  593540
  595165
  610031
  615933
  623300
  630411
  665929
  709917
  738518
]
20.69 ms
(5.42%)
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:
[
  "brunette fuck machine"
  "brunette fuck machine"
  "brunette fuck machine"
  20
]
8.22 ms
(2.15%)
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
  532746
  584564
  665929
  623300
  738518
  434355
  403439
  460813
  540348
  521429
  418101
  560427
  543864
  560405
  414064
  630411
  615933
  497905
  437605
  182118
  418112
  418139
  499789
  709917
  593540
  588755
  610031
  593504
  593513
  413398
  421052
  434365
  434286
  434338
  434337
  429596
  570978
  434313
  493839
  534381
  496340
  511376
  415855
  434293
  458770
  434364
  414350
  504723
  458761
  595165
  548550
  418144
  432296
  418122
  418102
  561061
  444924
]
2.56 ms
(0.67%)
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
  182118
  403439
  413398
  414064
  414350
  415855
  418101
  418102
  418112
  418122
  418139
  418144
  421052
  429596
  432296
  434286
  434293
  434313
  434337
  434338
  434355
  434364
  434365
  437605
  444924
  458761
  458770
  460813
  493839
  496340
  497905
  499789
  504723
  511376
  521429
  532746
  534381
  540348
  543864
  548550
  560405
  560427
  561061
  570978
  584564
  588755
  593504
  593513
  593540
  595165
  610031
  615933
  623300
  630411
  665929
  709917
  738518
]
1.58 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая секс machine"
]
1.27 ms
(0.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.26 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая секс machine"
]

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.