GET https://search.jues.net/search/embeds?q=cleaning%20house

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
218.24 ms
(42.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:
[
  "cleaning house"
  "cleaning house"
  "cleaning house"
  20
]
208.39 ms
(40.75%)
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
  385815
  407698
  413130
  444085
  450264
  455380
  467216
  476347
  477862
  494919
  503136
  503822
  504732
  512606
  514572
  522057
  537634
  554759
  566140
  570938
  576863
  579871
  596883
  596946
  596976
  610280
  617445
  655482
  660765
  685732
  693884
  724861
  734610
  759077
  759164
  775466
  781812
  789075
  793775
  799027
  800170
  802475
  813831
  823477
  823906
  824214
  828817
]
69.62 ms
(13.61%)
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
  385815
  407698
  413130
  444085
  450264
  455380
  467216
  476347
  477862
  494919
  503136
  503822
  504732
  512606
  514572
  522057
  537634
  554759
  566140
  570938
  576863
  579871
  596883
  596946
  596976
  610280
  617445
  655482
  660765
  685732
  693884
  724861
  734610
  759077
  759164
  775466
  781812
  789075
  793775
  799027
  800170
  802475
  813831
  823477
  823906
  824214
  828817
]
7.77 ms
(1.52%)
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
  450264
  504732
  610280
  503822
  800170
  407698
  413130
  759077
  570938
  576863
  793775
  789075
  579871
  734610
  759164
  724861
  385815
  467216
  596946
  823477
  494919
  617445
  781812
  775466
  799027
  444085
  655482
  685732
  476347
  522057
  512606
  828817
  824214
  823906
  537634
  802475
  660765
  596883
  813831
  693884
  554759
  455380
  477862
  566140
  596976
  514572
  503136
]
2.08 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cleaning house"
]
1.93 ms
(0.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cleaning house"
]
1.58 ms
(0.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cleaning house"
]

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.