GET https://search.jues.net/search/embeds/2?q=deep%20penetration

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
356.95 ms
(92.07%)
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
  96272
  400951
  404368
  414339
  414358
  414360
  429770
  447851
  454802
  459362
  474714
  476143
  482283
  502796
  505606
  510402
  530371
  530381
  530383
  530476
  530484
  530911
  531087
  531104
  531114
  531115
  531157
  531179
  531200
  531206
  531209
  531210
  531211
  531225
  531232
  531252
  532733
  532744
  532837
  532838
  532948
  533043
  533364
  533367
  533368
  533371
  533378
  533466
  534985
  535028
  535048
  535595
  536532
  536586
  536787
  537887
  537917
  537936
  540400
  540408
  540559
  541138
  542591
  544833
  550199
  555140
  583500
  592384
  596643
  599911
  599958
  599963
  600017
  600219
  600270
  600329
  601514
  604890
  606587
  616094
  628422
  631256
  632698
  633497
  637008
  637117
  637431
  637445
  639816
  640733
  640773
  641681
  642660
  644982
  646900
  648836
  648850
  650322
  651135
  652007
  666850
  666867
  667747
  676622
  685667
  693504
  696229
  699516
  703832
  703841
  704269
  708449
  712557
  719001
  722809
  727751
  731683
  770397
  799284
  805274
]
20.55 ms
(5.30%)
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
  454802
  583500
  637008
  633497
  642660
  414360
  531200
  537936
  541138
  652007
  699516
  646900
  685667
  708449
  592384
  799284
  727751
  540559
  666850
  96272
  537887
  531179
  532744
  696229
  712557
  719001
  648850
  666867
  722809
  599958
  606587
  632698
  637117
  637431
  600329
  600017
  770397
  616094
  400951
  505606
  502796
  404368
  414358
  429770
  644982
  476143
  530911
  531206
  531210
  536532
  540408
  532733
  510402
  530371
  530484
  531209
  531211
  533043
  536787
  537917
  474714
  550199
  542591
  704269
  648836
  650322
  651135
  667747
  676622
  693504
  544833
  555140
  599911
  599963
  600270
  601514
  637445
  596643
  600219
  604890
  628422
  639816
  640773
  805274
  731683
  631256
  640733
  641681
  703832
  703841
  482283
  414339
  459362
  447851
  530381
  530383
  531157
  531225
  531232
  531252
  532838
  533371
  535048
  531115
  533364
  533368
  535028
  535595
  536586
  540400
  530476
  531087
  531104
  531114
  532837
  532948
  533367
  533378
  533466
  534985
]
2.53 ms
(0.65%)
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
  96272
  400951
  404368
  414339
  414358
  414360
  429770
  447851
  454802
  459362
  474714
  476143
  482283
  502796
  505606
  510402
  530371
  530381
  530383
  530476
  530484
  530911
  531087
  531104
  531114
  531115
  531157
  531179
  531200
  531206
  531209
  531210
  531211
  531225
  531232
  531252
  532733
  532744
  532837
  532838
  532948
  533043
  533364
  533367
  533368
  533371
  533378
  533466
  534985
  535028
  535048
  535595
  536532
  536586
  536787
  537887
  537917
  537936
  540400
  540408
  540559
  541138
  542591
  544833
  550199
  555140
  583500
  592384
  596643
  599911
  599958
  599963
  600017
  600219
  600270
  600329
  601514
  604890
  606587
  616094
  628422
  631256
  632698
  633497
  637008
  637117
  637431
  637445
  639816
  640733
  640773
  641681
  642660
  644982
  646900
  648836
  648850
  650322
  651135
  652007
  666850
  666867
  667747
  676622
  685667
  693504
  696229
  699516
  703832
  703841
  704269
  708449
  712557
  719001
  722809
  727751
  731683
  770397
  799284
  805274
]
2.43 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "deep penetration"
]
1.88 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "deep penetration"
]
1.56 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "deep penetration"
]

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.