GET https://search.jues.net/search/embeds?q=alexandra%20wett%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
59.15 ms
(45.77%)
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
  482515
  489648
  497408
  499536
  502133
  506281
  509556
  524550
  524551
  524601
  526223
  526274
  526277
  548646
  554166
  569149
  578411
  580177
  586435
  591487
  591888
  591906
  603269
  606816
  609813
  610311
  611307
  680944
  710529
  714618
  714811
  721885
  747129
  758075
  758077
  761584
  775857
  800612
  802064
]
50.23 ms
(38.87%)
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:
[
  "alexandra wett anal"
  "alexandra wett anal"
  "alexandra wett anal"
  20
]
8.69 ms
(6.72%)
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
  721885
  747129
  800612
  775857
  509556
  524601
  802064
  714618
  611307
  710529
  761584
  482515
  758075
  580177
  758077
  591888
  499536
  591906
  714811
  524550
  489648
  506281
  603269
  569149
  497408
  606816
  609813
  548646
  680944
  524551
  502133
  526274
  526277
  591487
  554166
  586435
  610311
  526223
  578411
]
3.27 ms
(2.53%)
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
  482515
  489648
  497408
  499536
  502133
  506281
  509556
  524550
  524551
  524601
  526223
  526274
  526277
  548646
  554166
  569149
  578411
  580177
  586435
  591487
  591888
  591906
  603269
  606816
  609813
  610311
  611307
  680944
  710529
  714618
  714811
  721885
  747129
  758075
  758077
  761584
  775857
  800612
  802064
]
2.28 ms
(1.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "alexandra wett anal"
]
2.01 ms
(1.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "alexandrawett анал"
]
1.81 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "alexandrawett анал"
]

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.