GET https://search.jues.net/search/embeds/6?q=big%20game

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
178.57 ms
(86.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
  55524
  402419
  464991
  465145
  469058
  473260
  482993
  483049
  493428
  505259
  512986
  529498
  531712
  547371
  549474
  549502
  551113
  552587
  559972
  561293
  563945
  565775
  567909
  576542
  577046
  577064
  579397
  582356
  582757
  583005
  584708
  589022
  591699
  612577
  614974
  617578
  618947
  621421
  634629
  636739
  640325
  644905
  653915
  655295
  660123
  669397
  674278
  675168
  677903
  683840
  697023
  697183
  698150
  703648
  707541
  709399
  712426
  714586
  718875
  718960
  721037
  721658
  721813
  722248
  726810
  734711
  734717
  734722
  735102
  735106
  735407
  740447
  740601
  741738
  745914
  749442
  750577
  750877
  763747
  765871
  768503
  771314
  781100
  781788
  783935
  784172
  786426
  787103
  788121
  788263
  788267
  789165
  790196
  790198
  790210
  790214
  792547
  792796
  795674
  796208
  796842
  799659
  803006
  804571
  805362
  807203
  808323
  808326
  808335
  808965
  809054
  809143
  810384
  811226
  811334
  817821
  817933
  820229
  821468
  827895
]
18.09 ms
(8.73%)
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
  788121
  811226
  464991
  644905
  552587
  563945
  583005
  712426
  709399
  714586
  808326
  809054
  808965
  765871
  784172
  811334
  726810
  735106
  734717
  734711
  735102
  745914
  790198
  807203
  469058
  567909
  55524
  817933
  820229
  827895
  483049
  505259
  565775
  576542
  561293
  577064
  674278
  669397
  698150
  551113
  577046
  591699
  634629
  781788
  803006
  809143
  810384
  808323
  795674
  741738
  771314
  735407
  768503
  786426
  790196
  804571
  584708
  402419
  655295
  582356
  790210
  740447
  788263
  465145
  482993
  512986
  529498
  531712
  579397
  718875
  683840
  697023
  707541
  718960
  549502
  618947
  787103
  796208
  796842
  808335
  790214
  805362
  734722
  783935
  788267
  789165
  792547
  792796
  799659
  750577
  750877
  740601
  749442
  763747
  781100
  473260
  493428
  817821
  821468
  547371
  549474
  559972
  703648
  722248
  675168
  697183
  653915
  660123
  677903
  721037
  721658
  721813
  582757
  612577
  621421
  614974
  640325
  589022
  636739
  617578
]
3.17 ms
(1.53%)
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
  55524
  402419
  464991
  465145
  469058
  473260
  482993
  483049
  493428
  505259
  512986
  529498
  531712
  547371
  549474
  549502
  551113
  552587
  559972
  561293
  563945
  565775
  567909
  576542
  577046
  577064
  579397
  582356
  582757
  583005
  584708
  589022
  591699
  612577
  614974
  617578
  618947
  621421
  634629
  636739
  640325
  644905
  653915
  655295
  660123
  669397
  674278
  675168
  677903
  683840
  697023
  697183
  698150
  703648
  707541
  709399
  712426
  714586
  718875
  718960
  721037
  721658
  721813
  722248
  726810
  734711
  734717
  734722
  735102
  735106
  735407
  740447
  740601
  741738
  745914
  749442
  750577
  750877
  763747
  765871
  768503
  771314
  781100
  781788
  783935
  784172
  786426
  787103
  788121
  788263
  788267
  789165
  790196
  790198
  790210
  790214
  792547
  792796
  795674
  796208
  796842
  799659
  803006
  804571
  805362
  807203
  808323
  808326
  808335
  808965
  809054
  809143
  810384
  811226
  811334
  817821
  817933
  820229
  821468
  827895
]
2.06 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие игр"
]
1.67 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big game"
]
1.64 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.