GET https://search.jues.net/search/embeds/5?q=%D0%B2%20%D1%82%D0%B5%D0%BC%D0%BD%D1%8B%D1%85

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.43 ms
(82.71%)
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
  4350
  53805
  69440
  76122
  181292
  321858
  382296
  383051
  385577
  385938
  386625
  387000
  387318
  389262
  392747
  393849
  396567
  398047
  398523
  401964
  402024
  402195
  405802
  405858
  406793
  407187
  408741
  409416
  409759
  412179
  412772
  415533
  419102
  420012
  420338
  421619
  422336
  422506
  423305
  425324
  426091
  428804
  432200
  432573
  435509
  435580
  436938
  438694
  443046
  444119
  444153
  444234
  444379
  444389
  444420
  444474
  444582
  447658
  447758
  450208
  452538
  453303
  453573
  453712
  454682
  454781
  455187
  456796
  457274
  457976
  458009
  458303
  458693
  459291
  460032
  460276
  460355
  461286
  462167
  462673
  464553
  464587
  466035
  466756
  467172
  467806
  468326
  469207
  469486
  470143
  472074
  473949
  475106
  475109
  475132
  478545
  479374
  483310
  484056
  484446
  485043
  486256
  486423
  486822
  488160
  488916
  489164
  495241
  504465
  508890
  509112
  509546
  510630
  510735
  512298
  523002
  547231
  561435
  575126
  594878
]
22.24 ms
(11.91%)
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
  464553
  485043
  575126
  455187
  468326
  428804
  467172
  475109
  425324
  509546
  523002
  504465
  488916
  383051
  321858
  382296
  53805
  401964
  402024
  409416
  420338
  444389
  444474
  432200
  447758
  458303
  486822
  457274
  484056
  479374
  69440
  387000
  386625
  422506
  459291
  4350
  76122
  385938
  387318
  398523
  415533
  510735
  510630
  385577
  181292
  398047
  402195
  405802
  405858
  422336
  432573
  408741
  406793
  407187
  443046
  435509
  435580
  444379
  447658
  453303
  458009
  460032
  469486
  453573
  460355
  454682
  460276
  461286
  466035
  472074
  478545
  486256
  509112
  464587
  473949
  561435
  547231
  594878
  419102
  438694
  444153
  444234
  457976
  462673
  469207
  470143
  389262
  392747
  393849
  396567
  409759
  412179
  421619
  444582
  458693
  466756
  475132
  412772
  423305
  426091
  444119
  444420
  450208
  452538
  453712
  454781
  462167
  475106
  420012
  436938
  456796
  467806
  508890
  512298
  484446
  488160
  489164
  495241
  483310
  486423
]
2.84 ms
(1.52%)
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
  4350
  53805
  69440
  76122
  181292
  321858
  382296
  383051
  385577
  385938
  386625
  387000
  387318
  389262
  392747
  393849
  396567
  398047
  398523
  401964
  402024
  402195
  405802
  405858
  406793
  407187
  408741
  409416
  409759
  412179
  412772
  415533
  419102
  420012
  420338
  421619
  422336
  422506
  423305
  425324
  426091
  428804
  432200
  432573
  435509
  435580
  436938
  438694
  443046
  444119
  444153
  444234
  444379
  444389
  444420
  444474
  444582
  447658
  447758
  450208
  452538
  453303
  453573
  453712
  454682
  454781
  455187
  456796
  457274
  457976
  458009
  458303
  458693
  459291
  460032
  460276
  460355
  461286
  462167
  462673
  464553
  464587
  466035
  466756
  467172
  467806
  468326
  469207
  469486
  470143
  472074
  473949
  475106
  475109
  475132
  478545
  479374
  483310
  484056
  484446
  485043
  486256
  486423
  486822
  488160
  488916
  489164
  495241
  504465
  508890
  509112
  509546
  510630
  510735
  512298
  523002
  547231
  561435
  575126
  594878
]
2.02 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в темные"
]
1.94 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в темных"
]
1.76 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.80%)
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.