GET https://search.jues.net/search/embeds/7?q=they%20are%20new

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
180.96 ms
(88.00%)
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
  390554
  412274
  437742
  448974
  458030
  469047
  572501
  572773
  575860
  577918
  585263
  588635
  590401
  591228
  599666
  600190
  605082
  609090
  609479
  611611
  612250
  619011
  619371
  621431
  622429
  622879
  623624
  638147
  649139
  651227
  651727
  651998
  657469
  660042
  661928
  669852
  669914
  670003
  670315
  673947
  677581
  677604
  683689
  683802
  685916
  689794
  690265
  692994
  694810
  695706
  698039
  700671
  704166
  706596
  709556
  711531
  711660
  712231
  716880
  719225
  720798
  720881
  721429
  724342
  726393
  730606
  731783
  734923
  736241
  736433
  737752
  738583
  744450
  744703
  744735
  747154
  747340
  749215
  751321
  755328
  755588
  758088
  758163
  758819
  760941
  762047
  762183
  762187
  765150
  767868
  767962
  768255
  769424
  769809
  772571
  775732
  775783
  777587
  777878
  778137
  780047
  780835
  781677
  781749
  785459
  785584
  787345
  789281
  790761
  792980
  793062
  793934
  795187
  796904
  801492
  802954
  809150
  810507
  812340
  812378
]
14.38 ms
(6.99%)
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
  572773
  577918
  651727
  651998
  670003
  670315
  677581
  683802
  694810
  695706
  698039
  711660
  712231
  720798
  721429
  651227
  657469
  673947
  677604
  685916
  689794
  704166
  706596
  709556
  719225
  649139
  660042
  661928
  669852
  669914
  683689
  690265
  692994
  711531
  716880
  572501
  575860
  609090
  622879
  623624
  585263
  591228
  599666
  609479
  611611
  590401
  600190
  588635
  612250
  619011
  621431
  775783
  790761
  795187
  796904
  775732
  777587
  778137
  780047
  780835
  781749
  785459
  809150
  810507
  749215
  755588
  758819
  769424
  785584
  787345
  801492
  812340
  812378
  734923
  758163
  765150
  767868
  724342
  726393
  736241
  736433
  744703
  747154
  762183
  767962
  768255
  769809
  730606
  731783
  737752
  744450
  751321
  760941
  762047
  772571
  738583
  744735
  747340
  755328
  758088
  762187
  605082
  619371
  622429
  638147
  700671
  720881
  777878
  781677
  789281
  792980
  793062
  793934
  802954
  390554
  448974
  458030
  469047
  412274
  437742
]
2.86 ms
(1.39%)
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
  390554
  412274
  437742
  448974
  458030
  469047
  572501
  572773
  575860
  577918
  585263
  588635
  590401
  591228
  599666
  600190
  605082
  609090
  609479
  611611
  612250
  619011
  619371
  621431
  622429
  622879
  623624
  638147
  649139
  651227
  651727
  651998
  657469
  660042
  661928
  669852
  669914
  670003
  670315
  673947
  677581
  677604
  683689
  683802
  685916
  689794
  690265
  692994
  694810
  695706
  698039
  700671
  704166
  706596
  709556
  711531
  711660
  712231
  716880
  719225
  720798
  720881
  721429
  724342
  726393
  730606
  731783
  734923
  736241
  736433
  737752
  738583
  744450
  744703
  744735
  747154
  747340
  749215
  751321
  755328
  755588
  758088
  758163
  758819
  760941
  762047
  762183
  762187
  765150
  767868
  767962
  768255
  769424
  769809
  772571
  775732
  775783
  777587
  777878
  778137
  780047
  780835
  781677
  781749
  785459
  785584
  787345
  789281
  790761
  792980
  793062
  793934
  795187
  796904
  801492
  802954
  809150
  810507
  812340
  812378
]
2.31 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "new"
]
1.89 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "they are new"
]
1.73 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "new"
]
1.51 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.