GET https://search.jues.net/search/embeds/3?q=load%20cum

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.55 ms
(82.85%)
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
  7891
  81065
  396088
  396314
  396408
  397299
  402351
  406890
  412220
  413472
  418365
  419147
  426862
  427149
  428104
  433404
  434836
  436343
  437419
  437790
  439446
  439450
  447140
  447830
  450567
  450779
  452429
  455042
  456797
  458511
  458526
  459969
  460370
  460814
  463397
  474813
  484088
  488297
  491175
  495280
  496124
  499556
  500519
  500553
  504516
  505550
  510478
  512594
  512599
  524395
  529115
  530216
  539372
  541582
  542345
  543489
  556553
  556766
  560320
  560791
  562424
  565859
  579664
  584127
  586175
  590807
  591827
  594536
  598300
  603354
  604836
  605396
  606332
  612581
  619867
  625582
  627333
  627841
  636449
  641227
  650034
  668770
  677064
  715370
  718980
  720083
  722154
  723155
  723432
  725451
  726965
  731697
  735867
  738336
  741808
  744581
  746604
  747128
  757145
  761459
  763146
  763561
  764574
  764638
  767399
  767403
  767653
  775009
  775013
  782409
  790681
  790746
  792062
  794037
  795862
  796243
  797474
  803258
  803604
  809743
]
17.93 ms
(10.57%)
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
  720083
  603354
  795862
  790681
  797474
  767653
  741808
  747128
  746604
  763146
  767399
  731697
  738336
  767403
  606332
  641227
  790746
  529115
  500519
  500553
  562424
  722154
  586175
  782409
  796243
  809743
  757145
  764638
  726965
  763561
  619867
  7891
  396408
  402351
  437419
  463397
  434836
  499556
  496124
  543489
  715370
  668770
  723432
  604836
  590807
  627841
  775009
  775013
  744581
  764574
  794037
  627333
  406890
  436343
  412220
  530216
  439450
  413472
  439446
  433404
  452429
  447830
  459969
  495280
  460814
  556766
  542345
  723155
  718980
  579664
  598300
  792062
  735867
  803258
  803604
  427149
  81065
  396088
  418365
  450779
  491175
  524395
  397299
  437790
  456797
  458526
  450567
  556553
  584127
  541582
  560320
  650034
  677064
  565859
  591827
  594536
  725451
  761459
  636449
  428104
  474813
  426862
  488297
  484088
  512594
  512599
  460370
  396314
  419147
  455042
  447140
  458511
  504516
  505550
  510478
  539372
  560791
  625582
  605396
  612581
]
2.59 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
  7891
  81065
  396088
  396314
  396408
  397299
  402351
  406890
  412220
  413472
  418365
  419147
  426862
  427149
  428104
  433404
  434836
  436343
  437419
  437790
  439446
  439450
  447140
  447830
  450567
  450779
  452429
  455042
  456797
  458511
  458526
  459969
  460370
  460814
  463397
  474813
  484088
  488297
  491175
  495280
  496124
  499556
  500519
  500553
  504516
  505550
  510478
  512594
  512599
  524395
  529115
  530216
  539372
  541582
  542345
  543489
  556553
  556766
  560320
  560791
  562424
  565859
  579664
  584127
  586175
  590807
  591827
  594536
  598300
  603354
  604836
  605396
  606332
  612581
  619867
  625582
  627333
  627841
  636449
  641227
  650034
  668770
  677064
  715370
  718980
  720083
  722154
  723155
  723432
  725451
  726965
  731697
  735867
  738336
  741808
  744581
  746604
  747128
  757145
  761459
  763146
  763561
  764574
  764638
  767399
  767403
  767653
  775009
  775013
  782409
  790681
  790746
  792062
  794037
  795862
  796243
  797474
  803258
  803604
  809743
]
2.51 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "load cum"
]
2.04 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.03 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "load cum"
]
1.99 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "load cum"
]

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.