GET https://search.jues.net/search/embeds?q=skinny%20hairy%20shower

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.08 ms
(84.22%)
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
  23065
  173107
  327121
  391317
  395679
  399754
  405360
  416129
  417368
  421294
  422649
  422752
  422901
  426480
  427035
  429704
  435735
  440618
  442647
  445801
  462579
  462740
  464916
  466645
  466696
  467635
  467650
  470734
  472445
  473190
  476253
  477989
  478516
  493876
  500690
  506870
  511557
  512190
  513258
  516588
  519051
  519277
  520729
  520994
  525069
  525909
  533594
  536647
  538858
  541136
  543241
  544589
  546236
  547646
  548259
  548571
  549265
  549285
  549308
  549373
  549422
  550214
  551973
  551999
  557352
  559412
  559873
  561409
  564650
  572603
  572725
  573225
  574049
  574216
  576462
  579234
  580649
  581360
  581992
  585784
  585920
  587787
  588811
  588911
  589234
  589936
  592451
  592526
  593023
  597725
  597865
  603144
  606139
  606696
  607926
  623495
  646336
  650127
  652986
  660311
  661591
  670265
  670266
  682129
  696443
  720033
  732899
  750514
  753630
  777363
  792790
  797726
  807028
  811917
  811942
  816260
  818825
  820026
  820982
  821120
]
12.57 ms
(9.20%)
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
  820026
  597725
  652986
  327121
  807028
  696443
  811917
  593023
  519277
  585784
  544589
  753630
  23065
  811942
  506870
  607926
  516588
  820982
  538858
  543241
  588811
  750514
  427035
  391317
  541136
  670265
  478516
  589936
  500690
  416129
  525069
  549373
  561409
  572725
  585920
  587787
  466645
  581360
  564650
  512190
  573225
  557352
  579234
  429704
  661591
  466696
  470734
  818825
  519051
  551999
  606696
  606139
  777363
  467650
  520994
  511557
  559412
  399754
  576462
  549265
  546236
  550214
  597865
  797726
  792790
  422752
  821120
  549308
  580649
  660311
  588911
  426480
  173107
  445801
  533594
  525909
  493876
  551973
  572603
  549285
  548259
  581992
  670266
  589234
  592451
  592526
  442647
  462579
  462740
  513258
  650127
  520729
  421294
  440618
  473190
  476253
  547646
  548571
  549422
  574049
  646336
  682129
  720033
  559873
  574216
  623495
  603144
  732899
  417368
  405360
  467635
  477989
  422901
  395679
  435735
  422649
  816260
  472445
  536647
  464916
]
2.43 ms
(1.78%)
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
  23065
  173107
  327121
  391317
  395679
  399754
  405360
  416129
  417368
  421294
  422649
  422752
  422901
  426480
  427035
  429704
  435735
  440618
  442647
  445801
  462579
  462740
  464916
  466645
  466696
  467635
  467650
  470734
  472445
  473190
  476253
  477989
  478516
  493876
  500690
  506870
  511557
  512190
  513258
  516588
  519051
  519277
  520729
  520994
  525069
  525909
  533594
  536647
  538858
  541136
  543241
  544589
  546236
  547646
  548259
  548571
  549265
  549285
  549308
  549373
  549422
  550214
  551973
  551999
  557352
  559412
  559873
  561409
  564650
  572603
  572725
  573225
  574049
  574216
  576462
  579234
  580649
  581360
  581992
  585784
  585920
  587787
  588811
  588911
  589234
  589936
  592451
  592526
  593023
  597725
  597865
  603144
  606139
  606696
  607926
  623495
  646336
  650127
  652986
  660311
  661591
  670265
  670266
  682129
  696443
  720033
  732899
  750514
  753630
  777363
  792790
  797726
  807028
  811917
  811942
  816260
  818825
  820026
  820982
  821120
]
2.01 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny hairy shower"
]
1.80 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые волосатая shower"
]
1.23 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые волосатая shower"
]

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.