GET https://search.jues.net/search/embeds/8?q=%D0%B2%20%D0%BA%D0%BE%D1%80%D0%BE%D1%82%D0%BA%D0%BE%D0%BC

Query Metrics

7 Database Queries
7 Different statements
240.72 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
217.46 ms
(90.33%)
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
  464963
  476778
  489721
  491217
  496470
  497146
  498095
  500024
  502719
  511475
  512029
  512902
  516619
  517477
  521696
  525961
  526160
  526329
  526394
  527098
  527170
  527291
  528326
  528529
  529052
  530131
  531702
  532309
  532595
  536058
  537531
  539106
  539469
  540583
  542407
  542597
  543378
  543910
  546023
  546332
  551831
  551939
  554615
  555664
  556398
  556471
  556996
  558318
  558670
  558819
  561177
  562499
  564366
  567271
  568047
  568137
  568144
  569766
  572854
  574109
  575009
  576510
  576543
  578037
  578041
  579631
  580824
  580897
  581238
  581254
  581575
  581716
  584009
  584188
  585438
  586905
  588033
  592276
  593068
  593139
  593191
  593990
  594293
  595572
  595579
  596729
  597284
  597738
  598129
  598256
  599004
  599802
  600248
  601175
  601667
  602636
  602952
  602997
  603993
  615281
  616766
  620056
  624965
  625930
  626753
  626949
  628604
  630119
  630461
  630713
  633540
  634095
  635694
  644345
  646336
  651920
  652683
  659615
  671817
]
14.35 ms
(5.96%)
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
  595579
  633540
  491217
  496470
  512902
  517477
  528326
  516619
  529052
  531702
  532595
  537531
  511475
  476778
  489721
  542407
  542597
  546023
  546332
  555664
  558819
  568144
  572854
  578037
  558318
  564366
  575009
  580897
  581716
  543378
  551939
  556471
  556996
  568137
  581238
  651920
  652683
  664464
  671817
  551831
  602997
  585438
  593191
  599802
  602636
  620056
  624965
  635694
  593990
  603993
  626753
  630119
  630461
  588033
  592276
  601175
  601667
  626949
  628604
  630713
  497146
  512029
  595572
  539106
  539469
  500024
  502719
  525961
  526160
  526394
  527098
  528529
  530131
  532309
  540583
  526329
  527170
  527291
  536058
  498095
  521696
  464963
  568047
  569766
  578041
  579631
  543910
  576543
  581254
  581575
  554615
  556398
  584009
  584188
  659615
  646336
  558670
  561177
  567271
  574109
  576510
  580824
  593139
  596729
  597738
  644345
  593068
  634095
  594293
  597284
  598256
  599004
  600248
  616766
  586905
  598129
  602952
  625930
  615281
  562499
]
2.53 ms
(1.05%)
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
  464963
  476778
  489721
  491217
  496470
  497146
  498095
  500024
  502719
  511475
  512029
  512902
  516619
  517477
  521696
  525961
  526160
  526329
  526394
  527098
  527170
  527291
  528326
  528529
  529052
  530131
  531702
  532309
  532595
  536058
  537531
  539106
  539469
  540583
  542407
  542597
  543378
  543910
  546023
  546332
  551831
  551939
  554615
  555664
  556398
  556471
  556996
  558318
  558670
  558819
  561177
  562499
  564366
  567271
  568047
  568137
  568144
  569766
  572854
  574109
  575009
  576510
  576543
  578037
  578041
  579631
  580824
  580897
  581238
  581254
  581575
  581716
  584009
  584188
  585438
  586905
  588033
  592276
  593068
  593139
  593191
  593990
  594293
  595572
  595579
  596729
  597284
  597738
  598129
  598256
  599004
  599802
  600248
  601175
  601667
  602636
  602952
  602997
  603993
  615281
  616766
  620056
  624965
  625930
  626753
  626949
  628604
  630119
  630461
  630713
  633540
  634095
  635694
  644345
  646336
  651920
  652683
  659615
  671817
]
1.88 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в короткий"
]
1.71 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в коротком"
]
1.47 ms
(0.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.