GET https://search.jues.net/search/embeds/4?q=small%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.38 ms
(88.72%)
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
  385472
  385725
  457399
  529807
  530102
  530165
  530168
  530177
  530198
  530210
  530241
  530265
  543170
  544711
  544957
  545980
  546264
  546674
  548284
  548819
  553192
  555147
  556770
  560718
  560755
  561039
  562104
  577041
  578206
  581134
  592102
  603125
  610527
  611178
  613372
  613387
  613484
  613923
  615059
  619274
  622483
  625347
  628933
  630011
  632719
  632816
  634287
  635781
  636972
  638738
  639243
  645798
  647244
  648043
  648728
  649459
  651278
  651726
  653156
  653788
  653821
  665602
  668552
  670738
  671178
  678772
  679533
  685388
  688715
  689079
  689567
  689837
  689926
  692443
  692627
  694137
  694568
  696459
  699515
  704347
  704422
  705079
  705117
  705490
  707401
  707504
  715652
  716694
  718609
  719121
  726458
  727166
  736259
  736608
  761307
  762275
  767816
  774654
  775133
  778875
  783877
  786547
  790344
  796737
  798923
  808441
  813498
  813504
  814127
  818986
  824099
  824917
  825295
  826080
  826528
  826542
  826613
  826630
  827731
  827831
]
13.00 ms
(6.25%)
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
  796737
  560755
  786547
  726458
  715652
  385725
  798923
  670738
  530210
  530177
  548819
  707401
  578206
  613387
  611178
  544957
  546264
  385472
  824099
  826080
  818986
  457399
  767816
  761307
  694568
  544711
  636972
  762275
  679533
  696459
  615059
  827831
  530102
  529807
  562104
  553192
  546674
  555147
  561039
  648043
  671178
  685388
  707504
  648728
  651726
  653156
  668552
  689079
  689837
  704422
  705079
  718609
  645798
  647244
  649459
  653821
  665602
  678772
  688715
  689567
  689926
  692443
  545980
  560718
  581134
  613923
  619274
  625347
  610527
  613372
  613484
  635781
  628933
  592102
  622483
  638738
  808441
  736259
  813498
  727166
  630011
  632816
  699515
  705117
  705490
  719121
  775133
  778875
  824917
  774654
  790344
  813504
  694137
  639243
  530165
  530168
  530198
  530241
  530265
  543170
  634287
  556770
  577041
  716694
  651278
  548284
  783877
  736608
  653788
  692627
  632719
  603125
  704347
  825295
  826613
  826528
  826542
  826630
  814127
  827731
]
3.29 ms
(1.59%)
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
  385472
  385725
  457399
  529807
  530102
  530165
  530168
  530177
  530198
  530210
  530241
  530265
  543170
  544711
  544957
  545980
  546264
  546674
  548284
  548819
  553192
  555147
  556770
  560718
  560755
  561039
  562104
  577041
  578206
  581134
  592102
  603125
  610527
  611178
  613372
  613387
  613484
  613923
  615059
  619274
  622483
  625347
  628933
  630011
  632719
  632816
  634287
  635781
  636972
  638738
  639243
  645798
  647244
  648043
  648728
  649459
  651278
  651726
  653156
  653788
  653821
  665602
  668552
  670738
  671178
  678772
  679533
  685388
  688715
  689079
  689567
  689837
  689926
  692443
  692627
  694137
  694568
  696459
  699515
  704347
  704422
  705079
  705117
  705490
  707401
  707504
  715652
  716694
  718609
  719121
  726458
  727166
  736259
  736608
  761307
  762275
  767816
  774654
  775133
  778875
  783877
  786547
  790344
  796737
  798923
  808441
  813498
  813504
  814127
  818986
  824099
  824917
  825295
  826080
  826528
  826542
  826613
  826630
  827731
  827831
]
2.06 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small amateur"
]
1.75 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая любительск"
]
1.36 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.