GET https://search.jues.net/search/embeds/7?q=%D0%B4%D0%B5%D0%BB%D0%B8%D1%82%D1%81%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.27 ms
(85.46%)
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
  186948
  386623
  390508
  390951
  421343
  423858
  424646
  435318
  435487
  444753
  453825
  457267
  458784
  458791
  460178
  462546
  463278
  471326
  483056
  495292
  497688
  497859
  498368
  508051
  510220
  516070
  522161
  522446
  523803
  527225
  528429
  528597
  528832
  532918
  533849
  535042
  541994
  542067
  546994
  550302
  550305
  557487
  557551
  559332
  559526
  561289
  564263
  565929
  566187
  566413
  568185
  572214
  573749
  573756
  579848
  580771
  582459
  589598
  590325
  600316
  611561
  614020
  620879
  623620
  625594
  629273
  629400
  632021
  634297
  635949
  650845
  652945
  653972
  654562
  656639
  656815
  663172
  668501
  670205
  670763
  673583
  681288
  693076
  693077
  706934
  710485
  713565
  719808
  721541
  722827
  730497
  732074
  742677
  742683
  748239
  748241
  748252
  748432
  751026
  753505
  755011
  755170
  755219
  758281
  761102
  762885
  762907
  766734
  781447
  790739
  795138
  799941
  800373
  802277
  804468
  809931
  809932
  814741
  814781
  814883
]
16.30 ms
(8.69%)
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
  804468
  732074
  748239
  748241
  748252
  751026
  766734
  742677
  748432
  755011
  761102
  755219
  758281
  762907
  730497
  753505
  629400
  706934
  721541
  722827
  781447
  795138
  390951
  424646
  458784
  435318
  471326
  386623
  421343
  423858
  462546
  460178
  516070
  497859
  522446
  483056
  495292
  528429
  498368
  522161
  186948
  390508
  435487
  444753
  814741
  814781
  814883
  458791
  453825
  457267
  497688
  510220
  523803
  533849
  527225
  528597
  528832
  508051
  532918
  535042
  463278
  559526
  566413
  568185
  541994
  542067
  546994
  557487
  565929
  573749
  582459
  550305
  557551
  561289
  580771
  670205
  670763
  673583
  713565
  719808
  653972
  654562
  656815
  663172
  693076
  650845
  652945
  656639
  668501
  681288
  693077
  710485
  550302
  559332
  564263
  566187
  572214
  573756
  579848
  611561
  620879
  589598
  629273
  634297
  600316
  614020
  635949
  590325
  623620
  625594
  632021
  799941
  809931
  802277
  809932
  742683
  755170
  762885
  790739
  800373
]
3.14 ms
(1.67%)
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
  186948
  386623
  390508
  390951
  421343
  423858
  424646
  435318
  435487
  444753
  453825
  457267
  458784
  458791
  460178
  462546
  463278
  471326
  483056
  495292
  497688
  497859
  498368
  508051
  510220
  516070
  522161
  522446
  523803
  527225
  528429
  528597
  528832
  532918
  533849
  535042
  541994
  542067
  546994
  550302
  550305
  557487
  557551
  559332
  559526
  561289
  564263
  565929
  566187
  566413
  568185
  572214
  573749
  573756
  579848
  580771
  582459
  589598
  590325
  600316
  611561
  614020
  620879
  623620
  625594
  629273
  629400
  632021
  634297
  635949
  650845
  652945
  653972
  654562
  656639
  656815
  663172
  668501
  670205
  670763
  673583
  681288
  693076
  693077
  706934
  710485
  713565
  719808
  721541
  722827
  730497
  732074
  742677
  742683
  748239
  748241
  748252
  748432
  751026
  753505
  755011
  755170
  755219
  758281
  761102
  762885
  762907
  766734
  781447
  790739
  795138
  799941
  800373
  802277
  804468
  809931
  809932
  814741
  814781
  814883
]
2.37 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.01 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "делится"
]
1.76 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дел"
]
1.69 ms
(0.90%)
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.