GET https://search.jues.net/search/embeds/8?q=hairy%20mature%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.46 ms
(86.52%)
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
  401894
  408509
  408978
  411715
  413455
  414594
  423495
  439591
  448795
  450786
  454274
  455373
  457063
  461285
  461294
  462021
  466007
  466178
  466836
  467905
  469774
  473223
  475681
  479040
  482303
  484467
  484690
  484722
  486341
  490262
  490651
  493515
  495031
  495737
  506309
  509185
  517428
  517527
  524325
  525727
  527624
  544613
  544618
  545245
  545897
  546148
  552576
  555232
  555251
  555298
  555302
  555335
  555339
  555430
  555439
  555443
  558172
  563710
  566877
  569315
  574398
  578010
  578701
  580503
  585364
  589686
  590721
  591922
  592573
  592688
  609057
  614770
  614772
  614782
  614790
  614794
  622679
  680295
  696120
  707452
  710233
  710265
  713189
  714122
  714309
  714331
  714380
  714468
  714510
  714622
  714930
  717535
  722062
  725239
  725397
  730335
  735488
  754656
  761061
  768650
  788631
  790630
  791861
  796718
  797333
  802312
  802351
  803404
  803789
  804679
  807405
  807432
  807884
  812314
  812549
  819431
  824165
  826789
  827185
  827423
]
17.26 ms
(8.51%)
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
  414594
  555335
  826789
  827185
  824165
  461285
  517527
  566877
  714930
  707452
  714331
  589686
  788631
  803404
  725397
  754656
  804679
  812549
  725239
  730335
  622679
  713189
  714122
  722062
  796718
  807432
  807884
  609057
  590721
  479040
  466007
  545245
  484722
  484467
  486341
  475681
  448795
  546148
  411715
  714309
  578010
  710265
  401894
  574398
  527624
  506309
  544613
  544618
  555232
  555302
  555430
  563710
  545897
  552576
  680295
  710233
  555251
  555339
  592688
  614770
  614794
  614772
  614790
  614782
  827423
  819431
  493515
  509185
  461294
  580503
  812314
  790630
  802312
  802351
  807405
  735488
  761061
  714510
  714622
  791861
  797333
  803789
  454274
  439591
  466836
  490262
  484690
  408509
  482303
  495737
  490651
  578701
  717535
  591922
  467905
  462021
  466178
  455373
  423495
  495031
  524325
  525727
  555298
  555443
  696120
  585364
  768650
  469774
  408978
  413455
  473223
  555439
  558172
  450786
  517428
  714380
  569315
  592573
  714468
  457063
]
2.87 ms
(1.41%)
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
  401894
  408509
  408978
  411715
  413455
  414594
  423495
  439591
  448795
  450786
  454274
  455373
  457063
  461285
  461294
  462021
  466007
  466178
  466836
  467905
  469774
  473223
  475681
  479040
  482303
  484467
  484690
  484722
  486341
  490262
  490651
  493515
  495031
  495737
  506309
  509185
  517428
  517527
  524325
  525727
  527624
  544613
  544618
  545245
  545897
  546148
  552576
  555232
  555251
  555298
  555302
  555335
  555339
  555430
  555439
  555443
  558172
  563710
  566877
  569315
  574398
  578010
  578701
  580503
  585364
  589686
  590721
  591922
  592573
  592688
  609057
  614770
  614772
  614782
  614790
  614794
  622679
  680295
  696120
  707452
  710233
  710265
  713189
  714122
  714309
  714331
  714380
  714468
  714510
  714622
  714930
  717535
  722062
  725239
  725397
  730335
  735488
  754656
  761061
  768650
  788631
  790630
  791861
  796718
  797333
  802312
  802351
  803404
  803789
  804679
  807405
  807432
  807884
  812314
  812549
  819431
  824165
  826789
  827185
  827423
]
2.19 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy mature homemade"
]
1.67 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая mature домашн любительск"
]
1.47 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая mature домашн любительск"
]

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.