GET https://search.jues.net/search/embeds?q=anal%20mature%20doggy-style

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
94.58 ms
(49.15%)
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:
[
  "anal mature doggy-style"
  "anal mature doggy-style"
  "anal mature doggy-style"
  20
]
79.09 ms
(41.10%)
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
  150507
  387125
  390382
  411459
  421882
  421891
  422158
  422192
  424114
  434338
  439731
  439749
  441597
  447679
  454107
  468348
  483351
  502885
  503442
  510884
  516023
  523390
  526494
  527199
  543123
  562790
  565033
  579721
  580613
  582557
  665675
  681539
  694142
  702031
  726897
  729115
  736224
  738305
  740599
  740893
  742633
  742636
  756685
  761461
  761749
  765220
  776829
  780745
  784206
  790517
  791916
  796343
  800247
  802147
  826827
]
9.10 ms
(4.73%)
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
  800247
  802147
  738305
  483351
  150507
  826827
  579721
  726897
  387125
  740893
  756685
  729115
  796343
  736224
  765220
  468348
  424114
  441597
  761461
  776829
  503442
  421891
  742633
  523390
  790517
  702031
  740599
  543123
  780745
  784206
  791916
  565033
  526494
  761749
  510884
  694142
  582557
  439749
  502885
  516023
  390382
  411459
  434338
  422192
  742636
  681539
  439731
  665675
  422158
  421882
  527199
  580613
  454107
  447679
  562790
]
2.99 ms
(1.55%)
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
  150507
  387125
  390382
  411459
  421882
  421891
  422158
  422192
  424114
  434338
  439731
  439749
  441597
  447679
  454107
  468348
  483351
  502885
  503442
  510884
  516023
  523390
  526494
  527199
  543123
  562790
  565033
  579721
  580613
  582557
  665675
  681539
  694142
  702031
  726897
  729115
  736224
  738305
  740599
  740893
  742633
  742636
  756685
  761461
  761749
  765220
  776829
  780745
  784206
  790517
  791916
  796343
  800247
  802147
  826827
]
1.94 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal mature doggy-style"
]
1.75 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал mature рак style"
]
1.55 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал mature рак style"
]

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.