GET https://search.jues.net/search/embeds/8?q=%D1%81%20%D1%81%D1%8E%D0%B6%D0%B5%D1%82

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.11 ms
(53.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "с сюжет"
]
156.82 ms
(40.14%)
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
  460642
  467839
  468826
  469066
  470842
  471802
  473218
  486415
  486474
  493128
  493391
  494717
  495544
  497441
  498024
  498102
  500469
  502306
  504919
  505005
  510445
  510875
  510897
  511295
  511464
  512799
  512855
  513090
  513271
  514581
  514724
  515165
  517368
  519091
  519095
  519245
  521047
  521551
  522342
  523412
  523629
  525644
  527088
  527850
  529120
  529565
  530781
  531996
  532091
  543181
  578121
  580120
  580663
  581157
  583262
  585102
  586451
  586469
  586483
  586940
  587477
  587923
  588633
  589730
  589758
  590727
  592590
  593465
  594765
  594788
  594811
  594827
  594833
  594841
  594861
  594927
  596227
  597863
  598625
  599273
  599274
  599670
  600793
  601266
  601339
  601724
  603249
  603344
  605415
  605459
  605637
  605936
  605941
  607052
  607204
  610119
  611245
  612051
  614339
  615847
  617350
  618888
  618896
  619140
  619141
  619151
  620796
  621401
  621402
  621617
  621648
  623364
  623446
  623869
  624804
  624874
  628423
  636257
  642702
  754168
]
15.36 ms
(3.93%)
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
  578121
  580120
  580663
  581157
  583262
  587923
  588633
  594833
  594861
  600793
  605936
  607052
  619151
  621401
  586940
  589758
  592590
  594765
  594788
  594811
  598625
  599273
  599274
  599670
  601724
  603249
  610119
  621617
  621648
  623446
  624874
  586483
  594841
  594927
  596227
  597863
  601266
  605459
  607204
  615847
  618896
  619140
  619141
  620796
  621402
  624804
  636257
  586451
  586469
  587477
  590727
  593465
  594827
  601339
  603344
  605415
  605637
  605941
  614339
  623869
  642702
  754168
  611245
  612051
  618888
  623364
  628423
  585102
  543181
  589730
  617350
  469066
  493128
  493391
  468826
  470842
  486474
  460642
  467839
  471802
  473218
  486415
  497441
  498102
  500469
  510897
  512799
  512855
  514724
  519095
  519245
  523412
  527850
  529120
  531996
  532091
  494717
  495544
  498024
  510875
  511295
  515165
  517368
  519091
  521047
  521551
  522342
  523629
  525644
  527088
  529565
  530781
  502306
  504919
  505005
  510445
  511464
  513090
  513271
  514581
]
3.44 ms
(0.88%)
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
  460642
  467839
  468826
  469066
  470842
  471802
  473218
  486415
  486474
  493128
  493391
  494717
  495544
  497441
  498024
  498102
  500469
  502306
  504919
  505005
  510445
  510875
  510897
  511295
  511464
  512799
  512855
  513090
  513271
  514581
  514724
  515165
  517368
  519091
  519095
  519245
  521047
  521551
  522342
  523412
  523629
  525644
  527088
  527850
  529120
  529565
  530781
  531996
  532091
  543181
  578121
  580120
  580663
  581157
  583262
  585102
  586451
  586469
  586483
  586940
  587477
  587923
  588633
  589730
  589758
  590727
  592590
  593465
  594765
  594788
  594811
  594827
  594833
  594841
  594861
  594927
  596227
  597863
  598625
  599273
  599274
  599670
  600793
  601266
  601339
  601724
  603249
  603344
  605415
  605459
  605637
  605936
  605941
  607052
  607204
  610119
  611245
  612051
  614339
  615847
  617350
  618888
  618896
  619140
  619141
  619151
  620796
  621401
  621402
  621617
  621648
  623364
  623446
  623869
  624804
  624874
  628423
  636257
  642702
  754168
]
1.73 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сюжет"
]
1.57 ms
(0.40%)
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.