GET https://search.jues.net/search/embeds/5?q=%D0%B4%D0%B2%D1%83%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.42 ms
(86.81%)
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
  11320
  114557
  183074
  192968
  341546
  383250
  387221
  387576
  389197
  391202
  393460
  393765
  394227
  395539
  397699
  398878
  401820
  401840
  402207
  402664
  402672
  403979
  405324
  405360
  406711
  407290
  407324
  409163
  411030
  411947
  413240
  418725
  425684
  444127
  446314
  450189
  456952
  459086
  462525
  466382
  466640
  467758
  469084
  470607
  470608
  471526
  475695
  481099
  482147
  484802
  486161
  489241
  493488
  494277
  506552
  511384
  511864
  515236
  524745
  527231
  543971
  543982
  548727
  551186
  551269
  555664
  556063
  559716
  559841
  564894
  566997
  570418
  574079
  575059
  575765
  575787
  578363
  578380
  581001
  581145
  592307
  607376
  607403
  611307
  615883
  618882
  630638
  633022
  635584
  650793
  665921
  666828
  667875
  667878
  668542
  693073
  714199
  716856
  720188
  722903
  732055
  734428
  737332
  741196
  748251
  765841
  775834
  783109
  784247
  789711
  790213
  796250
  800240
  800610
  802112
  802343
  803454
  809301
  809439
  812796
]
14.75 ms
(8.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
  469084
  475695
  481099
  486161
  493488
  466382
  471526
  450189
  456952
  470607
  489241
  494277
  506552
  511384
  515236
  511864
  527231
  524745
  484802
  543982
  551186
  555664
  556063
  564894
  574079
  578363
  578380
  559716
  575059
  581145
  543971
  570418
  575765
  575787
  581001
  667878
  716856
  665921
  666828
  667875
  668542
  693073
  714199
  650793
  722903
  548727
  551269
  559841
  566997
  611307
  607376
  592307
  615883
  630638
  618882
  775834
  784247
  809439
  812796
  734428
  748251
  765841
  783109
  796250
  800240
  802112
  802343
  741196
  732055
  737332
  607403
  633022
  635584
  720188
  789711
  790213
  800610
  803454
  809301
  387221
  394227
  401840
  407290
  407324
  411947
  418725
  425684
  470608
  482147
  192968
  397699
  405324
  405360
  459086
  462525
  341546
  391202
  393460
  393765
  398878
  402207
  402672
  444127
  446314
  466640
  467758
  11320
  114557
  183074
  383250
  387576
  389197
  395539
  401820
  402664
  403979
  406711
  409163
  411030
  413240
]
2.95 ms
(1.62%)
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
  11320
  114557
  183074
  192968
  341546
  383250
  387221
  387576
  389197
  391202
  393460
  393765
  394227
  395539
  397699
  398878
  401820
  401840
  402207
  402664
  402672
  403979
  405324
  405360
  406711
  407290
  407324
  409163
  411030
  411947
  413240
  418725
  425684
  444127
  446314
  450189
  456952
  459086
  462525
  466382
  466640
  467758
  469084
  470607
  470608
  471526
  475695
  481099
  482147
  484802
  486161
  489241
  493488
  494277
  506552
  511384
  511864
  515236
  524745
  527231
  543971
  543982
  548727
  551186
  551269
  555664
  556063
  559716
  559841
  564894
  566997
  570418
  574079
  575059
  575765
  575787
  578363
  578380
  581001
  581145
  592307
  607376
  607403
  611307
  615883
  618882
  630638
  633022
  635584
  650793
  665921
  666828
  667875
  667878
  668542
  693073
  714199
  716856
  720188
  722903
  732055
  734428
  737332
  741196
  748251
  765841
  775834
  783109
  784247
  789711
  790213
  796250
  800240
  800610
  802112
  802343
  803454
  809301
  809439
  812796
]
2.05 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "двух"
]
1.58 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "двух"
]
1.40 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "двух"
]
1.33 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.