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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.17 ms
(85.31%)
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
  93524
  96955
  395275
  397188
  401614
  401757
  404946
  406404
  410651
  417094
  418623
  440902
  446999
  447662
  453820
  464929
  467953
  468453
  472272
  486589
  496750
  502781
  509859
  519444
  525081
  532365
  533164
  547220
  549089
  552653
  568093
  575625
  576934
  584246
  585457
  588162
  589067
  593599
  600146
  604311
  613240
  618074
  618363
  623289
  632568
  638585
  661950
  662203
  665959
  665980
  677053
  678554
  679660
  702046
  711937
  712698
  715892
  717837
  722925
  723566
  726221
  727266
  728151
  729644
  730355
  731350
  731463
  731565
  733661
  734483
  736830
  740839
  747430
  747740
  747815
  749688
  750760
  760895
  761711
  761748
  761814
  764125
  765428
  765717
  766634
  766740
  766762
  767276
  767289
  767318
  768261
  771039
  771288
  773097
  773314
  775484
  775614
  775896
  789465
  790496
  791364
  792139
  792571
  798675
  799091
  799348
  799974
  805655
  806649
  807353
  809306
  811552
  813984
  814008
  816016
  820167
  820901
  825941
  827899
]
12.63 ms
(8.28%)
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
  519444
  96955
  677053
  588162
  761748
  805655
  809306
  486589
  820167
  820901
  773314
  791364
  397188
  417094
  576934
  665959
  792139
  765428
  731565
  723566
  730355
  761814
  765717
  767276
  766762
  740839
  575625
  679660
  767289
  764125
  816016
  502781
  547220
  638585
  618074
  775484
  771288
  733661
  731350
  533164
  661950
  600146
  726221
  604311
  775896
  736830
  827899
  447662
  768261
  395275
  702046
  799348
  734483
  790496
  813984
  814008
  665980
  789465
  792571
  767318
  728151
  799974
  806649
  729644
  750760
  761711
  93524
  585457
  593599
  404946
  440902
  532365
  549089
  717837
  584246
  771039
  766740
  632568
  715892
  722925
  825941
  712698
  678554
  618363
  798675
  727266
  772133
  773097
  613240
  623289
  775614
  472272
  418623
  552653
  568093
  749688
  401757
  410651
  446999
  468453
  589067
  747740
  799091
  525081
  453820
  464929
  496750
  467953
  711937
  662203
  807353
  811552
  747430
  747815
  760895
  731463
  766634
  401614
  509859
  406404
]
2.47 ms
(1.62%)
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
  93524
  96955
  395275
  397188
  401614
  401757
  404946
  406404
  410651
  417094
  418623
  440902
  446999
  447662
  453820
  464929
  467953
  468453
  472272
  486589
  496750
  502781
  509859
  519444
  525081
  532365
  533164
  547220
  549089
  552653
  568093
  575625
  576934
  584246
  585457
  588162
  589067
  593599
  600146
  604311
  613240
  618074
  618363
  623289
  632568
  638585
  661950
  662203
  665959
  665980
  677053
  678554
  679660
  702046
  711937
  712698
  715892
  717837
  722925
  723566
  726221
  727266
  728151
  729644
  730355
  731350
  731463
  731565
  733661
  734483
  736830
  740839
  747430
  747740
  747815
  749688
  750760
  760895
  761711
  761748
  761814
  764125
  765428
  765717
  766634
  766740
  766762
  767276
  767289
  767318
  768261
  771039
  771288
  773097
  773314
  775484
  775614
  775896
  789465
  790496
  791364
  792139
  792571
  798675
  799091
  799348
  799974
  805655
  806649
  807353
  809306
  811552
  813984
  814008
  816016
  820167
  820901
  825941
  827899
]
1.97 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "best анал"
]
1.94 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "best of anal"
]
1.82 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "best анал"
]
1.58 ms
(1.04%)
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.