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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.63 ms
(87.48%)
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
  383672
  390108
  390286
  412855
  415863
  424192
  439796
  440708
  450933
  451222
  451316
  454384
  469959
  483735
  487291
  529595
  531827
  531852
  531855
  531874
  537155
  537269
  537321
  540426
  542874
  545449
  545462
  545551
  548197
  548926
  566282
  575171
  575956
  584031
  587484
  595166
  595194
  595581
  596223
  596632
  613780
  616349
  619666
  621960
  625779
  627194
  636751
  641997
  642076
  643249
  644335
  647530
  650719
  654988
  660383
  663317
  666855
  672323
  705571
  710528
  712496
  722383
  722394
  727976
  731790
  735931
  739798
  740580
  742672
  744050
  745295
  748492
  752654
  752689
  756749
  756785
  757473
  757872
  758622
  759335
  760195
  760548
  760563
  760659
  769149
  769343
  770379
  772257
  777751
  777768
  779280
  780309
  780387
  780393
  781259
  781262
  782998
  783016
  786015
  786864
  786888
  787466
  791028
  791880
  793072
  793149
  796692
  796700
  796716
  798297
  799683
  803551
  806454
  806828
  807110
  808971
  808991
  809015
  824668
  827296
]
11.68 ms
(6.65%)
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
  786888
  793149
  798297
  803551
  786864
  748492
  752654
  758622
  745295
  769343
  740580
  742672
  756749
  727976
  757473
  779280
  780387
  782998
  796700
  487291
  824668
  787466
  808971
  781262
  412855
  483735
  809015
  537155
  531827
  531852
  531874
  545462
  548926
  710528
  712496
  663317
  619666
  644335
  760548
  796716
  641997
  439796
  390286
  827296
  660383
  548197
  595166
  786015
  793072
  808991
  769149
  770379
  806454
  542874
  575956
  584031
  650719
  654988
  647530
  672323
  722394
  596223
  636751
  780393
  781259
  791028
  807110
  796692
  760195
  783016
  757872
  731790
  756785
  739798
  759335
  760563
  735931
  722383
  780309
  806828
  440708
  469959
  451316
  540426
  613780
  616349
  566282
  643249
  744050
  415863
  537321
  596632
  450933
  454384
  451222
  529595
  537269
  545449
  575171
  545551
  666855
  642076
  621960
  627194
  777751
  777768
  772257
  752689
  625779
  705571
  791880
  799683
  383672
  531855
  390108
  595194
  595581
  587484
  760659
  424192
]
3.16 ms
(1.80%)
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
  383672
  390108
  390286
  412855
  415863
  424192
  439796
  440708
  450933
  451222
  451316
  454384
  469959
  483735
  487291
  529595
  531827
  531852
  531855
  531874
  537155
  537269
  537321
  540426
  542874
  545449
  545462
  545551
  548197
  548926
  566282
  575171
  575956
  584031
  587484
  595166
  595194
  595581
  596223
  596632
  613780
  616349
  619666
  621960
  625779
  627194
  636751
  641997
  642076
  643249
  644335
  647530
  650719
  654988
  660383
  663317
  666855
  672323
  705571
  710528
  712496
  722383
  722394
  727976
  731790
  735931
  739798
  740580
  742672
  744050
  745295
  748492
  752654
  752689
  756749
  756785
  757473
  757872
  758622
  759335
  760195
  760548
  760563
  760659
  769149
  769343
  770379
  772257
  777751
  777768
  779280
  780309
  780387
  780393
  781259
  781262
  782998
  783016
  786015
  786864
  786888
  787466
  791028
  791880
  793072
  793149
  796692
  796700
  796716
  798297
  799683
  803551
  806454
  806828
  807110
  808971
  808991
  809015
  824668
  827296
]
1.94 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo riding solo"
]
1.81 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд riding соло"
]
1.61 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд riding соло"
]

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.