GET https://search.jues.net/search/embeds/3?q=%D1%81%20%D1%85%D1%83%D0%B4%D0%BE%D0%B9

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.94 ms
(82.75%)
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
  2208
  276696
  325743
  382276
  383320
  383581
  387883
  388108
  388925
  389861
  391186
  392413
  393442
  394361
  396378
  396748
  397389
  400473
  401350
  401979
  402060
  407618
  407786
  408331
  409372
  409613
  412315
  413967
  417023
  417848
  418970
  425061
  428141
  429095
  429244
  429573
  429611
  435239
  439729
  441224
  443116
  443723
  446049
  447628
  447869
  448877
  449327
  449992
  452208
  456198
  456641
  457133
  457311
  458170
  458830
  461500
  463120
  466029
  466526
  467069
  467361
  469863
  471893
  472560
  472796
  473803
  475725
  478865
  481292
  484872
  485930
  486949
  487287
  488651
  488902
  489157
  489324
  490653
  490839
  491958
  492081
  493134
  496796
  499008
  499552
  501169
  506206
  506875
  510535
  510643
  511064
  511188
  515310
  522327
  526393
  544521
  546745
  548620
  549773
  557910
  559985
  561701
  570310
  570648
  570649
  571876
  571924
  573093
  573306
  573559
  586638
  597114
  663386
  663410
  663857
  667829
  724050
  729886
  758230
  804876
]
16.39 ms
(10.77%)
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
  485930
  491958
  515310
  496796
  506875
  463120
  467069
  488902
  546745
  548620
  549773
  557910
  570648
  559985
  571924
  573093
  573306
  544521
  561701
  570649
  663410
  663857
  663386
  667829
  570310
  571876
  573559
  586638
  597114
  724050
  729886
  804876
  758230
  402060
  469863
  473803
  388108
  408331
  409613
  429095
  429573
  456198
  2208
  401350
  458170
  461500
  382276
  388925
  409372
  439729
  443723
  472796
  417023
  466029
  522327
  490653
  490839
  511188
  489157
  499552
  510643
  511064
  526393
  484872
  492081
  501169
  506206
  510535
  383581
  383320
  394361
  393442
  392413
  276696
  325743
  389861
  391186
  387883
  396378
  397389
  396748
  400473
  401979
  407618
  441224
  418970
  429244
  407786
  413967
  443116
  417848
  429611
  435239
  412315
  425061
  428141
  447869
  471893
  475725
  481292
  486949
  493134
  446049
  447628
  449327
  452208
  457133
  458830
  466526
  467361
  487287
  489324
  448877
  449992
  456641
  457311
  472560
  478865
  488651
  499008
]
3.26 ms
(2.14%)
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
  2208
  276696
  325743
  382276
  383320
  383581
  387883
  388108
  388925
  389861
  391186
  392413
  393442
  394361
  396378
  396748
  397389
  400473
  401350
  401979
  402060
  407618
  407786
  408331
  409372
  409613
  412315
  413967
  417023
  417848
  418970
  425061
  428141
  429095
  429244
  429573
  429611
  435239
  439729
  441224
  443116
  443723
  446049
  447628
  447869
  448877
  449327
  449992
  452208
  456198
  456641
  457133
  457311
  458170
  458830
  461500
  463120
  466029
  466526
  467069
  467361
  469863
  471893
  472560
  472796
  473803
  475725
  478865
  481292
  484872
  485930
  486949
  487287
  488651
  488902
  489157
  489324
  490653
  490839
  491958
  492081
  493134
  496796
  499008
  499552
  501169
  506206
  506875
  510535
  510643
  511064
  511188
  515310
  522327
  526393
  544521
  546745
  548620
  549773
  557910
  559985
  561701
  570310
  570648
  570649
  571876
  571924
  573093
  573306
  573559
  586638
  597114
  663386
  663410
  663857
  667829
  724050
  729886
  758230
  804876
]
1.75 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худой"
]
1.74 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с худой"
]
1.62 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.98%)
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.