GET https://search.jues.net/search/embeds/7?q=year

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.16 ms
(81.21%)
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
  386548
  396337
  400311
  402859
  413507
  418507
  418655
  418664
  421782
  429216
  429242
  432521
  438276
  445271
  458030
  460529
  466970
  478256
  489156
  492665
  493934
  508863
  517441
  529820
  531449
  532416
  533708
  544880
  549415
  552194
  553775
  553776
  555808
  558655
  564621
  566045
  569979
  570836
  574144
  576210
  577900
  579204
  582727
  583711
  615651
  616072
  627111
  644666
  647762
  648670
  650731
  650765
  652024
  659064
  672706
  673607
  676538
  677041
  677726
  683724
  685237
  693006
  693509
  698341
  698862
  700055
  707506
  709065
  709179
  711249
  716527
  718649
  720313
  723744
  733090
  734877
  738583
  739709
  740417
  743047
  748639
  748651
  749501
  749659
  749878
  750722
  752860
  756473
  756967
  764692
  765084
  766188
  767399
  768417
  769424
  772575
  773132
  773903
  773907
  777327
  781580
  785274
  785492
  786713
  787345
  787354
  789139
  792579
  795707
  796418
  801140
  801718
  810184
  812537
  814092
  814453
  818823
  821798
  824133
  824460
]
18.88 ms
(11.51%)
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
  750722
  756473
  769424
  773907
  787345
  787354
  789139
  792579
  801140
  801718
  733090
  739709
  740417
  748639
  748651
  749878
  764692
  772575
  723744
  734877
  749501
  756967
  766188
  768417
  773132
  767399
  773903
  738583
  743047
  749659
  752860
  765084
  615651
  616072
  627111
  644666
  698341
  700055
  711249
  718649
  777327
  781580
  785274
  785492
  786713
  795707
  796418
  810184
  812537
  438276
  466970
  458030
  386548
  396337
  400311
  402859
  418655
  418664
  421782
  432521
  445271
  418507
  413507
  429216
  429242
  814092
  814453
  824133
  818823
  821798
  824460
  492665
  478256
  460529
  489156
  508863
  533708
  517441
  529820
  531449
  532416
  493934
  558655
  564621
  579204
  583711
  553776
  566045
  577900
  582727
  555808
  650731
  676538
  677041
  677726
  683724
  693006
  698862
  709065
  716527
  647762
  650765
  652024
  659064
  672706
  673607
  685237
  707506
  709179
  648670
  693509
  720313
  544880
  549415
  552194
  553775
  569979
  570836
  574144
  576210
]
4.50 ms
(2.74%)
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
  386548
  396337
  400311
  402859
  413507
  418507
  418655
  418664
  421782
  429216
  429242
  432521
  438276
  445271
  458030
  460529
  466970
  478256
  489156
  492665
  493934
  508863
  517441
  529820
  531449
  532416
  533708
  544880
  549415
  552194
  553775
  553776
  555808
  558655
  564621
  566045
  569979
  570836
  574144
  576210
  577900
  579204
  582727
  583711
  615651
  616072
  627111
  644666
  647762
  648670
  650731
  650765
  652024
  659064
  672706
  673607
  676538
  677041
  677726
  683724
  685237
  693006
  693509
  698341
  698862
  700055
  707506
  709065
  709179
  711249
  716527
  718649
  720313
  723744
  733090
  734877
  738583
  739709
  740417
  743047
  748639
  748651
  749501
  749659
  749878
  750722
  752860
  756473
  756967
  764692
  765084
  766188
  767399
  768417
  769424
  772575
  773132
  773903
  773907
  777327
  781580
  785274
  785492
  786713
  787345
  787354
  789139
  792579
  795707
  796418
  801140
  801718
  810184
  812537
  814092
  814453
  818823
  821798
  824133
  824460
]
2.05 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "year"
]
1.88 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "year"
]
1.80 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "year"
]

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.