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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.45 ms
(78.76%)
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
  188395
  385752
  386734
  390623
  390950
  391959
  397781
  410651
  413183
  416294
  417836
  419320
  424436
  424658
  424875
  428113
  429899
  445395
  446079
  446131
  452832
  460171
  461282
  466012
  466392
  466884
  467940
  472001
  473832
  475056
  482231
  485311
  486192
  503836
  504020
  508807
  511027
  512809
  526089
  529369
  533594
  535384
  538870
  544323
  544478
  547423
  547428
  554866
  555288
  555337
  555387
  555425
  559139
  560077
  562147
  564304
  568060
  577039
  583953
  595772
  596844
  604313
  605157
  609887
  612816
  640677
  643767
  644285
  644296
  651635
  656200
  660732
  665790
  665936
  670904
  677724
  680215
  681075
  683003
  694222
  695871
  696120
  698423
  705710
  707408
  720714
  722212
  726942
  727560
  731328
  731463
  733217
  733416
  738528
  744463
  758256
  767287
  769291
  776312
  787274
  792533
  798705
  800052
  800288
  800712
  805222
  805777
  807394
  814178
  814926
  815054
  815943
  816545
  817119
  817154
  817632
  818468
  820586
  823746
  825304
]
24.25 ms
(15.47%)
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
  504020
  555425
  665936
  670904
  640677
  609887
  643767
  800052
  787274
  744463
  720714
  460171
  461282
  188395
  390950
  419320
  466392
  475056
  473832
  424436
  424658
  386734
  529369
  535384
  526089
  559139
  568060
  544323
  555337
  726942
  769291
  731328
  391959
  429899
  547423
  776312
  385752
  390623
  817632
  823746
  816545
  820586
  815943
  817119
  818468
  538870
  554866
  555288
  694222
  722212
  656200
  680215
  677724
  681075
  696120
  596844
  605157
  800712
  798705
  807394
  733416
  758256
  562147
  446131
  508807
  555387
  428113
  814926
  651635
  544478
  792533
  424875
  814178
  815054
  452832
  472001
  482231
  485311
  533594
  547428
  564304
  583953
  683003
  660732
  665790
  695871
  698423
  577039
  644285
  612816
  604313
  595772
  805222
  805777
  800288
  767287
  727560
  733217
  731463
  738528
  644296
  705710
  707408
  445395
  413183
  416294
  466012
  503836
  486192
  397781
  410651
  417836
  825304
  817154
  446079
  466884
  512809
  511027
  467940
  560077
]
2.19 ms
(1.40%)
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
  188395
  385752
  386734
  390623
  390950
  391959
  397781
  410651
  413183
  416294
  417836
  419320
  424436
  424658
  424875
  428113
  429899
  445395
  446079
  446131
  452832
  460171
  461282
  466012
  466392
  466884
  467940
  472001
  473832
  475056
  482231
  485311
  486192
  503836
  504020
  508807
  511027
  512809
  526089
  529369
  533594
  535384
  538870
  544323
  544478
  547423
  547428
  554866
  555288
  555337
  555387
  555425
  559139
  560077
  562147
  564304
  568060
  577039
  583953
  595772
  596844
  604313
  605157
  609887
  612816
  640677
  643767
  644285
  644296
  651635
  656200
  660732
  665790
  665936
  670904
  677724
  680215
  681075
  683003
  694222
  695871
  696120
  698423
  705710
  707408
  720714
  722212
  726942
  727560
  731328
  731463
  733217
  733416
  738528
  744463
  758256
  767287
  769291
  776312
  787274
  792533
  798705
  800052
  800288
  800712
  805222
  805777
  807394
  814178
  814926
  815054
  815943
  816545
  817119
  817154
  817632
  818468
  820586
  823746
  825304
]
2.03 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal milf hairy"
]
1.71 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал milf волосатая"
]
1.63 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал milf волосатая"
]

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.