GET https://search.jues.net/search/embeds/7?q=%D0%B5%D0%B1%D1%83%D1%82%20%D0%B4%D0%B2%D0%BE%D0%B5%D0%BC

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
234.60 ms
(91.86%)
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
  69704
  236472
  251147
  486170
  490198
  505706
  514711
  531916
  531960
  535385
  538536
  538891
  542995
  543688
  544661
  546304
  551113
  552756
  558201
  558928
  565902
  569548
  574159
  600649
  606064
  609435
  613447
  617640
  617849
  628112
  629662
  632048
  635835
  640909
  665773
  669946
  671702
  676711
  678586
  679044
  679049
  679061
  679078
  679079
  679096
  679135
  690855
  690913
  692248
  692330
  692813
  693028
  693041
  693860
  694211
  694222
  694478
  694522
  694555
  694562
  694877
  695188
  695390
  695391
  695621
  695631
  696554
  699757
  700034
  700852
  702188
  702863
  705306
  709512
  714128
  715542
  716202
  716640
  723659
  726365
  727413
  728022
  728131
  729917
  730222
  732551
  733113
  735177
  735570
  737478
  738054
  740461
  745943
  746733
  748689
  752509
  755836
  763935
  768023
  775815
  777957
  778221
  779241
  781513
  783381
  786096
  787302
  788169
  788596
  793454
  798285
  798993
  799481
  800800
  801733
  802103
  803406
  803771
  805532
  814258
]
9.82 ms
(3.85%)
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
  538536
  665773
  692813
  694478
  702188
  694877
  695391
  546304
  613447
  779241
  800800
  729917
  763935
  805532
  735570
  735177
  702863
  723659
  486170
  505706
  531916
  531960
  552756
  574159
  558928
  565902
  669946
  676711
  692248
  695390
  696554
  709512
  694211
  700034
  705306
  671702
  693028
  600649
  629662
  617640
  793454
  798285
  803406
  786096
  799481
  803771
  727413
  781513
  733113
  728131
  737478
  745943
  609435
  715542
  778221
  787302
  69704
  814258
  716640
  694562
  679049
  606064
  635835
  728022
  752509
  748689
  755836
  558201
  544661
  542995
  679135
  632048
  798993
  738054
  732551
  726365
  746733
  617849
  700852
  775815
  788169
  538891
  535385
  679044
  690855
  690913
  694522
  695631
  678586
  679096
  693860
  695621
  693041
  551113
  777957
  730222
  783381
  801733
  740461
  768023
  628112
  490198
  699757
  802103
  569548
  543688
  714128
  692330
  640909
  236472
  251147
  679061
  679078
  679079
  694222
  695188
  694555
  716202
  788596
  514711
]
3.29 ms
(1.29%)
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
  69704
  236472
  251147
  486170
  490198
  505706
  514711
  531916
  531960
  535385
  538536
  538891
  542995
  543688
  544661
  546304
  551113
  552756
  558201
  558928
  565902
  569548
  574159
  600649
  606064
  609435
  613447
  617640
  617849
  628112
  629662
  632048
  635835
  640909
  665773
  669946
  671702
  676711
  678586
  679044
  679049
  679061
  679078
  679079
  679096
  679135
  690855
  690913
  692248
  692330
  692813
  693028
  693041
  693860
  694211
  694222
  694478
  694522
  694555
  694562
  694877
  695188
  695390
  695391
  695621
  695631
  696554
  699757
  700034
  700852
  702188
  702863
  705306
  709512
  714128
  715542
  716202
  716640
  723659
  726365
  727413
  728022
  728131
  729917
  730222
  732551
  733113
  735177
  735570
  737478
  738054
  740461
  745943
  746733
  748689
  752509
  755836
  763935
  768023
  775815
  777957
  778221
  779241
  781513
  783381
  786096
  787302
  788169
  788596
  793454
  798285
  798993
  799481
  800800
  801733
  802103
  803406
  803771
  805532
  814258
]
2.32 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебут двоем"
]
1.99 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс два"
]
1.94 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.56%)
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.