Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.78 ms
(69.74%)
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
  383281
  397204
  416931
  423267
  455834
  457395
  470513
  475969
  477347
  477764
  484821
  491357
  494740
  499990
  505888
  506344
  517650
  522582
  524274
  525941
  526884
  529322
  529833
  543179
  543647
  543786
  555917
  556970
  558390
  563380
  565974
  590633
  592636
  597216
  599591
  603986
  624504
  700864
  701325
  714558
  729951
  738636
  753696
  802927
]
9.77 ms
(11.22%)
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:
[
  "woman domina"
  "woman domina"
  "woman domina"
  20
]
7.57 ms
(8.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
  729951
  802927
  599591
  592636
  397204
  563380
  543647
  506344
  475969
  494740
  558390
  714558
  753696
  700864
  416931
  477764
  491357
  624504
  455834
  522582
  543786
  457395
  383281
  555917
  701325
  738636
  470513
  529322
  529833
  543179
  477347
  524274
  565974
  603986
  517650
  556970
  423267
  505888
  499990
  597216
  526884
  484821
  590633
  525941
]
2.44 ms
(2.80%)
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
  383281
  397204
  416931
  423267
  455834
  457395
  470513
  475969
  477347
  477764
  484821
  491357
  494740
  499990
  505888
  506344
  517650
  522582
  524274
  525941
  526884
  529322
  529833
  543179
  543647
  543786
  555917
  556970
  558390
  563380
  565974
  590633
  592636
  597216
  599591
  603986
  624504
  700864
  701325
  714558
  729951
  738636
  753696
  802927
]
2.05 ms
(2.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "woman domina"
]
1.62 ms
(1.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "woman доминирован"
]
1.56 ms
(1.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "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.