GET https://search.jues.net/search/embeds/3?q=%D1%8F%D0%B7%D1%8B%D0%BA%20%D0%B2%20%D0%B6%D0%BE%D0%BF%D1%83

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.93 ms
(81.82%)
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
  7446
  382071
  385296
  391655
  401500
  402332
  402698
  402723
  404766
  405287
  406381
  408609
  415950
  417464
  418848
  420587
  421363
  421604
  421878
  421907
  427974
  431498
  432754
  433212
  433238
  435664
  439565
  443513
  447426
  449097
  451951
  453918
  457419
  458391
  461375
  461576
  463936
  467867
  474095
  474836
  478401
  478458
  489866
  491110
  491250
  493059
  493163
  494525
  500430
  502283
  509920
  513604
  515633
  516093
  521131
  521425
  522095
  523354
  524528
  526267
  531654
  532644
  536648
  541808
  543496
  547764
  549255
  550436
  550604
  551913
  551919
  552331
  553190
  554370
  557249
  559121
  561853
  561998
  565501
  569159
  574464
  576653
  580773
  583678
  586564
  587833
  591135
  593425
  594370
  597975
  598142
  598263
  598574
  604205
  605416
  608416
  609897
  610606
  612434
  613014
  613179
  613253
  615938
  617420
  617423
  620044
  620124
  620215
  620236
  620290
  623678
  623716
  624030
  625870
  651244
  652893
  653459
  654322
  685469
  740681
]
21.51 ms
(12.31%)
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
  421878
  478401
  491110
  494525
  433212
  433238
  7446
  443513
  418848
  598574
  435664
  574464
  547764
  391655
  417464
  478458
  509920
  740681
  385296
  453918
  489866
  526267
  550604
  402723
  457419
  431498
  474095
  521425
  421604
  500430
  651244
  493059
  516093
  569159
  623716
  421363
  522095
  515633
  559121
  401500
  427974
  458391
  594370
  463936
  415950
  654322
  620044
  461375
  523354
  439565
  624030
  451951
  536648
  580773
  652893
  402698
  561853
  620290
  620124
  406381
  551919
  531654
  604205
  461576
  382071
  447426
  587833
  421907
  449097
  561998
  653459
  605416
  613253
  404766
  583678
  549255
  685469
  625870
  467867
  521131
  553190
  557249
  491250
  474836
  402332
  565501
  613014
  623678
  586564
  597975
  608416
  513604
  420587
  550436
  598263
  609897
  612434
  408609
  532644
  432754
  551913
  552331
  576653
  598142
  620236
  593425
  502283
  524528
  541808
  543496
  620215
  615938
  610606
  591135
  493163
  554370
  617423
  405287
  617420
  613179
]
3.11 ms
(1.78%)
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
  7446
  382071
  385296
  391655
  401500
  402332
  402698
  402723
  404766
  405287
  406381
  408609
  415950
  417464
  418848
  420587
  421363
  421604
  421878
  421907
  427974
  431498
  432754
  433212
  433238
  435664
  439565
  443513
  447426
  449097
  451951
  453918
  457419
  458391
  461375
  461576
  463936
  467867
  474095
  474836
  478401
  478458
  489866
  491110
  491250
  493059
  493163
  494525
  500430
  502283
  509920
  513604
  515633
  516093
  521131
  521425
  522095
  523354
  524528
  526267
  531654
  532644
  536648
  541808
  543496
  547764
  549255
  550436
  550604
  551913
  551919
  552331
  553190
  554370
  557249
  559121
  561853
  561998
  565501
  569159
  574464
  576653
  580773
  583678
  586564
  587833
  591135
  593425
  594370
  597975
  598142
  598263
  598574
  604205
  605416
  608416
  609897
  610606
  612434
  613014
  613179
  613253
  615938
  617420
  617423
  620044
  620124
  620215
  620236
  620290
  623678
  623716
  624030
  625870
  651244
  652893
  653459
  654322
  685469
  740681
]
2.36 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "язык в жопу"
]
1.75 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "язык анал"
]
1.43 ms
(0.82%)
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.