GET https://search.jues.net/search/embeds/5?q=%D0%BD%D0%BE%D0%B3%D0%BE

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.93 ms
(81.94%)
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
  392207
  399904
  409640
  412886
  415965
  417084
  420330
  434946
  440079
  440904
  443117
  449822
  453314
  454743
  458115
  474026
  477261
  477703
  488176
  491783
  500015
  503670
  505219
  512546
  513948
  515123
  520049
  520885
  526281
  538021
  539893
  541582
  544766
  548721
  550530
  550676
  551229
  554169
  556722
  557213
  557900
  558011
  559047
  560320
  563251
  563352
  564561
  564745
  566514
  566998
  567158
  568373
  569038
  570468
  574015
  575102
  577875
  578161
  578444
  578574
  580449
  581630
  582394
  582567
  583666
  585473
  586727
  588691
  591154
  592187
  592355
  593416
  594866
  596503
  597160
  598113
  598401
  599840
  600610
  601253
  602099
  602515
  602913
  603553
  603894
  603930
  605562
  605651
  606367
  606819
  606868
  613496
  614435
  615022
  617543
  618690
  618767
  619091
  619509
  621794
  623835
  625575
  625945
  626145
  626322
  627330
  630243
  632342
  634223
  637512
  643973
  651920
  653534
  662557
  662904
  665386
  675341
  682508
  684178
  685943
]
16.64 ms
(10.91%)
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
  491783
  550676
  551229
  554169
  557900
  558011
  567158
  569038
  578161
  581630
  582394
  582567
  564561
  566514
  566998
  570468
  574015
  575102
  541582
  544766
  548721
  550530
  560320
  563352
  564745
  577875
  651920
  662557
  682508
  653534
  665386
  685943
  662904
  675341
  684178
  556722
  557213
  559047
  563251
  568373
  578444
  578574
  580449
  583666
  588691
  593416
  597160
  606367
  619091
  621794
  623835
  625945
  626145
  643973
  592187
  598113
  598401
  599840
  602515
  603930
  615022
  618690
  626322
  627330
  634223
  586727
  592355
  596503
  601253
  606819
  606868
  619509
  625575
  630243
  637512
  585473
  591154
  594866
  600610
  602913
  603553
  605562
  605651
  613496
  614435
  617543
  618767
  602099
  603894
  632342
  399904
  409640
  443117
  454743
  420330
  449822
  500015
  512546
  513948
  488176
  520049
  392207
  434946
  412886
  417084
  440904
  415965
  440079
  453314
  477703
  458115
  474026
  477261
  515123
  520885
  526281
  538021
  539893
  503670
  505219
]
3.30 ms
(2.17%)
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
  392207
  399904
  409640
  412886
  415965
  417084
  420330
  434946
  440079
  440904
  443117
  449822
  453314
  454743
  458115
  474026
  477261
  477703
  488176
  491783
  500015
  503670
  505219
  512546
  513948
  515123
  520049
  520885
  526281
  538021
  539893
  541582
  544766
  548721
  550530
  550676
  551229
  554169
  556722
  557213
  557900
  558011
  559047
  560320
  563251
  563352
  564561
  564745
  566514
  566998
  567158
  568373
  569038
  570468
  574015
  575102
  577875
  578161
  578444
  578574
  580449
  581630
  582394
  582567
  583666
  585473
  586727
  588691
  591154
  592187
  592355
  593416
  594866
  596503
  597160
  598113
  598401
  599840
  600610
  601253
  602099
  602515
  602913
  603553
  603894
  603930
  605562
  605651
  606367
  606819
  606868
  613496
  614435
  615022
  617543
  618690
  618767
  619091
  619509
  621794
  623835
  625575
  625945
  626145
  626322
  627330
  630243
  632342
  634223
  637512
  643973
  651920
  653534
  662557
  662904
  665386
  675341
  682508
  684178
  685943
]
2.40 ms
(1.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ного"
]
1.79 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ног"
]
1.75 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.08%)
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.