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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.42 ms
(84.08%)
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
  448949
  461683
  472799
  480613
  486002
  489539
  496632
  501137
  514620
  517280
  531924
  532394
  534572
  535359
  535367
  536348
  537143
  545042
  550645
  551756
  555573
  557062
  557237
  562181
  563620
  563919
  563922
  569379
  576744
  577652
  580356
  580802
  581385
  584298
  584363
  590048
  590211
  592126
  593736
  604808
  604927
  604928
  606127
  606639
  607450
  608430
  612199
  615486
  621229
  624374
  629239
  629416
  629788
  634697
  638829
  640405
  642201
  642354
  642743
  643919
  644217
  649585
  649956
  651094
  652148
  652681
  652818
  660035
  675570
  678836
  680431
  680437
  680772
  681153
  689161
  692473
  694197
  697216
  698899
  699061
  699135
  699355
  701709
  702144
  708591
  708626
  710249
  710410
  711606
  711777
  712197
  715226
  716570
  717741
  718213
  719790
  719994
  777445
  777790
  777844
  779804
  782477
  785107
  787580
  813774
  814581
  815884
  815975
  817249
  817745
  817825
  818274
  818502
  818777
  820003
  820380
  823230
  824094
  824304
  824802
]
15.97 ms
(9.63%)
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
  815975
  817249
  817745
  820380
  823230
  824094
  813774
  814581
  815884
  817825
  818274
  818502
  818777
  820003
  824304
  824802
  448949
  461683
  472799
  480613
  489539
  514620
  517280
  532394
  535359
  535367
  537143
  501137
  534572
  496632
  531924
  536348
  486002
  545042
  550645
  557062
  557237
  562181
  563620
  576744
  577652
  580802
  551756
  563919
  563922
  584363
  569379
  580356
  584298
  649956
  660035
  675570
  678836
  680437
  692473
  699355
  716570
  718213
  649585
  651094
  652818
  680431
  694197
  697216
  701709
  702144
  708626
  710249
  711777
  719994
  652148
  652681
  680772
  681153
  689161
  698899
  699061
  699135
  708591
  710410
  711606
  712197
  715226
  717741
  719790
  555573
  581385
  590048
  590211
  592126
  604927
  604928
  607450
  612199
  624374
  629416
  634697
  643919
  644217
  606639
  615486
  629239
  642354
  593736
  604808
  606127
  608430
  629788
  642201
  642743
  621229
  638829
  640405
  777445
  777790
  777844
  779804
  782477
  785107
  787580
]
3.59 ms
(2.16%)
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
  448949
  461683
  472799
  480613
  486002
  489539
  496632
  501137
  514620
  517280
  531924
  532394
  534572
  535359
  535367
  536348
  537143
  545042
  550645
  551756
  555573
  557062
  557237
  562181
  563620
  563919
  563922
  569379
  576744
  577652
  580356
  580802
  581385
  584298
  584363
  590048
  590211
  592126
  593736
  604808
  604927
  604928
  606127
  606639
  607450
  608430
  612199
  615486
  621229
  624374
  629239
  629416
  629788
  634697
  638829
  640405
  642201
  642354
  642743
  643919
  644217
  649585
  649956
  651094
  652148
  652681
  652818
  660035
  675570
  678836
  680431
  680437
  680772
  681153
  689161
  692473
  694197
  697216
  698899
  699061
  699135
  699355
  701709
  702144
  708591
  708626
  710249
  710410
  711606
  711777
  712197
  715226
  716570
  717741
  718213
  719790
  719994
  777445
  777790
  777844
  779804
  782477
  785107
  787580
  813774
  814581
  815884
  815975
  817249
  817745
  817825
  818274
  818502
  818777
  820003
  820380
  823230
  824094
  824304
  824802
]
1.95 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf hair"
]
1.81 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf hair"
]
1.66 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf 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.