GET https://search.jues.net/search/embeds/2?q=%D0%BF%D0%B8%D0%BA%D0%B0%D0%BF%20%D1%85%D1%85%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.40 ms
(84.60%)
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
  3
  4073
  27635
  28382
  28397
  29242
  34170
  35405
  40927
  58516
  61866
  69704
  123457
  172024
  185428
  191207
  194652
  223442
  228398
  326189
  350664
  359723
  362958
  372986
  382212
  382383
  382540
  382602
  383315
  383498
  383763
  385269
  385728
  385781
  388124
  389158
  389517
  391101
  391315
  391526
  393792
  396535
  397424
  397498
  397700
  398423
  398697
  401940
  403281
  409121
  409174
  413245
  418723
  428423
  455865
  457796
  460147
  461590
  461773
  462964
  469802
  477141
  488586
  502252
  503061
  503570
  504542
  528720
  528772
  528999
  533157
  537003
  572424
  573565
  611782
  614217
  663358
  663960
  664804
  665103
  667640
  668899
  670514
  671094
  672422
  694432
  705746
  710511
  716516
  717721
  718002
  720834
  725518
  725922
  727352
  728246
  728681
  734379
  735375
  735716
  742126
  748126
  748177
  753397
  757045
  757606
  761151
  761303
  761968
  766458
  771963
  776605
  787893
  788488
  791363
  818671
  818786
  820523
  821538
  821661
]
15.18 ms
(9.08%)
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
  717721
  191207
  460147
  40927
  185428
  383498
  61866
  3
  573565
  362958
  385269
  194652
  382540
  385728
  123457
  391526
  398423
  409174
  409121
  503061
  528772
  528999
  537003
  716516
  664804
  665103
  668899
  672422
  663960
  694432
  718002
  572424
  727352
  728681
  791363
  742126
  771963
  734379
  725518
  725922
  735716
  748126
  761151
  761303
  787893
  788488
  382602
  389517
  350664
  413245
  393792
  401940
  428423
  457796
  35405
  383315
  398697
  385781
  383763
  372986
  382383
  391101
  396535
  397498
  818786
  820523
  528720
  670514
  671094
  705746
  710511
  663358
  667640
  720834
  611782
  614217
  776605
  757045
  748177
  766458
  761968
  728246
  753397
  757606
  735375
  34170
  228398
  388124
  69704
  391315
  397700
  403281
  488586
  27635
  28382
  29242
  455865
  462964
  4073
  359723
  461590
  469802
  461773
  397424
  382212
  389158
  418723
  504542
  172024
  326189
  28397
  58516
  223442
  821661
  818671
  821538
  477141
  533157
  502252
  503570
]
2.93 ms
(1.75%)
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
  3
  4073
  27635
  28382
  28397
  29242
  34170
  35405
  40927
  58516
  61866
  69704
  123457
  172024
  185428
  191207
  194652
  223442
  228398
  326189
  350664
  359723
  362958
  372986
  382212
  382383
  382540
  382602
  383315
  383498
  383763
  385269
  385728
  385781
  388124
  389158
  389517
  391101
  391315
  391526
  393792
  396535
  397424
  397498
  397700
  398423
  398697
  401940
  403281
  409121
  409174
  413245
  418723
  428423
  455865
  457796
  460147
  461590
  461773
  462964
  469802
  477141
  488586
  502252
  503061
  503570
  504542
  528720
  528772
  528999
  533157
  537003
  572424
  573565
  611782
  614217
  663358
  663960
  664804
  665103
  667640
  668899
  670514
  671094
  672422
  694432
  705746
  710511
  716516
  717721
  718002
  720834
  725518
  725922
  727352
  728246
  728681
  734379
  735375
  735716
  742126
  748126
  748177
  753397
  757045
  757606
  761151
  761303
  761968
  766458
  771963
  776605
  787893
  788488
  791363
  818671
  818786
  820523
  821538
  821661
]
2.12 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "пикап ххх"
]
1.96 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пикап ххх"
]
1.83 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.03%)
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.