GET https://search.jues.net/search/embeds/2?q=japanese%20asian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.60 ms
(82.81%)
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
  70745
  166116
  384042
  386738
  401104
  401513
  406578
  415036
  415917
  428267
  433512
  457040
  457263
  457266
  475831
  500680
  500684
  505353
  510595
  512185
  512197
  515702
  516436
  525192
  532130
  533132
  534207
  550639
  550771
  550772
  550996
  551002
  551962
  551965
  551971
  551975
  551988
  552034
  552038
  552040
  552882
  552884
  552894
  552901
  552929
  552934
  552942
  554305
  556360
  556366
  556400
  556412
  556418
  557817
  557820
  557844
  558430
  559849
  559876
  559928
  566001
  566013
  566014
  568552
  568553
  568562
  576991
  590972
  605135
  605397
  607763
  613163
  615767
  619458
  619474
  619491
  620498
  621025
  622337
  622591
  622613
  622624
  622625
  622626
  622627
  622643
  628143
  632682
  634757
  643379
  667402
  675827
  680892
  685814
  690866
  693148
  694195
  694197
  694199
  698477
  702281
  710206
  711290
  712222
  713197
  713474
  715294
  739777
  745986
  746624
  747055
  750378
  759099
  761271
  772085
  772105
  787877
  788141
  792763
  810416
]
14.25 ms
(9.87%)
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
  556366
  556418
  559876
  559928
  552040
  690866
  551988
  552034
  552038
  552884
  566001
  622591
  643379
  613163
  615767
  401513
  552942
  685814
  713197
  552894
  622627
  607763
  386738
  457266
  475831
  457263
  694197
  739777
  551975
  552934
  551965
  550771
  557844
  694195
  698477
  712222
  667402
  552929
  628143
  605135
  787877
  788141
  759099
  746624
  745986
  622613
  702281
  166116
  428267
  433512
  512197
  500680
  500684
  505353
  515702
  532130
  516436
  525192
  533132
  550639
  550996
  551971
  557820
  551962
  552882
  556360
  566013
  568553
  568562
  550772
  557817
  566014
  568552
  680892
  556400
  556412
  632682
  605397
  619458
  620498
  621025
  810416
  619474
  619491
  622625
  634757
  384042
  401104
  510595
  710206
  70745
  415036
  457040
  576991
  406578
  415917
  512185
  534207
  551002
  558430
  559849
  552901
  694199
  675827
  693148
  715294
  554305
  590972
  622643
  622337
  622626
  747055
  761271
  772105
  792763
  772085
  750378
  622624
  711290
  713474
]
2.59 ms
(1.80%)
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
  70745
  166116
  384042
  386738
  401104
  401513
  406578
  415036
  415917
  428267
  433512
  457040
  457263
  457266
  475831
  500680
  500684
  505353
  510595
  512185
  512197
  515702
  516436
  525192
  532130
  533132
  534207
  550639
  550771
  550772
  550996
  551002
  551962
  551965
  551971
  551975
  551988
  552034
  552038
  552040
  552882
  552884
  552894
  552901
  552929
  552934
  552942
  554305
  556360
  556366
  556400
  556412
  556418
  557817
  557820
  557844
  558430
  559849
  559876
  559928
  566001
  566013
  566014
  568552
  568553
  568562
  576991
  590972
  605135
  605397
  607763
  613163
  615767
  619458
  619474
  619491
  620498
  621025
  622337
  622591
  622613
  622624
  622625
  622626
  622627
  622643
  628143
  632682
  634757
  643379
  667402
  675827
  680892
  685814
  690866
  693148
  694195
  694197
  694199
  698477
  702281
  710206
  711290
  712222
  713197
  713474
  715294
  739777
  745986
  746624
  747055
  750378
  759099
  761271
  772085
  772105
  787877
  788141
  792763
  810416
]
2.21 ms
(1.53%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "японк азиатк азиатк"
]
2.21 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "japanese asian"
]
1.85 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "японк азиатк азиатк"
]
1.72 ms
(1.19%)
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.