Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
53.02 ms
(72.30%)
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
  407795
  419882
  423940
  428382
  432751
  434712
  436178
  439925
  446815
  447618
  449809
  452491
  470568
  474495
  476261
  510767
  520235
  521438
  532681
  537564
  585961
  587267
  595808
  598511
  601882
  603668
  604702
  622245
  646923
  647052
  666714
  672355
  687163
  708219
  715097
  732925
  759355
  760529
  770146
  776931
]
6.68 ms
(9.11%)
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
  672355
  732925
  760529
  537564
  447618
  532681
  715097
  622245
  595808
  598511
  428382
  603668
  521438
  449809
  474495
  510767
  646923
  647052
  708219
  601882
  776931
  470568
  604702
  666714
  587267
  452491
  432751
  436178
  407795
  423940
  770146
  446815
  585961
  476261
  520235
  687163
  759355
  434712
  419882
  439925
]
4.42 ms
(6.02%)
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:
[
  "swinger pool"
  "swinger pool"
  "swinger pool"
  20
]
2.07 ms
(2.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.06 ms
(2.81%)
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
  407795
  419882
  423940
  428382
  432751
  434712
  436178
  439925
  446815
  447618
  449809
  452491
  470568
  474495
  476261
  510767
  520235
  521438
  532681
  537564
  585961
  587267
  595808
  598511
  601882
  603668
  604702
  622245
  646923
  647052
  666714
  672355
  687163
  708219
  715097
  732925
  759355
  760529
  770146
  776931
]
1.92 ms
(2.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "swinger pool"
]
1.59 ms
(2.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "свингер бассейн"
]
1.58 ms
(2.15%)
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.