GET https://search.jues.net/search/embeds/2?q=busty%20stepmom

Query Metrics

8 Database Queries
8 Different statements
105.82 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
75.72 ms
(71.55%)
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
  383631
  399043
  406969
  411704
  435942
  446743
  448711
  452333
  453446
  462213
  462398
  463768
  490769
  498428
  502738
  502740
  505823
  506909
  518507
  522767
  543509
  546121
  554040
  561478
  562894
  591284
  595595
  597857
  603703
  623810
  668457
  673655
  673658
  673659
  696565
  710268
  714868
  716307
  716354
  718011
  726576
  726956
  736408
  740131
  744204
  745382
  745397
  745435
  755684
  781908
  793886
  814515
  818402
  818403
  819342
  824451
]
12.00 ms
(11.34%)
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
  502738
  668457
  824451
  463768
  818402
  710268
  755684
  562894
  740131
  745435
  591284
  781908
  406969
  453446
  818403
  462213
  673658
  726956
  745382
  399043
  383631
  814515
  452333
  546121
  745397
  506909
  505823
  716307
  411704
  518507
  522767
  448711
  462398
  673655
  498428
  490769
  435942
  595595
  502740
  673659
  561478
  819342
  744204
  726576
  736408
  714868
  718011
  554040
  696565
  716354
  623810
  793886
  543509
  597857
  446743
  603703
]
8.12 ms
(7.67%)
1
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "busty stepmom"
  "busty stepmom"
  "busty stepmom"
  20
]
3.04 ms
(2.87%)
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
  383631
  399043
  406969
  411704
  435942
  446743
  448711
  452333
  453446
  462213
  462398
  463768
  490769
  498428
  502738
  502740
  505823
  506909
  518507
  522767
  543509
  546121
  554040
  561478
  562894
  591284
  595595
  597857
  603703
  623810
  668457
  673655
  673658
  673659
  696565
  710268
  714868
  716307
  716354
  718011
  726576
  726956
  736408
  740131
  744204
  745382
  745397
  745435
  755684
  781908
  793886
  814515
  818402
  818403
  819342
  824451
]
1.87 ms
(1.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "busty stepmom"
]
1.79 ms
(1.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "busty stepmom"
]
1.71 ms
(1.62%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "busty stepmom"
]
1.57 ms
(1.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.