Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
51.49 ms
(50.59%)
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
  388110
  428823
  465902
  469366
  531408
  539945
  570853
  571695
  575552
  583839
  585476
  586189
  596851
  600798
  602197
  603656
  616217
  724990
  730710
  740479
  751017
  759555
  760178
  760637
  761823
  767986
  770158
  772574
  776780
  776868
  795655
  796841
  799058
  800653
  800677
  800680
  810480
  810506
  811069
  811104
  811109
  811110
  811111
]
31.46 ms
(30.90%)
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:
[
  "mom nylon"
  "mom nylon"
  "mom nylon"
  20
]
7.73 ms
(7.59%)
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
  776780
  796841
  810506
  800653
  811111
  811104
  810480
  571695
  795655
  800680
  776868
  811109
  811069
  570853
  616217
  799058
  724990
  759555
  730710
  760637
  767986
  469366
  761823
  811110
  428823
  603656
  760178
  772574
  751017
  770158
  583839
  602197
  800677
  740479
  575552
  600798
  585476
  388110
  539945
  586189
  465902
  531408
  596851
]
2.57 ms
(2.52%)
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
  388110
  428823
  465902
  469366
  531408
  539945
  570853
  571695
  575552
  583839
  585476
  586189
  596851
  600798
  602197
  603656
  616217
  724990
  730710
  740479
  751017
  759555
  760178
  760637
  761823
  767986
  770158
  772574
  776780
  776868
  795655
  796841
  799058
  800653
  800677
  800680
  810480
  810506
  811069
  811104
  811109
  811110
  811111
]
2.54 ms
(2.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom nylon"
]
2.04 ms
(2.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom nylon"
]
1.97 ms
(1.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom nylon"
]

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.