GET https://search.jues.net/search/embeds/6?q=hard%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.46 ms
(81.24%)
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
  75762
  114360
  124361
  233353
  237293
  350425
  384262
  391940
  395881
  400470
  407876
  408249
  408464
  411710
  411985
  413053
  413827
  418969
  425249
  427543
  437176
  439607
  441022
  444542
  445903
  453156
  457971
  458327
  458651
  459579
  460141
  464446
  472531
  473316
  477908
  478832
  486556
  495665
  496049
  504214
  504846
  512973
  529846
  537199
  538031
  544381
  547974
  550379
  553442
  555750
  555793
  556030
  556427
  556653
  558037
  560195
  560202
  560411
  560429
  564180
  565254
  568580
  574451
  580216
  582790
  584234
  587311
  587885
  598042
  600856
  601381
  608534
  609147
  612856
  614718
  614867
  614980
  619536
  619987
  628391
  628396
  630524
  633114
  633733
  637004
  637427
  640770
  644192
  667679
  694967
  695107
  698124
  718091
  720614
  726520
  726529
  727022
  746722
  747597
  764333
  770462
  772100
  772113
  779224
  779346
  781761
  786277
  790234
  790804
  794933
  797264
  803081
  804099
  804609
  807332
  807334
  814235
  816776
  817398
]
17.77 ms
(11.33%)
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
  473316
  459579
  477908
  425249
  504214
  384262
  114360
  124361
  237293
  395881
  350425
  75762
  400470
  408249
  408464
  411985
  411710
  816776
  817398
  464446
  538031
  496049
  486556
  584234
  550379
  556653
  564180
  553442
  555750
  558037
  560411
  580216
  667679
  695107
  694967
  718091
  720614
  555793
  574451
  587885
  600856
  619987
  644192
  614718
  619536
  804609
  779346
  781761
  804099
  807332
  807334
  726520
  746722
  769103
  790804
  794933
  803081
  772100
  772113
  726529
  747597
  727022
  764333
  770462
  614980
  779224
  786277
  797264
  413053
  453156
  460141
  407876
  437176
  458651
  233353
  391940
  457971
  418969
  504846
  814235
  445903
  529846
  544381
  565254
  547974
  560195
  560202
  568580
  582790
  598042
  601381
  609147
  614867
  633733
  628391
  637004
  640770
  790234
  633114
  441022
  413827
  439607
  472531
  478832
  444542
  512973
  427543
  698124
  458327
  495665
  537199
  560429
  556030
  556427
  587311
  608534
  630524
  637427
  612856
  628396
]
3.82 ms
(2.43%)
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
  75762
  114360
  124361
  233353
  237293
  350425
  384262
  391940
  395881
  400470
  407876
  408249
  408464
  411710
  411985
  413053
  413827
  418969
  425249
  427543
  437176
  439607
  441022
  444542
  445903
  453156
  457971
  458327
  458651
  459579
  460141
  464446
  472531
  473316
  477908
  478832
  486556
  495665
  496049
  504214
  504846
  512973
  529846
  537199
  538031
  544381
  547974
  550379
  553442
  555750
  555793
  556030
  556427
  556653
  558037
  560195
  560202
  560411
  560429
  564180
  565254
  568580
  574451
  580216
  582790
  584234
  587311
  587885
  598042
  600856
  601381
  608534
  609147
  612856
  614718
  614867
  614980
  619536
  619987
  628391
  628396
  630524
  633114
  633733
  637004
  637427
  640770
  644192
  667679
  694967
  695107
  698124
  718091
  720614
  726520
  726529
  727022
  746722
  747597
  764333
  770462
  772100
  772113
  779224
  779346
  781761
  786277
  790234
  790804
  794933
  797264
  803081
  804099
  804609
  807332
  807334
  814235
  816776
  817398
]
2.32 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard young"
]
2.00 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard young"
]
1.73 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard young"
]

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.