GET https://search.jues.net/search/embeds?q=pawg%20russian%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.16 ms
(52.74%)
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
  400516
  431341
  434411
  436138
  455436
  456701
  465431
  465670
  467058
  467064
  468255
  472665
  476051
  482751
  498420
  513202
  525839
  526951
  549723
  549725
  549728
  554884
  555055
  568181
  576915
  591997
  595316
  629510
  697457
  742636
  755022
  759397
  761039
  762379
  764161
  785349
  785382
  796673
  797001
  797809
  804422
  807304
  811702
  811736
  813930
  819401
  824303
]
34.95 ms
(30.64%)
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:
[
  "pawg russian milf"
  "pawg russian milf"
  "pawg russian milf"
  20
]
9.00 ms
(7.89%)
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
  629510
  797809
  804422
  811702
  797001
  697457
  811736
  742636
  796673
  813930
  595316
  807304
  759397
  456701
  819401
  824303
  554884
  785349
  513202
  467064
  476051
  764161
  762379
  785382
  400516
  568181
  576915
  755022
  468255
  434411
  465670
  467058
  549728
  482751
  436138
  525839
  465431
  472665
  549725
  555055
  549723
  498420
  591997
  761039
  455436
  526951
  431341
]
3.02 ms
(2.65%)
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
  400516
  431341
  434411
  436138
  455436
  456701
  465431
  465670
  467058
  467064
  468255
  472665
  476051
  482751
  498420
  513202
  525839
  526951
  549723
  549725
  549728
  554884
  555055
  568181
  576915
  591997
  595316
  629510
  697457
  742636
  755022
  759397
  761039
  762379
  764161
  785349
  785382
  796673
  797001
  797809
  804422
  807304
  811702
  811736
  813930
  819401
  824303
]
2.28 ms
(2.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pawg russian milf"
]
1.63 ms
(1.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pawg русск milf"
]
1.48 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pawg русск milf"
]

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.