GET https://search.jues.net/search/embeds/10?q=mature%20old%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.35 ms
(82.19%)
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
  124144
  188379
  191398
  382255
  391562
  395701
  395970
  398931
  398964
  400185
  400479
  400847
  401273
  411751
  412827
  415734
  419524
  419529
  419531
  421327
  421863
  421884
  422353
  422354
  424411
  424462
  426434
  428512
  430810
  435676
  439623
  439641
  439673
  439681
  441004
  444003
  454175
  459643
  459857
  460739
  461057
  465524
  465963
  466200
  466217
  466229
  466251
  466869
  467619
  468842
  469595
  470286
  474627
  474661
  474685
  474689
  477468
  478379
  480290
  484620
  484656
  484665
  484671
  484700
  489138
  490138
  490404
  490409
  491913
  502903
  506056
  509995
  515693
  515986
  518827
  522343
  522605
  523562
  531073
  531231
  531279
  534003
  567338
  577883
  580940
  586564
  593808
  602974
  605576
  612960
  620254
  624465
  667644
  673791
  677974
  699625
  705325
  707368
  710592
  721146
  726654
  739659
  740097
  770115
  784307
  788173
  788767
  798680
  800854
  803459
  803919
  804619
  807327
  807383
  810828
  815051
  815598
  819506
  820683
  825039
]
16.05 ms
(10.87%)
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
  515986
  522343
  461057
  484620
  502903
  580940
  593808
  605576
  602974
  807327
  419524
  422354
  411751
  470286
  467619
  474661
  424411
  474627
  465963
  466217
  474685
  484671
  484700
  489138
  490404
  518827
  803919
  412827
  522605
  531231
  465524
  477468
  567338
  439641
  466869
  439673
  439681
  460739
  490409
  466251
  534003
  480290
  474689
  454175
  459857
  466229
  506056
  491913
  509995
  395701
  395970
  468842
  531073
  677974
  620254
  419529
  430810
  391562
  421884
  478379
  400479
  421863
  624465
  770115
  740097
  441004
  531279
  515693
  577883
  800854
  188379
  382255
  400847
  415734
  815598
  815051
  819506
  820683
  825039
  459643
  523562
  667644
  673791
  707368
  699625
  705325
  710592
  788173
  798680
  810828
  739659
  803459
  807383
  726654
  721146
  784307
  788767
  804619
  124144
  191398
  398931
  424462
  398964
  466200
  419531
  435676
  490138
  444003
  469595
  439623
  422353
  484665
  484656
  612960
  586564
  400185
  401273
  421327
  426434
  428512
]
3.41 ms
(2.31%)
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
  124144
  188379
  191398
  382255
  391562
  395701
  395970
  398931
  398964
  400185
  400479
  400847
  401273
  411751
  412827
  415734
  419524
  419529
  419531
  421327
  421863
  421884
  422353
  422354
  424411
  424462
  426434
  428512
  430810
  435676
  439623
  439641
  439673
  439681
  441004
  444003
  454175
  459643
  459857
  460739
  461057
  465524
  465963
  466200
  466217
  466229
  466251
  466869
  467619
  468842
  469595
  470286
  474627
  474661
  474685
  474689
  477468
  478379
  480290
  484620
  484656
  484665
  484671
  484700
  489138
  490138
  490404
  490409
  491913
  502903
  506056
  509995
  515693
  515986
  518827
  522343
  522605
  523562
  531073
  531231
  531279
  534003
  567338
  577883
  580940
  586564
  593808
  602974
  605576
  612960
  620254
  624465
  667644
  673791
  677974
  699625
  705325
  707368
  710592
  721146
  726654
  739659
  740097
  770115
  784307
  788173
  788767
  798680
  800854
  803459
  803919
  804619
  807327
  807383
  810828
  815051
  815598
  819506
  820683
  825039
]
2.00 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature old anal"
]
1.68 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature old анал"
]
1.60 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature old анал"
]

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.