Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.78 ms
(69.29%)
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
  404922
  419872
  443246
  443487
  452097
  453508
  453840
  455335
  461784
  466100
  467508
  467532
  471848
  472555
  474272
  483543
  490559
  493310
  502748
  505986
  510053
  511250
  514819
  516870
  517965
  518384
  520356
  521448
  522540
  523948
  526043
  526911
  528273
  543198
  551213
  552941
  553061
  562815
  564078
  565390
  573800
  574927
  578300
  590102
  591402
  600978
  603964
  609419
  617026
  621445
  621962
  628282
  662445
]
11.51 ms
(14.05%)
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
  551213
  574927
  609419
  455335
  461784
  467532
  474272
  466100
  472555
  510053
  502748
  505986
  490559
  516870
  528273
  522540
  526043
  565390
  552941
  562815
  564078
  600978
  617026
  590102
  453508
  404922
  520356
  523948
  493310
  517965
  518384
  553061
  621962
  591402
  443246
  443487
  471848
  511250
  521448
  453840
  526911
  621445
  452097
  578300
  628282
  419872
  467508
  483543
  514819
  573800
  543198
  603964
  662445
]
4.26 ms
(5.20%)
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:
[
  "place"
  "place"
  "place"
  20
]
2.66 ms
(3.24%)
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
  404922
  419872
  443246
  443487
  452097
  453508
  453840
  455335
  461784
  466100
  467508
  467532
  471848
  472555
  474272
  483543
  490559
  493310
  502748
  505986
  510053
  511250
  514819
  516870
  517965
  518384
  520356
  521448
  522540
  523948
  526043
  526911
  528273
  543198
  551213
  552941
  553061
  562815
  564078
  565390
  573800
  574927
  578300
  590102
  591402
  600978
  603964
  609419
  617026
  621445
  621962
  628282
  662445
]
2.19 ms
(2.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "place"
]
1.71 ms
(2.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "place"
]
1.29 ms
(1.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "place"
]

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.