GET https://search.jues.net/search/embeds/9?q=while

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.52 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.98 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "while"
]
3 10.79 ms
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
  766539
  769338
  728703
  733219
  739700
  741939
  742771
  742842
  744301
  749783
  750864
  751967
  752188
  753617
  759313
  759346
  764193
  765537
  767771
  769433
  730356
  731182
  731212
  738541
  742102
  742542
  748385
  749760
  750014
  750026
  751497
  756354
  758172
  761072
  761511
  761522
  763879
  768096
  768858
  770455
  772896
  602023
  607981
  608664
  615256
  617768
  620486
  627937
  632244
  633591
  635030
  635404
  638157
  644509
  699156
  701263
  708329
  711384
  712620
  715694
  715838
  722094
  776352
  776769
  776999
  777182
  778515
  778700
  779177
  779265
  784291
  785900
  787472
  789374
  791174
  792768
  795482
  797123
  797297
  798769
  800388
  800938
  801183
  801713
  803702
  804978
  810075
  810182
  810943
  812267
  812468
  384514
  456203
  397635
  233443
  386325
  285831
  383646
  250587
  400521
  401158
  405744
  441550
  441978
  444389
  415036
  817749
  818832
  821800
  824760
  816147
  816610
  816693
  816765
  817802
  819868
  821410
  821819
  823413
  824703
]
4 2.41 ms
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
  233443
  250587
  285831
  383646
  384514
  386325
  397635
  400521
  401158
  405744
  415036
  441550
  441978
  444389
  456203
  602023
  607981
  608664
  615256
  617768
  620486
  627937
  632244
  633591
  635030
  635404
  638157
  644509
  699156
  701263
  708329
  711384
  712620
  715694
  715838
  722094
  728703
  730356
  731182
  731212
  733219
  738541
  739700
  741939
  742102
  742542
  742771
  742842
  744301
  748385
  749760
  749783
  750014
  750026
  750864
  751497
  751967
  752188
  753617
  756354
  758172
  759313
  759346
  761072
  761511
  761522
  763879
  764193
  765537
  766539
  767771
  768096
  768858
  769338
  769433
  770455
  772896
  776352
  776769
  776999
  778515
  778700
  779177
  779265
  784291
  785900
  787472
  789374
  791174
  792768
  795482
  797123
  797297
  798769
  800388
  800938
  801183
  801713
  803702
  804978
  810075
  810182
  810943
  812267
  812468
  816147
  816610
  816693
  816765
  817749
  817802
  818832
  819868
  821410
  821800
  821819
  823413
  824703
  824760
]
5 113.09 ms
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
  233443
  250587
  285831
  383646
  384514
  386325
  397635
  400521
  401158
  405744
  415036
  441550
  441978
  444389
  456203
  602023
  607981
  608664
  615256
  617768
  620486
  627937
  632244
  633591
  635030
  635404
  638157
  644509
  699156
  701263
  708329
  711384
  712620
  715694
  715838
  722094
  728703
  730356
  731182
  731212
  733219
  738541
  739700
  741939
  742102
  742542
  742771
  742842
  744301
  748385
  749760
  749783
  750014
  750026
  750864
  751497
  751967
  752188
  753617
  756354
  758172
  759313
  759346
  761072
  761511
  761522
  763879
  764193
  765537
  766539
  767771
  768096
  768858
  769338
  769433
  770455
  772896
  776352
  776769
  776999
  778515
  778700
  779177
  779265
  784291
  785900
  787472
  789374
  791174
  792768
  795482
  797123
  797297
  798769
  800388
  800938
  801183
  801713
  803702
  804978
  810075
  810182
  810943
  812267
  812468
  816147
  816610
  816693
  816765
  817749
  817802
  818832
  819868
  821410
  821800
  821819
  823413
  824703
  824760
]
6 1.72 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "while"
]
7 1.47 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "while"
]

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.