GET https://search.jues.net/search/embeds/10?q=mature%20homemade%20shower

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.34 ms
(52.01%)
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
  403419
  421989
  435496
  439738
  454401
  455217
  474289
  477548
  479019
  481793
  482219
  486911
  486964
  493204
  493411
  494036
  500980
  504908
  504927
  517769
  517775
  519493
  520803
  522759
  524142
  527134
  527447
  530043
  538611
  539737
  541588
  541752
  541804
  542903
  544665
  545538
  557570
  584336
  584720
  587896
  588068
  593596
  603743
  605688
  643316
  724291
  724305
  730798
  735778
  807533
]
31.73 ms
(27.35%)
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:
[
  "mature homemade shower"
  "mature homemade shower"
  "mature homemade shower"
  20
]
13.97 ms
(12.04%)
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
  522759
  477548
  482219
  605688
  724291
  479019
  542903
  454401
  455217
  481793
  439738
  486964
  500980
  557570
  486911
  584336
  724305
  519493
  517769
  403419
  421989
  527134
  539737
  524142
  494036
  504908
  807533
  530043
  493411
  588068
  730798
  527447
  544665
  435496
  603743
  735778
  504927
  545538
  587896
  593596
  474289
  517775
  538611
  541752
  493204
  541588
  520803
  584720
  643316
  541804
]
2.36 ms
(2.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature homemade shower"
]
2.28 ms
(1.97%)
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
  403419
  421989
  435496
  439738
  454401
  455217
  474289
  477548
  479019
  481793
  482219
  486911
  486964
  493204
  493411
  494036
  500980
  504908
  504927
  517769
  517775
  519493
  520803
  522759
  524142
  527134
  527447
  530043
  538611
  539737
  541588
  541752
  541804
  542903
  544665
  545538
  557570
  584336
  584720
  587896
  588068
  593596
  603743
  605688
  643316
  724291
  724305
  730798
  735778
  807533
]
2.01 ms
(1.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature домашн любительск shower"
]
1.72 ms
(1.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature домашн любительск shower"
]

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.