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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
488.60 ms
(95.07%)
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
  24374
  388777
  389966
  391911
  391992
  398968
  401214
  405070
  405252
  411747
  420178
  421326
  422235
  423332
  424410
  424444
  425967
  426295
  427241
  428174
  428238
  429916
  437305
  443184
  447895
  450794
  451491
  452244
  453062
  453178
  454177
  454234
  454247
  458000
  458419
  460593
  460680
  460757
  460908
  462572
  463973
  464373
  466051
  467034
  470768
  470918
  471075
  472640
  473391
  475289
  475683
  483250
  484362
  489187
  493980
  494978
  496063
  496550
  499862
  501553
  505460
  505671
  508254
  509637
  509679
  512542
  512947
  513857
  517444
  517687
  517697
  520682
  526213
  527088
  528100
  528474
  530530
  531538
  536637
  537870
  543708
  543938
  554883
  559350
  566076
  567418
  569300
  569832
  573196
  576616
  577132
  578323
  578733
  578798
  580841
  581098
  583966
  583990
  584352
  584627
  594560
  595097
  605513
  605702
  607034
  618952
  618969
  619140
  619604
  625172
  628582
  632083
  635336
  646243
  667344
  690882
  740277
  746686
  792580
  823956
]
17.10 ms
(3.33%)
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
  508254
  509637
  499862
  512542
  517444
  517697
  531538
  501553
  512947
  513857
  530530
  460680
  493980
  543708
  554883
  577132
  584627
  573196
  566076
  567418
  578733
  578798
  583990
  667344
  690882
  580841
  618952
  628582
  618969
  594560
  605513
  607034
  619140
  619604
  595097
  605702
  792580
  746686
  740277
  632083
  635336
  424410
  454234
  466051
  470768
  471075
  405252
  424444
  454247
  460908
  462572
  470918
  391992
  401214
  420178
  421326
  429916
  453062
  460757
  388777
  398968
  405070
  443184
  454177
  458000
  472640
  422235
  451491
  496063
  484362
  489187
  528474
  460593
  581098
  463973
  389966
  467034
  505671
  24374
  625172
  473391
  437305
  475289
  505460
  823956
  458419
  494978
  391911
  423332
  411747
  426295
  428238
  425967
  427241
  428174
  453178
  464373
  483250
  447895
  450794
  452244
  496550
  526213
  537870
  527088
  528100
  520682
  536637
  509679
  517687
  475683
  569832
  578323
  543938
  559350
  569300
  583966
  584352
  646243
  576616
]
2.84 ms
(0.55%)
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
  24374
  388777
  389966
  391911
  391992
  398968
  401214
  405070
  405252
  411747
  420178
  421326
  422235
  423332
  424410
  424444
  425967
  426295
  427241
  428174
  428238
  429916
  437305
  443184
  447895
  450794
  451491
  452244
  453062
  453178
  454177
  454234
  454247
  458000
  458419
  460593
  460680
  460757
  460908
  462572
  463973
  464373
  466051
  467034
  470768
  470918
  471075
  472640
  473391
  475289
  475683
  483250
  484362
  489187
  493980
  494978
  496063
  496550
  499862
  501553
  505460
  505671
  508254
  509637
  509679
  512542
  512947
  513857
  517444
  517687
  517697
  520682
  526213
  527088
  528100
  528474
  530530
  531538
  536637
  537870
  543708
  543938
  554883
  559350
  566076
  567418
  569300
  569832
  573196
  576616
  577132
  578323
  578733
  578798
  580841
  581098
  583966
  583990
  584352
  584627
  594560
  595097
  605513
  605702
  607034
  618952
  618969
  619140
  619604
  625172
  628582
  632083
  635336
  646243
  667344
  690882
  740277
  746686
  792580
  823956
]
1.61 ms
(0.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf chubby hairy"
]
1.34 ms
(0.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.28 ms
(0.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf chubby волосатая"
]
1.16 ms
(0.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf chubby волосатая"
]

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.