GET https://search.jues.net/search/embeds/9?q=throat%20throat

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.70 ms
(85.70%)
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
  384898
  388374
  417934
  417940
  417951
  419931
  419932
  419950
  421411
  421657
  422304
  422444
  422967
  422997
  423271
  423709
  423760
  423762
  432890
  435813
  436093
  438290
  439593
  439769
  439800
  439823
  439837
  442384
  443271
  443514
  444080
  444798
  444869
  446840
  448210
  451018
  451144
  453669
  453688
  453730
  454928
  455360
  455485
  455772
  456571
  456790
  457574
  457687
  459093
  459749
  459759
  463495
  464706
  467683
  470719
  471959
  475365
  475960
  477449
  477456
  488155
  489073
  494172
  494513
  495063
  495937
  496667
  501433
  503400
  506100
  506475
  508195
  508200
  508539
  509201
  511245
  513725
  513773
  515678
  516998
  517451
  518501
  520596
  529527
  535933
  540721
  542520
  545268
  546226
  552069
  560837
  568035
  576270
  577651
  578301
  580293
  588237
  589356
  595516
  602031
  602104
  613993
  623832
  641857
  642665
  713192
  727959
  729920
  730299
  750827
  756952
  771924
  787765
  791164
  801292
  806423
  807177
  809647
  809894
  810229
]
13.80 ms
(8.65%)
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
  588237
  641857
  791164
  806423
  750827
  801292
  807177
  810229
  730299
  727959
  756952
  771924
  602031
  602104
  613993
  809647
  809894
  384898
  417940
  443271
  470719
  417934
  419931
  422967
  423271
  439593
  439837
  442384
  459093
  422304
  423709
  444080
  459749
  388374
  417951
  422444
  438290
  457574
  421657
  444798
  455360
  477449
  513725
  509201
  517451
  494172
  506100
  508200
  511245
  515678
  540721
  488155
  489073
  496667
  520596
  423760
  422997
  421411
  423762
  432890
  419932
  419950
  448210
  451144
  467683
  459759
  446840
  453730
  454928
  455772
  456790
  495063
  513773
  518501
  494513
  508539
  535933
  495937
  516998
  529527
  463495
  542520
  580293
  560837
  545268
  552069
  568035
  576270
  578301
  713192
  546226
  577651
  589356
  595516
  623832
  642665
  729920
  787765
  443514
  444869
  453669
  453688
  455485
  464706
  475365
  435813
  471959
  475960
  436093
  456571
  439769
  439800
  439823
  457687
  451018
  477456
  501433
  503400
  506475
  508195
]
3.10 ms
(1.94%)
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
  384898
  388374
  417934
  417940
  417951
  419931
  419932
  419950
  421411
  421657
  422304
  422444
  422967
  422997
  423271
  423709
  423760
  423762
  432890
  435813
  436093
  438290
  439593
  439769
  439800
  439823
  439837
  442384
  443271
  443514
  444080
  444798
  444869
  446840
  448210
  451018
  451144
  453669
  453688
  453730
  454928
  455360
  455485
  455772
  456571
  456790
  457574
  457687
  459093
  459749
  459759
  463495
  464706
  467683
  470719
  471959
  475365
  475960
  477449
  477456
  488155
  489073
  494172
  494513
  495063
  495937
  496667
  501433
  503400
  506100
  506475
  508195
  508200
  508539
  509201
  511245
  513725
  513773
  515678
  516998
  517451
  518501
  520596
  529527
  535933
  540721
  542520
  545268
  546226
  552069
  560837
  568035
  576270
  577651
  578301
  580293
  588237
  589356
  595516
  602031
  602104
  613993
  623832
  641857
  642665
  713192
  727959
  729920
  730299
  750827
  756952
  771924
  787765
  791164
  801292
  806423
  807177
  809647
  809894
  810229
]
1.62 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "throat throat"
]
1.48 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "throat throat"
]
1.44 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "throat throat"
]

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.