GET https://search.jues.net/search/embeds/2?q=xxx%20with%20little

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.99 ms
(86.03%)
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
  409369
  460827
  494863
  496245
  499306
  509769
  530261
  530389
  530595
  533107
  535909
  536008
  538466
  540154
  549601
  553909
  556262
  565307
  576485
  578353
  581994
  588110
  592766
  615953
  617862
  636117
  639142
  644135
  645643
  645685
  645777
  654080
  655170
  666692
  673254
  674266
  676156
  680879
  681456
  686341
  691474
  696067
  698936
  705024
  705333
  707584
  712273
  714249
  716671
  719635
  728891
  728938
  729674
  736841
  739087
  740974
  741138
  742003
  744568
  744613
  746307
  746371
  746458
  754136
  756098
  756403
  756729
  757571
  758525
  761224
  761520
  761938
  764026
  764920
  767291
  768653
  768803
  770204
  771025
  773061
  773402
  775478
  778365
  778776
  778930
  779149
  781186
  783171
  783782
  783802
  784171
  784195
  786257
  786643
  787392
  787934
  789899
  790653
  791727
  792264
  794469
  794865
  795333
  796929
  799167
  801150
  802042
  802930
  803310
  804885
  806990
  810370
  817988
  818122
  818704
  819284
  821731
  822571
  825246
]
13.23 ms
(7.85%)
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
  581994
  556262
  654080
  716671
  719635
  645685
  666692
  674266
  691474
  705024
  698936
  576485
  636117
  617862
  775478
  783802
  787392
  790653
  806990
  794865
  801150
  742003
  746307
  773061
  783171
  791727
  799167
  802930
  810370
  761938
  728891
  744568
  764026
  754136
  761520
  771025
  615953
  639142
  707584
  714249
  786257
  786643
  804885
  409369
  802042
  784171
  818704
  821731
  822571
  817988
  818122
  819284
  825246
  536008
  496245
  509769
  530389
  540154
  494863
  499306
  530595
  533107
  535909
  538466
  530261
  460827
  549601
  565307
  553909
  578353
  673254
  676156
  681456
  696067
  712273
  645777
  655170
  705333
  645643
  680879
  686341
  644135
  592766
  588110
  778930
  779149
  783782
  789899
  794469
  795333
  778365
  778776
  781186
  787934
  792264
  729674
  739087
  773537
  784195
  796929
  803310
  728938
  756098
  767291
  770204
  736841
  746371
  746458
  756729
  757571
  758525
  764920
  744613
  761224
  768653
  768803
  773402
  740974
  741138
  756403
]
3.00 ms
(1.78%)
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
  409369
  460827
  494863
  496245
  499306
  509769
  530261
  530389
  530595
  533107
  535909
  536008
  538466
  540154
  549601
  553909
  556262
  565307
  576485
  578353
  581994
  588110
  592766
  615953
  617862
  636117
  639142
  644135
  645643
  645685
  645777
  654080
  655170
  666692
  673254
  674266
  676156
  680879
  681456
  686341
  691474
  696067
  698936
  705024
  705333
  707584
  712273
  714249
  716671
  719635
  728891
  728938
  729674
  736841
  739087
  740974
  741138
  742003
  744568
  744613
  746307
  746371
  746458
  754136
  756098
  756403
  756729
  757571
  758525
  761224
  761520
  761938
  764026
  764920
  767291
  768653
  768803
  770204
  771025
  773061
  773402
  775478
  778365
  778776
  778930
  779149
  781186
  783171
  783782
  783802
  784171
  784195
  786257
  786643
  787392
  787934
  789899
  790653
  791727
  792264
  794469
  794865
  795333
  796929
  799167
  801150
  802042
  802930
  803310
  804885
  806990
  810370
  817988
  818122
  818704
  819284
  821731
  822571
  825246
]
1.99 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "xxx with little"
]
1.98 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "xxx little"
]
1.71 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "xxx little"
]

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.