Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
94.98 ms
(71.13%)
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
  419631
  420358
  421678
  428280
  432929
  434371
  434374
  435794
  436186
  436230
  444069
  445455
  448773
  450722
  450977
  456518
  465054
  468012
  476514
  480848
  480861
  482940
  488734
  491299
  506269
  513817
  514248
  515358
  517464
  521544
  524324
  524690
  539319
  545648
  547241
  569020
  583021
  616315
  639796
  639810
  649619
  666871
  668690
  674959
  676634
  686821
  694958
  757431
  763398
  771993
  786444
  797842
  799666
  799667
  806580
  806591
]
18.41 ms
(13.78%)
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:
[
  "cosplay dildo masturbation"
  "cosplay dildo masturbation"
  "cosplay dildo masturbation"
  20
]
10.27 ms
(7.69%)
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
  616315
  806591
  513817
  686821
  668690
  694958
  797842
  799667
  757431
  771993
  445455
  432929
  448773
  806580
  465054
  545648
  649619
  480861
  444069
  419631
  786444
  799666
  450722
  434371
  436186
  435794
  488734
  674959
  436230
  420358
  517464
  428280
  763398
  547241
  506269
  515358
  639810
  491299
  421678
  434374
  476514
  539319
  639796
  524324
  468012
  521544
  450977
  569020
  480848
  482940
  666871
  595376
  514248
  583021
  456518
  676634
  524690
]
2.23 ms
(1.67%)
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
  419631
  420358
  421678
  428280
  432929
  434371
  434374
  435794
  436186
  436230
  444069
  445455
  448773
  450722
  450977
  456518
  465054
  468012
  476514
  480848
  480861
  482940
  488734
  491299
  506269
  513817
  514248
  515358
  517464
  521544
  524324
  524690
  539319
  545648
  547241
  569020
  583021
  616315
  639796
  639810
  649619
  666871
  668690
  674959
  676634
  686821
  694958
  757431
  763398
  771993
  786444
  797842
  799666
  799667
  806580
  806591
]
2.17 ms
(1.62%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "коспл дилд мастурбац"
]
2.04 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cosplay dildo masturbation"
]
1.73 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.27%)
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.