GET https://search.jues.net/search/embeds?q=teen%20gina%20gerson

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
91.85 ms
(60.29%)
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
  381912
  387922
  395826
  396050
  396358
  396449
  408489
  414673
  417428
  418399
  418404
  418410
  418416
  418417
  421146
  421271
  426033
  426038
  426042
  426044
  430809
  447629
  447643
  447650
  447689
  452053
  461291
  468757
  478873
  487713
  491650
  491718
  506445
  518468
  531780
  550207
  574818
  575058
  575068
  575162
  576079
  576109
  576324
  576347
  576371
  596168
  597014
  621988
  631968
  633782
  636026
  714431
  714463
  714464
  714473
  714526
  742143
  742158
  775788
  775797
  775831
]
39.50 ms
(25.93%)
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:
[
  "teen gina gerson"
  "teen gina gerson"
  "teen gina gerson"
  20
]
10.36 ms
(6.80%)
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
  714526
  396449
  426042
  478873
  430809
  447650
  414673
  531780
  575058
  575162
  576347
  518468
  633782
  714431
  447643
  418416
  487713
  574818
  742158
  550207
  381912
  714463
  468757
  418404
  714473
  636026
  775788
  775831
  418417
  426044
  576109
  714464
  775797
  742143
  396050
  631968
  408489
  576324
  387922
  417428
  491718
  447629
  575068
  576371
  597014
  576079
  418410
  447689
  491650
  426038
  396358
  461291
  426033
  506445
  395826
  421146
  418399
  421271
  452053
  596168
  621988
]
2.97 ms
(1.95%)
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
  381912
  387922
  395826
  396050
  396358
  396449
  408489
  414673
  417428
  418399
  418404
  418410
  418416
  418417
  421146
  421271
  426033
  426038
  426042
  426044
  430809
  447629
  447643
  447650
  447689
  452053
  461291
  468757
  478873
  487713
  491650
  491718
  506445
  518468
  531780
  550207
  574818
  575058
  575068
  575162
  576079
  576109
  576324
  576347
  576371
  596168
  597014
  621988
  631968
  633782
  636026
  714431
  714463
  714464
  714473
  714526
  742143
  742158
  775788
  775797
  775831
]
2.30 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen gina gerson"
]
2.06 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen ginagerson"
]
1.66 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen ginagerson"
]

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.