Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.72 ms
(61.11%)
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
  381941
  408463
  408499
  428388
  451569
  452228
  452282
  455156
  470848
  504423
  505095
  516045
  537606
  542826
  543175
  544706
  544796
  563958
  565355
  565358
  565402
  570159
  575197
  579776
  591591
  592385
  596616
  597216
  604487
  614715
  623292
  632563
  633962
  644798
  645993
  674116
  704114
  716255
  719817
  720015
  732782
  732792
  748365
  771052
  785126
]
19.19 ms
(19.31%)
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:
[
  "bbc woman"
  "bbc woman"
  "bbc woman"
  20
]
9.08 ms
(9.14%)
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
  704114
  408499
  591591
  604487
  537606
  544706
  563958
  674116
  633962
  771052
  505095
  408463
  720015
  785126
  719817
  732792
  543175
  716255
  381941
  544796
  565358
  644798
  732782
  565402
  579776
  592385
  451569
  455156
  470848
  614715
  748365
  428388
  570159
  565355
  623292
  504423
  452228
  452282
  516045
  645993
  596616
  542826
  575197
  597216
  632563
]
2.99 ms
(3.01%)
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
  381941
  408463
  408499
  428388
  451569
  452228
  452282
  455156
  470848
  504423
  505095
  516045
  537606
  542826
  543175
  544706
  544796
  563958
  565355
  565358
  565402
  570159
  575197
  579776
  591591
  592385
  596616
  597216
  604487
  614715
  623292
  632563
  633962
  644798
  645993
  674116
  704114
  716255
  719817
  720015
  732782
  732792
  748365
  771052
  785126
]
2.17 ms
(2.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc woman"
]
1.83 ms
(1.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbc woman"
]
1.59 ms
(1.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbc woman"
]

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.