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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
234.35 ms
(49.56%)
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
  428686
  484268
  535443
  540150
  542445
  543022
  544617
  551037
  551894
  556040
  559020
  562053
  565571
  565997
  570735
  571248
  575411
  576509
  580129
  580382
  584267
  584379
  585812
  592890
  596244
  612553
  615605
  615634
  619807
  621363
  623339
  626841
  630536
  632991
  633823
  639741
  639751
  642700
  644655
  649306
  650608
  662480
  662796
  666472
  666734
  668628
  672760
  677892
  678492
  678966
  681251
  690524
  697555
  701194
  704916
  710265
  712712
  714612
  714658
  721737
  726434
  727052
  732805
  733887
  734342
  737605
  738564
  741441
  741756
  741862
  743380
  743684
  744280
  744418
  745264
  746686
  748154
  749335
  750533
  751470
  761479
  762210
  768157
  775860
  784161
  784254
  784308
  784501
  786608
  790371
  793671
  795137
  795812
  796919
  797250
  799636
  800527
  801326
  802949
  803960
  804199
  805836
  808659
  810347
  810390
  811270
  811862
  811882
  811889
  811992
  812279
  812326
  812934
  814333
  817889
  818377
  819573
  820774
  826971
  827080
]
214.68 ms
(45.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "писсинг большие сиськ"
]
15.52 ms
(3.28%)
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
  803960
  761479
  732805
  784501
  801326
  540150
  797250
  799636
  678492
  721737
  804199
  805836
  737605
  712712
  580129
  623339
  666472
  639751
  580382
  556040
  562053
  584267
  650608
  690524
  615634
  811882
  744418
  762210
  743684
  701194
  811862
  811889
  584379
  630536
  678966
  428686
  571248
  626841
  796919
  811270
  734342
  808659
  748154
  542445
  662480
  644655
  810390
  733887
  710265
  672760
  751470
  704916
  639741
  543022
  677892
  668628
  714612
  817889
  826971
  621363
  795137
  812934
  632991
  592890
  786608
  741756
  585812
  745264
  544617
  790371
  775860
  800527
  484268
  784161
  814333
  559020
  649306
  596244
  793671
  768157
  795812
  551037
  810347
  811992
  727052
  750533
  575411
  681251
  570735
  666734
  812326
  726434
  633823
  565997
  565571
  551894
  802949
  827080
  576509
  812279
  744280
  738564
  746686
  818377
  819573
  820774
  662796
  697555
  714658
  619807
  741862
  743380
  749335
  612553
  784254
  784308
  741441
  535443
  642700
  615605
]
2.79 ms
(0.59%)
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
  428686
  484268
  535443
  540150
  542445
  543022
  544617
  551037
  551894
  556040
  559020
  562053
  565571
  565997
  570735
  571248
  575411
  576509
  580129
  580382
  584267
  584379
  585812
  592890
  596244
  612553
  615605
  615634
  619807
  621363
  623339
  626841
  630536
  632991
  633823
  639741
  639751
  642700
  644655
  649306
  650608
  662480
  662796
  666472
  666734
  668628
  672760
  677892
  678492
  678966
  681251
  690524
  697555
  701194
  704916
  710265
  712712
  714612
  714658
  721737
  726434
  727052
  732805
  733887
  734342
  737605
  738564
  741441
  741756
  741862
  743380
  743684
  744280
  744418
  745264
  746686
  748154
  749335
  750533
  751470
  761479
  762210
  768157
  775860
  784161
  784254
  784308
  784501
  786608
  790371
  793671
  795137
  795812
  796919
  797250
  799636
  800527
  801326
  802949
  803960
  804199
  805836
  808659
  810347
  810390
  811270
  811862
  811882
  811889
  811992
  812279
  812326
  812934
  814333
  817889
  818377
  819573
  820774
  826971
  827080
]
1.99 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг большие сиськ"
]
1.89 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss big tits"
]
1.60 ms
(0.34%)
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.