Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
55.07 ms
(66.94%)
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
  437476
  437875
  440835
  463295
  466046
  469649
  475091
  480553
  484249
  490987
  502122
  507582
  519242
  525187
  539493
  553076
  573315
  583607
  584841
  603035
  604070
  605412
  609584
  615689
  617004
  621239
  626978
  652278
  679822
  681895
  706634
  720515
  756388
  757070
  770928
  788453
  788602
  788699
  791713
  793593
  799811
  802018
  809647
  809932
]
9.58 ms
(11.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:
[
  "соня тату"
  "соня тату"
  "соня тату"
  20
]
8.06 ms
(9.80%)
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
  788453
  706634
  584841
  652278
  440835
  799811
  791713
  757070
  539493
  720515
  802018
  604070
  609584
  756388
  793593
  490987
  525187
  463295
  615689
  502122
  507582
  681895
  583607
  605412
  788699
  788602
  770928
  437875
  437476
  475091
  553076
  679822
  809932
  809647
  480553
  466046
  603035
  519242
  573315
  484249
  621239
  626978
  469649
  617004
]
2.53 ms
(3.07%)
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
  437476
  437875
  440835
  463295
  466046
  469649
  475091
  480553
  484249
  490987
  502122
  507582
  519242
  525187
  539493
  553076
  573315
  583607
  584841
  603035
  604070
  605412
  609584
  615689
  617004
  621239
  626978
  652278
  679822
  681895
  706634
  720515
  756388
  757070
  770928
  788453
  788602
  788699
  791713
  793593
  799811
  802018
  809647
  809932
]
2.19 ms
(2.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соня тату"
]
1.74 ms
(2.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(2.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сон татуированные"
]
1.41 ms
(1.71%)
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.