Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.25 ms
(66.22%)
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
  130089
  130126
  233446
  391262
  393067
  393778
  398227
  409725
  410430
  411384
  417212
  420769
  429768
  430081
  431105
  442987
  443752
  443764
  453089
  454261
  454293
  459857
  460731
  467611
  474645
  474696
  475630
  482938
  483826
  484472
  501255
  501611
  511938
  517853
  526528
  531064
  543881
  554392
  557387
  583640
  589146
  591882
  612816
  620779
  750234
  801024
]
14.72 ms
(13.68%)
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:
[
  "мамку по кругу"
  "мамку по кругу"
  "мамку по кругу"
  20
]
11.55 ms
(10.74%)
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
  750234
  130126
  801024
  233446
  130089
  442987
  483826
  612816
  393067
  526528
  393778
  409725
  410430
  411384
  620779
  398227
  501255
  391262
  454261
  589146
  474645
  443752
  453089
  501611
  443764
  482938
  511938
  474696
  583640
  460731
  531064
  454293
  429768
  431105
  484472
  417212
  430081
  459857
  517853
  591882
  420769
  467611
  557387
  475630
  543881
  554392
]
2.67 ms
(2.48%)
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
  130089
  130126
  233446
  391262
  393067
  393778
  398227
  409725
  410430
  411384
  417212
  420769
  429768
  430081
  431105
  442987
  443752
  443764
  453089
  454261
  454293
  459857
  460731
  467611
  474645
  474696
  475630
  482938
  483826
  484472
  501255
  501611
  511938
  517853
  526528
  531064
  543881
  554392
  557387
  583640
  589146
  591882
  612816
  620779
  750234
  801024
]
2.08 ms
(1.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.01 ms
(1.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамку по кругу"
]
1.78 ms
(1.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин круг"
]
1.55 ms
(1.44%)
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.