GET https://search.jues.net/search/embeds/3?q=japanese%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.26 ms
(54.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "japanese girl"
]
156.69 ms
(40.18%)
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
  273182
  384472
  387304
  392423
  415036
  429546
  473060
  478425
  491452
  499485
  512178
  512180
  512193
  512213
  512220
  519956
  521230
  522193
  523399
  523560
  528593
  533129
  533136
  550721
  550776
  551002
  551972
  552898
  552917
  552930
  552944
  554415
  556398
  556409
  558423
  558426
  558427
  558430
  559849
  559853
  559855
  559856
  559863
  559866
  559873
  559896
  559897
  564595
  565475
  565483
  566003
  572725
  572732
  574642
  575276
  576536
  576991
  582908
  583298
  586623
  588390
  590949
  590958
  590960
  591849
  593431
  596394
  598515
  600806
  603191
  603458
  610669
  613857
  619427
  619431
  619433
  620943
  622336
  622337
  622615
  622626
  622643
  622646
  622654
  623568
  634877
  637737
  640685
  643028
  650945
  660979
  673041
  675827
  693148
  694193
  694199
  709649
  711290
  712164
  713474
  721756
  722426
  736172
  742126
  742469
  742486
  742925
  746624
  747055
  749551
  755824
  761271
  771601
  772085
  772105
  788141
  792763
  805776
  810369
]
12.90 ms
(3.31%)
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
  788141
  746624
  622337
  622626
  551972
  575276
  564595
  805776
  551002
  558430
  559849
  693148
  622643
  747055
  772105
  792763
  713474
  415036
  473060
  523399
  528593
  556398
  590949
  619433
  593431
  598515
  576536
  70745
  565483
  736172
  712164
  694199
  675827
  761271
  772085
  711290
  273182
  709649
  622336
  622646
  552917
  613857
  610669
  392423
  552898
  512220
  512180
  521230
  499485
  491452
  574642
  583298
  556409
  582908
  550776
  558426
  559855
  559873
  600806
  637737
  640685
  576991
  478425
  533136
  554415
  591849
  512178
  558423
  559896
  694193
  673041
  634877
  619427
  810369
  742126
  749551
  742925
  623568
  722426
  512193
  558427
  559856
  590958
  590960
  603191
  387304
  429546
  586623
  771601
  512213
  519956
  533129
  523560
  565475
  572732
  550721
  566003
  559866
  559897
  643028
  620943
  552944
  559853
  660979
  622615
  522193
  552930
  603458
  755824
  742486
  384472
  559863
  572725
  650945
  588390
  596394
  619431
  622654
  742469
  721756
]
2.83 ms
(0.73%)
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
  273182
  384472
  387304
  392423
  415036
  429546
  473060
  478425
  491452
  499485
  512178
  512180
  512193
  512213
  512220
  519956
  521230
  522193
  523399
  523560
  528593
  533129
  533136
  550721
  550776
  551002
  551972
  552898
  552917
  552930
  552944
  554415
  556398
  556409
  558423
  558426
  558427
  558430
  559849
  559853
  559855
  559856
  559863
  559866
  559873
  559896
  559897
  564595
  565475
  565483
  566003
  572725
  572732
  574642
  575276
  576536
  576991
  582908
  583298
  586623
  588390
  590949
  590958
  590960
  591849
  593431
  596394
  598515
  600806
  603191
  603458
  610669
  613857
  619427
  619431
  619433
  620943
  622336
  622337
  622615
  622626
  622643
  622646
  622654
  623568
  634877
  637737
  640685
  643028
  650945
  660979
  673041
  675827
  693148
  694193
  694199
  709649
  711290
  712164
  713474
  721756
  722426
  736172
  742126
  742469
  742486
  742925
  746624
  747055
  749551
  755824
  761271
  771601
  772085
  772105
  788141
  792763
  805776
  810369
]
1.95 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "японк азиатк девушк"
]
1.60 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.