Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
106.65 ms
(76.10%)
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
  420565
  423913
  432650
  439710
  440657
  442533
  448561
  459485
  463185
  464702
  467758
  469651
  476015
  476264
  482945
  483424
  487472
  488550
  488571
  488867
  492567
  493017
  493191
  496566
  497062
  504183
  504186
  506794
  507703
  511033
  512086
  516819
  517261
  517769
  521502
  521507
  523465
  524174
  524833
  527391
  528144
  553591
  554234
  555973
  555995
  556470
  557226
  557941
  568096
  596978
  602716
  605559
  615817
  621887
  625127
  649211
  756735
  768570
  783215
  806247
  812675
]
13.90 ms
(9.92%)
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:
[
  "home hidden"
  "home hidden"
  "home hidden"
  20
]
10.58 ms
(7.55%)
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
  553591
  568096
  596978
  812675
  420565
  463185
  469651
  467758
  476264
  527391
  482945
  523465
  768570
  440657
  492567
  448561
  497062
  488550
  555973
  554234
  555995
  649211
  625127
  806247
  524833
  483424
  493191
  493017
  488571
  517261
  439710
  512086
  516819
  488867
  506794
  621887
  783215
  521502
  557226
  557941
  476015
  504186
  504183
  487472
  507703
  464702
  521507
  496566
  756735
  423913
  442533
  524174
  605559
  615817
  517769
  432650
  459485
  528144
  602716
  511033
  556470
]
2.30 ms
(1.64%)
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
  420565
  423913
  432650
  439710
  440657
  442533
  448561
  459485
  463185
  464702
  467758
  469651
  476015
  476264
  482945
  483424
  487472
  488550
  488571
  488867
  492567
  493017
  493191
  496566
  497062
  504183
  504186
  506794
  507703
  511033
  512086
  516819
  517261
  517769
  521502
  521507
  523465
  524174
  524833
  527391
  528144
  553591
  554234
  555973
  555995
  556470
  557226
  557941
  568096
  596978
  602716
  605559
  615817
  621887
  625127
  649211
  756735
  768570
  783215
  806247
  812675
]
1.81 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "home скрыт"
]
1.80 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "home hidden"
]
1.63 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "home скрыт"
]
1.46 ms
(1.05%)
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.