Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
54.69 ms
(54.70%)
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
  431759
  445200
  457226
  487472
  491702
  491725
  493015
  496585
  497834
  499183
  505922
  506232
  507668
  517833
  520823
  521141
  521495
  524180
  525884
  526101
  527620
  544202
  548680
  560438
  560760
  567408
  573056
  573597
  574520
  574527
  574867
  575065
  575069
  575109
  575117
  575144
  575214
  575764
  575779
  576041
  576051
  591219
  594838
  620754
  650915
  700733
]
24.56 ms
(24.57%)
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:
[
  "public home porn"
  "public home porn"
  "public home porn"
  20
]
10.72 ms
(10.72%)
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
  575214
  650915
  700733
  548680
  524180
  505922
  573056
  575764
  567408
  591219
  457226
  507668
  527620
  560438
  560760
  574867
  575065
  575779
  491725
  575069
  575109
  576051
  573597
  491702
  575117
  576041
  520823
  526101
  493015
  496585
  521141
  574520
  517833
  499183
  487472
  544202
  497834
  506232
  431759
  525884
  594838
  445200
  521495
  575144
  574527
  620754
]
2.62 ms
(2.62%)
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
  431759
  445200
  457226
  487472
  491702
  491725
  493015
  496585
  497834
  499183
  505922
  506232
  507668
  517833
  520823
  521141
  521495
  524180
  525884
  526101
  527620
  544202
  548680
  560438
  560760
  567408
  573056
  573597
  574520
  574527
  574867
  575065
  575069
  575109
  575117
  575144
  575214
  575764
  575779
  576041
  576051
  591219
  594838
  620754
  650915
  700733
]
2.09 ms
(2.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public home porn"
]
1.86 ms
(1.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на home улиц porn"
]
1.63 ms
(1.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на home улиц porn"
]

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.