GET https://search.jues.net/search/embeds/3?q=%D0%B6%D0%BE%D0%BF%D0%BE%D0%B9%20%D1%82%D1%80%D0%B5%D1%82%D1%81%D1%8F

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.22 ms
(88.18%)
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
  16974
  383315
  392386
  396439
  406945
  408988
  417162
  429024
  437616
  448045
  451495
  453451
  454942
  457153
  462369
  465055
  466105
  467022
  480513
  482585
  485039
  492644
  493119
  496304
  496668
  496923
  506010
  507006
  509353
  509874
  510841
  511638
  513117
  513821
  516069
  516988
  518932
  520257
  523071
  524741
  525146
  526856
  532321
  533264
  534466
  536432
  537164
  538794
  540403
  545104
  545137
  545623
  546517
  547581
  547954
  549656
  550642
  551688
  551689
  558367
  559255
  564393
  566118
  568637
  568654
  568976
  571312
  572719
  575250
  575315
  577876
  581425
  583799
  584686
  587394
  592324
  593289
  595308
  597618
  598762
  604005
  604997
  605667
  606035
  609990
  616551
  619370
  620992
  622309
  626356
  627202
  630088
  639982
  644119
  644160
  645621
  668015
  668776
  669247
  670811
  681501
  713641
  726653
  736928
  743240
  749611
  750301
  750666
  763861
  765220
  769448
  770544
  777154
  778423
  794192
  795752
  804249
  809297
  810464
  811060
]
13.69 ms
(6.85%)
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
  763861
  794192
  810464
  795752
  811060
  406945
  587394
  437616
  493119
  480513
  496668
  778423
  749611
  736928
  509874
  770544
  485039
  516069
  516988
  518932
  545137
  769448
  496304
  392386
  526856
  568976
  571312
  581425
  644160
  598762
  408988
  558367
  743240
  448045
  532321
  513117
  534466
  537164
  538794
  511638
  513821
  551689
  546517
  668776
  668015
  713641
  575250
  606035
  630088
  619370
  622309
  644119
  605667
  620992
  604997
  777154
  809297
  750666
  765220
  726653
  804249
  383315
  507006
  568637
  627202
  639982
  465055
  457153
  547581
  550642
  681501
  597618
  545104
  533264
  592324
  496923
  525146
  536432
  551688
  559255
  568654
  577876
  566118
  564393
  595308
  604005
  616551
  16974
  454942
  453451
  509353
  572719
  626356
  609990
  593289
  750301
  451495
  466105
  462369
  492644
  506010
  396439
  417162
  429024
  510841
  524741
  540403
  523071
  520257
  467022
  482585
  583799
  547954
  549656
  575315
  584686
  545623
  669247
  645621
  670811
]
2.65 ms
(1.33%)
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
  16974
  383315
  392386
  396439
  406945
  408988
  417162
  429024
  437616
  448045
  451495
  453451
  454942
  457153
  462369
  465055
  466105
  467022
  480513
  482585
  485039
  492644
  493119
  496304
  496668
  496923
  506010
  507006
  509353
  509874
  510841
  511638
  513117
  513821
  516069
  516988
  518932
  520257
  523071
  524741
  525146
  526856
  532321
  533264
  534466
  536432
  537164
  538794
  540403
  545104
  545137
  545623
  546517
  547581
  547954
  549656
  550642
  551688
  551689
  558367
  559255
  564393
  566118
  568637
  568654
  568976
  571312
  572719
  575250
  575315
  577876
  581425
  583799
  584686
  587394
  592324
  593289
  595308
  597618
  598762
  604005
  604997
  605667
  606035
  609990
  616551
  619370
  620992
  622309
  626356
  627202
  630088
  639982
  644119
  644160
  645621
  668015
  668776
  669247
  670811
  681501
  713641
  726653
  736928
  743240
  749611
  750301
  750666
  763861
  765220
  769448
  770544
  777154
  778423
  794192
  795752
  804249
  809297
  810464
  811060
]
1.99 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жопой трется"
]
1.91 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп трет"
]
1.87 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп трет"
]
1.52 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.