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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.26 ms
(87.42%)
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
  400928
  414103
  423802
  538066
  542987
  544899
  544915
  546016
  546493
  546813
  549040
  553812
  554846
  555089
  555486
  556796
  557522
  559293
  559311
  559805
  565500
  565935
  567588
  569736
  575360
  579128
  581281
  581960
  585260
  588035
  588748
  600304
  604589
  605527
  610484
  618259
  620037
  625300
  626163
  631457
  631459
  632017
  634745
  635775
  636284
  638441
  640442
  641226
  642429
  650146
  651984
  667589
  667914
  668648
  669331
  669870
  673214
  690800
  693848
  694482
  696584
  697182
  698841
  698916
  702960
  708591
  714012
  714382
  714953
  717667
  718498
  726657
  727039
  728240
  730104
  730936
  731007
  735976
  737496
  740858
  742056
  744077
  746562
  748048
  751427
  753170
  756949
  757052
  758322
  759761
  774663
  776414
  776842
  781850
  785466
  787564
  788322
  793694
  794394
  794968
  796273
  796860
  796992
  798087
  800319
  800430
  801804
  803516
  804260
  804432
  806700
  810360
  810684
  811503
  812332
  813534
  818502
  818867
  825879
  826501
]
13.68 ms
(7.51%)
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
  667914
  669331
  696584
  693848
  694482
  697182
  567588
  642429
  605527
  638441
  635775
  641226
  781850
  811503
  785466
  800430
  812332
  737496
  758322
  798087
  801804
  804260
  804432
  813534
  728240
  730936
  742056
  726657
  744077
  751427
  759761
  727039
  735976
  756949
  604589
  776414
  788322
  796860
  803516
  714012
  636284
  400928
  414103
  542987
  546016
  555089
  581281
  557522
  559293
  579128
  787564
  730104
  423802
  818867
  826501
  825879
  818502
  538066
  546493
  546813
  559311
  575360
  544899
  549040
  559805
  565500
  553812
  554846
  569736
  581960
  651984
  673214
  690800
  698916
  702960
  714382
  717667
  650146
  698841
  718498
  667589
  668648
  669870
  708591
  714953
  544915
  555486
  556796
  565935
  585260
  588035
  610484
  631457
  632017
  634745
  640442
  600304
  620037
  625300
  626163
  588748
  618259
  631459
  794394
  794968
  800319
  810684
  774663
  776842
  793694
  796273
  796992
  806700
  810360
  731007
  740858
  746562
  748048
  753170
  757052
]
2.62 ms
(1.44%)
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
  400928
  414103
  423802
  538066
  542987
  544899
  544915
  546016
  546493
  546813
  549040
  553812
  554846
  555089
  555486
  556796
  557522
  559293
  559311
  559805
  565500
  565935
  567588
  569736
  575360
  579128
  581281
  581960
  585260
  588035
  588748
  600304
  604589
  605527
  610484
  618259
  620037
  625300
  626163
  631457
  631459
  632017
  634745
  635775
  636284
  638441
  640442
  641226
  642429
  650146
  651984
  667589
  667914
  668648
  669331
  669870
  673214
  690800
  693848
  694482
  696584
  697182
  698841
  698916
  702960
  708591
  714012
  714382
  714953
  717667
  718498
  726657
  727039
  728240
  730104
  730936
  731007
  735976
  737496
  740858
  742056
  744077
  746562
  748048
  751427
  753170
  756949
  757052
  758322
  759761
  774663
  776414
  776842
  781850
  785466
  787564
  788322
  793694
  794394
  794968
  796273
  796860
  796992
  798087
  800319
  800430
  801804
  803516
  804260
  804432
  806700
  810360
  810684
  811503
  812332
  813534
  818502
  818867
  825879
  826501
]
1.91 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие pussy дырк"
]
1.63 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие pussy дырк"
]
1.57 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big pussy hole"
]
1.51 ms
(0.83%)
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.