GET https://search.jues.net/search/embeds/3?q=%D1%80%D0%B0%D0%BA%20%D0%B3%D1%80%D1%83%D0%B4%D0%B8

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.88 ms
(83.37%)
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
  7748
  91754
  145353
  152529
  153618
  187986
  223663
  324579
  382182
  382449
  382501
  386923
  387130
  387490
  389563
  389969
  390775
  391009
  396048
  396616
  396796
  396805
  397605
  398430
  401388
  411913
  416428
  421350
  425441
  443938
  446900
  447779
  448955
  452592
  460076
  460341
  461804
  465914
  475127
  478387
  483642
  487753
  489922
  493185
  493195
  494313
  503787
  506274
  508409
  509365
  511652
  519344
  522190
  526683
  529965
  532137
  535439
  538007
  543498
  545900
  546477
  547885
  564341
  564956
  568017
  568927
  570830
  590486
  594552
  595599
  599502
  600341
  602667
  608715
  615920
  632070
  635860
  660442
  665421
  667215
  674323
  674941
  675321
  684704
  701427
  711554
  714247
  720163
  727844
  729115
  733786
  738139
  738207
  738751
  739371
  753633
  759073
  759687
  759747
  760400
  761922
  778841
  779951
  780583
  780830
  787340
  790900
  792406
  800303
  800906
  800988
  805041
  809869
  810006
  810445
  810898
  811527
  811736
  814730
]
14.31 ms
(9.40%)
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
  396796
  145353
  547885
  568017
  223663
  780583
  738207
  460341
  564956
  570830
  674941
  711554
  805041
  811736
  759687
  714247
  508409
  187986
  391009
  390775
  397605
  460076
  503787
  632070
  599502
  760400
  778841
  800906
  387490
  478387
  396048
  396616
  396805
  153618
  382182
  382501
  443938
  526683
  811527
  792406
  733786
  738751
  729115
  7748
  447779
  382449
  546477
  564341
  545900
  739371
  684704
  615920
  446900
  600341
  448955
  461804
  519344
  493195
  535439
  398430
  800988
  660442
  674323
  665421
  594552
  738139
  701427
  489922
  493185
  635860
  91754
  411913
  522190
  511652
  494313
  543498
  720163
  727844
  759747
  753633
  761922
  779951
  780830
  800303
  416428
  324579
  602667
  809869
  810445
  475127
  826039
  532137
  759073
  389969
  814730
  568927
  590486
  595599
  810006
  787340
  790900
  810898
  675321
  421350
  425441
  529965
  487753
  608715
  389563
  387130
  452592
  465914
  483642
  506274
  538007
  386923
  509365
  152529
  401388
  667215
]
3.20 ms
(2.10%)
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
  7748
  91754
  145353
  152529
  153618
  187986
  223663
  324579
  382182
  382449
  382501
  386923
  387130
  387490
  389563
  389969
  390775
  391009
  396048
  396616
  396796
  396805
  397605
  398430
  401388
  411913
  416428
  421350
  425441
  443938
  446900
  447779
  448955
  452592
  460076
  460341
  461804
  465914
  475127
  478387
  483642
  487753
  489922
  493185
  493195
  494313
  503787
  506274
  508409
  509365
  511652
  519344
  522190
  526683
  529965
  532137
  535439
  538007
  543498
  545900
  546477
  547885
  564341
  564956
  568017
  568927
  570830
  590486
  594552
  595599
  599502
  600341
  602667
  608715
  615920
  632070
  635860
  660442
  665421
  667215
  674323
  674941
  675321
  684704
  701427
  711554
  714247
  720163
  727844
  729115
  733786
  738139
  738207
  738751
  739371
  753633
  759073
  759687
  759747
  760400
  761922
  778841
  779951
  780583
  780830
  787340
  790900
  792406
  800303
  800906
  800988
  805041
  809869
  810006
  810445
  810898
  811527
  811736
  814730
]
2.14 ms
(1.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.14 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "рак груди"
]
1.85 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак сиськ"
]
1.66 ms
(1.09%)
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.