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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.49 ms
(81.92%)
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
  384124
  388785
  397905
  411334
  411704
  437530
  439752
  444145
  448708
  451469
  451498
  457460
  457515
  458000
  460762
  464339
  464521
  465399
  465947
  466244
  466801
  467469
  467489
  467540
  469372
  469403
  470018
  470768
  471449
  472688
  473133
  473829
  474113
  477961
  479024
  479100
  479102
  479103
  479104
  479112
  484399
  496873
  503580
  505690
  506212
  512608
  516043
  522486
  522589
  523164
  526208
  531989
  532876
  533607
  534336
  536444
  536458
  544468
  544489
  546113
  546119
  546715
  546716
  548182
  549221
  549224
  549842
  549846
  550220
  552286
  554323
  554542
  559071
  560943
  562958
  563025
  563090
  563173
  563640
  566327
  566940
  569943
  573918
  579613
  585158
  590941
  591260
  591977
  607258
  609689
  624821
  632268
  665319
  678767
  696308
  699707
  710560
  717935
  724252
  725561
  726587
  727449
  727769
  727898
  728317
  728385
  741764
  746686
  748236
  748256
  759946
  781914
  788543
  790885
  799360
  806084
  807326
  810774
  810834
  811475
]
17.66 ms
(11.53%)
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
  464339
  466801
  473133
  473829
  484399
  512608
  516043
  522589
  523164
  534336
  536444
  496873
  531989
  526208
  536458
  503580
  505690
  506212
  522486
  532876
  533607
  460762
  465947
  469403
  544468
  546113
  549221
  554542
  563025
  563173
  566940
  569943
  546119
  546715
  546716
  548182
  554323
  559071
  544489
  552286
  563090
  573918
  710560
  678767
  696308
  665319
  717935
  549224
  549842
  549846
  550220
  560943
  562958
  563640
  566327
  579613
  585158
  591977
  609689
  590941
  607258
  632268
  591260
  624821
  790885
  806084
  810774
  811475
  807326
  724252
  727449
  727898
  746686
  748256
  725561
  728317
  727769
  741764
  748236
  726587
  728385
  759946
  699707
  781914
  788543
  799360
  810834
  411334
  448708
  457515
  470018
  470768
  472688
  479102
  388785
  439752
  451498
  465399
  467489
  479104
  397905
  437530
  451469
  457460
  467469
  467540
  469372
  471449
  474113
  477961
  479024
  384124
  411704
  444145
  458000
  464521
  466244
  479100
  479103
  479112
]
3.04 ms
(1.98%)
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
  384124
  388785
  397905
  411334
  411704
  437530
  439752
  444145
  448708
  451469
  451498
  457460
  457515
  458000
  460762
  464339
  464521
  465399
  465947
  466244
  466801
  467469
  467489
  467540
  469372
  469403
  470018
  470768
  471449
  472688
  473133
  473829
  474113
  477961
  479024
  479100
  479102
  479103
  479104
  479112
  484399
  496873
  503580
  505690
  506212
  512608
  516043
  522486
  522589
  523164
  526208
  531989
  532876
  533607
  534336
  536444
  536458
  544468
  544489
  546113
  546119
  546715
  546716
  548182
  549221
  549224
  549842
  549846
  550220
  552286
  554323
  554542
  559071
  560943
  562958
  563025
  563090
  563173
  563640
  566327
  566940
  569943
  573918
  579613
  585158
  590941
  591260
  591977
  607258
  609689
  624821
  632268
  665319
  678767
  696308
  699707
  710560
  717935
  724252
  725561
  726587
  727449
  727769
  727898
  728317
  728385
  741764
  746686
  748236
  748256
  759946
  781914
  788543
  790885
  799360
  806084
  807326
  810774
  810834
  811475
]
1.87 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature hair"
]
1.77 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature hair"
]
1.60 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature hair"
]

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.