Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
58.46 ms
(72.54%)
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
  14534
  256218
  382820
  384862
  418101
  428860
  442831
  447886
  447890
  455373
  458688
  459381
  462038
  462337
  467365
  468741
  469432
  471077
  471879
  483436
  484816
  490086
  491955
  502808
  509948
  511607
  513655
  514393
  515275
  516656
  521941
  522874
  525337
  552899
  555786
  556004
  558464
  565481
  572053
  578081
  618476
  630177
  636811
  699627
  715869
  724275
  741294
]
8.52 ms
(10.57%)
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
  447886
  471077
  509948
  515275
  467365
  558464
  552899
  428860
  471879
  384862
  455373
  458688
  256218
  462038
  521941
  484816
  514393
  382820
  418101
  468741
  556004
  699627
  715869
  578081
  636811
  741294
  724275
  516656
  490086
  483436
  442831
  462337
  555786
  14534
  459381
  469432
  511607
  513655
  618476
  522874
  565481
  447890
  502808
  572053
  630177
  525337
  491955
]
4.95 ms
(6.14%)
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:
[
  "beautiful cunt"
  "beautiful cunt"
  "beautiful cunt"
  20
]
2.45 ms
(3.04%)
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
  14534
  256218
  382820
  384862
  418101
  428860
  442831
  447886
  447890
  455373
  458688
  459381
  462038
  462337
  467365
  468741
  469432
  471077
  471879
  483436
  484816
  490086
  491955
  502808
  509948
  511607
  513655
  514393
  515275
  516656
  521941
  522874
  525337
  552899
  555786
  556004
  558464
  565481
  572053
  578081
  618476
  630177
  636811
  699627
  715869
  724275
  741294
]
1.74 ms
(2.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful cunt"
]
1.50 ms
(1.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая cunt"
]
1.50 ms
(1.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая cunt"
]
1.48 ms
(1.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.