GET https://search.jues.net/search/embeds/3?q=%D0%B2%20%D0%BF%D1%8F%D1%82%D0%B5%D1%80%D0%BE

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
231.42 ms
(90.40%)
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
  97377
  298519
  365924
  383902
  385457
  390131
  391472
  394212
  400988
  408685
  417794
  420117
  420171
  420284
  421208
  422753
  423548
  425359
  428057
  428521
  431673
  432963
  437687
  438971
  439586
  439876
  442618
  443251
  443738
  443789
  450678
  451715
  453525
  453629
  454262
  457590
  458336
  458996
  460783
  461306
  463630
  466362
  467010
  468004
  468167
  468375
  470255
  471426
  473845
  475293
  478081
  479499
  484561
  484923
  485223
  485589
  486319
  486970
  490887
  491145
  491390
  493161
  495087
  497753
  500511
  502460
  503922
  504714
  508254
  509137
  513975
  514234
  514297
  514750
  517660
  518628
  519233
  520291
  524038
  526918
  527765
  530705
  537227
  538368
  544082
  550676
  552847
  557735
  557968
  559034
  559038
  560705
  561492
  564565
  564593
  566607
  570896
  571048
  571439
  573954
  577901
  578847
  579370
  580042
  581323
  598341
  610012
  613024
  614876
  617445
  619457
  620153
  630119
  632562
  666983
  673158
  680275
  748943
  748951
  748968
]
15.67 ms
(6.12%)
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
  530705
  537227
  559034
  573954
  442618
  425359
  432963
  453629
  365924
  423548
  666983
  428057
  450678
  513975
  550676
  557968
  564565
  561492
  557735
  617445
  630119
  394212
  453525
  443738
  520291
  485223
  538368
  298519
  420117
  461306
  478081
  484923
  524038
  497753
  514234
  517660
  466362
  468375
  486319
  559038
  560705
  566607
  581323
  544082
  673158
  552847
  578847
  598341
  748943
  390131
  468004
  470255
  385457
  408685
  438971
  439876
  495087
  491145
  502460
  486970
  527765
  620153
  383902
  467010
  421208
  471426
  484561
  491390
  508254
  518628
  571048
  579370
  619457
  431673
  457590
  519233
  504714
  503922
  417794
  422753
  437687
  443251
  420284
  451715
  458996
  475293
  473845
  509137
  571439
  580042
  577901
  680275
  610012
  613024
  632562
  748951
  748968
  468167
  391472
  97377
  420171
  485589
  500511
  490887
  526918
  514750
  514297
  614876
  439586
  564593
  400988
  463630
  454262
  458336
  460783
  443789
  493161
  570896
  428521
  479499
]
2.69 ms
(1.05%)
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
  97377
  298519
  365924
  383902
  385457
  390131
  391472
  394212
  400988
  408685
  417794
  420117
  420171
  420284
  421208
  422753
  423548
  425359
  428057
  428521
  431673
  432963
  437687
  438971
  439586
  439876
  442618
  443251
  443738
  443789
  450678
  451715
  453525
  453629
  454262
  457590
  458336
  458996
  460783
  461306
  463630
  466362
  467010
  468004
  468167
  468375
  470255
  471426
  473845
  475293
  478081
  479499
  484561
  484923
  485223
  485589
  486319
  486970
  490887
  491145
  491390
  493161
  495087
  497753
  500511
  502460
  503922
  504714
  508254
  509137
  513975
  514234
  514297
  514750
  517660
  518628
  519233
  520291
  524038
  526918
  527765
  530705
  537227
  538368
  544082
  550676
  552847
  557735
  557968
  559034
  559038
  560705
  561492
  564565
  564593
  566607
  570896
  571048
  571439
  573954
  577901
  578847
  579370
  580042
  581323
  598341
  610012
  613024
  614876
  617445
  619457
  620153
  630119
  632562
  666983
  673158
  680275
  748943
  748951
  748968
]
1.80 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в пятеро"
]
1.61 ms
(0.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в пят"
]
1.45 ms
(0.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.52%)
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.