GET https://search.jues.net/search/embeds?q=girl%20football

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
89.26 ms
(69.60%)
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
  396603
  415693
  416177
  458435
  468531
  472206
  477607
  486977
  494949
  501263
  511062
  516060
  534994
  540882
  547898
  548457
  549464
  549474
  549995
  564804
  578845
  579040
  579281
  579288
  579292
  579301
  579302
  579309
  579311
  579312
  589197
  618332
  628289
  654638
  668508
  677604
  682633
  689004
  689520
  689940
  705405
  710433
  733324
  751417
  752154
  752158
  758891
  759470
  769378
  776614
  777184
  787024
  789387
  791094
  796603
  805020
  809603
  812954
  822377
]
19.62 ms
(15.30%)
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:
[
  "girl football"
  "girl football"
  "girl football"
  20
]
9.27 ms
(7.23%)
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
  579309
  549995
  540882
  548457
  579288
  812954
  791094
  789387
  796603
  777184
  689940
  416177
  396603
  547898
  549474
  751417
  822377
  682633
  677604
  549464
  654638
  579302
  752154
  733324
  787024
  705405
  710433
  589197
  769378
  564804
  759470
  579281
  689520
  776614
  809603
  458435
  477607
  618332
  628289
  579040
  689004
  668508
  578845
  486977
  579311
  758891
  472206
  511062
  415693
  516060
  805020
  468531
  494949
  501263
  579312
  579292
  752158
  579301
  534994
]
2.97 ms
(2.32%)
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
  396603
  415693
  416177
  458435
  468531
  472206
  477607
  486977
  494949
  501263
  511062
  516060
  534994
  540882
  547898
  548457
  549464
  549474
  549995
  564804
  578845
  579040
  579281
  579288
  579292
  579301
  579302
  579309
  579311
  579312
  589197
  618332
  628289
  654638
  668508
  677604
  682633
  689004
  689520
  689940
  705405
  710433
  733324
  751417
  752154
  752158
  758891
  759470
  769378
  776614
  777184
  787024
  789387
  791094
  796603
  805020
  809603
  812954
  822377
]
2.05 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl football"
]
1.81 ms
(1.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк football"
]
1.61 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк football"
]

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.