Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
53.20 ms
(66.99%)
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
  385745
  452244
  452245
  468377
  473958
  481142
  488724
  531298
  532749
  533018
  534150
  537189
  588298
  591742
  600003
  604546
  612399
  630552
  632269
  632563
  632703
  634185
  637087
  639710
  639716
  639729
  641700
  645993
  646428
  650316
  651051
  674943
  679801
  701488
  703836
  716902
  720178
  748968
  769488
  809395
  811680
  817229
  817264
  820768
]
10.72 ms
(13.50%)
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
  537189
  769488
  531298
  532749
  591742
  809395
  748968
  533018
  637087
  385745
  534150
  651051
  632703
  703836
  588298
  634185
  811680
  645993
  716902
  641700
  612399
  600003
  632269
  720178
  650316
  674943
  817229
  817264
  701488
  632563
  604546
  820768
  468377
  646428
  473958
  639710
  452245
  452244
  639729
  488724
  481142
  639716
  679801
  630552
]
4.90 ms
(6.16%)
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:
[
  "daniela"
  "daniela"
  "daniela"
  20
]
2.46 ms
(3.10%)
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
  385745
  452244
  452245
  468377
  473958
  481142
  488724
  531298
  532749
  533018
  534150
  537189
  588298
  591742
  600003
  604546
  612399
  630552
  632269
  632563
  632703
  634185
  637087
  639710
  639716
  639729
  641700
  645993
  646428
  650316
  651051
  674943
  679801
  701488
  703836
  716902
  720178
  748968
  769488
  809395
  811680
  817229
  817264
  820768
]
2.22 ms
(2.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "daniela"
]
2.17 ms
(2.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.07 ms
(2.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "daniela"
]
1.68 ms
(2.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "daniela"
]

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.