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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
337.92 ms
(93.15%)
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
  96452
  188462
  357886
  386896
  390286
  396251
  407683
  415966
  416523
  416631
  416668
  416708
  421152
  421993
  423435
  423784
  430178
  450948
  452810
  466639
  468943
  471654
  486721
  488342
  488820
  495467
  497906
  498318
  506063
  513256
  513842
  516818
  518471
  521682
  526188
  528936
  545428
  545439
  549091
  552800
  556880
  568962
  573192
  576848
  590803
  595215
  597190
  598141
  598461
  600348
  604824
  606275
  608550
  628553
  641997
  642035
  648869
  653047
  653925
  660382
  662850
  669017
  669035
  669057
  670366
  671045
  672950
  677343
  679676
  684422
  699397
  707357
  707432
  713195
  722395
  725604
  725631
  733582
  739131
  739145
  745126
  749070
  749219
  749254
  751546
  752602
  752633
  752644
  752665
  752676
  758778
  760238
  761432
  761706
  765714
  766415
  770250
  770253
  770410
  770804
  775922
  776209
  785591
  787466
  788118
  789466
  794390
  795211
  796057
  796744
  799693
  801686
  801898
  808331
  808971
  808998
  811459
  828086
  828394
]
14.86 ms
(4.10%)
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
  722395
  648869
  670366
  713195
  660382
  662850
  669017
  669035
  669057
  671045
  672950
  545439
  552800
  556880
  573192
  576848
  600348
  604824
  616047
  642035
  608550
  590803
  597190
  595215
  598141
  628553
  641997
  788118
  794390
  776209
  733582
  752665
  752676
  770804
  785591
  796057
  799693
  808998
  766415
  770250
  725631
  739131
  739145
  745126
  749070
  749219
  751546
  761432
  770253
  749254
  752602
  752633
  752644
  758778
  765714
  770410
  707432
  808331
  811459
  96452
  416708
  188462
  357886
  386896
  390286
  396251
  450948
  468943
  407683
  421152
  423784
  452810
  466639
  471654
  416523
  416631
  416668
  421993
  423435
  495467
  513256
  498318
  506063
  513842
  521682
  488820
  497906
  516818
  518471
  725604
  761706
  801686
  488342
  549091
  801898
  828394
  415966
  526188
  606275
  430178
  545428
  699397
  828086
  653925
  679676
  787466
  795211
  808971
  528936
  486721
  568962
  653047
  677343
  684422
  707357
  598461
  796744
  775922
  789466
  760238
]
3.21 ms
(0.89%)
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
  96452
  188462
  357886
  386896
  390286
  396251
  407683
  415966
  416523
  416631
  416668
  416708
  421152
  421993
  423435
  423784
  430178
  450948
  452810
  466639
  468943
  471654
  486721
  488342
  488820
  495467
  497906
  498318
  506063
  513256
  513842
  516818
  518471
  521682
  526188
  528936
  545428
  545439
  549091
  552800
  556880
  568962
  573192
  576848
  590803
  595215
  597190
  598141
  598461
  600348
  604824
  606275
  608550
  628553
  641997
  642035
  648869
  653047
  653925
  660382
  662850
  669017
  669035
  669057
  670366
  671045
  672950
  677343
  679676
  684422
  699397
  707357
  707432
  713195
  722395
  725604
  725631
  733582
  739131
  739145
  745126
  749070
  749219
  749254
  751546
  752602
  752633
  752644
  752665
  752676
  758778
  760238
  761432
  761706
  765714
  766415
  770250
  770253
  770410
  770804
  775922
  776209
  785591
  787466
  788118
  789466
  794390
  795211
  796057
  796744
  799693
  801686
  801898
  808331
  808971
  808998
  811459
  828086
  828394
]
1.98 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор riding"
]
1.92 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hardcore riding"
]
1.24 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор riding"
]

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.