GET https://search.jues.net/search/embeds/8?q=homemade%20huge

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.18 ms
(57.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск огромные"
]
130.49 ms
(36.04%)
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
  33821
  154127
  391944
  391954
  403439
  416634
  416678
  416707
  416708
  419640
  421257
  423784
  424765
  426519
  438880
  440045
  441040
  441050
  445365
  445651
  445950
  446799
  447140
  449173
  450948
  452338
  452810
  455918
  459357
  460765
  461894
  462605
  467568
  469833
  470428
  478489
  479738
  480263
  480450
  483684
  489331
  494781
  499921
  502894
  505356
  507181
  509643
  511670
  516676
  517879
  518941
  519374
  520918
  524678
  524788
  524803
  525431
  531347
  532483
  534665
  539319
  541274
  542146
  547478
  553430
  559784
  562012
  562019
  563267
  563728
  567561
  578654
  582330
  582595
  583049
  596684
  597875
  609959
  610716
  618066
  621457
  651693
  660412
  668701
  671043
  678713
  695869
  707432
  707689
  715460
  715462
  730722
  735906
  739125
  745126
  745309
  752632
  752633
  752644
  752660
  752683
  767668
  770253
  770263
  770264
  770404
  770800
  773670
  775982
  776209
  784681
  786668
  787966
  794690
  802591
  804234
  808742
  811125
  824701
  825805
]
15.72 ms
(4.34%)
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
  752683
  770263
  770800
  784681
  811125
  752632
  745126
  773670
  770253
  770264
  735906
  752633
  752644
  770404
  707432
  775982
  403439
  423784
  440045
  446799
  469833
  421257
  524788
  426519
  517879
  518941
  489331
  678713
  618066
  154127
  391944
  416707
  441040
  445365
  445651
  452338
  455918
  470428
  479738
  511670
  499921
  524678
  507181
  494781
  516676
  519374
  532483
  483684
  541274
  578654
  553430
  567561
  582595
  542146
  671043
  715462
  660412
  651693
  668701
  695869
  715460
  563267
  596684
  804234
  776209
  787966
  808742
  739125
  745309
  730722
  752660
  391954
  416708
  419640
  462605
  450948
  478489
  452810
  480263
  480450
  441050
  445950
  509643
  502894
  582330
  583049
  563728
  707689
  597875
  610716
  621457
  609959
  33821
  825805
  794690
  539319
  416634
  524803
  459357
  525431
  786668
  824701
  767668
  802591
  416678
  438880
  424765
  467568
  449173
  447140
  460765
  505356
  534665
  520918
  531347
  461894
  547478
  562019
  559784
  562012
]
2.62 ms
(0.72%)
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
  33821
  154127
  391944
  391954
  403439
  416634
  416678
  416707
  416708
  419640
  421257
  423784
  424765
  426519
  438880
  440045
  441040
  441050
  445365
  445651
  445950
  446799
  447140
  449173
  450948
  452338
  452810
  455918
  459357
  460765
  461894
  462605
  467568
  469833
  470428
  478489
  479738
  480263
  480450
  483684
  489331
  494781
  499921
  502894
  505356
  507181
  509643
  511670
  516676
  517879
  518941
  519374
  520918
  524678
  524788
  524803
  525431
  531347
  532483
  534665
  539319
  541274
  542146
  547478
  553430
  559784
  562012
  562019
  563267
  563728
  567561
  578654
  582330
  582595
  583049
  596684
  597875
  609959
  610716
  618066
  621457
  651693
  660412
  668701
  671043
  678713
  695869
  707432
  707689
  715460
  715462
  730722
  735906
  739125
  745126
  745309
  752632
  752633
  752644
  752660
  752683
  767668
  770253
  770263
  770264
  770404
  770800
  773670
  775982
  776209
  784681
  786668
  787966
  794690
  802591
  804234
  808742
  811125
  824701
  825805
]
1.85 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade huge"
]
1.64 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск огромные"
]
1.59 ms
(0.44%)
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.