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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
481.33 ms
(57.29%)
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
  632706
  817613
  827592
  520879
  664602
  670405
  596222
  800119
  791003
  757217
  804371
  738326
  741221
  745998
  635812
  801810
  814302
  672764
  710026
  757237
  768059
  741881
  755057
  774666
  775815
  672755
  739561
  543652
  542549
  646176
  639796
  600297
  599833
  634784
  635215
  698133
  554859
  618864
  606484
  772107
  740472
  718924
  827279
  824664
  540111
  566973
  580868
  666991
  575358
  633244
  607217
  784246
  765812
  735828
  744765
  729253
  741402
  751390
  798273
  818291
  667471
  704896
  618870
  811887
  782745
  790158
  731762
  734350
  768683
  715888
  793723
  737883
  789111
  732869
  727969
  800920
  576453
  632750
  793438
  807881
  736396
  800763
  809925
  545389
  678095
  666894
  641953
  639719
  630552
  639060
  642006
  632579
  610199
  820347
  824196
  827591
  817864
  671773
  672401
  719649
  719829
  685511
  690942
  554843
  642226
  809358
  753656
  751453
  729187
  753707
  738694
  758145
  608679
  752840
  747069
  721949
  814285
  542423
  546049
  631396
]
212.22 ms
(25.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss on tits"
]
137.75 ms
(16.40%)
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
  520879
  540111
  542423
  542549
  543652
  545389
  546049
  554843
  554859
  566973
  575358
  576453
  580868
  596222
  599833
  600297
  606484
  607217
  608679
  610199
  618864
  618870
  630552
  631396
  632579
  632706
  632750
  633244
  634784
  635215
  635812
  639060
  639719
  639796
  641953
  642006
  642226
  646176
  664602
  666894
  666991
  667471
  670405
  671773
  672401
  672755
  672764
  678095
  685511
  690942
  698133
  704896
  710026
  715888
  718924
  719649
  719829
  721949
  727969
  729187
  729253
  731762
  732869
  734350
  735828
  736396
  737883
  738326
  738694
  739561
  740472
  741221
  741402
  741881
  744765
  745998
  747069
  751390
  751453
  752840
  753656
  753707
  755057
  757217
  757237
  758145
  765812
  768059
  768683
  772107
  774666
  775815
  782745
  784246
  789111
  790158
  791003
  793438
  793723
  798273
  800119
  800763
  800920
  801810
  804371
  807881
  809358
  809925
  811887
  814285
  814302
  817613
  817864
  818291
  820347
  824196
  824664
  827279
  827591
  827592
]
3.29 ms
(0.39%)
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
  520879
  540111
  542423
  542549
  543652
  545389
  546049
  554843
  554859
  566973
  575358
  576453
  580868
  596222
  599833
  600297
  606484
  607217
  608679
  610199
  618864
  618870
  630552
  631396
  632579
  632706
  632750
  633244
  634784
  635215
  635812
  639060
  639719
  639796
  641953
  642006
  642226
  646176
  664602
  666894
  666991
  667471
  670405
  671773
  672401
  672755
  672764
  678095
  685511
  690942
  698133
  704896
  710026
  715888
  718924
  719649
  719829
  721949
  727969
  729187
  729253
  731762
  732869
  734350
  735828
  736396
  737883
  738326
  738694
  739561
  740472
  741221
  741402
  741881
  744765
  745998
  747069
  751390
  751453
  752840
  753656
  753707
  755057
  757217
  757237
  758145
  765812
  768059
  768683
  772107
  774666
  775815
  782745
  784246
  789111
  790158
  791003
  793438
  793723
  798273
  800119
  800763
  800920
  801810
  804371
  807881
  809358
  809925
  811887
  814285
  814302
  817613
  817864
  818291
  820347
  824196
  824664
  827279
  827591
  827592
]
2.07 ms
(0.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг сиськ"
]
1.89 ms
(0.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.