GET https://search.jues.net/search/embeds/9?q=amateur%20hot%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.90 ms
(89.12%)
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
  397113
  448907
  453693
  458571
  459730
  466031
  468291
  468343
  469173
  475280
  475802
  488119
  489321
  502315
  509019
  509082
  525182
  529210
  529903
  530290
  531963
  535710
  536852
  548274
  555010
  564046
  569266
  569814
  575288
  575625
  577175
  583178
  585166
  596188
  600861
  603728
  605040
  605583
  613813
  615197
  619260
  619898
  627212
  629573
  630651
  634320
  640617
  641064
  655241
  657831
  661311
  666386
  669319
  670686
  673573
  676793
  678661
  680611
  682908
  699313
  701661
  703464
  707558
  708189
  709396
  710597
  712632
  712648
  712653
  713323
  719065
  721959
  725411
  727778
  729287
  732810
  738447
  741185
  745478
  745872
  750814
  753123
  757983
  758310
  759928
  761195
  761949
  763265
  763373
  777819
  777940
  779729
  780400
  782165
  784024
  785318
  789020
  791674
  792132
  792419
  794778
  795528
  796316
  796580
  796752
  798019
  800041
  800676
  800788
  801300
  802131
  802137
  804375
  810484
  810505
  810948
  811259
  818709
  825202
  826649
]
10.79 ms
(5.73%)
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
  811259
  741185
  759928
  732810
  750814
  729287
  727778
  745478
  725411
  761949
  453693
  469173
  475802
  509019
  458571
  529210
  509082
  535710
  536852
  468291
  564046
  569814
  575625
  577175
  548274
  575288
  678661
  680611
  708189
  712632
  713323
  661311
  666386
  669319
  670686
  676793
  682908
  707558
  712648
  712653
  655241
  657831
  710597
  600861
  619260
  619898
  630651
  613813
  629573
  634320
  605040
  605583
  641064
  627212
  640617
  791674
  802137
  777940
  763373
  603728
  699313
  701661
  709396
  721959
  502315
  475280
  397113
  825202
  826649
  818709
  466031
  488119
  448907
  459730
  468343
  489321
  525182
  529903
  530290
  583178
  569266
  719065
  555010
  585166
  777819
  784024
  792132
  796580
  800676
  810484
  810948
  779729
  782165
  795528
  796752
  798019
  800041
  800788
  810505
  758310
  761195
  794778
  796316
  757983
  738447
  763265
  745872
  753123
  780400
  785318
  789020
  801300
  802131
  804375
  531963
  673573
  703464
  615197
  596188
  792419
]
2.68 ms
(1.42%)
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
  397113
  448907
  453693
  458571
  459730
  466031
  468291
  468343
  469173
  475280
  475802
  488119
  489321
  502315
  509019
  509082
  525182
  529210
  529903
  530290
  531963
  535710
  536852
  548274
  555010
  564046
  569266
  569814
  575288
  575625
  577175
  583178
  585166
  596188
  600861
  603728
  605040
  605583
  613813
  615197
  619260
  619898
  627212
  629573
  630651
  634320
  640617
  641064
  655241
  657831
  661311
  666386
  669319
  670686
  673573
  676793
  678661
  680611
  682908
  699313
  701661
  703464
  707558
  708189
  709396
  710597
  712632
  712648
  712653
  713323
  719065
  721959
  725411
  727778
  729287
  732810
  738447
  741185
  745478
  745872
  750814
  753123
  757983
  758310
  759928
  761195
  761949
  763265
  763373
  777819
  777940
  779729
  780400
  782165
  784024
  785318
  789020
  791674
  792132
  792419
  794778
  795528
  796316
  796580
  796752
  798019
  800041
  800676
  800788
  801300
  802131
  802137
  804375
  810484
  810505
  810948
  811259
  818709
  825202
  826649
]
1.97 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur hot milf"
]
1.90 ms
(1.01%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск hot milf"
]
1.46 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск hot 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.