Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.58 ms
(58.67%)
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
  416208
  443138
  455147
  457963
  464594
  467981
  468965
  475272
  478981
  480861
  483709
  485147
  490025
  493361
  494081
  500562
  510445
  510913
  512927
  515861
  519701
  520077
  520778
  522663
  523013
  523154
  524690
  524867
  525727
  526368
  527222
  528041
  530377
  543772
  556044
  557207
  558132
  560924
  564327
  565281
  566243
  578397
  580222
  581816
  585725
  587651
  588244
  602407
  603694
  616205
  616787
  619747
  625436
  644849
  647893
]
24.67 ms
(20.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:
[
  "fuck mother game"
  "fuck mother game"
  "fuck mother game"
  20
]
15.04 ms
(12.33%)
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
  580222
  560924
  581816
  515861
  585725
  467981
  524867
  443138
  475272
  619747
  510445
  519701
  625436
  524690
  566243
  526368
  512927
  416208
  556044
  480861
  558132
  602407
  510913
  522663
  523013
  493361
  520077
  616787
  525727
  483709
  543772
  490025
  485147
  557207
  644849
  528041
  457963
  520778
  616205
  578397
  523154
  468965
  588244
  565281
  527222
  478981
  564327
  647893
  530377
  587651
  603694
  455147
  464594
  494081
  500562
]
2.31 ms
(1.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс мам женщин игр"
]
2.30 ms
(1.89%)
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
  416208
  443138
  455147
  457963
  464594
  467981
  468965
  475272
  478981
  480861
  483709
  485147
  490025
  493361
  494081
  500562
  510445
  510913
  512927
  515861
  519701
  520077
  520778
  522663
  523013
  523154
  524690
  524867
  525727
  526368
  527222
  528041
  530377
  543772
  556044
  557207
  558132
  560924
  564327
  565281
  566243
  578397
  580222
  581816
  585725
  587651
  588244
  602407
  603694
  616205
  616787
  619747
  625436
  644849
  647893
]
2.21 ms
(1.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck mother game"
]
2.08 ms
(1.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс мам женщин игр"
]
1.81 ms
(1.48%)
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.