GET https://search.jues.net/search/embeds/3?q=creampie%20cock

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.50 ms
(87.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
  6768
  391956
  397642
  418020
  459771
  463596
  530235
  533167
  533375
  533389
  536988
  537484
  538954
  539384
  539658
  543165
  547099
  551585
  552596
  552636
  577079
  579464
  579835
  602129
  612146
  615604
  617403
  626440
  634376
  637571
  641017
  641456
  648273
  649580
  652734
  653530
  654455
  654462
  655467
  656134
  656137
  656487
  656532
  656644
  659387
  663315
  664591
  666996
  670550
  673455
  673528
  674882
  676437
  677180
  677258
  680909
  684339
  687147
  689123
  689779
  692962
  695693
  696032
  696560
  698765
  700719
  700845
  702294
  703335
  703788
  704265
  706199
  707753
  709134
  709565
  710083
  710321
  710545
  711838
  713021
  713933
  715027
  715055
  715479
  716417
  717214
  717551
  718107
  718818
  718850
  719392
  719961
  720093
  720154
  720521
  720570
  721649
  722068
  723161
  723268
  732756
  738642
  747562
  748076
  753219
  761546
  777120
  817301
  817324
  818605
  819264
  819332
  819377
  819397
  823732
  823849
  823954
  824679
  825423
  825472
]
11.08 ms
(6.64%)
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
  738642
  753219
  612146
  617403
  626440
  637571
  641017
  641456
  703788
  704265
  713021
  722068
  777120
  397642
  533375
  664591
  823849
  459771
  530235
  677180
  719961
  659387
  677258
  687147
  707753
  551585
  602129
  615604
  634376
  748076
  732756
  747562
  761546
  391956
  6768
  418020
  823732
  825423
  817301
  819377
  823954
  818605
  825472
  817324
  819264
  819332
  819397
  824679
  463596
  533389
  539658
  533167
  536988
  537484
  538954
  539384
  577079
  543165
  552596
  579464
  579835
  653530
  654455
  656487
  666996
  684339
  689123
  706199
  710545
  711838
  713933
  718818
  718850
  719392
  721649
  723268
  648273
  654462
  655467
  656134
  656644
  674882
  680909
  689779
  692962
  695693
  696032
  700845
  703335
  710083
  715055
  716417
  720154
  720521
  723161
  649580
  652734
  656137
  656532
  663315
  670550
  673455
  673528
  676437
  696560
  698765
  700719
  702294
  709134
  709565
  710321
  715027
  715479
  717214
  717551
  718107
  720093
  720570
  547099
  552636
]
2.83 ms
(1.69%)
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
  6768
  391956
  397642
  418020
  459771
  463596
  530235
  533167
  533375
  533389
  536988
  537484
  538954
  539384
  539658
  543165
  547099
  551585
  552596
  552636
  577079
  579464
  579835
  602129
  612146
  615604
  617403
  626440
  634376
  637571
  641017
  641456
  648273
  649580
  652734
  653530
  654455
  654462
  655467
  656134
  656137
  656487
  656532
  656644
  659387
  663315
  664591
  666996
  670550
  673455
  673528
  674882
  676437
  677180
  677258
  680909
  684339
  687147
  689123
  689779
  692962
  695693
  696032
  696560
  698765
  700719
  700845
  702294
  703335
  703788
  704265
  706199
  707753
  709134
  709565
  710083
  710321
  710545
  711838
  713021
  713933
  715027
  715055
  715479
  716417
  717214
  717551
  718107
  718818
  718850
  719392
  719961
  720093
  720154
  720521
  720570
  721649
  722068
  723161
  723268
  732756
  738642
  747562
  748076
  753219
  761546
  777120
  817301
  817324
  818605
  819264
  819332
  819377
  819397
  823732
  823849
  823954
  824679
  825423
  825472
]
1.83 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie cock"
]
1.60 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie cock"
]
1.42 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie cock"
]

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.