GET https://search.jues.net/search/embeds/3?q=%D0%B3%D0%BE%D1%80%D1%8F%D1%87%D1%83%D1%8E

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.59 ms
(85.97%)
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
  520609
  531679
  532531
  533495
  535364
  546587
  551024
  554120
  554176
  562593
  565228
  566398
  566433
  570686
  573104
  576778
  577296
  582843
  583744
  585665
  593360
  596164
  599599
  601147
  602582
  612273
  613712
  615763
  624462
  624722
  626187
  627655
  628030
  634954
  635846
  637756
  639355
  639966
  646041
  646886
  650970
  665626
  665749
  670424
  671107
  672410
  675746
  680583
  692270
  693295
  696525
  699672
  705425
  708107
  710453
  712137
  713657
  715161
  717833
  717904
  718606
  719786
  720002
  721200
  722161
  722162
  722440
  723995
  732568
  732620
  733650
  734217
  735465
  737949
  738178
  741142
  742027
  746623
  748515
  755367
  760455
  762896
  764988
  770154
  773159
  773213
  773380
  773469
  776686
  777460
  777949
  778968
  779220
  779335
  780947
  781113
  782779
  791434
  792676
  793007
  794377
  795121
  795223
  795285
  795880
  796000
  796754
  797524
  797582
  799403
  801860
  802399
  802725
  804370
  805338
  811917
  812338
  813642
  813857
  813865
]
12.12 ms
(7.20%)
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
  566433
  576778
  570686
  692270
  722161
  593360
  635846
  628030
  612273
  797582
  804370
  732620
  738178
  723995
  733650
  755367
  746623
  613712
  615763
  705425
  717833
  722440
  532531
  601147
  813642
  813857
  813865
  535364
  562593
  554176
  565228
  671107
  699672
  670424
  717904
  675746
  712137
  713657
  624722
  626187
  634954
  602582
  627655
  637756
  776686
  780947
  791434
  793007
  794377
  799403
  811917
  777949
  795121
  734217
  760455
  773213
  792676
  795880
  796754
  797524
  737949
  741142
  742027
  773159
  773469
  732568
  748515
  762896
  770154
  773380
  708107
  520609
  533495
  531679
  546587
  551024
  554120
  582843
  566398
  573104
  577296
  583744
  646886
  665749
  646041
  650970
  665626
  672410
  710453
  720002
  680583
  693295
  696525
  715161
  718606
  719786
  721200
  722162
  585665
  596164
  599599
  639966
  624462
  639355
  778968
  795223
  796000
  801860
  802399
  802725
  777460
  779220
  779335
  781113
  782779
  795285
  805338
  812338
  735465
  764988
]
3.38 ms
(2.01%)
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
  520609
  531679
  532531
  533495
  535364
  546587
  551024
  554120
  554176
  562593
  565228
  566398
  566433
  570686
  573104
  576778
  577296
  582843
  583744
  585665
  593360
  596164
  599599
  601147
  602582
  612273
  613712
  615763
  624462
  624722
  626187
  627655
  628030
  634954
  635846
  637756
  639355
  639966
  646041
  646886
  650970
  665626
  665749
  670424
  671107
  672410
  675746
  680583
  692270
  693295
  696525
  699672
  705425
  708107
  710453
  712137
  713657
  715161
  717833
  717904
  718606
  719786
  720002
  721200
  722161
  722162
  722440
  723995
  732568
  732620
  733650
  734217
  735465
  737949
  738178
  741142
  742027
  746623
  748515
  755367
  760455
  762896
  764988
  770154
  773159
  773213
  773380
  773469
  776686
  777460
  777949
  778968
  779220
  779335
  780947
  781113
  782779
  791434
  792676
  793007
  794377
  795121
  795223
  795285
  795880
  796000
  796754
  797524
  797582
  799403
  801860
  802399
  802725
  804370
  805338
  811917
  812338
  813642
  813857
  813865
]
2.28 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "горячую"
]
2.22 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "горяч"
]
1.62 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.