GET https://search.jues.net/search/embeds/9?q=extreme%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.88 ms
(86.43%)
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
  65760
  89199
  154240
  154535
  155198
  346141
  382960
  382993
  383869
  383920
  387394
  392839
  395252
  398073
  398095
  398113
  401178
  403288
  408885
  408911
  415859
  416173
  416527
  416531
  416537
  416575
  416690
  419834
  423927
  428366
  432933
  435593
  442337
  444531
  445968
  449921
  469087
  476710
  477759
  480502
  482293
  499930
  499931
  506119
  508939
  514215
  514257
  514879
  515441
  526902
  529128
  529713
  529714
  531583
  533717
  534529
  534535
  535651
  538253
  538510
  540945
  541128
  541421
  544143
  545422
  545453
  547464
  547476
  547890
  550708
  550884
  580193
  622720
  642013
  736337
  738822
  739154
  739805
  740926
  742303
  743947
  744021
  744795
  745083
  745086
  745128
  746177
  748287
  748491
  749067
  749084
  749221
  749700
  752617
  752627
  752637
  752652
  752675
  752686
  752710
  752712
  752713
  752784
  761621
  766943
  769148
  770254
  770262
  771887
  784985
  785073
  788521
  794213
  801629
  801643
  804417
  806928
  810635
  811765
  814151
]
13.61 ms
(7.69%)
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
  806928
  811765
  739154
  749067
  749221
  749700
  752652
  752675
  752710
  752712
  752713
  761621
  766943
  770262
  738822
  742303
  745086
  746177
  749084
  752686
  752784
  769148
  771887
  743947
  744021
  744795
  745083
  745128
  748491
  770254
  736337
  740926
  748287
  752617
  752627
  752637
  622720
  642013
  785073
  788521
  794213
  801629
  801643
  804417
  810635
  403288
  392839
  435593
  398073
  65760
  154535
  395252
  538510
  401178
  415859
  408885
  444531
  477759
  499931
  547890
  550884
  482293
  432933
  506119
  784985
  739805
  383920
  382960
  382993
  383869
  154240
  155198
  346141
  89199
  387394
  398113
  398095
  416173
  423927
  416527
  416531
  416575
  408911
  416537
  416690
  419834
  428366
  442337
  814151
  445968
  480502
  449921
  476710
  499930
  508939
  514215
  515441
  531583
  514257
  529128
  529713
  534529
  514879
  538253
  526902
  529714
  533717
  534535
  535651
  469087
  545453
  547464
  547476
  550708
  541128
  541421
  580193
  540945
  544143
  545422
]
2.90 ms
(1.64%)
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
  65760
  89199
  154240
  154535
  155198
  346141
  382960
  382993
  383869
  383920
  387394
  392839
  395252
  398073
  398095
  398113
  401178
  403288
  408885
  408911
  415859
  416173
  416527
  416531
  416537
  416575
  416690
  419834
  423927
  428366
  432933
  435593
  442337
  444531
  445968
  449921
  469087
  476710
  477759
  480502
  482293
  499930
  499931
  506119
  508939
  514215
  514257
  514879
  515441
  526902
  529128
  529713
  529714
  531583
  533717
  534529
  534535
  535651
  538253
  538510
  540945
  541128
  541421
  544143
  545422
  545453
  547464
  547476
  547890
  550708
  550884
  580193
  622720
  642013
  736337
  738822
  739154
  739805
  740926
  742303
  743947
  744021
  744795
  745083
  745086
  745128
  746177
  748287
  748491
  749067
  749084
  749221
  749700
  752617
  752627
  752637
  752652
  752675
  752686
  752710
  752712
  752713
  752784
  761621
  766943
  769148
  770254
  770262
  771887
  784985
  785073
  788521
  794213
  801629
  801643
  804417
  806928
  810635
  811765
  814151
]
2.18 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор соло"
]
1.85 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme solo"
]
1.77 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор соло"
]
1.68 ms
(0.95%)
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.