GET https://search.jues.net/search/embeds?q=productions

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
62.66 ms
(73.72%)
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
  455326
  488724
  493810
  519392
  522466
  524350
  524352
  530993
  531998
  532017
  532018
  532029
  532030
  534192
  537118
  537132
  537900
  554403
  560865
  567209
  577398
  585431
  593336
  597216
  607037
  615640
  615813
  626340
  632025
  634178
  639269
  648219
  651621
  651666
  668986
  728474
  746797
  770160
  770389
  773841
  777358
  782432
  782472
  797667
  802451
  804721
  804734
  805207
  806676
  808135
  808217
  812658
  818363
  823370
  826910
]
8.37 ms
(9.84%)
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
  615813
  534192
  802451
  537118
  626340
  746797
  777358
  808135
  530993
  532018
  639269
  615640
  806676
  808217
  651621
  804721
  782472
  804734
  805207
  770160
  537900
  593336
  773841
  770389
  782432
  797667
  728474
  812658
  531998
  532017
  532030
  560865
  668986
  577398
  522466
  567209
  632025
  585431
  818363
  634178
  597216
  823370
  826910
  455326
  524352
  537132
  524350
  554403
  607037
  648219
  493810
  532029
  488724
  519392
  651666
]
4.18 ms
(4.92%)
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:
[
  "productions"
  "productions"
  "productions"
  20
]
2.24 ms
(2.64%)
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
  455326
  488724
  493810
  519392
  522466
  524350
  524352
  530993
  531998
  532017
  532018
  532029
  532030
  534192
  537118
  537132
  537900
  554403
  560865
  567209
  577398
  585431
  593336
  597216
  607037
  615640
  615813
  626340
  632025
  634178
  639269
  648219
  651621
  651666
  668986
  728474
  746797
  770160
  770389
  773841
  777358
  782432
  782472
  797667
  802451
  804721
  804734
  805207
  806676
  808135
  808217
  812658
  818363
  823370
  826910
]
2.15 ms
(2.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "productions"
]
2.01 ms
(2.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "productions"
]
1.82 ms
(2.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(1.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "productions"
]

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.