GET https://search.jues.net/search/embeds/6?q=russian%20milf%20dildo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.44 ms
(85.56%)
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
  7295
  389966
  391170
  395883
  400491
  400837
  418102
  424008
  424214
  427122
  429598
  429869
  429872
  429889
  429902
  434334
  434338
  435594
  438013
  438018
  439705
  450023
  452937
  452950
  458829
  464978
  465970
  466204
  467763
  467877
  467886
  468142
  469158
  470191
  470215
  473237
  473391
  479768
  480501
  480707
  484692
  490731
  494332
  496240
  498963
  503506
  507638
  508565
  509439
  510836
  513627
  517816
  518595
  519358
  520911
  522689
  523033
  526049
  527424
  532954
  533732
  535622
  545901
  547734
  547754
  547789
  547795
  555044
  555057
  555062
  555091
  556524
  560403
  563438
  565308
  590102
  599234
  599354
  601792
  619540
  619935
  620248
  649528
  672821
  672825
  695477
  700965
  705630
  712542
  722216
  742298
  742303
  742338
  745466
  745485
  749929
  751582
  751627
  754843
  757099
  765815
  767111
  768914
  778130
  779595
  781332
  790648
  795979
  799217
  803035
  806973
  807009
  807594
  808342
  808468
  810896
  814386
  825700
]
16.31 ms
(9.04%)
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
  518595
  498963
  503506
  547795
  555044
  555062
  599354
  619935
  467886
  429598
  429869
  434334
  435594
  470191
  434338
  458829
  467763
  519358
  490731
  522689
  510836
  555057
  547734
  555091
  599234
  424008
  751582
  450023
  526049
  523033
  473391
  400491
  438018
  520911
  424214
  452937
  439705
  452950
  470215
  509439
  532954
  389966
  418102
  479768
  533732
  535622
  672825
  712542
  695477
  700965
  722216
  545901
  619540
  795979
  745485
  749929
  790648
  808342
  810896
  725143
  742303
  745466
  742298
  765815
  768914
  779595
  799217
  469158
  556524
  560403
  547754
  438013
  508565
  484692
  814386
  825700
  672821
  649528
  620248
  781332
  803035
  807009
  806973
  808468
  807594
  742338
  751627
  767111
  754843
  757099
  705630
  778130
  395883
  494332
  496240
  468142
  563438
  547789
  565308
  601792
  590102
  467877
  466204
  7295
  391170
  429889
  464978
  513476
  513627
  527424
  507638
  517816
  480707
  429902
  465970
  429872
  400837
  427122
  473237
  480501
]
3.23 ms
(1.79%)
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
  7295
  389966
  391170
  395883
  400491
  400837
  418102
  424008
  424214
  427122
  429598
  429869
  429872
  429889
  429902
  434334
  434338
  435594
  438013
  438018
  439705
  450023
  452937
  452950
  458829
  464978
  465970
  466204
  467763
  467877
  467886
  468142
  469158
  470191
  470215
  473237
  473391
  479768
  480501
  480707
  484692
  490731
  494332
  496240
  498963
  503506
  507638
  508565
  509439
  510836
  513627
  517816
  518595
  519358
  520911
  522689
  523033
  526049
  527424
  532954
  533732
  535622
  545901
  547734
  547754
  547789
  547795
  555044
  555057
  555062
  555091
  556524
  560403
  563438
  565308
  590102
  599234
  599354
  601792
  619540
  619935
  620248
  649528
  672821
  672825
  695477
  700965
  705630
  712542
  722216
  742298
  742303
  742338
  745466
  745485
  749929
  751582
  751627
  754843
  757099
  765815
  767111
  768914
  778130
  779595
  781332
  790648
  795979
  799217
  803035
  806973
  807009
  807594
  808342
  808468
  810896
  814386
  825700
]
1.84 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian milf dildo"
]
1.71 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск milf дилд"
]
1.54 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск milf дилд"
]
1.45 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.