GET https://search.jues.net/search/embeds/9?q=doggy%20hot

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.44 ms
(86.33%)
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
  4266
  104990
  191343
  233862
  276780
  281450
  382186
  385952
  387186
  396106
  396278
  401336
  402032
  403378
  417519
  419159
  435472
  437417
  443836
  446315
  453972
  454091
  468222
  472062
  474360
  476981
  478686
  479958
  480857
  488556
  508483
  518151
  546599
  546772
  555728
  560266
  560867
  580343
  585157
  586608
  586912
  588344
  590970
  591516
  597108
  599508
  603959
  605583
  605976
  607432
  609108
  609679
  615197
  616500
  618019
  621509
  625097
  634995
  640319
  640617
  643025
  678916
  699232
  709872
  711535
  713015
  713841
  716004
  721959
  725547
  727015
  728392
  730069
  730267
  731354
  733542
  734416
  738418
  741032
  745912
  749945
  750275
  752496
  756261
  757180
  761009
  761098
  761192
  767193
  770730
  771643
  773730
  774855
  778185
  778526
  778962
  779317
  780843
  782702
  782745
  784289
  787217
  787827
  788051
  789927
  791371
  791374
  793971
  795743
  796807
  798798
  800050
  800721
  802487
  805652
  806081
  806242
  807134
  812198
  812655
]
15.21 ms
(7.66%)
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
  716004
  580343
  597108
  605976
  609108
  615197
  590970
  591516
  618019
  625097
  640319
  585157
  599508
  603959
  605583
  616500
  634995
  586608
  588344
  621509
  640617
  643025
  778526
  779317
  789927
  795743
  805652
  807134
  812655
  774855
  778185
  778962
  780843
  782745
  791374
  800721
  725547
  741032
  752496
  761098
  770730
  773730
  784289
  788051
  798798
  802487
  728392
  730069
  730267
  731354
  756261
  757180
  761009
  738418
  734416
  745912
  767193
  771643
  727015
  733542
  749945
  750275
  761192
  609679
  699232
  709872
  711535
  713015
  713841
  721959
  782702
  787217
  787827
  791371
  793971
  796807
  800050
  806081
  806242
  812198
  385952
  387186
  396106
  401336
  402032
  233862
  276780
  281450
  4266
  104990
  191343
  453972
  437417
  382186
  403378
  443836
  435472
  419159
  454091
  478686
  518151
  474360
  546772
  560867
  546599
  555728
  560266
  678916
  586912
  607432
  446315
  468222
  480857
  396278
  476981
  479958
  417519
  472062
  508483
  488556
]
4.36 ms
(2.19%)
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
  4266
  104990
  191343
  233862
  276780
  281450
  382186
  385952
  387186
  396106
  396278
  401336
  402032
  403378
  417519
  419159
  435472
  437417
  443836
  446315
  453972
  454091
  468222
  472062
  474360
  476981
  478686
  479958
  480857
  488556
  508483
  518151
  546599
  546772
  555728
  560266
  560867
  580343
  585157
  586608
  586912
  588344
  590970
  591516
  597108
  599508
  603959
  605583
  605976
  607432
  609108
  609679
  615197
  616500
  618019
  621509
  625097
  634995
  640319
  640617
  643025
  678916
  699232
  709872
  711535
  713015
  713841
  716004
  721959
  725547
  727015
  728392
  730069
  730267
  731354
  733542
  734416
  738418
  741032
  745912
  749945
  750275
  752496
  756261
  757180
  761009
  761098
  761192
  767193
  770730
  771643
  773730
  774855
  778185
  778526
  778962
  779317
  780843
  782702
  782745
  784289
  787217
  787827
  788051
  789927
  791371
  791374
  793971
  795743
  796807
  798798
  800050
  800721
  802487
  805652
  806081
  806242
  807134
  812198
  812655
]
2.15 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy hot"
]
2.01 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак hot"
]
1.79 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак hot"
]

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.