GET https://search.jues.net/search/embeds/3?q=%D0%B2%20%D0%B4%D1%83%D1%88%D0%B5%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
234.00 ms
(88.04%)
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
  47583
  385671
  391890
  421260
  424671
  434259
  438127
  439753
  443396
  445604
  447211
  448396
  450377
  451338
  452666
  457965
  459342
  460387
  461829
  463310
  467920
  467979
  470459
  472877
  473679
  473973
  474994
  478588
  480256
  484105
  485332
  497683
  498425
  502859
  517355
  520388
  524905
  526147
  532111
  539398
  539530
  542178
  547962
  551881
  552089
  553665
  557678
  561027
  561044
  564632
  566539
  566746
  567216
  567822
  583522
  586926
  597844
  599501
  602632
  606625
  607469
  614061
  628824
  635723
  635735
  636568
  645275
  649310
  659460
  672421
  683798
  690441
  697962
  706558
  739441
  762517
  763128
  763815
  765343
  768834
  768835
  770359
  774935
  780772
  783193
  786732
  788451
  789027
  789054
  789341
  791463
  791981
  792050
  792299
  797176
  798745
  800436
  804154
  811973
  815134
  816120
  816185
  817214
  817437
  817998
  819199
  819718
  819930
  821493
  821634
  821681
  822706
  823063
  823379
  825035
  826183
  828592
  828705
]
13.24 ms
(4.98%)
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
  786732
  47583
  463310
  517355
  443396
  451338
  457965
  460387
  497683
  539530
  474994
  553665
  547962
  564632
  567216
  586926
  607469
  606625
  635723
  599501
  602632
  791981
  452666
  447211
  448396
  473679
  438127
  439753
  467979
  445604
  459342
  478588
  502859
  484105
  485332
  524905
  526147
  823063
  826183
  828592
  828705
  551881
  789341
  498425
  815134
  783193
  792299
  767642
  763815
  816120
  822706
  823379
  817437
  819718
  811973
  421260
  434259
  817998
  532111
  539398
  557678
  566539
  683798
  649310
  672421
  697962
  706558
  561027
  566746
  614061
  628824
  636568
  774935
  789054
  791463
  792050
  739441
  765343
  770359
  780772
  461829
  768834
  385671
  816185
  391890
  470459
  821634
  817214
  819930
  823117
  819199
  821493
  821681
  825035
  561044
  645275
  690441
  635735
  798745
  800436
  797176
  788451
  762517
  768835
  789027
  659460
  480256
  472877
  542178
  597844
  763128
  804154
  424671
  450377
  473973
  467920
  520388
  567822
  552089
  583522
]
11.20 ms
(4.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в душе pov"
]
2.46 ms
(0.93%)
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
  47583
  385671
  391890
  421260
  424671
  434259
  438127
  439753
  443396
  445604
  447211
  448396
  450377
  451338
  452666
  457965
  459342
  460387
  461829
  463310
  467920
  467979
  470459
  472877
  473679
  473973
  474994
  478588
  480256
  484105
  485332
  497683
  498425
  502859
  517355
  520388
  524905
  526147
  532111
  539398
  539530
  542178
  547962
  551881
  552089
  553665
  557678
  561027
  561044
  564632
  566539
  566746
  567216
  567822
  583522
  586926
  597844
  599501
  602632
  606625
  607469
  614061
  628824
  635723
  635735
  636568
  645275
  649310
  659460
  672421
  683798
  690441
  697962
  706558
  739441
  762517
  763128
  763815
  765343
  768834
  768835
  770359
  774935
  780772
  783193
  786732
  788451
  789027
  789054
  789341
  791463
  791981
  792050
  792299
  797176
  798745
  800436
  804154
  811973
  815134
  816120
  816185
  817214
  817437
  817998
  819199
  819718
  819930
  821493
  821634
  821681
  822706
  823063
  823379
  825035
  826183
  828592
  828705
]
1.93 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ван пов"
]
1.50 ms
(0.56%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.55%)
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.