GET https://search.jues.net/search/embeds/6?q=sex%20hot

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.49 ms
(86.66%)
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
  13338
  21626
  73672
  190732
  324827
  365901
  382385
  438765
  475280
  518818
  528397
  547259
  551024
  565228
  570686
  573104
  593193
  601147
  603001
  603612
  604163
  611796
  611905
  612273
  624462
  633748
  634954
  638858
  644273
  671107
  680583
  693295
  695638
  699672
  708107
  710453
  713657
  716769
  717833
  717904
  718606
  721200
  722113
  722161
  722440
  724770
  730763
  733650
  738178
  741142
  748477
  749982
  753405
  755367
  758870
  760455
  760851
  760918
  773380
  773469
  777460
  779220
  779509
  780180
  781121
  787739
  787882
  793808
  793894
  795083
  795880
  796241
  797524
  797582
  799403
  800112
  800688
  802349
  802399
  804370
  810626
  813857
  817873
  819209
  819210
  819413
  819778
  820591
  820734
  823546
  823554
  823873
  824910
  825006
  825434
  825750
  826300
  826342
  826792
  826976
  827105
  827164
  827403
  827930
  827946
  828088
  828106
  828169
  828195
  828199
  828336
  828440
  828452
  828467
  828493
  828699
  828725
  828805
]
9.08 ms
(6.70%)
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
  644273
  518818
  475280
  828336
  828440
  324827
  633748
  826300
  547259
  716769
  638858
  796241
  604163
  593193
  755367
  828195
  828199
  828699
  828452
  438765
  601147
  190732
  799403
  826342
  828169
  825434
  828467
  570686
  722161
  612273
  797582
  804370
  733650
  717833
  826792
  826976
  828106
  828493
  748477
  760851
  611905
  693295
  777460
  762279
  365901
  382385
  813857
  828805
  565228
  671107
  699672
  717904
  713657
  634954
  760455
  795880
  797524
  741142
  773469
  773380
  708107
  528397
  819413
  827105
  820734
  680583
  721200
  779220
  749982
  722113
  13338
  795083
  800112
  21626
  827164
  611796
  760918
  827403
  824910
  823546
  738178
  722440
  603612
  603001
  73672
  817873
  819210
  820591
  819209
  819778
  823554
  825750
  828088
  828725
  551024
  573104
  710453
  718606
  624462
  802399
  787739
  724770
  780180
  781121
  787882
  823873
  827946
  810626
  825006
  826137
  730763
  800688
  758870
  827930
  695638
  779509
  793808
  793894
  802349
  753405
]
2.24 ms
(1.65%)
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
  13338
  21626
  73672
  190732
  324827
  365901
  382385
  438765
  475280
  518818
  528397
  547259
  551024
  565228
  570686
  573104
  593193
  601147
  603001
  603612
  604163
  611796
  611905
  612273
  624462
  633748
  634954
  638858
  644273
  671107
  680583
  693295
  695638
  699672
  708107
  710453
  713657
  716769
  717833
  717904
  718606
  721200
  722113
  722161
  722440
  724770
  730763
  733650
  738178
  741142
  748477
  749982
  753405
  755367
  758870
  760455
  760851
  760918
  773380
  773469
  777460
  779220
  779509
  780180
  781121
  787739
  787882
  793808
  793894
  795083
  795880
  796241
  797524
  797582
  799403
  800112
  800688
  802349
  802399
  804370
  810626
  813857
  817873
  819209
  819210
  819413
  819778
  820591
  820734
  823546
  823554
  823873
  824910
  825006
  825434
  825750
  826300
  826342
  826792
  826976
  827105
  827164
  827403
  827930
  827946
  828088
  828106
  828169
  828195
  828199
  828336
  828440
  828452
  828467
  828493
  828699
  828725
  828805
]
2.06 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex hot"
]
1.78 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс hot"
]
1.27 ms
(0.94%)
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.