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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.64 ms
(50.90%)
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
  400964
  411681
  417328
  423329
  425353
  434601
  445627
  445728
  445740
  445751
  446856
  446976
  451983
  452602
  475630
  479709
  487746
  490831
  496794
  503194
  507663
  516661
  518438
  518493
  521852
  523198
  527447
  543852
  543881
  544472
  554392
  558440
  573403
  576262
  577108
  579360
  582376
  583723
  584720
  591033
  591056
  591094
  593860
  599863
  605398
  605461
  605521
  605553
  614720
  644961
  720257
  814865
]
34.85 ms
(31.32%)
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:
[
  "mature wife interracial"
  "mature wife interracial"
  "mature wife interracial"
  20
]
10.96 ms
(9.84%)
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
  496794
  582376
  591033
  599863
  605461
  605398
  605553
  591094
  614720
  479709
  446976
  503194
  521852
  554392
  544472
  490831
  445728
  446856
  576262
  720257
  425353
  445751
  452602
  593860
  518438
  527447
  445627
  579360
  644961
  814865
  516661
  445740
  411681
  518493
  507663
  423329
  523198
  573403
  583723
  591056
  543852
  400964
  558440
  451983
  487746
  543881
  605521
  434601
  417328
  475630
  577108
  584720
]
2.73 ms
(2.45%)
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
  400964
  411681
  417328
  423329
  425353
  434601
  445627
  445728
  445740
  445751
  446856
  446976
  451983
  452602
  475630
  479709
  487746
  490831
  496794
  503194
  507663
  516661
  518438
  518493
  521852
  523198
  527447
  543852
  543881
  544472
  554392
  558440
  573403
  576262
  577108
  579360
  582376
  583723
  584720
  591033
  591056
  591094
  593860
  599863
  605398
  605461
  605521
  605553
  614720
  644961
  720257
  814865
]
1.83 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature wife interracial"
]
1.62 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature жен межрасов"
]
1.40 ms
(1.26%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(1.12%)
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.