GET https://search.jues.net/search/embeds/4?q=%D1%81%20%D0%BF%D0%B5%D1%80%D0%B2%D1%8B%D0%BC

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
113.45 ms
(79.34%)
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
  487422
  488468
  503705
  528875
  528997
  531807
  533100
  539541
  553757
  553886
  555277
  556056
  560987
  563328
  565070
  565199
  567684
  574116
  577838
  630089
  648512
  652188
  653359
  653398
  655163
  655296
  656144
  656557
  656563
  660081
  661936
  664410
  665760
  666654
  675612
  677354
  680097
  682080
  682227
  683061
  684455
  686521
  696511
  701541
  702914
  705225
  708087
  715765
  715907
  716845
  717654
  719435
  720158
  720458
  722632
  722636
  723597
  724862
  725085
  725347
  726438
  727352
  728556
  729814
  731380
  731434
  732369
  735377
  735961
  736176
  737290
  738486
  739320
  739913
  740823
  741319
  741981
  743083
  743092
  744159
  744923
  745835
  746967
  749807
  750161
  756884
  757038
  759299
  760186
  760361
  760964
  761983
  762768
  764105
  765412
  766389
  766670
  768062
  768066
  770473
  771430
  772411
  773654
  776029
  778547
  778946
  781762
  785616
  788633
  791675
  794198
  800035
  800432
  804956
  807586
  809764
  811509
  811893
  812140
  814280
]
19.93 ms
(13.94%)
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
  776029
  778547
  785616
  800432
  727352
  732369
  736176
  740823
  741981
  743092
  756884
  760964
  764105
  770473
  771430
  781762
  791675
  794198
  807586
  811509
  811893
  731380
  735377
  743083
  744159
  760186
  762768
  766670
  768062
  724862
  725347
  726438
  729814
  731434
  739913
  744923
  745835
  746967
  765412
  766389
  773654
  738486
  739320
  760361
  772411
  725085
  728556
  735961
  737290
  741319
  749807
  750161
  757038
  759299
  761983
  768066
  630089
  717654
  720158
  778946
  788633
  800035
  804956
  809764
  812140
  723597
  814280
  487422
  488468
  528997
  531807
  539541
  503705
  528875
  533100
  563328
  565070
  574116
  555277
  560987
  577838
  553757
  553886
  556056
  565199
  567684
  648512
  656557
  661936
  675612
  683061
  705225
  708087
  719435
  720458
  722632
  653359
  653398
  655296
  656144
  656563
  665760
  666654
  677354
  682080
  686521
  696511
  701541
  702914
  715765
  715907
  716845
  722636
  652188
  655163
  660081
  664410
  680097
  682227
  684455
]
2.79 ms
(1.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с первым"
]
2.29 ms
(1.60%)
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
  487422
  488468
  503705
  528875
  528997
  531807
  533100
  539541
  553757
  553886
  555277
  556056
  560987
  563328
  565070
  565199
  567684
  574116
  577838
  630089
  648512
  652188
  653359
  653398
  655163
  655296
  656144
  656557
  656563
  660081
  661936
  664410
  665760
  666654
  675612
  677354
  680097
  682080
  682227
  683061
  684455
  686521
  696511
  701541
  702914
  705225
  708087
  715765
  715907
  716845
  717654
  719435
  720158
  720458
  722632
  722636
  723597
  724862
  725085
  725347
  726438
  727352
  728556
  729814
  731380
  731434
  732369
  735377
  735961
  736176
  737290
  738486
  739320
  739913
  740823
  741319
  741981
  743083
  743092
  744159
  744923
  745835
  746967
  749807
  750161
  756884
  757038
  759299
  760186
  760361
  760964
  761983
  762768
  764105
  765412
  766389
  766670
  768062
  768066
  770473
  771430
  772411
  773654
  776029
  778547
  778946
  781762
  785616
  788633
  791675
  794198
  800035
  800432
  804956
  807586
  809764
  811509
  811893
  812140
  814280
]
1.64 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "перв"
]
1.52 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.96%)
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.