Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.03 ms
(44.48%)
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:
[
  "business anal"
  "business anal"
  "business anal"
  20
]
68.88 ms
(43.75%)
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
  395710
  401989
  404787
  410651
  452582
  464240
  465354
  467146
  467604
  468108
  469096
  469115
  475055
  476138
  485073
  504781
  511830
  515602
  515909
  523064
  531221
  533964
  555136
  563552
  566651
  590613
  595837
  617350
  628171
  636750
  643004
  691619
  707145
  708476
  730386
  751615
  753769
  781607
  789709
  798908
  802028
  814760
  818391
]
8.38 ms
(5.32%)
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
  628171
  395710
  617350
  753769
  691619
  818391
  707145
  781607
  798908
  410651
  802028
  469115
  467146
  475055
  515909
  708476
  789709
  523064
  469096
  751615
  401989
  485073
  464240
  533964
  590613
  531221
  476138
  595837
  563552
  468108
  636750
  504781
  814760
  730386
  555136
  643004
  452582
  515602
  465354
  467604
  511830
  566651
  404787
]
2.89 ms
(1.84%)
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
  395710
  401989
  404787
  410651
  452582
  464240
  465354
  467146
  467604
  468108
  469096
  469115
  475055
  476138
  485073
  504781
  511830
  515602
  515909
  523064
  531221
  533964
  555136
  563552
  566651
  590613
  595837
  617350
  628171
  636750
  643004
  691619
  707145
  708476
  730386
  751615
  753769
  781607
  789709
  798908
  802028
  814760
  818391
]
1.99 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "business anal"
]
1.95 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "business анал"
]
1.51 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "business анал"
]

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.