GET https://search.jues.net/search/embeds/3?q=sex%20pov%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
69.70 ms
(46.11%)
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
  420816
  423802
  429708
  437518
  438579
  440526
  442234
  460204
  463828
  467966
  480403
  484277
  491436
  496704
  499726
  500527
  501228
  502533
  506197
  514141
  514164
  517436
  518897
  522755
  524267
  524273
  524286
  524291
  524323
  524330
  524331
  524350
  524652
  524654
  524655
  524657
  546105
  554551
  567355
  575556
  577540
  579344
  582262
  595610
  651632
]
63.60 ms
(42.08%)
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:
[
  "sex pov solo"
  "sex pov solo"
  "sex pov solo"
  20
]
8.35 ms
(5.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
  514164
  518897
  524273
  524286
  440526
  651632
  480403
  524350
  524267
  595610
  522755
  524330
  524657
  484277
  496704
  524655
  524654
  524652
  546105
  517436
  460204
  524331
  524291
  567355
  438579
  467966
  463828
  577540
  582262
  437518
  554551
  423802
  506197
  429708
  442234
  500527
  579344
  514141
  420816
  491436
  575556
  502533
  524323
  501228
  499726
]
2.39 ms
(1.58%)
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
  420816
  423802
  429708
  437518
  438579
  440526
  442234
  460204
  463828
  467966
  480403
  484277
  491436
  496704
  499726
  500527
  501228
  502533
  506197
  514141
  514164
  517436
  518897
  522755
  524267
  524273
  524286
  524291
  524323
  524330
  524331
  524350
  524652
  524654
  524655
  524657
  546105
  554551
  567355
  575556
  577540
  579344
  582262
  595610
  651632
]
2.09 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex pov solo"
]
1.82 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс пов соло"
]
1.74 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.98%)
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.