GET https://search.jues.net/search/embeds/7?q=mature%20stepson

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.43 ms
(83.44%)
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
  397372
  401909
  406969
  407019
  433291
  439735
  439771
  448409
  454501
  454666
  457418
  462472
  465354
  466064
  466165
  466729
  467682
  469345
  474148
  476283
  478373
  478374
  482545
  483386
  484611
  484704
  485458
  485922
  487343
  490030
  493127
  493215
  493221
  493899
  496862
  507624
  515916
  516222
  516713
  517017
  518944
  519046
  526833
  527991
  532821
  546126
  549548
  549831
  549840
  549843
  551741
  557596
  562960
  562964
  563003
  563012
  563641
  564246
  564551
  565261
  565737
  565757
  567491
  580744
  580750
  582222
  590345
  591130
  600394
  602961
  610293
  615513
  619511
  620307
  628648
  636242
  637402
  644093
  649156
  660006
  670755
  673655
  676121
  678962
  682304
  694006
  710447
  714884
  716299
  720105
  720603
  725624
  726590
  738203
  738281
  738325
  742861
  747094
  750301
  759756
  764151
  780612
  788281
  791737
  792617
  794106
  794306
  794766
  796123
  799127
  799352
  801856
  802206
  803086
  803776
  803813
  804458
  806356
  809554
  813956
]
17.25 ms
(11.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
  490030
  466064
  532821
  518944
  527991
  507624
  467682
  582222
  551741
  565757
  562960
  563003
  563012
  564551
  694006
  720105
  676121
  682304
  714884
  660006
  670755
  710447
  546126
  602961
  620307
  636242
  628648
  644093
  794106
  799352
  801856
  803776
  802206
  725624
  742861
  764151
  791737
  794766
  809554
  738203
  738281
  759756
  738325
  750301
  726590
  747094
  615513
  716299
  720603
  780612
  788281
  794306
  796123
  803813
  804458
  806356
  401909
  406969
  484611
  485922
  493899
  526833
  483386
  678962
  448409
  457418
  465354
  439771
  439735
  454501
  493221
  484704
  487343
  493127
  496862
  515916
  397372
  813956
  482545
  485458
  469345
  476283
  454666
  466729
  474148
  516222
  519046
  517017
  516713
  493215
  549831
  565261
  557596
  549548
  549843
  564246
  565737
  580744
  649156
  673655
  549840
  562964
  563641
  567491
  580750
  619511
  637402
  590345
  600394
  610293
  591130
  803086
  792617
  799127
  407019
  433291
  462472
  466165
  478373
  478374
]
2.34 ms
(1.50%)
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
  397372
  401909
  406969
  407019
  433291
  439735
  439771
  448409
  454501
  454666
  457418
  462472
  465354
  466064
  466165
  466729
  467682
  469345
  474148
  476283
  478373
  478374
  482545
  483386
  484611
  484704
  485458
  485922
  487343
  490030
  493127
  493215
  493221
  493899
  496862
  507624
  515916
  516222
  516713
  517017
  518944
  519046
  526833
  527991
  532821
  546126
  549548
  549831
  549840
  549843
  551741
  557596
  562960
  562964
  563003
  563012
  563641
  564246
  564551
  565261
  565737
  565757
  567491
  580744
  580750
  582222
  590345
  591130
  600394
  602961
  610293
  615513
  619511
  620307
  628648
  636242
  637402
  644093
  649156
  660006
  670755
  673655
  676121
  678962
  682304
  694006
  710447
  714884
  716299
  720105
  720603
  725624
  726590
  738203
  738281
  738325
  742861
  747094
  750301
  759756
  764151
  780612
  788281
  791737
  792617
  794106
  794306
  794766
  796123
  799127
  799352
  801856
  802206
  803086
  803776
  803813
  804458
  806356
  809554
  813956
]
1.85 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature stepson"
]
1.49 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature stepson"
]
1.41 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature stepson"
]

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.