GET https://search.jues.net/search/embeds?q=maria%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
65.70 ms
(61.80%)
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
  154451
  383299
  384836
  388081
  390259
  401022
  411161
  418367
  418890
  425379
  426124
  429800
  465557
  522641
  531904
  533800
  546422
  557520
  575397
  579506
  587506
  590432
  596634
  597194
  599064
  601950
  620901
  621085
  631464
  648516
  650270
  670364
  710889
  769293
  769325
  769328
  772621
  774085
  774211
  790726
  799034
  806577
  806996
  813597
]
22.35 ms
(21.02%)
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:
[
  "maria solo"
  "maria solo"
  "maria solo"
  20
]
7.23 ms
(6.81%)
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
  631464
  597194
  806996
  790726
  769293
  531904
  596634
  813597
  774085
  799034
  710889
  383299
  769328
  769325
  774211
  429800
  806577
  388081
  670364
  579506
  620901
  601950
  546422
  557520
  575397
  587506
  772621
  533800
  621085
  650270
  384836
  390259
  401022
  648516
  426124
  411161
  154451
  425379
  465557
  599064
  522641
  418367
  418890
  590432
]
3.55 ms
(3.34%)
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
  154451
  383299
  384836
  388081
  390259
  401022
  411161
  418367
  418890
  425379
  426124
  429800
  465557
  522641
  531904
  533800
  546422
  557520
  575397
  579506
  587506
  590432
  596634
  597194
  599064
  601950
  620901
  621085
  631464
  648516
  650270
  670364
  710889
  769293
  769325
  769328
  772621
  774085
  774211
  790726
  799034
  806577
  806996
  813597
]
2.18 ms
(2.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "maria solo"
]
1.84 ms
(1.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "maria соло"
]
1.78 ms
(1.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "maria соло"
]

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.