GET https://search.jues.net/search/embeds/5?q=dirty%20ass%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
187.67 ms
(87.04%)
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
  409021
  411703
  412262
  414604
  414973
  417212
  430190
  431350
  437765
  438077
  439587
  443573
  446275
  447917
  452606
  452953
  453929
  455265
  462926
  468442
  470064
  471109
  481341
  482499
  483709
  491398
  495198
  503866
  504408
  504738
  508701
  509024
  510301
  510898
  516862
  517797
  518599
  519246
  519278
  521807
  521849
  525378
  525504
  525727
  526055
  528358
  528406
  536689
  537672
  542748
  545480
  551919
  552578
  554854
  563865
  566634
  568514
  568546
  569087
  569094
  569100
  569132
  569154
  569194
  569201
  569526
  569548
  571042
  573175
  580773
  590425
  592782
  595315
  596168
  596571
  596960
  597736
  599882
  599938
  600302
  600995
  601244
  603386
  604919
  605746
  607227
  614308
  614743
  619007
  629764
  633166
  639739
  662879
  669188
  673577
  675429
  675431
  675435
  682531
  688656
  689702
  693338
  734038
  813532
]
18.29 ms
(8.48%)
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
  462926
  437765
  633166
  569100
  603386
  452606
  517797
  443573
  552578
  566634
  675429
  675431
  673577
  693338
  569087
  596960
  601244
  813532
  438077
  411703
  491398
  528406
  689702
  675435
  471109
  568546
  571042
  600302
  409021
  504408
  590425
  453929
  508701
  528358
  447917
  439587
  592782
  521807
  510898
  597736
  412262
  482499
  455265
  468442
  519246
  521849
  526055
  554854
  573175
  662879
  569094
  569194
  607227
  414973
  481341
  509024
  542748
  569201
  569526
  599882
  734038
  430190
  537672
  536689
  446275
  525378
  525727
  516862
  483709
  551919
  569132
  569548
  569154
  688656
  629764
  595315
  604919
  431350
  414604
  504738
  510301
  682531
  568514
  614743
  495198
  596571
  417212
  619007
  605746
  452953
  580773
  525504
  669188
  600995
  519278
  614308
  470064
  503866
  639739
  563865
  518599
  599938
  596168
  545480
]
2.49 ms
(1.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
  409021
  411703
  412262
  414604
  414973
  417212
  430190
  431350
  437765
  438077
  439587
  443573
  446275
  447917
  452606
  452953
  453929
  455265
  462926
  468442
  470064
  471109
  481341
  482499
  483709
  491398
  495198
  503866
  504408
  504738
  508701
  509024
  510301
  510898
  516862
  517797
  518599
  519246
  519278
  521807
  521849
  525378
  525504
  525727
  526055
  528358
  528406
  536689
  537672
  542748
  545480
  551919
  552578
  554854
  563865
  566634
  568514
  568546
  569087
  569094
  569100
  569132
  569154
  569194
  569201
  569526
  569548
  571042
  573175
  580773
  590425
  592782
  595315
  596168
  596571
  596960
  597736
  599882
  599938
  600302
  600995
  601244
  603386
  604919
  605746
  607227
  614308
  614743
  619007
  629764
  633166
  639739
  662879
  669188
  673577
  675429
  675431
  675435
  682531
  688656
  689702
  693338
  734038
  813532
]
1.90 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dirty ass milf"
]
1.86 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dirty жоп milf"
]
1.67 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dirty жоп milf"
]

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.