GET https://search.jues.net/search/embeds/3?q=anal%20real

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.86 ms
(49.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал real"
]
191.65 ms
(45.00%)
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
  382432
  395735
  401264
  401757
  420254
  420877
  423516
  427544
  432743
  432745
  440274
  440414
  440749
  440902
  440947
  440963
  441984
  451629
  455745
  457146
  458443
  459650
  462681
  464853
  465540
  468749
  487987
  499083
  505725
  516692
  520790
  525039
  537958
  541755
  552697
  560966
  562225
  564750
  577678
  581384
  590029
  598623
  599072
  604221
  608070
  610434
  610517
  610522
  614880
  615841
  619797
  621979
  626688
  631117
  633455
  636951
  641153
  647060
  656597
  659324
  665831
  668097
  685843
  692817
  695882
  696198
  696536
  707569
  712374
  712393
  713676
  719225
  720449
  721978
  724048
  727805
  727882
  731224
  731361
  732579
  735005
  740009
  748334
  757715
  760214
  761030
  761531
  762199
  766588
  769291
  769683
  771858
  784288
  784292
  786578
  789273
  790972
  791416
  792184
  793075
  793597
  796183
  796194
  798675
  800975
  801290
  801737
  805643
  807419
  813016
  815174
  815729
  816052
  816359
  816544
  818833
  820164
  823359
  824320
  824868
]
16.56 ms
(3.89%)
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
  735005
  816052
  731224
  732579
  815174
  818833
  815729
  816359
  816544
  695882
  696198
  621979
  641153
  590029
  784292
  786578
  792184
  731361
  769683
  789273
  440963
  824320
  459650
  499083
  516692
  564750
  712374
  720449
  665831
  656597
  685843
  696536
  793075
  796183
  801737
  793597
  761531
  766588
  796194
  762199
  771858
  631117
  791416
  805643
  692817
  401264
  441984
  487987
  619797
  727805
  455745
  432743
  824868
  525039
  713676
  659324
  740009
  761030
  440947
  465540
  440749
  427544
  440902
  541755
  610522
  633455
  598623
  610517
  636951
  608070
  807419
  760214
  813016
  727882
  707569
  382432
  820164
  721978
  719225
  668097
  560966
  610434
  626688
  790972
  800975
  801290
  798675
  784288
  748334
  757715
  712393
  423516
  464853
  468749
  537958
  562225
  581384
  647060
  599072
  604221
  615841
  769291
  401757
  395735
  458443
  457146
  505725
  552697
  823359
  451629
  462681
  577678
  614880
  724048
  420254
  440274
  440414
  432745
  420877
  520790
]
3.01 ms
(0.71%)
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
  382432
  395735
  401264
  401757
  420254
  420877
  423516
  427544
  432743
  432745
  440274
  440414
  440749
  440902
  440947
  440963
  441984
  451629
  455745
  457146
  458443
  459650
  462681
  464853
  465540
  468749
  487987
  499083
  505725
  516692
  520790
  525039
  537958
  541755
  552697
  560966
  562225
  564750
  577678
  581384
  590029
  598623
  599072
  604221
  608070
  610434
  610517
  610522
  614880
  615841
  619797
  621979
  626688
  631117
  633455
  636951
  641153
  647060
  656597
  659324
  665831
  668097
  685843
  692817
  695882
  696198
  696536
  707569
  712374
  712393
  713676
  719225
  720449
  721978
  724048
  727805
  727882
  731224
  731361
  732579
  735005
  740009
  748334
  757715
  760214
  761030
  761531
  762199
  766588
  769291
  769683
  771858
  784288
  784292
  786578
  789273
  790972
  791416
  792184
  793075
  793597
  796183
  796194
  798675
  800975
  801290
  801737
  805643
  807419
  813016
  815174
  815729
  816052
  816359
  816544
  818833
  820164
  823359
  824320
  824868
]
1.87 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal real"
]
1.50 ms
(0.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал real"
]
1.46 ms
(0.34%)
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.