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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.35 ms
(86.14%)
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
  388180
  390108
  439405
  439960
  439993
  441027
  448414
  453583
  473745
  483749
  494491
  494529
  494532
  500290
  508566
  510746
  525315
  529595
  530428
  531822
  531827
  531852
  531855
  531874
  537155
  537269
  541533
  542874
  545242
  545449
  545462
  545551
  548197
  548926
  566282
  575171
  575885
  584031
  587484
  595149
  595166
  595177
  595194
  595581
  599477
  600922
  621960
  627194
  636751
  641787
  642076
  643249
  644335
  647530
  654988
  660383
  663317
  666855
  670210
  676689
  690531
  705571
  707571
  710528
  722383
  722394
  727976
  731790
  739798
  740580
  745295
  748492
  752654
  752675
  752713
  756749
  756785
  757473
  758622
  760195
  760548
  760563
  760659
  769149
  769343
  770379
  772213
  772257
  777751
  777768
  779280
  780306
  780329
  780387
  780393
  781259
  782044
  782517
  782998
  783016
  784236
  786015
  786864
  786888
  791028
  791880
  793072
  793149
  796700
  796716
  797001
  798297
  803551
  806454
  806524
  807110
  808991
  811603
  827296
  828478
]
14.56 ms
(8.51%)
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
  676689
  595149
  595177
  806524
  811603
  828478
  566282
  643249
  531827
  531852
  548926
  710528
  644335
  500290
  453583
  483749
  541533
  786888
  803551
  752654
  758622
  745295
  740580
  756749
  782998
  796700
  575885
  690531
  782044
  537155
  510746
  531874
  545462
  663317
  760548
  796716
  494529
  595166
  441027
  494491
  448414
  595194
  545242
  780306
  793149
  798297
  786864
  748492
  769343
  727976
  757473
  779280
  780329
  780387
  545449
  575171
  545551
  666855
  621960
  777751
  777768
  772257
  587484
  647530
  636751
  525315
  388180
  827296
  660383
  548197
  769149
  770379
  783016
  797001
  529595
  537269
  494532
  642076
  627194
  784236
  705571
  791880
  390108
  595581
  760659
  707571
  542874
  584031
  654988
  722394
  780393
  781259
  791028
  807110
  760195
  772213
  731790
  756785
  739798
  760563
  722383
  531855
  641787
  473745
  508566
  439405
  439993
  439960
  786015
  793072
  808991
  806454
  599477
  531822
  530428
  670210
  600922
  782517
  752675
  752713
]
2.68 ms
(1.56%)
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
  388180
  390108
  439405
  439960
  439993
  441027
  448414
  453583
  473745
  483749
  494491
  494529
  494532
  500290
  508566
  510746
  525315
  529595
  530428
  531822
  531827
  531852
  531855
  531874
  537155
  537269
  541533
  542874
  545242
  545449
  545462
  545551
  548197
  548926
  566282
  575171
  575885
  584031
  587484
  595149
  595166
  595177
  595194
  595581
  599477
  600922
  621960
  627194
  636751
  641787
  642076
  643249
  644335
  647530
  654988
  660383
  663317
  666855
  670210
  676689
  690531
  705571
  707571
  710528
  722383
  722394
  727976
  731790
  739798
  740580
  745295
  748492
  752654
  752675
  752713
  756749
  756785
  757473
  758622
  760195
  760548
  760563
  760659
  769149
  769343
  770379
  772213
  772257
  777751
  777768
  779280
  780306
  780329
  780387
  780393
  781259
  782044
  782517
  782998
  783016
  784236
  786015
  786864
  786888
  791028
  791880
  793072
  793149
  796700
  796716
  797001
  798297
  803551
  806454
  806524
  807110
  808991
  811603
  827296
  828478
]
2.03 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding dildo amateur"
]
1.56 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding дилд любительск"
]
1.50 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.81%)
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.