GET https://search.jues.net/search/embeds/7?q=%D0%B2%20%D0%BA%D0%BE%D0%BC%D0%BD%D0%B0%D1%82%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.64 ms
(86.01%)
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
  282218
  386142
  387366
  389171
  394488
  396236
  396308
  400138
  410682
  410995
  411468
  416288
  418494
  418958
  420398
  426030
  427786
  429880
  439638
  445220
  445228
  445803
  446331
  448711
  450226
  451452
  454212
  455504
  456865
  458974
  460752
  463673
  465162
  465333
  466386
  467934
  469303
  474875
  476349
  481162
  483502
  484607
  486259
  486763
  489691
  490380
  491290
  491508
  491535
  496182
  496397
  500077
  500571
  500995
  505639
  506044
  506821
  507211
  508856
  510612
  512322
  512369
  512606
  512843
  512897
  513781
  514797
  515745
  521492
  521759
  521820
  522284
  522767
  524052
  524109
  524456
  526663
  526774
  526818
  526886
  529171
  529187
  538237
  540779
  545622
  548191
  549159
  551617
  560470
  561470
  561985
  562775
  565565
  567382
  567677
  570407
  570839
  570878
  571464
  576052
  576344
  577377
  588376
  590345
  594087
  596453
  600456
  601364
  601551
  602971
  611290
  617188
  622704
  654786
  657768
  661989
  693965
  739090
  795880
]
17.65 ms
(8.89%)
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
  446331
  456865
  282218
  400138
  389171
  394488
  410995
  469303
  418958
  465162
  522767
  513781
  538237
  524052
  549159
  491290
  521492
  657768
  529171
  507211
  416288
  445228
  455504
  486259
  571464
  601364
  463673
  506044
  505639
  427786
  474875
  512369
  515745
  476349
  561470
  560470
  654786
  567382
  596453
  590345
  622704
  617188
  467934
  396236
  450226
  420398
  486763
  483502
  512606
  522284
  491535
  500571
  500995
  739090
  387366
  521820
  567677
  576052
  576344
  693965
  661989
  565565
  577377
  600456
  602971
  594087
  460752
  445220
  458974
  466386
  411468
  418494
  429880
  526818
  484607
  496182
  506821
  512322
  510612
  524109
  508856
  529187
  386142
  448711
  445803
  496397
  521759
  570407
  570839
  588376
  611290
  426030
  451452
  439638
  500077
  524456
  490380
  514797
  489691
  526886
  512897
  795880
  551617
  561985
  454212
  548191
  570878
  545622
  562775
  601551
  465333
  481162
  526663
  491508
  512843
  526774
  766674
  396308
  410682
  540779
]
2.74 ms
(1.38%)
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
  282218
  386142
  387366
  389171
  394488
  396236
  396308
  400138
  410682
  410995
  411468
  416288
  418494
  418958
  420398
  426030
  427786
  429880
  439638
  445220
  445228
  445803
  446331
  448711
  450226
  451452
  454212
  455504
  456865
  458974
  460752
  463673
  465162
  465333
  466386
  467934
  469303
  474875
  476349
  481162
  483502
  484607
  486259
  486763
  489691
  490380
  491290
  491508
  491535
  496182
  496397
  500077
  500571
  500995
  505639
  506044
  506821
  507211
  508856
  510612
  512322
  512369
  512606
  512843
  512897
  513781
  514797
  515745
  521492
  521759
  521820
  522284
  522767
  524052
  524109
  524456
  526663
  526774
  526818
  526886
  529171
  529187
  538237
  540779
  545622
  548191
  549159
  551617
  560470
  561470
  561985
  562775
  565565
  567382
  567677
  570407
  570839
  570878
  571464
  576052
  576344
  577377
  588376
  590345
  594087
  596453
  600456
  601364
  601551
  602971
  611290
  617188
  622704
  654786
  657768
  661989
  693965
  739090
  795880
]
1.85 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "в комнат"
]
1.84 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в комнат"
]
1.84 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.