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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.09 ms
(86.50%)
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
  451083
  476614
  485238
  496952
  507549
  519253
  520178
  526328
  528574
  529368
  530203
  532373
  534044
  539162
  539574
  540169
  542967
  546193
  548247
  554108
  556269
  567978
  574260
  574423
  581885
  583432
  585553
  588138
  589191
  591914
  591946
  592598
  601504
  604199
  605632
  609208
  610115
  616517
  616636
  617356
  617754
  618175
  621005
  621615
  621990
  625831
  626121
  627479
  628921
  628942
  629622
  630144
  631073
  631816
  632679
  633981
  635755
  637224
  639278
  643786
  644227
  645071
  645328
  646545
  646713
  648144
  649866
  653100
  653102
  653126
  654329
  654417
  656538
  656580
  656616
  656632
  658933
  661427
  664454
  664473
  665080
  666660
  666678
  668068
  669310
  674494
  675150
  678249
  679879
  680300
  686794
  690214
  692372
  692919
  693677
  694130
  697578
  700271
  701212
  701669
  707412
  707562
  710007
  712477
  714194
  715379
  715521
  716952
  717150
  718346
  718614
  719500
  719987
  720217
  720319
  722046
  722810
  722880
]
12.41 ms
(7.35%)
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
  828024
  451083
  485238
  528574
  539162
  540169
  496952
  507549
  520178
  532373
  526328
  529368
  530203
  534044
  539574
  519253
  476614
  556269
  567978
  542967
  554108
  574423
  581885
  583432
  653100
  653102
  658933
  661427
  664454
  664473
  665080
  666660
  674494
  679879
  694130
  707412
  712477
  715521
  716952
  717150
  719500
  722810
  645071
  645328
  646545
  646713
  653126
  654417
  656538
  656580
  656616
  678249
  680300
  686794
  688681
  690214
  692372
  692919
  700271
  701212
  715379
  718346
  718614
  719987
  720217
  722880
  648144
  649866
  654329
  656632
  666678
  668068
  669310
  675150
  693677
  697578
  701669
  707562
  710007
  714194
  720319
  722046
  546193
  548247
  574260
  601504
  605632
  609208
  616636
  618175
  626121
  628942
  630144
  631073
  633981
  643786
  585553
  591914
  604199
  610115
  617356
  617754
  621005
  621615
  621990
  629622
  631816
  632679
  637224
  639278
  644227
  616517
  625831
  627479
  628921
  635755
  588138
  589191
  591946
  592598
]
3.14 ms
(1.86%)
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
  451083
  476614
  485238
  496952
  507549
  519253
  520178
  526328
  528574
  529368
  530203
  532373
  534044
  539162
  539574
  540169
  542967
  546193
  548247
  554108
  556269
  567978
  574260
  574423
  581885
  583432
  585553
  588138
  589191
  591914
  591946
  592598
  601504
  604199
  605632
  609208
  610115
  616517
  616636
  617356
  617754
  618175
  621005
  621615
  621990
  625831
  626121
  627479
  628921
  628942
  629622
  630144
  631073
  631816
  632679
  633981
  635755
  637224
  639278
  643786
  644227
  645071
  645328
  646545
  646713
  648144
  649866
  653100
  653102
  653126
  654329
  654417
  656538
  656580
  656616
  656632
  658933
  661427
  664454
  664473
  665080
  666660
  666678
  668068
  669310
  674494
  675150
  678249
  679879
  680300
  686794
  690214
  692372
  692919
  693677
  694130
  697578
  700271
  701212
  701669
  707412
  707562
  710007
  712477
  714194
  715379
  715521
  716952
  717150
  718346
  718614
  719500
  719987
  720217
  720319
  722046
  722810
  722880
]
2.12 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie cock"
]
1.79 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie cock"
]
1.75 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.94%)
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.