GET https://search.jues.net/search/embeds/3?q=riding%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.68 ms
(87.79%)
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
  384416
  384498
  397680
  497410
  513421
  541347
  556424
  557262
  577610
  581980
  588363
  591863
  592540
  592546
  597180
  597935
  606804
  616506
  635878
  636152
  636425
  638014
  638177
  639503
  640254
  641292
  653844
  666491
  687326
  693218
  699988
  705502
  707633
  712458
  714373
  714389
  716781
  717359
  718107
  718113
  719043
  721714
  723867
  724015
  724053
  725299
  725304
  728661
  728954
  729018
  730165
  730175
  738878
  749780
  752520
  754229
  755395
  758710
  759503
  760621
  765383
  767277
  767449
  768518
  768641
  769068
  775410
  775464
  777675
  780585
  780977
  781142
  783649
  783873
  788358
  788681
  790336
  791028
  791135
  791185
  791631
  791657
  791663
  791728
  791860
  793396
  793488
  793658
  794053
  795082
  795236
  795253
  795771
  796034
  796679
  796692
  796796
  796998
  798497
  799829
  800897
  800998
  801677
  801678
  801997
  803890
  803961
  804593
  805270
  810083
  811925
  813297
  813305
  817325
  818759
  820362
  825890
  826369
  828788
]
11.70 ms
(6.24%)
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
  717359
  718107
  636425
  616506
  636152
  638014
  597180
  781142
  791135
  798497
  813297
  775410
  775464
  791185
  793658
  794053
  796034
  796998
  800998
  811925
  728661
  738878
  759503
  791657
  795771
  803961
  804593
  725304
  752520
  723867
  724015
  730175
  754229
  758710
  765383
  728954
  755395
  768518
  725299
  749780
  699988
  791860
  795082
  800897
  801997
  803890
  805270
  384416
  384498
  397680
  820362
  817325
  818759
  825890
  828788
  826369
  497410
  513421
  541347
  557262
  581980
  577610
  687326
  693218
  707633
  721714
  653844
  712458
  714373
  714389
  719043
  666491
  705502
  716781
  718113
  556424
  588363
  591863
  592540
  592546
  606804
  635878
  638177
  640254
  597935
  639503
  641292
  777675
  780977
  788681
  791028
  791663
  791728
  799829
  801677
  813305
  780585
  783873
  788358
  791631
  793488
  795253
  796692
  801678
  724053
  729018
  730165
  760621
  767277
  767449
  768641
  769068
  769374
  783649
  790336
  793396
  795236
  796679
  796796
  810083
]
3.65 ms
(1.94%)
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
  384416
  384498
  397680
  497410
  513421
  541347
  556424
  557262
  577610
  581980
  588363
  591863
  592540
  592546
  597180
  597935
  606804
  616506
  635878
  636152
  636425
  638014
  638177
  639503
  640254
  641292
  653844
  666491
  687326
  693218
  699988
  705502
  707633
  712458
  714373
  714389
  716781
  717359
  718107
  718113
  719043
  721714
  723867
  724015
  724053
  725299
  725304
  728661
  728954
  729018
  730165
  730175
  738878
  749780
  752520
  754229
  755395
  758710
  759503
  760621
  765383
  767277
  767449
  768518
  768641
  769068
  775410
  775464
  777675
  780585
  780977
  781142
  783649
  783873
  788358
  788681
  790336
  791028
  791135
  791185
  791631
  791657
  791663
  791728
  791860
  793396
  793488
  793658
  794053
  795082
  795236
  795253
  795771
  796034
  796679
  796692
  796796
  796998
  798497
  799829
  800897
  800998
  801677
  801678
  801997
  803890
  803961
  804593
  805270
  810083
  811925
  813297
  813305
  817325
  818759
  820362
  825890
  826369
  828788
]
2.09 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding cum"
]
1.94 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding cum"
]
1.80 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "riding cum"
]

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.