GET https://search.jues.net/search/embeds/9?q=double%20anal%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.95 ms
(80.84%)
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
  389700
  401916
  406381
  406933
  409861
  417212
  428397
  443779
  458555
  474718
  483547
  489328
  514580
  517844
  522871
  522911
  524986
  530495
  530912
  530935
  531155
  531182
  532676
  532812
  534215
  536310
  536582
  541419
  541634
  541635
  541690
  541738
  541886
  541923
  543849
  543918
  551919
  556046
  556054
  559577
  562832
  566782
  569922
  577368
  580290
  583701
  599844
  599865
  599867
  599890
  599899
  599913
  600029
  600271
  601046
  601600
  604517
  604569
  605553
  607261
  610271
  613146
  614308
  619483
  623380
  628336
  632595
  632599
  632617
  632646
  632693
  633111
  633123
  633753
  633758
  633786
  633799
  634138
  634218
  635215
  636300
  636306
  636309
  639334
  639790
  639818
  641678
  642018
  642066
  642385
  642660
  645936
  647932
  647960
  648795
  648817
  648820
  648839
  648868
  650155
  650774
  651607
  665776
  666586
  666853
  668526
  668549
  676623
  676632
  676634
  678063
  678128
  685701
  695122
  713564
  716887
  720298
  803455
  809508
  820762
]
19.96 ms
(12.42%)
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
  532676
  536310
  530935
  551919
  580290
  541634
  541690
  556054
  650774
  651607
  668549
  648795
  648817
  648839
  665776
  666853
  668526
  676632
  678063
  645936
  648868
  666586
  676623
  678128
  713564
  720298
  599890
  632617
  641678
  642018
  601046
  601600
  610271
  613146
  642066
  642385
  599899
  633786
  639790
  619483
  632599
  632646
  633111
  633753
  633758
  633799
  636309
  716887
  809508
  389700
  443779
  401916
  409861
  517844
  522911
  541419
  650155
  623380
  406933
  483547
  514580
  543849
  559577
  577368
  562832
  541738
  541923
  566782
  569922
  599867
  600029
  599844
  599913
  632693
  605553
  633123
  634138
  600271
  604569
  428397
  458555
  417212
  474718
  522871
  531155
  532812
  636306
  406381
  820762
  531182
  534215
  530912
  530495
  536582
  541886
  556046
  647932
  647960
  648820
  676634
  695122
  639818
  614308
  632595
  803455
  604517
  635215
  524986
  541635
  543918
  583701
  685701
  607261
  628336
  639334
  642660
  599865
  636300
  634218
  489328
]
3.27 ms
(2.03%)
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
  389700
  401916
  406381
  406933
  409861
  417212
  428397
  443779
  458555
  474718
  483547
  489328
  514580
  517844
  522871
  522911
  524986
  530495
  530912
  530935
  531155
  531182
  532676
  532812
  534215
  536310
  536582
  541419
  541634
  541635
  541690
  541738
  541886
  541923
  543849
  543918
  551919
  556046
  556054
  559577
  562832
  566782
  569922
  577368
  580290
  583701
  599844
  599865
  599867
  599890
  599899
  599913
  600029
  600271
  601046
  601600
  604517
  604569
  605553
  607261
  610271
  613146
  614308
  619483
  623380
  628336
  632595
  632599
  632617
  632646
  632693
  633111
  633123
  633753
  633758
  633786
  633799
  634138
  634218
  635215
  636300
  636306
  636309
  639334
  639790
  639818
  641678
  642018
  642066
  642385
  642660
  645936
  647932
  647960
  648795
  648817
  648820
  648839
  648868
  650155
  650774
  651607
  665776
  666586
  666853
  668526
  668549
  676623
  676632
  676634
  678063
  678128
  685701
  695122
  713564
  716887
  720298
  803455
  809508
  820762
]
2.13 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double anal mom"
]
1.92 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double анал mom"
]
1.77 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double анал mom"
]

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.