GET https://search.jues.net/search/embeds/3?q=%D0%B7%D0%B0%D0%B4%D1%80%D0%B0%D0%BB%D0%B0

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
186.71 ms
(90.64%)
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
  233941
  366053
  386589
  387944
  388523
  393122
  398685
  405987
  410699
  416646
  422320
  422816
  425288
  427162
  428687
  441957
  450830
  452997
  453151
  455345
  457257
  461314
  462215
  466703
  472853
  473454
  473696
  479690
  491344
  493119
  493861
  495101
  498892
  499545
  500182
  500958
  502472
  503294
  503689
  504044
  504075
  505924
  506571
  506743
  511821
  512144
  513196
  515296
  515409
  515443
  515540
  520298
  524741
  525228
  528536
  529396
  529918
  529986
  531265
  534467
  536711
  541030
  541167
  541298
  541460
  542915
  543272
  545623
  548002
  548373
  548395
  550237
  551665
  551914
  552576
  552937
  553166
  556843
  557001
  557581
  559266
  560084
  560145
  560275
  561372
  561660
  562624
  564283
  564640
  566332
  567950
  570033
  575195
  577481
  578079
  579441
  580218
  582036
  584149
  586994
  589657
  594941
  600307
  600437
  600518
  601143
  603366
  604422
  605147
  609076
  610052
  611298
  622607
  653506
  657322
  661060
  663389
  687155
  690881
]
10.15 ms
(4.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
  552576
  557581
  560084
  560145
  561372
  561660
  575195
  577481
  687155
  657322
  661060
  663389
  690881
  653506
  551665
  552937
  557001
  570033
  579441
  589657
  601143
  605147
  600307
  600437
  600518
  604422
  611298
  610052
  586994
  594941
  622607
  603366
  609076
  398685
  422320
  233941
  405987
  422816
  366053
  388523
  425288
  503294
  495101
  491344
  515443
  525228
  515296
  386589
  393122
  387944
  416646
  441957
  410699
  427162
  428687
  452997
  455345
  457257
  466703
  479690
  493119
  450830
  453151
  473454
  473696
  462215
  504044
  504075
  506571
  512144
  513196
  524741
  529396
  531265
  498892
  499545
  500182
  500958
  503689
  528536
  529986
  536711
  502472
  505924
  506743
  515409
  520298
  526388
  529918
  511821
  515540
  534467
  461314
  472853
  493861
  541460
  543272
  548002
  550237
  556843
  559266
  560275
  562624
  584149
  541030
  541167
  542915
  553166
  564283
  564640
  566332
  567950
  578079
  580218
  582036
  541298
  545623
  548373
  548395
  551914
]
2.31 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "задрала"
]
2.28 ms
(1.11%)
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
  233941
  366053
  386589
  387944
  388523
  393122
  398685
  405987
  410699
  416646
  422320
  422816
  425288
  427162
  428687
  441957
  450830
  452997
  453151
  455345
  457257
  461314
  462215
  466703
  472853
  473454
  473696
  479690
  491344
  493119
  493861
  495101
  498892
  499545
  500182
  500958
  502472
  503294
  503689
  504044
  504075
  505924
  506571
  506743
  511821
  512144
  513196
  515296
  515409
  515443
  515540
  520298
  524741
  525228
  528536
  529396
  529918
  529986
  531265
  534467
  536711
  541030
  541167
  541298
  541460
  542915
  543272
  545623
  548002
  548373
  548395
  550237
  551665
  551914
  552576
  552937
  553166
  556843
  557001
  557581
  559266
  560084
  560145
  560275
  561372
  561660
  562624
  564283
  564640
  566332
  567950
  570033
  575195
  577481
  578079
  579441
  580218
  582036
  584149
  586994
  589657
  594941
  600307
  600437
  600518
  601143
  603366
  604422
  605147
  609076
  610052
  611298
  622607
  653506
  657322
  661060
  663389
  687155
  690881
]
1.63 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "задра"
]
1.46 ms
(0.71%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.70%)
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.