GET https://search.jues.net/search/embeds?q=granny%20blowjob%20loves

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
74.63 ms
(65.05%)
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
  381951
  388719
  390233
  401903
  411918
  412985
  413454
  413461
  416238
  416850
  449084
  450134
  450136
  453146
  459643
  465356
  466919
  468199
  470566
  472596
  472654
  479772
  485764
  485769
  498216
  498310
  499327
  502030
  506832
  514331
  517835
  525494
  534579
  534594
  546562
  546933
  563424
  567731
  581007
  588519
  636438
  678738
  681640
  716557
  724420
  742843
  743967
  758441
  766660
  770187
  781961
  781980
  788978
  801117
  826785
]
17.73 ms
(15.45%)
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:
[
  "granny blowjob loves"
  "granny blowjob loves"
  "granny blowjob loves"
  20
]
13.17 ms
(11.48%)
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
  826785
  546562
  390233
  450136
  450134
  498310
  472596
  781961
  485769
  724420
  411918
  742843
  743967
  534594
  567731
  485764
  801117
  416238
  636438
  588519
  514331
  502030
  449084
  466919
  401903
  479772
  681640
  453146
  413454
  498216
  499327
  470566
  766660
  758441
  770187
  788978
  781980
  525494
  716557
  472654
  517835
  381951
  412985
  563424
  413461
  506832
  581007
  416850
  678738
  468199
  459643
  546933
  465356
  388719
  534579
]
2.59 ms
(2.25%)
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
  381951
  388719
  390233
  401903
  411918
  412985
  413454
  413461
  416238
  416850
  449084
  450134
  450136
  453146
  459643
  465356
  466919
  468199
  470566
  472596
  472654
  479772
  485764
  485769
  498216
  498310
  499327
  502030
  506832
  514331
  517835
  525494
  534579
  534594
  546562
  546933
  563424
  567731
  581007
  588519
  636438
  678738
  681640
  716557
  724420
  742843
  743967
  758441
  766660
  770187
  781961
  781980
  788978
  801117
  826785
]
1.78 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "granny blowjob loves"
]
1.68 ms
(1.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "granny минет оральн секс loves"
]
1.60 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "granny минет оральн секс loves"
]
1.56 ms
(1.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.