GET https://search.jues.net/search/embeds/10?q=hairy%20anal%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.05 ms
(81.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
  386142
  388341
  391386
  396253
  397392
  404415
  404584
  404778
  405028
  406698
  411681
  415160
  419956
  422192
  423332
  425523
  426294
  428224
  434309
  434376
  436942
  439801
  440632
  441853
  442128
  444831
  444916
  444918
  445408
  447276
  452293
  453568
  455126
  456293
  456516
  460040
  460673
  460804
  463976
  464328
  469357
  470015
  473391
  475684
  475869
  479422
  482527
  483373
  483978
  484681
  487746
  490262
  490511
  491802
  491823
  494833
  495051
  504474
  505526
  505548
  506081
  508180
  513025
  513135
  513141
  513775
  513949
  514070
  515964
  517604
  518493
  523537
  529485
  531804
  537970
  538794
  540511
  541055
  543852
  549239
  555317
  558490
  566374
  567336
  573754
  574258
  577392
  583757
  584352
  596925
  604429
  605521
  605586
  609794
  610606
  614766
  614770
  614827
  614831
  614835
  615382
  618185
  622675
  630063
  634071
  660144
  688116
  689424
  689436
  714346
  714479
  724305
  731158
  807852
]
19.74 ms
(11.83%)
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
  460040
  724305
  505526
  731158
  484681
  483373
  404415
  538794
  614770
  614766
  807852
  479422
  508180
  513949
  574258
  537970
  428224
  634071
  513775
  396253
  541055
  411681
  447276
  714479
  386142
  469357
  513135
  610606
  660144
  614835
  404778
  405028
  558490
  419956
  523537
  482527
  605586
  388341
  444831
  515964
  504474
  456516
  573754
  404584
  517604
  475869
  444918
  456293
  543852
  406698
  470015
  495051
  540511
  518493
  422192
  566374
  714346
  618185
  630063
  622675
  436942
  460673
  689424
  605521
  513025
  391386
  425523
  426294
  475684
  614831
  491823
  445408
  513141
  490511
  442128
  455126
  434309
  441853
  494833
  531804
  583757
  555317
  689436
  596925
  549239
  491802
  615382
  487746
  397392
  444916
  439801
  440632
  567336
  483978
  453568
  505548
  614827
  460804
  464328
  473391
  415160
  688116
  423332
  584352
  609794
  434376
  490262
  506081
  514070
  529485
  452293
  577392
  463976
  604429
]
3.62 ms
(2.17%)
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
  386142
  388341
  391386
  396253
  397392
  404415
  404584
  404778
  405028
  406698
  411681
  415160
  419956
  422192
  423332
  425523
  426294
  428224
  434309
  434376
  436942
  439801
  440632
  441853
  442128
  444831
  444916
  444918
  445408
  447276
  452293
  453568
  455126
  456293
  456516
  460040
  460673
  460804
  463976
  464328
  469357
  470015
  473391
  475684
  475869
  479422
  482527
  483373
  483978
  484681
  487746
  490262
  490511
  491802
  491823
  494833
  495051
  504474
  505526
  505548
  506081
  508180
  513025
  513135
  513141
  513775
  513949
  514070
  515964
  517604
  518493
  523537
  529485
  531804
  537970
  538794
  540511
  541055
  543852
  549239
  555317
  558490
  566374
  567336
  573754
  574258
  577392
  583757
  584352
  596925
  604429
  605521
  605586
  609794
  610606
  614766
  614770
  614827
  614831
  614835
  615382
  618185
  622675
  630063
  634071
  660144
  688116
  689424
  689436
  714346
  714479
  724305
  731158
  807852
]
2.17 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая анал жен"
]
1.79 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy anal wife"
]
1.63 ms
(0.98%)
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.