GET https://search.jues.net/search/embeds/3?q=%D0%BD%D0%B0%20%D0%B4%D0%BE%D0%BC%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.84 ms
(84.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
  133235
  199286
  203645
  305464
  384786
  401126
  410688
  414432
  419334
  423464
  427738
  435166
  445106
  445766
  446805
  450077
  451001
  454479
  457966
  458494
  458533
  458878
  458899
  459022
  459415
  460790
  462937
  463155
  463305
  463758
  468267
  469013
  473342
  473344
  480924
  480991
  484329
  486200
  486643
  487712
  490070
  490607
  493006
  495259
  495324
  496607
  500638
  502560
  505202
  505538
  510244
  515674
  515707
  516689
  517864
  518947
  520903
  523709
  525453
  525898
  530423
  531814
  533325
  537107
  538021
  547964
  548740
  551228
  552604
  555663
  566081
  568915
  573416
  582808
  586366
  598463
  601721
  609689
  641554
  642527
  645138
  655188
  666496
  669458
  674474
  686011
  689561
  691878
  696126
  707510
  710403
  715041
  718788
  725098
  725477
  725568
  726701
  731105
  733142
  738301
  742059
  747313
  750308
  750587
  752108
  754168
  765870
  769133
  773553
  774227
  781150
  784856
  787284
  787950
  788887
  790460
  792080
  792817
  807247
  812763
]
14.94 ms
(9.63%)
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
  505538
  518947
  691878
  486200
  707510
  645138
  641554
  459022
  457966
  642527
  486643
  582808
  552604
  725477
  750308
  725098
  555663
  515674
  525453
  715041
  784856
  787284
  807247
  742059
  765870
  419334
  790460
  446805
  551228
  573416
  788887
  502560
  496607
  689561
  696126
  686011
  459415
  473344
  463155
  484329
  454479
  530423
  750587
  773553
  747313
  674474
  666496
  787950
  774227
  733142
  726701
  510244
  601721
  462937
  458533
  450077
  568915
  427738
  460790
  515707
  384786
  525898
  451001
  523709
  500638
  445766
  480924
  473342
  490607
  538021
  423464
  458899
  458878
  493006
  533325
  548740
  203645
  655188
  516689
  586366
  792080
  731105
  812763
  445106
  752108
  710403
  401126
  469013
  537107
  725568
  792817
  463758
  495259
  781150
  609689
  754168
  468267
  505202
  520903
  133235
  410688
  414432
  487712
  517864
  566081
  463305
  495324
  718788
  305464
  490070
  480991
  531814
  547964
  598463
  738301
  435166
  199286
  669458
  769133
  458494
]
3.09 ms
(1.99%)
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
  133235
  199286
  203645
  305464
  384786
  401126
  410688
  414432
  419334
  423464
  427738
  435166
  445106
  445766
  446805
  450077
  451001
  454479
  457966
  458494
  458533
  458878
  458899
  459022
  459415
  460790
  462937
  463155
  463305
  463758
  468267
  469013
  473342
  473344
  480924
  480991
  484329
  486200
  486643
  487712
  490070
  490607
  493006
  495259
  495324
  496607
  500638
  502560
  505202
  505538
  510244
  515674
  515707
  516689
  517864
  518947
  520903
  523709
  525453
  525898
  530423
  531814
  533325
  537107
  538021
  547964
  548740
  551228
  552604
  555663
  566081
  568915
  573416
  582808
  586366
  598463
  601721
  609689
  641554
  642527
  645138
  655188
  666496
  669458
  674474
  686011
  689561
  691878
  696126
  707510
  710403
  715041
  718788
  725098
  725477
  725568
  726701
  731105
  733142
  738301
  742059
  747313
  750308
  750587
  752108
  754168
  765870
  769133
  773553
  774227
  781150
  784856
  787284
  787950
  788887
  790460
  792080
  792817
  807247
  812763
]
1.76 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "на дому"
]
1.71 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на домашн любительск"
]
1.54 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.28 ms
(0.82%)
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.