Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
318.31 ms
(68.64%)
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:
[
  "milf pissing anal"
  "milf pissing anal"
  "milf pissing anal"
  20
]
125.30 ms
(27.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
  541854
  545480
  555317
  581929
  599940
  599987
  600021
  600252
  600257
  600268
  600360
  601578
  619204
  623178
  628332
  630531
  630552
  632585
  633435
  633502
  634140
  635275
  637413
  639060
  639719
  639741
  639751
  639767
  639774
  641953
  641978
  642006
  642705
  642774
  646176
  647860
  647893
  647948
  666850
  666906
  674983
  675008
  675010
  675017
  676428
  678095
  683054
]
9.48 ms
(2.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
  632585
  555317
  619204
  628332
  641953
  600360
  639767
  600257
  630552
  639060
  541854
  666906
  646176
  674983
  642705
  678095
  675017
  600021
  647860
  666850
  639741
  623178
  647948
  675010
  676428
  600252
  634140
  639719
  601578
  639774
  642006
  600268
  675008
  642774
  630531
  633435
  633502
  639751
  647893
  637413
  581929
  545480
  635275
  641978
  683054
  599940
  599987
]
2.54 ms
(0.55%)
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
  541854
  545480
  555317
  581929
  599940
  599987
  600021
  600252
  600257
  600268
  600360
  601578
  619204
  623178
  628332
  630531
  630552
  632585
  633435
  633502
  634140
  635275
  637413
  639060
  639719
  639741
  639751
  639767
  639774
  641953
  641978
  642006
  642705
  642774
  646176
  647860
  647893
  647948
  666850
  666906
  674983
  675008
  675010
  675017
  676428
  678095
  683054
]
2.34 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf pissing anal"
]
2.17 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(0.44%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf pissing анал"
]
1.52 ms
(0.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf pissing анал"
]

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.