GET https://search.jues.net/search/embeds/6?q=load

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.47 ms
(85.22%)
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
  81065
  191189
  388688
  396088
  397299
  403703
  413472
  418365
  419174
  422150
  422426
  424529
  425395
  427149
  431345
  433404
  434889
  439446
  439450
  447830
  448843
  449146
  450149
  450156
  450779
  452224
  452429
  452675
  457008
  458639
  459969
  459989
  460814
  461984
  463537
  463618
  469988
  470053
  473650
  479784
  487950
  491175
  495280
  497234
  497766
  503082
  503359
  512631
  517132
  523272
  524395
  540647
  542345
  543507
  546868
  547031
  556766
  564688
  567010
  574659
  576502
  579664
  579849
  579877
  585838
  593381
  598300
  612951
  613848
  614045
  618104
  627183
  636116
  636462
  645265
  647657
  653330
  665740
  667909
  705226
  707698
  708148
  708450
  708894
  709292
  709819
  718980
  720074
  720607
  723155
  726907
  728741
  728967
  734521
  735867
  736425
  747544
  752876
  759653
  761949
  763378
  764486
  774534
  776773
  780936
  785175
  786312
  789783
  792062
  793451
  795483
  801063
  803258
  803604
  804210
  806797
  808095
  809485
  811906
  814675
]
14.56 ms
(9.09%)
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
  439450
  413472
  439446
  422426
  424529
  433404
  431345
  814675
  457008
  450156
  452429
  459989
  463537
  479784
  447830
  448843
  450149
  452224
  459969
  469988
  470053
  495280
  517132
  540647
  497766
  503359
  460814
  473650
  487950
  574659
  579877
  556766
  567010
  576502
  542345
  543507
  547031
  667909
  705226
  707698
  708450
  723155
  720074
  645265
  647657
  653330
  665740
  709292
  709819
  718980
  546868
  564688
  579664
  579849
  585838
  612951
  613848
  614045
  627183
  593381
  618104
  636116
  598300
  786312
  795483
  804210
  776773
  789783
  811906
  785175
  792062
  728967
  736425
  726907
  763378
  734521
  735867
  752876
  728741
  747544
  759653
  761949
  764486
  636462
  708148
  708894
  720607
  774534
  780936
  793451
  801063
  803258
  803604
  806797
  808095
  809485
  427149
  81065
  388688
  458639
  396088
  403703
  425395
  452675
  191189
  418365
  449146
  461984
  463618
  450779
  512631
  491175
  503082
  497234
  523272
  524395
  397299
  422150
  419174
  434889
]
2.47 ms
(1.54%)
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
  81065
  191189
  388688
  396088
  397299
  403703
  413472
  418365
  419174
  422150
  422426
  424529
  425395
  427149
  431345
  433404
  434889
  439446
  439450
  447830
  448843
  449146
  450149
  450156
  450779
  452224
  452429
  452675
  457008
  458639
  459969
  459989
  460814
  461984
  463537
  463618
  469988
  470053
  473650
  479784
  487950
  491175
  495280
  497234
  497766
  503082
  503359
  512631
  517132
  523272
  524395
  540647
  542345
  543507
  546868
  547031
  556766
  564688
  567010
  574659
  576502
  579664
  579849
  579877
  585838
  593381
  598300
  612951
  613848
  614045
  618104
  627183
  636116
  636462
  645265
  647657
  653330
  665740
  667909
  705226
  707698
  708148
  708450
  708894
  709292
  709819
  718980
  720074
  720607
  723155
  726907
  728741
  728967
  734521
  735867
  736425
  747544
  752876
  759653
  761949
  763378
  764486
  774534
  776773
  780936
  785175
  786312
  789783
  792062
  793451
  795483
  801063
  803258
  803604
  804210
  806797
  808095
  809485
  811906
  814675
]
2.06 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "load"
]
1.57 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "load"
]
1.57 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "load"
]

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.