GET https://search.jues.net/search/embeds/4?q=hot%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
335.14 ms
(91.89%)
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
  2291
  6602
  53396
  90485
  235834
  247381
  382021
  391113
  391475
  392775
  393731
  393761
  395170
  395522
  395654
  395669
  395688
  395849
  399292
  401116
  401881
  401993
  402009
  402046
  403928
  409166
  409895
  411449
  411697
  412554
  418803
  424622
  435468
  444414
  444579
  446456
  447495
  451498
  461991
  472249
  479044
  479046
  483142
  484443
  496112
  501891
  505501
  508376
  524566
  558607
  563038
  566642
  567391
  573783
  574839
  577775
  588005
  590224
  590919
  596161
  597494
  604043
  604048
  607215
  607772
  614523
  618970
  623512
  624231
  624465
  630309
  645011
  647945
  663504
  663968
  665184
  667319
  684096
  694154
  699650
  701014
  701682
  712158
  712822
  725399
  727400
  734825
  741502
  743120
  743345
  743396
  744095
  746154
  747515
  748130
  748171
  748685
  748989
  753778
  755699
  758465
  760837
  761181
  767155
  769786
  775997
  790501
  790667
  799468
  800074
  800509
  800533
  807380
  808134
  811931
  812364
  816584
  818119
  821365
  821745
]
18.91 ms
(5.19%)
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
  618970
  623512
  775997
  790667
  725399
  743345
  748171
  767155
  769786
  800074
  748989
  761181
  734825
  743396
  748685
  758465
  744095
  746154
  741502
  604043
  607215
  614523
  701014
  393731
  247381
  395654
  395669
  90485
  235834
  409166
  479046
  444414
  505501
  501891
  816584
  665184
  663504
  667319
  624465
  800509
  807380
  753778
  799468
  382021
  6602
  391475
  573783
  747515
  451498
  411697
  409895
  393761
  395170
  395522
  395688
  395849
  53396
  399292
  401881
  402009
  402046
  403928
  411449
  424622
  412554
  818119
  821365
  821745
  446456
  483142
  447495
  496112
  508376
  563038
  574839
  647945
  701682
  712158
  712822
  645011
  663968
  684096
  694154
  558607
  566642
  567391
  577775
  590919
  607772
  588005
  596161
  590224
  597494
  630309
  812364
  800533
  743120
  748130
  755699
  790501
  808134
  760837
  727400
  604048
  624231
  699650
  811931
  391113
  418803
  2291
  392775
  401993
  401116
  435468
  444579
  461991
  479044
  472249
  524566
  484443
]
2.89 ms
(0.79%)
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
  2291
  6602
  53396
  90485
  235834
  247381
  382021
  391113
  391475
  392775
  393731
  393761
  395170
  395522
  395654
  395669
  395688
  395849
  399292
  401116
  401881
  401993
  402009
  402046
  403928
  409166
  409895
  411449
  411697
  412554
  418803
  424622
  435468
  444414
  444579
  446456
  447495
  451498
  461991
  472249
  479044
  479046
  483142
  484443
  496112
  501891
  505501
  508376
  524566
  558607
  563038
  566642
  567391
  573783
  574839
  577775
  588005
  590224
  590919
  596161
  597494
  604043
  604048
  607215
  607772
  614523
  618970
  623512
  624231
  624465
  630309
  645011
  647945
  663504
  663968
  665184
  667319
  684096
  694154
  699650
  701014
  701682
  712158
  712822
  725399
  727400
  734825
  741502
  743120
  743345
  743396
  744095
  746154
  747515
  748130
  748171
  748685
  748989
  753778
  755699
  758465
  760837
  761181
  767155
  769786
  775997
  790501
  790667
  799468
  800074
  800509
  800533
  807380
  808134
  811931
  812364
  816584
  818119
  821365
  821745
]
2.28 ms
(0.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot young"
]
1.92 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot young"
]
1.82 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot young"
]
1.76 ms
(0.48%)
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.