GET https://search.jues.net/search/embeds/9?q=piss%20on%20tits

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
228.56 ms
(89.67%)
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
  540139
  540150
  542285
  542445
  545418
  551037
  556040
  556337
  559020
  559924
  562053
  569379
  571248
  574000
  580129
  580382
  581033
  584267
  585812
  589337
  593734
  596244
  597763
  598048
  604715
  605512
  606322
  612430
  614382
  615053
  615634
  623339
  626332
  626841
  629680
  630254
  630536
  636463
  637511
  639741
  639751
  640156
  640859
  642774
  644655
  645700
  647860
  649306
  650075
  650608
  650634
  650919
  651922
  662480
  671070
  672760
  678492
  690524
  701194
  710265
  712712
  714577
  721737
  724039
  726330
  728605
  732589
  732805
  733887
  734342
  734364
  736534
  736944
  737605
  741692
  743684
  744418
  745264
  745981
  747384
  748138
  748154
  757246
  758292
  761479
  762210
  768157
  784127
  784501
  786458
  788127
  793671
  794240
  795416
  795812
  795979
  796577
  796919
  797240
  797250
  799636
  799934
  800506
  800698
  801326
  802315
  803960
  804199
  805836
  808659
  810390
  811010
  811270
  811862
  811882
  811889
  814333
  817709
  817879
  819488
]
15.27 ms
(5.99%)
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
  795416
  800506
  626332
  797250
  757246
  799636
  726330
  545418
  647860
  642774
  630536
  819488
  581033
  671070
  612430
  597763
  630254
  788127
  797240
  799934
  732589
  745981
  589337
  640859
  817709
  817879
  569379
  650634
  605512
  606322
  604715
  629680
  736534
  724039
  758292
  637511
  559924
  796577
  710265
  672760
  803960
  761479
  732805
  784501
  801326
  542445
  556337
  662480
  574000
  640156
  598048
  644655
  795979
  786458
  810390
  802315
  733887
  747384
  542285
  645700
  650075
  714577
  593734
  615053
  794240
  728605
  736944
  748138
  734364
  741692
  614382
  800698
  811010
  814333
  559020
  571248
  712712
  649306
  596244
  626841
  796919
  811270
  793671
  734342
  808659
  748154
  768157
  795812
  540150
  580382
  556040
  562053
  584267
  650608
  678492
  651922
  690524
  721737
  615634
  585812
  804199
  811882
  805836
  737605
  744418
  745264
  762210
  743684
  701194
  811862
  811889
  639741
  639751
  540139
  551037
  650919
  580129
  636463
  623339
  784127
]
3.36 ms
(1.32%)
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
  540139
  540150
  542285
  542445
  545418
  551037
  556040
  556337
  559020
  559924
  562053
  569379
  571248
  574000
  580129
  580382
  581033
  584267
  585812
  589337
  593734
  596244
  597763
  598048
  604715
  605512
  606322
  612430
  614382
  615053
  615634
  623339
  626332
  626841
  629680
  630254
  630536
  636463
  637511
  639741
  639751
  640156
  640859
  642774
  644655
  645700
  647860
  649306
  650075
  650608
  650634
  650919
  651922
  662480
  671070
  672760
  678492
  690524
  701194
  710265
  712712
  714577
  721737
  724039
  726330
  728605
  732589
  732805
  733887
  734342
  734364
  736534
  736944
  737605
  741692
  743684
  744418
  745264
  745981
  747384
  748138
  748154
  757246
  758292
  761479
  762210
  768157
  784127
  784501
  786458
  788127
  793671
  794240
  795416
  795812
  795979
  796577
  796919
  797240
  797250
  799636
  799934
  800506
  800698
  801326
  802315
  803960
  804199
  805836
  808659
  810390
  811010
  811270
  811862
  811882
  811889
  814333
  817709
  817879
  819488
]
2.19 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг сиськ"
]
2.09 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss on tits"
]
1.75 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг сиськ"
]
1.67 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.