GET https://search.jues.net/search/embeds/4?q=japanese%20natural

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.19 ms
(86.71%)
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
  122425
  163762
  167756
  285321
  383744
  384433
  386892
  387682
  396910
  415623
  417960
  419947
  420218
  425804
  428784
  431555
  432317
  434270
  445879
  447826
  448103
  457265
  460954
  463753
  467705
  478030
  491456
  494510
  501252
  503026
  510581
  510582
  510584
  511927
  512189
  512198
  512210
  512221
  512223
  515881
  518972
  521249
  524178
  525176
  525178
  525197
  525401
  525605
  531903
  533388
  536525
  539942
  540168
  541591
  546770
  550637
  550640
  550717
  550742
  550762
  551005
  551066
  551121
  551969
  551976
  551984
  552020
  552028
  552041
  552052
  552055
  554318
  557205
  557503
  557518
  557537
  557812
  559905
  559923
  562900
  564601
  565473
  565479
  565977
  565979
  565982
  565997
  565998
  566000
  566002
  566007
  566010
  566074
  570759
  572740
  573424
  581393
  586588
  588228
  589684
  590925
  591592
  595765
  601024
  601159
  601160
  603576
  604844
  614730
  621017
  622628
  623502
  623522
  623564
  623604
  623818
  628161
  628167
  671835
  673051
]
12.86 ms
(7.79%)
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
  512223
  623818
  163762
  167756
  572740
  396910
  512210
  510584
  432317
  551969
  552028
  557537
  510582
  386892
  540168
  566000
  590925
  285321
  434270
  562900
  581393
  559923
  552052
  565998
  573424
  122425
  565979
  384433
  524178
  383744
  448103
  551976
  565473
  463753
  525197
  447826
  533388
  525605
  536525
  541591
  551005
  566007
  551066
  566010
  552020
  603576
  595765
  501252
  467705
  559905
  588228
  554318
  525176
  431555
  512189
  428784
  419947
  420218
  671835
  565479
  478030
  460954
  491456
  511927
  518972
  525178
  515881
  539942
  521249
  551984
  552041
  552055
  565977
  550637
  564601
  550717
  550762
  557518
  546770
  628161
  591592
  604844
  586588
  601024
  623564
  623502
  445879
  628167
  623604
  557205
  417960
  425804
  387682
  415623
  494510
  512221
  531903
  565982
  565997
  566002
  550640
  566074
  673051
  551121
  557812
  623522
  589684
  621017
  601159
  510581
  622628
  457265
  503026
  614730
  512198
  525401
  550742
  557503
  570759
  601160
]
2.42 ms
(1.46%)
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
  122425
  163762
  167756
  285321
  383744
  384433
  386892
  387682
  396910
  415623
  417960
  419947
  420218
  425804
  428784
  431555
  432317
  434270
  445879
  447826
  448103
  457265
  460954
  463753
  467705
  478030
  491456
  494510
  501252
  503026
  510581
  510582
  510584
  511927
  512189
  512198
  512210
  512221
  512223
  515881
  518972
  521249
  524178
  525176
  525178
  525197
  525401
  525605
  531903
  533388
  536525
  539942
  540168
  541591
  546770
  550637
  550640
  550717
  550742
  550762
  551005
  551066
  551121
  551969
  551976
  551984
  552020
  552028
  552041
  552052
  552055
  554318
  557205
  557503
  557518
  557537
  557812
  559905
  559923
  562900
  564601
  565473
  565479
  565977
  565979
  565982
  565997
  565998
  566000
  566002
  566007
  566010
  566074
  570759
  572740
  573424
  581393
  586588
  588228
  589684
  590925
  591592
  595765
  601024
  601159
  601160
  603576
  604844
  614730
  621017
  622628
  623502
  623522
  623564
  623604
  623818
  628161
  628167
  671835
  673051
]
1.90 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "japanese natural"
]
1.77 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "японк азиатк натуральная натуральные"
]
1.63 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "японк азиатк натуральная натуральные"
]

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.