GET https://search.jues.net/search/embeds/3?q=%D0%B2%20%D0%BA%D0%BB%D1%83%D0%B1

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.77 ms
(89.51%)
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
  389014
  391772
  392581
  443323
  449690
  451538
  453925
  453947
  454523
  457332
  457343
  462317
  467678
  471366
  479381
  479405
  479558
  482379
  486444
  487122
  487710
  491022
  494276
  496722
  497963
  501005
  502279
  503659
  507341
  508480
  508978
  510380
  512452
  513377
  516839
  517092
  517105
  519171
  521661
  523293
  523306
  524006
  526492
  527352
  537424
  537749
  539139
  542213
  543171
  545819
  546747
  546776
  546779
  550511
  554301
  554566
  555668
  555698
  555895
  556007
  556209
  560113
  561117
  562665
  563897
  564320
  566284
  570110
  575265
  579764
  589277
  589767
  590591
  591817
  592321
  594979
  598857
  616445
  641480
  652539
  653861
  657737
  661925
  663537
  671245
  671442
  674905
  676308
  676760
  692711
  695780
  696395
  698129
  704966
  728523
  749662
  757698
  761228
  765930
  778519
  781444
  785591
  788085
  790138
  792354
]
12.74 ms
(5.98%)
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
  589767
  451538
  523306
  496722
  508978
  561117
  545819
  454523
  512452
  550511
  560113
  491022
  486444
  467678
  462317
  503659
  519171
  502279
  443323
  517092
  554301
  516839
  652539
  391772
  527352
  564320
  501005
  508480
  566284
  570110
  757698
  778519
  790138
  788085
  765930
  555668
  749662
  510380
  392581
  676308
  761228
  704966
  781444
  539139
  695780
  657737
  589277
  792354
  521661
  537749
  696395
  676760
  479381
  453947
  674905
  513377
  507341
  671245
  591817
  479405
  537424
  543171
  616445
  598857
  592321
  728523
  449690
  453925
  487710
  563897
  698129
  487122
  556007
  523293
  389014
  497963
  671442
  590591
  641480
  517105
  555895
  554566
  546779
  579764
  482379
  575265
  524006
  555698
  562665
  692711
  546776
  556209
  785591
  457343
  653861
  494276
  542213
  594979
  479558
  546747
  457332
  526492
  661925
  471366
  663537
]
2.65 ms
(1.24%)
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
  389014
  391772
  392581
  443323
  449690
  451538
  453925
  453947
  454523
  457332
  457343
  462317
  467678
  471366
  479381
  479405
  479558
  482379
  486444
  487122
  487710
  491022
  494276
  496722
  497963
  501005
  502279
  503659
  507341
  508480
  508978
  510380
  512452
  513377
  516839
  517092
  517105
  519171
  521661
  523293
  523306
  524006
  526492
  527352
  537424
  537749
  539139
  542213
  543171
  545819
  546747
  546776
  546779
  550511
  554301
  554566
  555668
  555698
  555895
  556007
  556209
  560113
  561117
  562665
  563897
  564320
  566284
  570110
  575265
  579764
  589277
  589767
  590591
  591817
  592321
  594979
  598857
  616445
  641480
  652539
  653861
  657737
  661925
  663537
  671245
  671442
  674905
  676308
  676760
  692711
  695780
  696395
  698129
  704966
  728523
  749662
  757698
  761228
  765930
  778519
  781444
  785591
  788085
  790138
  792354
]
2.31 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в клуб"
]
1.81 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в клуб"
]
1.52 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.35 ms
(0.63%)
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.