GET https://search.jues.net/search/embeds/8?q=%D0%B4%D1%83%D1%88%20%D1%80%D1%83%D1%81%D1%81%D0%BA%D0%BE%D0%B5

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.74 ms
(86.52%)
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
  232995
  365945
  390931
  391928
  392604
  400994
  424195
  426096
  429872
  435064
  439738
  445818
  452181
  455594
  455738
  456499
  459476
  469797
  470498
  472574
  473269
  473761
  473977
  478400
  478753
  478902
  479091
  479272
  479452
  482856
  482917
  482933
  483601
  485429
  485966
  486334
  487547
  488144
  489073
  489331
  491144
  495228
  495328
  496357
  499021
  501747
  501801
  501912
  501996
  502388
  502944
  505372
  510007
  511055
  512061
  513516
  515841
  516778
  518901
  520395
  521959
  522249
  522481
  522792
  523731
  523959
  524424
  525984
  526326
  527625
  527794
  528215
  542742
  543678
  544955
  546775
  551278
  551888
  552324
  555963
  555994
  560554
  561563
  569593
  571971
  587918
  599549
  599617
  600438
  601358
  602841
  605296
  636643
  656019
  658052
  658266
  658487
  658624
  675464
  692944
  693264
  704595
  707507
  715422
  736058
  744912
  766783
  799915
  803232
  803233
  810708
  816120
  817437
  817835
  817880
  818038
  819930
  819940
  819991
  825698
]
16.37 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
  569593
  542742
  561563
  571971
  555963
  560554
  600438
  601358
  587918
  599617
  744912
  636643
  426096
  435064
  400994
  470498
  459476
  513516
  522792
  495228
  482856
  482917
  487547
  522249
  523731
  524424
  527625
  488144
  489073
  489331
  501996
  502388
  515841
  518901
  520395
  523959
  526326
  527794
  528215
  803232
  803233
  473977
  232995
  816120
  817437
  478902
  544955
  543678
  656019
  799915
  766783
  810708
  391928
  483601
  486334
  472574
  485966
  546775
  555994
  552324
  551278
  599549
  605296
  390931
  424195
  469797
  473761
  392604
  455594
  455738
  429872
  456499
  445818
  452181
  473269
  478400
  478753
  479091
  479272
  479452
  501801
  512061
  516778
  521959
  501912
  502944
  511055
  510007
  522481
  482933
  485429
  491144
  495328
  496357
  499021
  501747
  505372
  525984
  602841
  551888
  736058
  365945
  439738
  817835
  825698
  819930
  819940
  817880
  818038
  819991
  658052
  658624
  693264
  707507
  715422
  658266
  704595
  658487
  675464
  692944
]
2.44 ms
(1.32%)
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
  232995
  365945
  390931
  391928
  392604
  400994
  424195
  426096
  429872
  435064
  439738
  445818
  452181
  455594
  455738
  456499
  459476
  469797
  470498
  472574
  473269
  473761
  473977
  478400
  478753
  478902
  479091
  479272
  479452
  482856
  482917
  482933
  483601
  485429
  485966
  486334
  487547
  488144
  489073
  489331
  491144
  495228
  495328
  496357
  499021
  501747
  501801
  501912
  501996
  502388
  502944
  505372
  510007
  511055
  512061
  513516
  515841
  516778
  518901
  520395
  521959
  522249
  522481
  522792
  523731
  523959
  524424
  525984
  526326
  527625
  527794
  528215
  542742
  543678
  544955
  546775
  551278
  551888
  552324
  555963
  555994
  560554
  561563
  569593
  571971
  587918
  599549
  599617
  600438
  601358
  602841
  605296
  636643
  656019
  658052
  658266
  658487
  658624
  675464
  692944
  693264
  704595
  707507
  715422
  736058
  744912
  766783
  799915
  803232
  803233
  810708
  816120
  817437
  817835
  817880
  818038
  819930
  819940
  819991
  825698
]
1.72 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "душ русское"
]
1.61 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ван русск"
]
1.57 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.72%)
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.