Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
66.37 ms
(61.26%)
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
  419633
  420804
  420858
  421759
  424770
  430366
  434306
  434336
  437926
  439345
  471110
  473038
  482916
  495170
  497690
  515545
  519563
  522148
  530494
  532152
  532442
  561905
  564641
  573795
  584322
  585826
  595871
  596621
  598504
  599091
  602268
  605850
  621161
  621653
  640732
  672992
  677854
  708551
  740503
  742224
  757586
  770382
  788800
  791303
  793022
  812039
  821602
]
21.38 ms
(19.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:
[
  "dildo skinny cute"
  "dildo skinny cute"
  "dildo skinny cute"
  20
]
11.59 ms
(10.70%)
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
  740503
  473038
  821602
  812039
  471110
  437926
  599091
  793022
  742224
  439345
  420858
  621161
  791303
  532442
  788800
  434306
  561905
  421759
  584322
  621653
  757586
  430366
  522148
  672992
  605850
  564641
  596621
  495170
  419633
  677854
  598504
  434336
  770382
  708551
  420804
  595871
  424770
  602268
  585826
  573795
  497690
  640732
  482916
  530494
  532152
  519563
  515545
]
2.92 ms
(2.69%)
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
  419633
  420804
  420858
  421759
  424770
  430366
  434306
  434336
  437926
  439345
  471110
  473038
  482916
  495170
  497690
  515545
  519563
  522148
  530494
  532152
  532442
  561905
  564641
  573795
  584322
  585826
  595871
  596621
  598504
  599091
  602268
  605850
  621161
  621653
  640732
  672992
  677854
  708551
  740503
  742224
  757586
  770382
  788800
  791303
  793022
  812039
  821602
]
1.81 ms
(1.67%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo skinny cute"
]
1.35 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд худые cute"
]
1.24 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд худые cute"
]

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.