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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
258.78 ms
(92.54%)
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
  3438
  6056
  16808
  75936
  89480
  123862
  124308
  188150
  188244
  188258
  188462
  259942
  271638
  381842
  382184
  383508
  384752
  385638
  386573
  387104
  387296
  387448
  388098
  388154
  388440
  389713
  391075
  391158
  391571
  391930
  398532
  407810
  419146
  443422
  443925
  451022
  454384
  473334
  477933
  480851
  488414
  488961
  493119
  520936
  527842
  529247
  531275
  535533
  536519
  542787
  543585
  543904
  545890
  548305
  555274
  571123
  573183
  576533
  583820
  592652
  595143
  607697
  621716
  642820
  643542
  647689
  664825
  664855
  665394
  665414
  665456
  665503
  665507
  666993
  667314
  668182
  668739
  668827
  668829
  672938
  681179
  681216
  693308
  699385
  717514
  721004
  725030
  726544
  728657
  729274
  730620
  741700
  744370
  746713
  751245
  755089
  758446
  768658
  788141
  788192
  788772
  793676
  794732
  799910
  800405
  800916
  801161
  801712
  804134
  804432
  817292
  817591
  818622
  818712
  823850
  827283
  827593
  828257
  828760
]
11.68 ms
(4.18%)
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
  721004
  665456
  699385
  788772
  391158
  16808
  398532
  529247
  817292
  828044
  828760
  668739
  801712
  768658
  407810
  451022
  473334
  535533
  665394
  592652
  607697
  643542
  595143
  728657
  717514
  388440
  443422
  454384
  527842
  520936
  89480
  384752
  271638
  382184
  419146
  542787
  665414
  726544
  188462
  389713
  443925
  823850
  545890
  668827
  693308
  804134
  793676
  751245
  385638
  386573
  383508
  123862
  188244
  188258
  391930
  381842
  188150
  387296
  388098
  391075
  493119
  488414
  531275
  536519
  573183
  576533
  666993
  681216
  665507
  667314
  664825
  664855
  665503
  672938
  681179
  555274
  642820
  788192
  725030
  746713
  758446
  804432
  741700
  729274
  621716
  391571
  480851
  477933
  388154
  488961
  124308
  259942
  75936
  6056
  3438
  387104
  387448
  818712
  827283
  817591
  818622
  828257
  827593
  543904
  583820
  543585
  548305
  571123
  647689
  668182
  668829
  801161
  794732
  799910
  755089
  788141
  800405
  800916
  744370
  730620
]
2.81 ms
(1.01%)
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
  3438
  6056
  16808
  75936
  89480
  123862
  124308
  188150
  188244
  188258
  188462
  259942
  271638
  381842
  382184
  383508
  384752
  385638
  386573
  387104
  387296
  387448
  388098
  388154
  388440
  389713
  391075
  391158
  391571
  391930
  398532
  407810
  419146
  443422
  443925
  451022
  454384
  473334
  477933
  480851
  488414
  488961
  493119
  520936
  527842
  529247
  531275
  535533
  536519
  542787
  543585
  543904
  545890
  548305
  555274
  571123
  573183
  576533
  583820
  592652
  595143
  607697
  621716
  642820
  643542
  647689
  664825
  664855
  665394
  665414
  665456
  665503
  665507
  666993
  667314
  668182
  668739
  668827
  668829
  672938
  681179
  681216
  693308
  699385
  717514
  721004
  725030
  726544
  728657
  729274
  730620
  741700
  744370
  746713
  751245
  755089
  758446
  768658
  788141
  788192
  788772
  793676
  794732
  799910
  800405
  800916
  801161
  801712
  804134
  804432
  817292
  817591
  818622
  818712
  823850
  827283
  827593
  828257
  828760
]
1.74 ms
(0.62%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding mature"
]
1.52 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding mature"
]
1.49 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "riding mature"
]

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.