GET https://search.jues.net/search/embeds/8?q=russian%20hardcore

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.63 ms
(82.69%)
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
  390533
  390642
  391668
  391944
  411014
  411478
  414125
  415050
  417367
  421050
  425118
  425181
  426629
  427128
  427141
  427292
  428412
  429859
  429861
  430178
  434293
  434376
  435535
  436132
  439531
  439572
  439688
  444538
  445745
  445961
  447305
  448257
  456240
  457541
  460900
  461924
  462553
  465148
  467879
  467893
  471102
  474800
  476785
  477143
  477145
  477246
  478775
  480905
  484706
  489228
  490507
  490996
  495470
  497560
  498018
  500335
  500342
  504781
  506105
  511864
  512442
  514043
  519699
  526905
  528055
  530005
  530310
  531177
  531524
  533765
  534119
  534561
  536264
  536382
  538977
  541274
  542705
  544404
  547235
  548157
  552819
  553808
  554235
  556339
  556888
  556909
  560106
  565247
  569261
  569554
  571648
  571846
  575401
  578724
  583085
  583474
  599362
  605725
  630395
  653520
  662046
  679357
  683259
  686581
  700171
  714497
  716543
  730857
  738342
  741981
  754207
  754946
  762514
  765731
  765995
  777130
  786985
  797561
  827950
]
18.98 ms
(11.57%)
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
  530005
  714497
  605725
  434376
  390533
  391668
  428412
  439572
  439688
  474800
  390642
  429859
  425118
  448257
  460900
  489228
  571648
  686581
  679357
  700171
  599362
  630395
  777130
  797561
  738342
  741981
  754207
  765995
  730857
  754946
  761775
  762514
  765731
  786985
  504781
  554235
  583085
  417367
  434293
  436132
  439531
  457541
  461924
  467879
  467893
  471102
  480905
  411478
  427292
  444538
  465148
  421050
  429861
  477145
  411014
  414125
  447305
  462553
  476785
  477246
  415050
  445961
  456240
  500335
  534561
  495470
  497560
  498018
  500342
  506105
  519699
  528055
  536382
  484706
  531524
  531177
  683259
  565247
  445745
  478775
  430178
  490996
  490507
  391944
  425181
  426629
  427128
  427141
  435535
  827950
  477143
  533765
  534119
  536264
  511864
  512442
  514043
  538977
  526905
  530310
  541274
  547235
  552819
  553808
  556339
  556888
  560106
  569261
  569554
  571846
  578724
  548157
  556909
  575401
  542705
  544404
  583474
  662046
  716543
  653520
]
2.62 ms
(1.60%)
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
  390533
  390642
  391668
  391944
  411014
  411478
  414125
  415050
  417367
  421050
  425118
  425181
  426629
  427128
  427141
  427292
  428412
  429859
  429861
  430178
  434293
  434376
  435535
  436132
  439531
  439572
  439688
  444538
  445745
  445961
  447305
  448257
  456240
  457541
  460900
  461924
  462553
  465148
  467879
  467893
  471102
  474800
  476785
  477143
  477145
  477246
  478775
  480905
  484706
  489228
  490507
  490996
  495470
  497560
  498018
  500335
  500342
  504781
  506105
  511864
  512442
  514043
  519699
  526905
  528055
  530005
  530310
  531177
  531524
  533765
  534119
  534561
  536264
  536382
  538977
  541274
  542705
  544404
  547235
  548157
  552819
  553808
  554235
  556339
  556888
  556909
  560106
  565247
  569261
  569554
  571648
  571846
  575401
  578724
  583085
  583474
  599362
  605725
  630395
  653520
  662046
  679357
  683259
  686581
  700171
  714497
  716543
  730857
  738342
  741981
  754207
  754946
  762514
  765731
  765995
  777130
  786985
  797561
  827950
]
1.98 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian hardcore"
]
1.65 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск хардкор"
]
1.64 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск хардкор"
]
1.52 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.