GET https://search.jues.net/search/embeds?q=pregnant%20cuckold

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.07 ms
(78.35%)
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
  397519
  397988
  477565
  483497
  487206
  508754
  508766
  508775
  508777
  517596
  519925
  527037
  558788
  560435
  566657
  567336
  567341
  572243
  573362
  573367
  578717
  578733
  578783
  578793
  583990
  588142
  594589
  594786
  604050
  605653
  606784
  610037
  624405
  628582
  628714
  629201
  629750
  630326
  630725
  635786
  636369
  650967
  664613
  666033
  666068
  668680
  725950
  729181
  732640
  732943
  773977
  785153
  790888
  792672
  807710
  808290
]
14.37 ms
(9.00%)
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:
[
  "pregnant cuckold"
  "pregnant cuckold"
  "pregnant cuckold"
  20
]
10.18 ms
(6.38%)
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
  666033
  729181
  567341
  606784
  508775
  397519
  630725
  483497
  567336
  397988
  573362
  578783
  668680
  527037
  725950
  573367
  628582
  566657
  508754
  594589
  578793
  477565
  578717
  588142
  508777
  487206
  664613
  629750
  583990
  792672
  650967
  630326
  773977
  629201
  572243
  807710
  635786
  610037
  666068
  628714
  519925
  790888
  517596
  732943
  558788
  560435
  605653
  624405
  508766
  578733
  594786
  636369
  808290
  732640
  604050
  785153
]
2.57 ms
(1.61%)
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
  397519
  397988
  477565
  483497
  487206
  508754
  508766
  508775
  508777
  517596
  519925
  527037
  558788
  560435
  566657
  567336
  567341
  572243
  573362
  573367
  578717
  578733
  578783
  578793
  583990
  588142
  594589
  594786
  604050
  605653
  606784
  610037
  624405
  628582
  628714
  629201
  629750
  630326
  630725
  635786
  636369
  650967
  664613
  666033
  666068
  668680
  725950
  729181
  732640
  732943
  773977
  785153
  790888
  792672
  807710
  808290
]
2.20 ms
(1.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беремен куколд"
]
1.89 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беремен куколд"
]
1.86 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pregnant cuckold"
]
1.49 ms
(0.93%)
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.