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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.50 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.61 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "came"
]
3 18.95 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
  470390
  470720
  445704
  449516
  467741
  479222
  489886
  490142
  451855
  460687
  510462
  511209
  517133
  525231
  533840
  540752
  503342
  517940
  522291
  525270
  506736
  512431
  517997
  522518
  524409
  528779
  540380
  501443
  504018
  507469
  517409
  532688
  540097
  481059
  484906
  546105
  551795
  560733
  561502
  566829
  567177
  574171
  577525
  563674
  573508
  577792
  549565
  574978
  675172
  693952
  694938
  694971
  711673
  718859
  648976
  662389
  675968
  679685
  691744
  703357
  706535
  707935
  714074
  657777
  670565
  675576
  676571
  687150
  699844
  702038
  551078
  557003
  559387
  560961
  560984
  561427
  562497
  564242
  578571
  589514
  625472
  585552
  599555
  618032
  628425
  599142
  630334
  605002
  610960
  624045
  625915
  641004
  787996
  791211
  793497
  795538
  806432
  779423
  793699
  800578
  801305
  802750
  788048
  789103
  802711
  725012
  725425
  738442
  766592
  728523
  753548
  774333
  768797
  731457
  732774
  732868
  732911
  746525
  748416
  614684
]
4 4.48 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
  445704
  449516
  451855
  460687
  467741
  470390
  470720
  479222
  481059
  484906
  489886
  490142
  501443
  503342
  504018
  506736
  507469
  510462
  511209
  512431
  517133
  517409
  517940
  517997
  522291
  522518
  524409
  525231
  525270
  528779
  532688
  533840
  540097
  540380
  540752
  546105
  549565
  551078
  551795
  557003
  559387
  560733
  560961
  560984
  561427
  561502
  562497
  563674
  564242
  566829
  567177
  573508
  574171
  574978
  577525
  577792
  578571
  585552
  589514
  599142
  599555
  605002
  610960
  614684
  618032
  624045
  625472
  625915
  628425
  630334
  641004
  648976
  657777
  662389
  670565
  675172
  675576
  675968
  676571
  679685
  687150
  691744
  693952
  694938
  694971
  699844
  702038
  703357
  706535
  707935
  711673
  714074
  718859
  725012
  725425
  728523
  731457
  732774
  732868
  732911
  738442
  746525
  748416
  753548
  766592
  768797
  774333
  779423
  787996
  788048
  789103
  791211
  793497
  793699
  795538
  800578
  801305
  802711
  802750
  806432
]
5 133.40 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
  445704
  449516
  451855
  460687
  467741
  470390
  470720
  479222
  481059
  484906
  489886
  490142
  501443
  503342
  504018
  506736
  507469
  510462
  511209
  512431
  517133
  517409
  517940
  517997
  522291
  522518
  524409
  525231
  525270
  528779
  532688
  533840
  540097
  540380
  540752
  546105
  549565
  551078
  551795
  557003
  559387
  560733
  560961
  560984
  561427
  561502
  562497
  563674
  564242
  566829
  567177
  573508
  574171
  574978
  577525
  577792
  578571
  585552
  589514
  599142
  599555
  605002
  610960
  614684
  618032
  624045
  625472
  625915
  628425
  630334
  641004
  648976
  657777
  662389
  670565
  675172
  675576
  675968
  676571
  679685
  687150
  691744
  693952
  694938
  694971
  699844
  702038
  703357
  706535
  707935
  711673
  714074
  718859
  725012
  725425
  728523
  731457
  732774
  732868
  732911
  738442
  746525
  748416
  753548
  766592
  768797
  774333
  779423
  787996
  788048
  789103
  791211
  793497
  793699
  795538
  800578
  801305
  802711
  802750
  806432
]
6 1.98 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "came"
]
7 1.50 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "came"
]

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.