GET https://search.jues.net/search/embeds/3?q=%D0%B2%D0%B8%D1%81%D1%8F%D1%87%D0%B8%D0%B9

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.64 ms
(85.44%)
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
  461037
  461240
  466954
  470432
  472151
  472700
  476308
  485751
  500470
  500982
  503842
  505343
  505690
  505692
  506778
  510872
  510874
  512067
  512993
  513335
  514774
  517480
  517490
  517826
  518826
  518836
  518847
  518854
  520373
  520520
  524867
  524880
  525490
  528524
  529400
  534138
  543575
  546122
  546878
  547538
  548231
  548264
  549222
  551932
  553215
  554110
  554442
  554448
  554459
  554500
  554839
  555007
  555285
  555348
  555402
  556586
  557267
  558287
  559165
  560869
  561507
  562962
  562975
  563424
  565749
  566361
  567143
  567339
  570933
  570966
  573196
  577037
  577132
  578146
  579425
  581203
  582317
  582462
  584019
  584212
  585050
  588804
  589664
  589670
  590410
  590524
  591861
  592636
  593856
  598840
  601342
  603930
  604577
  605460
  605904
  612056
  612276
  612996
  614350
  620349
  622503
  625807
  644092
  644198
  652644
  663485
  663926
  664542
  664593
  664858
  665236
  665454
  667195
  667344
  667555
  668639
  668676
  675145
  690916
  766583
]
18.51 ms
(8.81%)
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
  582462
  546122
  547538
  548231
  554110
  554500
  563424
  565749
  578146
  667195
  667555
  668676
  675145
  664858
  665236
  690916
  555348
  562975
  577037
  591861
  598840
  620349
  644198
  593856
  603930
  605904
  612276
  612996
  614350
  644092
  589664
  589670
  592636
  601342
  605460
  622503
  588804
  590410
  590524
  625807
  766583
  604577
  612056
  585050
  466954
  472700
  461037
  472151
  476308
  485751
  500470
  505692
  510874
  517826
  518826
  520520
  525490
  500982
  506778
  510872
  517490
  518836
  518847
  518854
  520373
  505343
  513335
  517480
  524867
  528524
  529400
  503842
  505690
  512067
  512993
  514774
  524880
  534138
  461240
  470432
  549222
  551932
  554448
  554459
  555402
  558287
  559165
  567143
  567339
  577132
  581203
  582317
  543575
  555285
  556586
  560869
  570966
  573196
  579425
  548264
  554442
  554839
  555007
  562962
  570933
  584019
  584212
  663485
  663926
  664593
  667344
  664542
  668639
  652644
  665454
  546878
  553215
  557267
  561507
  566361
]
4.10 ms
(1.95%)
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
  461037
  461240
  466954
  470432
  472151
  472700
  476308
  485751
  500470
  500982
  503842
  505343
  505690
  505692
  506778
  510872
  510874
  512067
  512993
  513335
  514774
  517480
  517490
  517826
  518826
  518836
  518847
  518854
  520373
  520520
  524867
  524880
  525490
  528524
  529400
  534138
  543575
  546122
  546878
  547538
  548231
  548264
  549222
  551932
  553215
  554110
  554442
  554448
  554459
  554500
  554839
  555007
  555285
  555348
  555402
  556586
  557267
  558287
  559165
  560869
  561507
  562962
  562975
  563424
  565749
  566361
  567143
  567339
  570933
  570966
  573196
  577037
  577132
  578146
  579425
  581203
  582317
  582462
  584019
  584212
  585050
  588804
  589664
  589670
  590410
  590524
  591861
  592636
  593856
  598840
  601342
  603930
  604577
  605460
  605904
  612056
  612276
  612996
  614350
  620349
  622503
  625807
  644092
  644198
  652644
  663485
  663926
  664542
  664593
  664858
  665236
  665454
  667195
  667344
  667555
  668639
  668676
  675145
  690916
  766583
]
2.44 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "висячий"
]
1.97 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "обвисший"
]
1.78 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.