Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
64.40 ms
(45.73%)
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:
[
  "ass latin sex"
  "ass latin sex"
  "ass latin sex"
  20
]
59.16 ms
(42.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
  392538
  395685
  401114
  416029
  420530
  420541
  423332
  432647
  443218
  445387
  448829
  449372
  453938
  454208
  454924
  472781
  473871
  474989
  476578
  481364
  497678
  500758
  503299
  507880
  511777
  514565
  515786
  516020
  525236
  528399
  528710
  543013
  552139
  564737
  564741
  566140
  580765
  588644
  596659
  624502
  625444
  636007
  654914
  679653
  804442
]
9.22 ms
(6.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
  679653
  804442
  528399
  423332
  392538
  454208
  511777
  497678
  516020
  552139
  654914
  432647
  445387
  453938
  566140
  515786
  476578
  401114
  543013
  525236
  636007
  416029
  474989
  395685
  503299
  472781
  588644
  420530
  528710
  580765
  564741
  564737
  625444
  449372
  454924
  500758
  624502
  481364
  514565
  443218
  596659
  448829
  507880
  420541
  473871
]
1.92 ms
(1.36%)
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
  392538
  395685
  401114
  416029
  420530
  420541
  423332
  432647
  443218
  445387
  448829
  449372
  453938
  454208
  454924
  472781
  473871
  474989
  476578
  481364
  497678
  500758
  503299
  507880
  511777
  514565
  515786
  516020
  525236
  528399
  528710
  543013
  552139
  564737
  564741
  566140
  580765
  588644
  596659
  624502
  625444
  636007
  654914
  679653
  804442
]
1.86 ms
(1.32%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп latin секс"
]
1.56 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass latin sex"
]
1.44 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп latin секс"
]
1.28 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.