Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
66.46 ms
(65.87%)
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
  415811
  434789
  436047
  437772
  438851
  444015
  446396
  447253
  451132
  452305
  452563
  452645
  455610
  455974
  456451
  459661
  462863
  464716
  466557
  477772
  485511
  488282
  497179
  500503
  501603
  505795
  519859
  521204
  524408
  525450
  525994
  546226
  551090
  552355
  554812
  586118
  595043
  597208
  621140
]
19.09 ms
(18.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:
[
  "oral creampie homemade"
  "oral creampie homemade"
  "oral creampie homemade"
  20
]
6.74 ms
(6.68%)
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
  452645
  415811
  485511
  497179
  488282
  621140
  546226
  464716
  444015
  437772
  501603
  519859
  524408
  525994
  466557
  552355
  434789
  446396
  455610
  455974
  447253
  452305
  500503
  525450
  595043
  436047
  477772
  452563
  459661
  521204
  551090
  456451
  462863
  554812
  438851
  505795
  451132
  505794
  597208
  586118
]
1.91 ms
(1.90%)
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
  415811
  434789
  436047
  437772
  438851
  444015
  446396
  447253
  451132
  452305
  452563
  452645
  455610
  455974
  456451
  459661
  462863
  464716
  466557
  477772
  485511
  488282
  497179
  500503
  501603
  505795
  519859
  521204
  524408
  525450
  525994
  546226
  551090
  552355
  554812
  586118
  595043
  597208
  621140
]
1.82 ms
(1.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "oral creampie homemade"
]
1.72 ms
(1.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "oral creampie домашн любительск"
]
1.68 ms
(1.67%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "oral creampie домашн любительск"
]

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.