GET https://search.jues.net/search/embeds/5?q=blonde%20bondage

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.41 ms
(72.71%)
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
  398634
  409667
  412583
  412925
  416989
  417328
  419929
  420125
  420291
  429999
  444606
  451563
  454074
  454107
  459488
  462450
  467298
  470774
  471165
  471626
  476752
  496100
  497409
  499787
  503405
  504841
  509879
  512059
  516103
  516122
  516610
  517655
  518599
  519561
  520736
  520740
  524309
  527915
  528011
  533957
  536262
  561814
  569194
  595923
  602655
]
12.07 ms
(11.19%)
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
  516610
  520740
  524309
  499787
  517655
  412925
  459488
  536262
  561814
  595923
  451563
  476752
  454074
  520736
  528011
  420125
  471626
  454107
  503405
  470774
  509879
  496100
  497409
  420291
  416989
  519561
  462450
  444606
  516103
  516122
  467298
  429999
  412583
  471165
  504841
  602655
  518599
  533957
  409667
  419929
  512059
  417328
  398634
  569194
  527915
]
7.73 ms
(7.17%)
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:
[
  "blonde bondage"
  "blonde bondage"
  "blonde bondage"
  20
]
2.50 ms
(2.32%)
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
  398634
  409667
  412583
  412925
  416989
  417328
  419929
  420125
  420291
  429999
  444606
  451563
  454074
  454107
  459488
  462450
  467298
  470774
  471165
  471626
  476752
  496100
  497409
  499787
  503405
  504841
  509879
  512059
  516103
  516122
  516610
  517655
  518599
  519561
  520736
  520740
  524309
  527915
  528011
  533957
  536262
  561814
  569194
  595923
  602655
]
2.08 ms
(1.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde bondage"
]
1.76 ms
(1.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая бдсм"
]
1.65 ms
(1.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.