GET https://search.jues.net/search/embeds/3?q=grandpa%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.10 ms
(68.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "grandpa mature"
]
58.24 ms
(19.02%)
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
  423375
  426025
  450849
  471951
  474024
  474120
  474139
  476409
  482808
  487911
  488308
  491023
  496832
  504386
  511009
  511418
  515206
  515262
  515724
  521740
  525116
  525118
  541630
  541759
  543924
  545000
  545538
  550230
  550433
  550434
  550437
  554309
  556427
  557064
  557312
  571199
  571428
  597867
  599600
  608358
  619398
  619399
  640687
  662137
  665108
  665116
  668176
  678791
  681215
  790884
]
17.77 ms
(5.80%)
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:
[
  "grandpa mature"
  "grandpa mature"
  "grandpa mature"
  20
]
10.85 ms
(3.54%)
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
  550230
  474024
  488308
  515262
  515724
  550437
  543924
  665116
  668176
  678791
  665108
  545000
  554309
  619399
  790884
  471951
  511418
  541630
  681215
  525116
  525118
  450849
  571199
  545538
  619398
  640687
  597867
  474120
  487911
  426025
  423375
  476409
  496832
  504386
  557064
  541759
  662137
  556427
  557312
  482808
  550433
  608358
  599600
  550434
  491023
  515206
  571428
  474139
  521740
  511009
]
2.45 ms
(0.80%)
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
  423375
  426025
  450849
  471951
  474024
  474120
  474139
  476409
  482808
  487911
  488308
  491023
  496832
  504386
  511009
  511418
  515206
  515262
  515724
  521740
  525116
  525118
  541630
  541759
  543924
  545000
  545538
  550230
  550433
  550434
  550437
  554309
  556427
  557064
  557312
  571199
  571428
  597867
  599600
  608358
  619398
  619399
  640687
  662137
  665108
  665116
  668176
  678791
  681215
  790884
]
2.10 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "grandpa mature"
]
1.86 ms
(0.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "grandpa mature"
]

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.