GET https://search.jues.net/search/embeds/9?q=%D0%B4%D0%B0%D1%91%D1%82%20%D0%B4%D1%80%D1%83%D0%B3%D0%BE%D0%BC%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.93 ms
(84.70%)
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
  51420
  80529
  203480
  213144
  382385
  392270
  399717
  406121
  409861
  416233
  416364
  419371
  421254
  422028
  425715
  427447
  428958
  430436
  430556
  432077
  433211
  437864
  442318
  442841
  443704
  446718
  447240
  449635
  452513
  454147
  461025
  464442
  467559
  467721
  470604
  472320
  473598
  473970
  474923
  475202
  483961
  490491
  494036
  500622
  504189
  505843
  514644
  514645
  518558
  521985
  522212
  522227
  523857
  525249
  529234
  529293
  531513
  532149
  534296
  538333
  540106
  543954
  548012
  551577
  552588
  556045
  557410
  559111
  566370
  575043
  575116
  584054
  588129
  588285
  594886
  597559
  602629
  604680
  633257
  650157
  655358
  657680
  658314
  663446
  663516
  675588
  682984
  685168
  690002
  691640
  701208
  702349
  713407
  715160
  716966
  724115
  725280
  725427
  729179
  730696
  730810
  731504
  749881
  753125
  753310
  762803
  764845
  776686
  782558
  782631
  783133
  784243
  785695
  787901
  795473
  796181
  796310
  798405
  803867
  814450
]
18.10 ms
(10.09%)
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
  416364
  430436
  443704
  454147
  474923
  409861
  428958
  467559
  470604
  437864
  446718
  467721
  473970
  392270
  416233
  442841
  447240
  452513
  464442
  504189
  514644
  518558
  521985
  522227
  505843
  522212
  500622
  382385
  532149
  543954
  663516
  702349
  663446
  685168
  716966
  691640
  776686
  796181
  785695
  762803
  782558
  796310
  730810
  749881
  731504
  730696
  713407
  203480
  80529
  814450
  483961
  584054
  575043
  557410
  682984
  690002
  715160
  701208
  588129
  604680
  633257
  782631
  787901
  798405
  803867
  725427
  783133
  795473
  725280
  753125
  753310
  764845
  729179
  724115
  784243
  419371
  427447
  433211
  472320
  449635
  531513
  525249
  461025
  548012
  559111
  566370
  575116
  552588
  650157
  657680
  658314
  655358
  675588
  551577
  556045
  588285
  602629
  594886
  597559
  425715
  422028
  421254
  432077
  442318
  475202
  399717
  406121
  473598
  430556
  514645
  523857
  538333
  494036
  529234
  534296
  529293
  213144
  51420
  490491
  540106
]
2.75 ms
(1.53%)
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
  51420
  80529
  203480
  213144
  382385
  392270
  399717
  406121
  409861
  416233
  416364
  419371
  421254
  422028
  425715
  427447
  428958
  430436
  430556
  432077
  433211
  437864
  442318
  442841
  443704
  446718
  447240
  449635
  452513
  454147
  461025
  464442
  467559
  467721
  470604
  472320
  473598
  473970
  474923
  475202
  483961
  490491
  494036
  500622
  504189
  505843
  514644
  514645
  518558
  521985
  522212
  522227
  523857
  525249
  529234
  529293
  531513
  532149
  534296
  538333
  540106
  543954
  548012
  551577
  552588
  556045
  557410
  559111
  566370
  575043
  575116
  584054
  588129
  588285
  594886
  597559
  602629
  604680
  633257
  650157
  655358
  657680
  658314
  663446
  663516
  675588
  682984
  685168
  690002
  691640
  701208
  702349
  713407
  715160
  716966
  724115
  725280
  725427
  729179
  730696
  730810
  731504
  749881
  753125
  753310
  762803
  764845
  776686
  782558
  782631
  783133
  784243
  785695
  787901
  795473
  796181
  796310
  798405
  803867
  814450
]
1.78 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "даёт другому"
]
1.60 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "друг"
]
1.55 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.