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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.12 ms
(80.31%)
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
  411737
  422192
  428103
  428224
  436942
  439801
  441853
  442128
  445617
  445641
  448714
  452293
  454264
  454954
  456293
  456516
  463842
  463976
  464139
  464328
  465312
  466885
  466982
  466989
  467611
  467972
  468630
  468910
  469534
  473391
  475684
  475828
  475869
  484727
  485454
  490262
  491802
  491823
  493210
  494833
  494985
  495051
  506081
  506801
  507651
  508518
  508523
  511313
  511596
  512447
  513025
  513775
  514070
  515723
  516744
  517604
  517881
  519853
  522556
  524882
  525026
  525864
  526052
  527451
  528361
  529213
  529485
  531511
  535460
  537970
  538848
  541588
  541611
  541633
  541665
  541683
  541871
  549225
  549233
  549239
  558490
  559127
  559132
  566374
  573393
  575198
  576710
  576723
  577392
  579341
  583701
  584352
  593372
  601324
  604429
  605521
  610695
  612434
  614737
  615382
  630063
  639824
  641978
  642016
  643103
  646901
  649953
  650380
  676117
  688116
  714346
  714479
  731158
  756395
  788776
  814903
]
31.34 ms
(14.46%)
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
  511313
  529213
  643103
  475828
  484727
  731158
  593372
  468630
  508518
  579341
  583701
  649953
  527451
  428224
  507651
  541665
  524882
  517881
  467611
  541633
  646901
  714479
  411737
  456293
  814903
  454954
  466982
  493210
  639824
  756395
  516744
  535460
  525864
  558490
  610695
  494985
  508523
  573393
  469534
  522556
  537970
  575198
  676117
  456516
  517604
  475869
  688116
  714346
  630063
  448714
  436942
  491802
  531511
  506801
  549233
  576723
  650380
  576710
  463842
  464139
  612434
  526052
  466885
  513025
  788776
  468910
  495051
  422192
  445617
  485454
  515723
  538848
  525026
  428103
  541683
  614737
  642016
  445641
  512447
  541871
  464328
  475684
  494833
  566374
  442128
  528361
  601324
  605521
  513775
  491823
  465312
  615382
  441853
  439801
  541588
  641978
  541611
  559127
  514070
  473391
  584352
  454264
  519853
  549239
  466989
  577392
  490262
  506081
  467972
  529485
  511596
  549225
  559132
  452293
  463976
  604429
]
3.67 ms
(1.69%)
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
  411737
  422192
  428103
  428224
  436942
  439801
  441853
  442128
  445617
  445641
  448714
  452293
  454264
  454954
  456293
  456516
  463842
  463976
  464139
  464328
  465312
  466885
  466982
  466989
  467611
  467972
  468630
  468910
  469534
  473391
  475684
  475828
  475869
  484727
  485454
  490262
  491802
  491823
  493210
  494833
  494985
  495051
  506081
  506801
  507651
  508518
  508523
  511313
  511596
  512447
  513025
  513775
  514070
  515723
  516744
  517604
  517881
  519853
  522556
  524882
  525026
  525864
  526052
  527451
  528361
  529213
  529485
  531511
  535460
  537970
  538848
  541588
  541611
  541633
  541665
  541683
  541871
  549225
  549233
  549239
  558490
  559127
  559132
  566374
  573393
  575198
  576710
  576723
  577392
  579341
  583701
  584352
  593372
  601324
  604429
  605521
  610695
  612434
  614737
  615382
  630063
  639824
  641978
  642016
  643103
  646901
  649953
  650380
  676117
  688116
  714346
  714479
  731158
  756395
  788776
  814903
]
2.15 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal saggy hairy"
]
1.89 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал saggy волосатая"
]
1.87 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал saggy волосатая"
]

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.