GET https://search.jues.net/search/embeds/7?q=pov%20hard

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.35 ms
(89.42%)
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
  388629
  397766
  412332
  420605
  423823
  427543
  427940
  433066
  433993
  435411
  438401
  439022
  441850
  441852
  455002
  455253
  456795
  459065
  459985
  461217
  466365
  469597
  473316
  473825
  476527
  479426
  481019
  486139
  494552
  506003
  513894
  518348
  522088
  525944
  527712
  528561
  541678
  552370
  556171
  557665
  558592
  559005
  568932
  569440
  570833
  577688
  579215
  579227
  582197
  585452
  586707
  590176
  590184
  593276
  595459
  597258
  598216
  599230
  601081
  603800
  604362
  608800
  608945
  612255
  616442
  618839
  619965
  619974
  622167
  623234
  623303
  625325
  629195
  629552
  639845
  640432
  648183
  650098
  653801
  659452
  660435
  686457
  692130
  693656
  696291
  699867
  720547
  726734
  731346
  733742
  757353
  760210
  762817
  767982
  771770
  772909
  774468
  780191
  783446
  788079
  790126
  793449
  794964
  795142
  796339
  800554
  800903
  802947
  804876
  806473
  807419
  808685
  808858
  809605
  809705
  810619
  811950
  815080
  818090
  824606
]
14.47 ms
(6.27%)
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
  556171
  696291
  648183
  720547
  590176
  800903
  733742
  793449
  760210
  420605
  439022
  423823
  774468
  818090
  824606
  466365
  455002
  473825
  481019
  455253
  456795
  459065
  461217
  486139
  522088
  494552
  525944
  459985
  541678
  559005
  570833
  568932
  582197
  650098
  659452
  692130
  653801
  660435
  686457
  693656
  699867
  552370
  577688
  579227
  595459
  608945
  618839
  619974
  622167
  629195
  640432
  598216
  629552
  639845
  585452
  599230
  601081
  616442
  623303
  586707
  603800
  783446
  790126
  808685
  808858
  780191
  796339
  800554
  807419
  809605
  811950
  726734
  757353
  772909
  794964
  795142
  802947
  804876
  809705
  810619
  762817
  767982
  771770
  731346
  604362
  608800
  623234
  788079
  806473
  388629
  441852
  441850
  473316
  433993
  427940
  435411
  506003
  527712
  528561
  518348
  427543
  619965
  476527
  513894
  625325
  590184
  612255
  433066
  438401
  815080
  469597
  479426
  557665
  558592
  569440
  579215
  597258
  593276
  397766
  412332
]
2.56 ms
(1.11%)
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
  388629
  397766
  412332
  420605
  423823
  427543
  427940
  433066
  433993
  435411
  438401
  439022
  441850
  441852
  455002
  455253
  456795
  459065
  459985
  461217
  466365
  469597
  473316
  473825
  476527
  479426
  481019
  486139
  494552
  506003
  513894
  518348
  522088
  525944
  527712
  528561
  541678
  552370
  556171
  557665
  558592
  559005
  568932
  569440
  570833
  577688
  579215
  579227
  582197
  585452
  586707
  590176
  590184
  593276
  595459
  597258
  598216
  599230
  601081
  603800
  604362
  608800
  608945
  612255
  616442
  618839
  619965
  619974
  622167
  623234
  623303
  625325
  629195
  629552
  639845
  640432
  648183
  650098
  653801
  659452
  660435
  686457
  692130
  693656
  696291
  699867
  720547
  726734
  731346
  733742
  757353
  760210
  762817
  767982
  771770
  772909
  774468
  780191
  783446
  788079
  790126
  793449
  794964
  795142
  796339
  800554
  800903
  802947
  804876
  806473
  807419
  808685
  808858
  809605
  809705
  810619
  811950
  815080
  818090
  824606
]
2.14 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов hard"
]
1.93 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов hard"
]
1.80 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov hard"
]
1.54 ms
(0.67%)
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.