GET https://search.jues.net/search/embeds/8?q=interracial%20webcam%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.37 ms
(49.28%)
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
  390835
  432683
  433040
  433047
  434971
  435462
  443112
  446976
  452228
  452282
  452283
  460327
  467019
  467581
  470412
  477072
  482644
  499332
  503274
  503453
  505460
  508424
  508883
  512528
  512533
  513215
  516924
  517049
  518766
  519117
  521507
  524865
  529404
  545828
  555798
  558185
  559154
  561980
  568371
  571751
  573403
  579360
  583428
  591094
  595070
  603612
  604352
  605374
  606294
  617214
  619692
  621348
  624511
  632055
  643113
  647090
  659025
  809272
]
57.86 ms
(36.38%)
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:
[
  "interracial webcam sex"
  "interracial webcam sex"
  "interracial webcam sex"
  20
]
12.92 ms
(8.13%)
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
  508424
  482644
  568371
  647090
  624511
  435462
  571751
  619692
  433047
  433040
  452228
  460327
  606294
  809272
  632055
  452283
  516924
  604352
  518766
  477072
  617214
  643113
  452282
  470412
  595070
  561980
  659025
  605374
  508883
  559154
  434971
  505460
  512533
  390835
  499332
  503274
  512528
  467019
  555798
  583428
  503453
  443112
  521507
  513215
  517049
  524865
  603612
  621348
  446976
  591094
  558185
  467581
  579360
  529404
  432683
  573403
  519117
  545828
]
2.69 ms
(1.69%)
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
  390835
  432683
  433040
  433047
  434971
  435462
  443112
  446976
  452228
  452282
  452283
  460327
  467019
  467581
  470412
  477072
  482644
  499332
  503274
  503453
  505460
  508424
  508883
  512528
  512533
  513215
  516924
  517049
  518766
  519117
  521507
  524865
  529404
  545828
  555798
  558185
  559154
  561980
  568371
  571751
  573403
  579360
  583428
  591094
  595070
  603612
  604352
  605374
  606294
  617214
  619692
  621348
  624511
  632055
  643113
  647090
  659025
  809272
]
1.96 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "interracial webcam sex"
]
1.78 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "межрасов вебкамер секс"
]
1.73 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межрасов вебкамер секс"
]
1.72 ms
(1.08%)
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.