GET https://search.jues.net/search/embeds/6?q=mature%20busty%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
363.97 ms
(92.09%)
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
  172262
  197591
  383631
  391247
  395701
  397782
  400178
  401465
  405543
  408056
  408085
  408659
  409032
  412288
  413087
  415579
  415581
  416926
  416974
  425992
  430701
  431504
  433808
  440687
  443246
  444558
  447740
  449023
  449093
  449870
  449929
  452246
  453292
  453305
  454564
  455411
  456396
  457644
  457988
  458715
  460248
  460603
  462472
  463764
  464131
  465654
  467542
  468760
  469288
  469301
  471701
  472322
  474494
  477209
  477874
  477885
  478963
  480787
  482255
  483444
  487356
  489985
  491249
  497233
  498441
  501569
  501733
  505518
  505691
  513335
  514601
  514706
  515027
  515698
  517001
  520665
  522767
  523599
  525396
  527923
  532684
  532808
  539645
  540343
  540952
  543849
  545637
  549687
  554258
  554886
  555865
  561380
  563246
  566311
  581487
  581833
  586555
  592438
  604326
  604782
  604887
  605694
  612044
  620208
  637650
  644266
  644270
  667647
  668550
  671712
  697078
  717862
  788494
  792530
  799049
  800205
  810824
  815290
  817841
  821043
]
20.07 ms
(5.08%)
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
  532684
  501569
  515027
  563246
  637650
  792530
  462472
  478963
  391247
  467542
  454564
  457988
  477885
  430701
  464131
  517001
  514706
  172262
  400178
  440687
  408659
  425992
  408085
  431504
  815290
  449023
  453305
  489985
  456396
  469301
  539645
  513335
  540343
  525396
  545637
  554258
  554886
  555865
  644270
  605694
  788494
  810824
  405543
  401465
  408056
  413087
  449870
  480787
  522767
  498441
  474494
  412288
  455411
  463764
  543849
  395701
  458715
  460603
  468760
  469288
  527923
  501733
  505691
  514601
  491249
  540952
  667647
  586555
  443246
  465654
  383631
  197591
  397782
  409032
  416926
  416974
  433808
  415579
  415581
  444558
  817841
  821043
  449093
  477209
  483444
  453292
  460248
  471701
  447740
  449929
  452246
  457644
  477874
  482255
  497233
  532808
  515698
  520665
  523599
  505518
  472322
  487356
  549687
  581487
  581833
  717862
  671712
  668550
  697078
  561380
  566311
  604782
  604887
  620208
  592438
  612044
  604326
  644266
  799049
  800205
]
3.59 ms
(0.91%)
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
  172262
  197591
  383631
  391247
  395701
  397782
  400178
  401465
  405543
  408056
  408085
  408659
  409032
  412288
  413087
  415579
  415581
  416926
  416974
  425992
  430701
  431504
  433808
  440687
  443246
  444558
  447740
  449023
  449093
  449870
  449929
  452246
  453292
  453305
  454564
  455411
  456396
  457644
  457988
  458715
  460248
  460603
  462472
  463764
  464131
  465654
  467542
  468760
  469288
  469301
  471701
  472322
  474494
  477209
  477874
  477885
  478963
  480787
  482255
  483444
  487356
  489985
  491249
  497233
  498441
  501569
  501733
  505518
  505691
  513335
  514601
  514706
  515027
  515698
  517001
  520665
  522767
  523599
  525396
  527923
  532684
  532808
  539645
  540343
  540952
  543849
  545637
  549687
  554258
  554886
  555865
  561380
  563246
  566311
  581487
  581833
  586555
  592438
  604326
  604782
  604887
  605694
  612044
  620208
  637650
  644266
  644270
  667647
  668550
  671712
  697078
  717862
  788494
  792530
  799049
  800205
  810824
  815290
  817841
  821043
]
2.25 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature busty milf"
]
1.96 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature busty milf"
]
1.80 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature busty 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.