GET https://search.jues.net/search/embeds/6?q=deep%20hardcore

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.38 ms
(79.37%)
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
  417003
  419132
  453226
  453793
  454859
  464148
  466404
  466649
  468395
  472337
  497974
  500777
  506213
  510396
  518992
  530495
  530696
  531155
  531182
  531201
  531420
  532245
  532655
  532745
  532751
  532755
  532812
  533363
  533369
  533563
  533696
  533746
  534149
  534387
  534432
  536458
  536676
  536744
  536783
  537648
  537663
  537863
  537881
  540422
  540572
  542212
  545611
  554867
  554903
  555094
  555096
  556336
  564524
  565089
  565245
  565257
  566786
  572775
  576560
  577391
  579178
  580597
  591582
  592644
  599835
  600257
  600297
  608157
  609165
  623838
  624196
  626293
  631581
  632678
  633449
  634218
  634527
  634533
  634563
  635215
  636300
  636306
  636320
  639334
  640813
  644916
  648241
  654048
  665742
  666865
  676636
  676644
  680589
  685714
  686942
  692038
  695902
  715373
  725416
  733594
  738834
  745915
  745962
  756634
  759926
  761691
  762327
  765940
  776310
  780410
  785580
  786725
  788852
  795295
  800544
  803394
  806886
  809310
  818504
]
19.83 ms
(13.30%)
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
  786725
  725416
  762327
  765940
  745915
  759926
  738834
  761691
  809310
  419132
  532751
  536676
  540572
  510396
  530696
  531182
  532245
  537663
  537863
  533369
  530495
  534387
  537648
  676636
  565245
  640813
  600297
  636320
  632678
  635215
  417003
  818504
  554867
  565089
  564524
  555096
  692038
  695902
  654048
  665742
  676644
  576560
  624196
  626293
  608157
  592644
  623838
  631581
  785580
  776310
  780410
  803394
  806886
  756634
  733594
  795295
  800544
  453226
  644916
  533563
  534149
  531155
  531420
  532655
  532812
  536744
  536783
  532745
  533363
  545611
  566786
  648241
  666865
  636306
  639334
  636300
  599835
  600257
  634218
  633449
  506213
  685714
  453793
  464148
  466649
  454859
  497974
  540422
  555094
  556336
  542212
  554903
  565257
  579178
  626851
  634527
  634563
  788852
  745962
  715373
  472337
  500777
  609165
  531201
  532755
  533746
  466404
  580597
  534432
  537881
  518992
  533696
  536458
  468395
  572775
  577391
  680589
  686942
  634533
  591582
]
3.19 ms
(2.14%)
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
  417003
  419132
  453226
  453793
  454859
  464148
  466404
  466649
  468395
  472337
  497974
  500777
  506213
  510396
  518992
  530495
  530696
  531155
  531182
  531201
  531420
  532245
  532655
  532745
  532751
  532755
  532812
  533363
  533369
  533563
  533696
  533746
  534149
  534387
  534432
  536458
  536676
  536744
  536783
  537648
  537663
  537863
  537881
  540422
  540572
  542212
  545611
  554867
  554903
  555094
  555096
  556336
  564524
  565089
  565245
  565257
  566786
  572775
  576560
  577391
  579178
  580597
  591582
  592644
  599835
  600257
  600297
  608157
  609165
  623838
  624196
  626293
  631581
  632678
  633449
  634218
  634527
  634533
  634563
  635215
  636300
  636306
  636320
  639334
  640813
  644916
  648241
  654048
  665742
  666865
  676636
  676644
  680589
  685714
  686942
  692038
  695902
  715373
  725416
  733594
  738834
  745915
  745962
  756634
  759926
  761691
  762327
  765940
  776310
  780410
  785580
  786725
  788852
  795295
  800544
  803394
  806886
  809310
  818504
]
2.29 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "deep hardcore"
]
1.89 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "deep хардкор"
]
1.79 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "deep хардкор"
]

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.