GET https://search.jues.net/search/embeds/3?q=mouth%20sperm

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.67 ms
(86.13%)
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
  69883
  336884
  393164
  398679
  488565
  494312
  503388
  505936
  517739
  520364
  540606
  543153
  553701
  563382
  563962
  581289
  584956
  586978
  591919
  597829
  623407
  634597
  634599
  636399
  642041
  663223
  666001
  666402
  674616
  695693
  696220
  697731
  707729
  710819
  714360
  717958
  718400
  718533
  719215
  719284
  720082
  720272
  723156
  724810
  729186
  730717
  731277
  731429
  733138
  733198
  734402
  735841
  736643
  739253
  739542
  739981
  746725
  746730
  755605
  763002
  767801
  767807
  767816
  768974
  769221
  769840
  770067
  772339
  772371
  775159
  775162
  775165
  777452
  777961
  779047
  779781
  779783
  780250
  781034
  781465
  782691
  786841
  787222
  787258
  787269
  790057
  790705
  790766
  791605
  791617
  810044
  810216
  813634
  813955
  817001
  819718
  821429
  823875
  823897
  824113
  824948
  824973
  825006
  825045
  825108
  825179
  825180
  825208
  825347
  825417
  825425
  825460
  825464
  825837
  826240
  826586
  827108
  828193
]
12.63 ms
(7.96%)
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
  825417
  826524
  780250
  494312
  719215
  636399
  779783
  730717
  746730
  781465
  540606
  543153
  720272
  718400
  634599
  724810
  735841
  755605
  770067
  775165
  787269
  825837
  825179
  825347
  825464
  767816
  597829
  813955
  488565
  505936
  563962
  666001
  718533
  719284
  723156
  775159
  775162
  779781
  781034
  791617
  734402
  739253
  746725
  782691
  786841
  787258
  790705
  791605
  731277
  768974
  769221
  772339
  729186
  736643
  739981
  763002
  767801
  731429
  714360
  777961
  779047
  787222
  790766
  810044
  810216
  336884
  823875
  824973
  817001
  823897
  826240
  827108
  821429
  825108
  825180
  828193
  696220
  733198
  769840
  813634
  695693
  707729
  720082
  777452
  790057
  739542
  772371
  767807
  717958
  642041
  517739
  825045
  520364
  503388
  393164
  398679
  825006
  825460
  826137
  826586
  825425
  824948
  825208
  819718
  824113
  733138
  69883
  553701
  563382
  663223
  666402
  674616
  697731
  710819
  581289
  584956
  586978
  623407
  591919
  634597
]
2.29 ms
(1.44%)
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
  69883
  336884
  393164
  398679
  488565
  494312
  503388
  505936
  517739
  520364
  540606
  543153
  553701
  563382
  563962
  581289
  584956
  586978
  591919
  597829
  623407
  634597
  634599
  636399
  642041
  663223
  666001
  666402
  674616
  695693
  696220
  697731
  707729
  710819
  714360
  717958
  718400
  718533
  719215
  719284
  720082
  720272
  723156
  724810
  729186
  730717
  731277
  731429
  733138
  733198
  734402
  735841
  736643
  739253
  739542
  739981
  746725
  746730
  755605
  763002
  767801
  767807
  767816
  768974
  769221
  769840
  770067
  772339
  772371
  775159
  775162
  775165
  777452
  777961
  779047
  779781
  779783
  780250
  781034
  781465
  782691
  786841
  787222
  787258
  787269
  790057
  790705
  790766
  791605
  791617
  810044
  810216
  813634
  813955
  817001
  819718
  821429
  823875
  823897
  824113
  824948
  824973
  825006
  825045
  825108
  825179
  825180
  825208
  825347
  825417
  825425
  825460
  825464
  825837
  826240
  826586
  827108
  828193
]
1.99 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mouth sperm"
]
1.62 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mouth сперм"
]
1.53 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mouth сперм"
]

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.