GET https://search.jues.net/search/embeds/6?q=wife%20films

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
89.15 ms
(70.15%)
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
  157194
  400143
  411846
  422270
  424903
  426233
  426903
  439606
  446976
  452251
  452282
  453365
  458333
  470913
  473235
  473293
  483417
  495374
  501203
  502539
  502549
  503178
  504768
  504909
  509713
  511300
  517450
  521367
  524276
  526777
  527134
  527944
  532419
  542627
  566370
  567468
  569830
  571135
  572026
  583832
  584644
  586591
  590602
  591094
  603147
  610575
  618534
  620157
  630919
  636154
  641624
  644005
  659025
  712775
]
18.79 ms
(14.79%)
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:
[
  "wife films"
  "wife films"
  "wife films"
  20
]
9.95 ms
(7.83%)
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
  503178
  712775
  644005
  618534
  157194
  473293
  502549
  501203
  411846
  458333
  511300
  504909
  527944
  426233
  424903
  542627
  473235
  452282
  521367
  571135
  603147
  630919
  439606
  470913
  526777
  566370
  502539
  517450
  567468
  452251
  532419
  569830
  659025
  620157
  583832
  641624
  590602
  527134
  586591
  591094
  446976
  483417
  453365
  400143
  495374
  504768
  509713
  426903
  422270
  572026
  584644
  636154
  524276
  610575
]
2.57 ms
(2.02%)
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
  157194
  400143
  411846
  422270
  424903
  426233
  426903
  439606
  446976
  452251
  452282
  453365
  458333
  470913
  473235
  473293
  483417
  495374
  501203
  502539
  502549
  503178
  504768
  504909
  509713
  511300
  517450
  521367
  524276
  526777
  527134
  527944
  532419
  542627
  566370
  567468
  569830
  571135
  572026
  583832
  584644
  586591
  590602
  591094
  603147
  610575
  618534
  620157
  630919
  636154
  641624
  644005
  659025
  712775
]
1.87 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife films"
]
1.81 ms
(1.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен фильм"
]
1.47 ms
(1.16%)
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.