GET https://search.jues.net/search/embeds?q=alexandra-wett

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
99.68 ms
(80.23%)
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
  489787
  489788
  491626
  491627
  491630
  492529
  497408
  499536
  502087
  502133
  506281
  509556
  524550
  524551
  524601
  526223
  526227
  526274
  526277
  548646
  554166
  559352
  566298
  569108
  569149
  569213
  578411
  580177
  584382
  586435
  591487
  591888
  591906
  592981
  603269
  606816
  609813
  610311
  611307
  629760
  664494
  680944
  710529
  710577
  714618
  714811
  719963
  721885
  721932
  734117
  747129
  758075
  758077
  761440
  761584
  775857
  800612
  802064
]
10.38 ms
(8.36%)
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
  569213
  761440
  710577
  710529
  800612
  611307
  734117
  761584
  719963
  482515
  758075
  721932
  775857
  580177
  758077
  714618
  721885
  591906
  591888
  491627
  499536
  491626
  714811
  664494
  559352
  491630
  526227
  584382
  802064
  747129
  489787
  524550
  506281
  489648
  603269
  502087
  569108
  489788
  509556
  629760
  569149
  566298
  497408
  524601
  492529
  548646
  680944
  592981
  606816
  609813
  524551
  526274
  526277
  502133
  586435
  591487
  554166
  610311
  526223
  578411
]
3.68 ms
(2.96%)
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"
  "alexandra-wett"
  "alexandra-wett"
  20
]
2.77 ms
(2.23%)
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
  489787
  489788
  491626
  491627
  491630
  492529
  497408
  499536
  502087
  502133
  506281
  509556
  524550
  524551
  524601
  526223
  526227
  526274
  526277
  548646
  554166
  559352
  566298
  569108
  569149
  569213
  578411
  580177
  584382
  586435
  591487
  591888
  591906
  592981
  603269
  606816
  609813
  610311
  611307
  629760
  664494
  680944
  710529
  710577
  714618
  714811
  719963
  721885
  721932
  734117
  747129
  758075
  758077
  761440
  761584
  775857
  800612
  802064
]
2.29 ms
(1.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "alexandrawett"
]
1.86 ms
(1.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "alexandrawett"
]
1.84 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "alexandra-wett"
]
1.75 ms
(1.41%)
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.