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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.56 ms
(84.27%)
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
  35344
  72607
  193452
  194286
  383925
  387997
  388557
  389474
  391423
  391472
  391583
  397830
  397907
  399401
  400093
  400178
  401902
  401952
  401971
  403378
  407424
  411694
  411738
  411745
  413134
  413783
  414784
  415553
  415734
  416791
  420903
  422299
  427537
  428450
  428500
  430188
  430411
  442407
  443692
  443836
  444098
  444468
  445060
  445914
  446007
  448834
  454208
  455619
  459896
  464753
  465860
  467510
  468536
  472358
  474151
  474399
  474549
  475881
  480468
  481242
  482505
  489851
  490931
  493117
  501836
  504195
  504805
  505690
  509918
  510889
  515123
  520889
  528237
  530016
  540186
  543509
  558844
  561077
  562898
  575722
  576036
  589752
  591208
  597262
  599600
  601152
  607372
  615883
  617134
  619524
  628087
  667644
  704914
  717628
  724233
  726753
  727465
  730072
  732074
  744968
  746636
  748251
  758299
  758428
  770642
  776521
  781306
  782593
  784306
  788880
  788936
  794956
  799208
  799585
  801363
  811005
  813913
  814857
  815598
  824791
]
18.65 ms
(9.79%)
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
  589752
  591208
  601152
  615883
  619524
  782593
  801363
  776521
  727465
  746636
  748251
  758299
  781306
  784306
  788936
  799585
  732074
  758428
  726753
  730072
  724233
  744968
  770642
  717628
  788880
  794956
  799208
  811005
  388557
  397830
  397907
  400093
  401952
  401971
  445914
  472358
  481242
  389474
  391423
  391472
  391583
  416791
  422299
  430188
  383925
  401902
  411694
  415553
  443692
  464753
  465860
  474399
  444098
  455619
  467510
  475881
  509918
  520889
  504805
  501836
  504195
  510889
  528237
  448834
  575722
  597262
  607372
  628087
  617134
  599600
  72607
  194286
  193452
  35344
  387997
  399401
  400178
  403378
  407424
  411745
  415734
  443836
  411738
  414784
  430411
  444468
  413134
  413783
  428450
  428500
  427537
  442407
  420903
  445060
  824791
  813913
  814857
  815598
  482505
  459896
  468536
  474151
  474549
  490931
  446007
  454208
  480468
  515123
  530016
  540186
  505690
  489851
  493117
  543509
  558844
  561077
  562898
  576036
  667644
  704914
]
3.33 ms
(1.75%)
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
  35344
  72607
  193452
  194286
  383925
  387997
  388557
  389474
  391423
  391472
  391583
  397830
  397907
  399401
  400093
  400178
  401902
  401952
  401971
  403378
  407424
  411694
  411738
  411745
  413134
  413783
  414784
  415553
  415734
  416791
  420903
  422299
  427537
  428450
  428500
  430188
  430411
  442407
  443692
  443836
  444098
  444468
  445060
  445914
  446007
  448834
  454208
  455619
  459896
  464753
  465860
  467510
  468536
  472358
  474151
  474399
  474549
  475881
  480468
  481242
  482505
  489851
  490931
  493117
  501836
  504195
  504805
  505690
  509918
  510889
  515123
  520889
  528237
  530016
  540186
  543509
  558844
  561077
  562898
  575722
  576036
  589752
  591208
  597262
  599600
  601152
  607372
  615883
  617134
  619524
  628087
  667644
  704914
  717628
  724233
  726753
  727465
  730072
  732074
  744968
  746636
  748251
  758299
  758428
  770642
  776521
  781306
  782593
  784306
  788880
  788936
  794956
  799208
  799585
  801363
  811005
  813913
  814857
  815598
  824791
]
2.53 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot young"
]
1.73 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot young"
]
1.72 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot young"
]

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.