GET https://search.jues.net/search/embeds/2?q=%D0%B1%D0%B5%D0%B7%20%D1%8E%D0%B1%D0%BA%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
250.30 ms
(91.27%)
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
  6765
  66348
  86315
  188282
  311746
  386583
  393582
  394138
  420044
  421553
  423770
  429859
  442573
  443433
  445374
  447966
  462406
  463398
  463409
  471038
  498542
  498786
  514620
  516149
  518810
  523813
  524733
  529015
  530641
  533756
  534474
  536005
  541815
  544922
  549482
  553571
  554126
  555032
  555657
  557186
  559068
  559223
  560305
  560456
  560826
  574646
  577698
  580025
  584485
  591838
  606263
  606628
  607836
  607845
  617242
  618985
  620129
  621663
  623071
  627790
  636959
  639282
  640507
  641378
  641509
  644840
  668734
  669880
  671572
  682728
  683036
  685204
  689161
  697614
  702258
  702380
  703016
  704442
  716823
  720356
  725508
  725529
  728090
  730517
  733982
  734995
  735659
  735870
  737637
  738000
  741257
  741857
  746188
  746575
  746873
  747999
  749207
  751372
  753176
  753946
  757111
  758318
  759164
  759837
  760883
  766487
  771491
  774020
  780887
  783091
  783345
  789335
  791314
  793141
  795984
  796752
  797906
  799870
  813404
]
14.71 ms
(5.36%)
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
  741257
  759837
  728090
  734995
  746188
  423770
  555657
  557186
  463409
  559223
  443433
  529015
  534474
  549482
  671572
  702380
  620129
  730517
  747999
  311746
  421553
  533756
  498542
  524733
  530641
  462406
  541815
  668734
  704442
  720356
  683036
  553571
  606628
  618985
  623071
  606263
  607845
  641509
  640507
  793141
  796752
  783091
  799870
  746873
  766487
  735659
  737637
  725529
  735870
  746575
  751372
  641378
  702258
  386583
  442573
  559068
  621663
  429859
  498786
  66348
  463398
  544922
  574646
  636959
  607836
  725213
  733982
  749207
  789335
  760883
  759164
  617242
  393582
  445374
  514620
  518810
  516149
  584485
  560456
  580025
  716823
  703016
  682728
  689161
  555032
  591838
  627790
  639282
  791314
  813404
  753946
  771491
  774020
  783345
  795984
  741857
  738000
  725508
  753176
  757111
  758318
  394138
  523813
  644840
  554126
  780887
  797906
  188282
  86315
  6765
  420044
  447966
  536005
  471038
  560826
  577698
  560305
  669880
  685204
  697614
]
2.99 ms
(1.09%)
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
  6765
  66348
  86315
  188282
  311746
  386583
  393582
  394138
  420044
  421553
  423770
  429859
  442573
  443433
  445374
  447966
  462406
  463398
  463409
  471038
  498542
  498786
  514620
  516149
  518810
  523813
  524733
  529015
  530641
  533756
  534474
  536005
  541815
  544922
  549482
  553571
  554126
  555032
  555657
  557186
  559068
  559223
  560305
  560456
  560826
  574646
  577698
  580025
  584485
  591838
  606263
  606628
  607836
  607845
  617242
  618985
  620129
  621663
  623071
  627790
  636959
  639282
  640507
  641378
  641509
  644840
  668734
  669880
  671572
  682728
  683036
  685204
  689161
  697614
  702258
  702380
  703016
  704442
  716823
  720356
  725508
  725529
  728090
  730517
  733982
  734995
  735659
  735870
  737637
  738000
  741257
  741857
  746188
  746575
  746873
  747999
  749207
  751372
  753176
  753946
  757111
  758318
  759164
  759837
  760883
  766487
  771491
  774020
  780887
  783091
  783345
  789335
  791314
  793141
  795984
  796752
  797906
  799870
  813404
]
1.67 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "без юбки"
]
1.66 ms
(0.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "без юбк"
]
1.49 ms
(0.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(0.53%)
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.