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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
195.01 ms
(89.90%)
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
  73503
  418438
  425475
  529594
  529610
  531876
  534654
  550596
  559171
  583594
  622853
  625231
  627126
  637798
  717103
  718117
  723196
  724806
  724829
  725333
  726308
  734453
  735559
  735789
  735795
  738543
  740040
  740082
  740666
  742951
  743967
  744713
  744762
  746391
  747273
  748107
  749145
  750358
  750574
  750671
  750856
  751004
  751287
  751972
  752221
  753778
  754432
  754497
  755866
  757186
  757301
  757686
  758128
  758604
  759872
  760092
  762253
  763524
  764716
  765823
  767908
  768699
  768882
  769046
  769073
  770098
  770729
  771873
  773809
  774919
  775187
  775512
  777873
  778012
  778600
  779035
  779123
  779132
  779142
  780452
  781125
  781184
  782345
  782858
  784290
  784426
  785735
  786700
  787167
  788962
  789282
  789380
  789825
  792260
  792728
  793484
  794623
  794889
  794912
  795855
  796792
  796937
  797342
  797357
  801437
  803551
  805106
  808479
  816659
  823605
  823650
  825335
  825412
  825916
  826613
  827141
  827167
  827241
  827490
  828847
]
11.94 ms
(5.50%)
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
  622853
  637798
  425475
  73503
  418438
  825916
  826613
  825335
  816659
  823650
  827141
  827167
  827241
  823605
  825412
  828847
  827490
  529594
  531876
  529610
  534654
  550596
  559171
  583594
  718117
  775512
  778600
  779132
  779142
  787167
  788962
  789380
  792260
  793484
  794623
  794912
  795855
  796937
  797342
  803551
  774919
  775187
  778012
  779123
  780452
  781125
  781184
  782345
  782858
  784426
  785735
  794889
  801437
  805106
  725333
  740040
  749145
  750358
  750574
  750671
  751004
  752221
  754432
  755866
  757186
  757301
  764716
  769073
  784290
  786700
  789825
  792728
  808479
  734453
  742951
  743967
  744762
  746391
  750856
  758128
  759872
  762253
  765823
  769046
  724829
  726308
  735789
  735795
  747273
  751972
  753778
  757686
  758604
  767908
  735559
  738543
  751287
  760092
  763524
  768699
  768882
  770098
  771873
  724806
  740082
  740666
  744713
  748107
  754497
  770729
  773809
  625231
  627126
  717103
  723196
  777873
  779035
  789282
  796792
  797357
]
2.83 ms
(1.31%)
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
  73503
  418438
  425475
  529594
  529610
  531876
  534654
  550596
  559171
  583594
  622853
  625231
  627126
  637798
  717103
  718117
  723196
  724806
  724829
  725333
  726308
  734453
  735559
  735789
  735795
  738543
  740040
  740082
  740666
  742951
  743967
  744713
  744762
  746391
  747273
  748107
  749145
  750358
  750574
  750671
  750856
  751004
  751287
  751972
  752221
  753778
  754432
  754497
  755866
  757186
  757301
  757686
  758128
  758604
  759872
  760092
  762253
  763524
  764716
  765823
  767908
  768699
  768882
  769046
  769073
  770098
  770729
  771873
  773809
  774919
  775187
  775512
  777873
  778012
  778600
  779035
  779123
  779132
  779142
  780452
  781125
  781184
  782345
  782858
  784290
  784426
  785735
  786700
  787167
  788962
  789282
  789380
  789825
  792260
  792728
  793484
  794623
  794889
  794912
  795855
  796792
  796937
  797342
  797357
  801437
  803551
  805106
  808479
  816659
  823605
  823650
  825335
  825412
  825916
  826613
  827141
  827167
  827241
  827490
  828847
]
1.92 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск hot"
]
1.84 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur hot"
]
1.82 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.71%)
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.