Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
104.80 ms
(48.42%)
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
  457383
  460624
  472299
  488573
  512793
  512816
  512818
  521563
  521569
  534751
  543144
  543184
  543243
  543247
  543433
  543527
  543777
  548532
  556927
  556938
  556940
  565921
  565933
  566563
  574989
  585106
  585107
  586457
  586498
  586499
  586511
  586512
  586528
  591438
  591597
  595323
  602293
  604419
  606820
  617116
  622930
  622931
  623642
  623650
  633423
  650681
  687552
  687572
  687610
  714048
  789714
]
94.88 ms
(43.83%)
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:
[
  "sex mom hijab"
  "sex mom hijab"
  "sex mom hijab"
  20
]
7.52 ms
(3.48%)
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
  789714
  586499
  585106
  585107
  556940
  586457
  586512
  512816
  586498
  586511
  521569
  556938
  543144
  617116
  586528
  574989
  622930
  687552
  591597
  687572
  534751
  714048
  650681
  687610
  512793
  622931
  623650
  595323
  556927
  623642
  460624
  543247
  543184
  488573
  548532
  543243
  565921
  457383
  543433
  602293
  566563
  521563
  512818
  606820
  472299
  543527
  565933
  543777
  604419
  633423
  591438
]
2.31 ms
(1.07%)
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
  457383
  460624
  472299
  488573
  512793
  512816
  512818
  521563
  521569
  534751
  543144
  543184
  543243
  543247
  543433
  543527
  543777
  548532
  556927
  556938
  556940
  565921
  565933
  566563
  574989
  585106
  585107
  586457
  586498
  586499
  586511
  586512
  586528
  591438
  591597
  595323
  602293
  604419
  606820
  617116
  622930
  622931
  623642
  623650
  633423
  650681
  687552
  687572
  687610
  714048
  789714
]
1.83 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex mom hijab"
]
1.74 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс mom hijab"
]
1.73 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс mom hijab"
]
1.64 ms
(0.76%)
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.