Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
96.73 ms
(79.76%)
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
  397863
  415596
  453732
  467323
  483431
  498457
  506704
  511876
  517603
  519375
  523400
  523855
  531605
  532986
  534612
  542345
  547462
  547471
  547539
  559939
  564327
  568707
  574380
  584034
  584195
  585687
  586914
  588416
  592489
  594810
  594947
  601281
  601636
  622777
  623178
  632294
  635858
  644268
  651154
  668645
  681074
  681075
  681122
  700492
  706438
  715068
  736113
  744277
  745926
  766779
  788926
  803148
  807863
]
8.77 ms
(7.23%)
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
  506704
  736113
  681075
  523400
  700492
  766779
  547471
  531605
  715068
  584034
  584195
  744277
  635858
  807863
  415596
  511876
  681074
  574380
  397863
  467323
  594947
  681122
  547539
  769921
  547462
  585687
  534612
  668645
  788926
  651154
  588416
  586914
  601636
  519375
  568707
  542345
  601281
  803148
  745926
  632294
  706438
  594810
  483431
  498457
  532986
  623178
  644268
  453732
  592489
  622777
  523855
  559939
  517603
  564327
]
5.03 ms
(4.15%)
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:
[
  "куча мамк"
  "куча мамк"
  "куча мамк"
  20
]
2.90 ms
(2.39%)
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
  397863
  415596
  453732
  467323
  483431
  498457
  506704
  511876
  517603
  519375
  523400
  523855
  531605
  532986
  534612
  542345
  547462
  547471
  547539
  559939
  564327
  568707
  574380
  584034
  584195
  585687
  586914
  588416
  592489
  594810
  594947
  601281
  601636
  622777
  623178
  632294
  635858
  644268
  651154
  668645
  681074
  681075
  681122
  700492
  706438
  715068
  736113
  744277
  745926
  766779
  788926
  803148
  807863
]
2.08 ms
(1.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.01 ms
(1.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куча мамк"
]
1.90 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куч мам женщин"
]
1.85 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.