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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.25 ms
(83.54%)
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
  460298
  520616
  526681
  528979
  528999
  529037
  530415
  537283
  542001
  546757
  548965
  552430
  555731
  555769
  559538
  583175
  583432
  584620
  588819
  589326
  592802
  602684
  610493
  613989
  614552
  614915
  620468
  620488
  622485
  624784
  628574
  632793
  637123
  637609
  639299
  640899
  643783
  649548
  657130
  659471
  660321
  664454
  667084
  667331
  669343
  670255
  672676
  682884
  685232
  685515
  690676
  695093
  700097
  704464
  705224
  717099
  717666
  718957
  721102
  724072
  725313
  728122
  731324
  732611
  734732
  737426
  738995
  742216
  744477
  747491
  748795
  750550
  750604
  751021
  752890
  753912
  756102
  757043
  760894
  762792
  764120
  765452
  765816
  766372
  766684
  767016
  767019
  767363
  769850
  770285
  770777
  772193
  776013
  777609
  779019
  779977
  781025
  781057
  786992
  790384
  790984
  791004
  792734
  794636
  795899
  798419
  798944
  800439
  800713
  801024
  801784
  803487
  804731
  807077
  810290
  810333
  811332
  813447
  813592
  813648
]
12.20 ms
(8.62%)
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
  790384
  798944
  800439
  800713
  801024
  813447
  725313
  756102
  762792
  769850
  770777
  810290
  724072
  728122
  732611
  744477
  750550
  765452
  767016
  734732
  737426
  738995
  742216
  753912
  757043
  760894
  764120
  766372
  766684
  748795
  751021
  765816
  772193
  731324
  747491
  750604
  752890
  767019
  767363
  770285
  624784
  721102
  777609
  779977
  781025
  781057
  786992
  790984
  792734
  794636
  801784
  807077
  546757
  637123
  813648
  813592
  460298
  520616
  529037
  526681
  528979
  537283
  528999
  530415
  552430
  555769
  542001
  559538
  584620
  555731
  583432
  659471
  664454
  669343
  672676
  682884
  690676
  695093
  717099
  649548
  657130
  667084
  667331
  685232
  700097
  704464
  705224
  660321
  670255
  685515
  717666
  718957
  548965
  583175
  628574
  610493
  620468
  620488
  622485
  637609
  639299
  588819
  592802
  613989
  614915
  632793
  589326
  602684
  614552
  640899
  643783
  776013
  779019
  791004
  795899
  798419
  803487
  804731
  810333
  811332
]
3.04 ms
(2.14%)
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
  460298
  520616
  526681
  528979
  528999
  529037
  530415
  537283
  542001
  546757
  548965
  552430
  555731
  555769
  559538
  583175
  583432
  584620
  588819
  589326
  592802
  602684
  610493
  613989
  614552
  614915
  620468
  620488
  622485
  624784
  628574
  632793
  637123
  637609
  639299
  640899
  643783
  649548
  657130
  659471
  660321
  664454
  667084
  667331
  669343
  670255
  672676
  682884
  685232
  685515
  690676
  695093
  700097
  704464
  705224
  717099
  717666
  718957
  721102
  724072
  725313
  728122
  731324
  732611
  734732
  737426
  738995
  742216
  744477
  747491
  748795
  750550
  750604
  751021
  752890
  753912
  756102
  757043
  760894
  762792
  764120
  765452
  765816
  766372
  766684
  767016
  767019
  767363
  769850
  770285
  770777
  772193
  776013
  777609
  779019
  779977
  781025
  781057
  786992
  790384
  790984
  791004
  792734
  794636
  795899
  798419
  798944
  800439
  800713
  801024
  801784
  803487
  804731
  807077
  810290
  810333
  811332
  813447
  813592
  813648
]
2.20 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с первым"
]
2.00 ms
(1.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "перв"
]
1.97 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.33%)
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.