Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
67.70 ms
(54.32%)
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
  429797
  475625
  512050
  514147
  523205
  526003
  526475
  543659
  544368
  544840
  545409
  545418
  551947
  553054
  570736
  572382
  572575
  584647
  598871
  599835
  599856
  600290
  625417
  659437
  663976
  667904
  675729
  686047
  706909
  710626
  712684
  716613
  721551
  721685
  728730
  730893
  753954
  778531
  787922
  789874
  790884
  794990
  799980
  802417
  803244
  804113
  805159
  807536
]
31.36 ms
(25.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:
[
  "старый мужик грубо"
  "старый мужик грубо"
  "старый мужик грубо"
  20
]
15.94 ms
(12.79%)
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
  804113
  675729
  572575
  802417
  572382
  794990
  721685
  787922
  807536
  790884
  584647
  710626
  799980
  789874
  721551
  544368
  551947
  805159
  753954
  728730
  778531
  803244
  475625
  514147
  667904
  716613
  512050
  706909
  712684
  686047
  659437
  598871
  730893
  526475
  663976
  429797
  570736
  625417
  600290
  599856
  526003
  523205
  553054
  544840
  543659
  545409
  599835
  545418
]
2.29 ms
(1.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старый мужчин груб"
]
2.00 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "старый мужик грубо"
]
1.99 ms
(1.60%)
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
  429797
  475625
  512050
  514147
  523205
  526003
  526475
  543659
  544368
  544840
  545409
  545418
  551947
  553054
  570736
  572382
  572575
  584647
  598871
  599835
  599856
  600290
  625417
  659437
  663976
  667904
  675729
  686047
  706909
  710626
  712684
  716613
  721551
  721685
  728730
  730893
  753954
  778531
  787922
  789874
  790884
  794990
  799980
  802417
  803244
  804113
  805159
  807536
]
1.86 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "старый мужчин груб"
]
1.49 ms
(1.20%)
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.