Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
53.07 ms
(60.60%)
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
  305328
  385469
  391302
  397901
  404318
  412618
  417493
  417639
  417930
  438447
  438714
  447013
  447023
  448483
  449901
  450824
  453445
  453538
  455483
  455708
  460379
  464442
  473567
  474473
  477051
  477389
  482163
  496310
  507047
  507117
  508730
  508874
  510586
  513171
  514295
  516310
  517369
  527729
  528855
  532090
  552326
  559659
  566710
  567188
  572645
  583146
  588943
  604101
  605952
  614603
]
16.94 ms
(19.35%)
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
  417930
  572645
  391302
  417639
  385469
  460379
  449901
  448483
  473567
  450824
  527729
  507117
  453538
  455483
  516310
  404318
  588943
  464442
  605952
  447013
  438714
  305328
  532090
  496310
  508730
  513171
  510586
  566710
  559659
  438447
  453445
  482163
  528855
  552326
  397901
  477051
  455708
  508874
  517369
  604101
  447023
  417493
  477389
  507047
  474473
  514295
  583146
  412618
  567188
  614603
]
7.41 ms
(8.46%)
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.52 ms
(2.87%)
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
  305328
  385469
  391302
  397901
  404318
  412618
  417493
  417639
  417930
  438447
  438714
  447013
  447023
  448483
  449901
  450824
  453445
  453538
  455483
  455708
  460379
  464442
  473567
  474473
  477051
  477389
  482163
  496310
  507047
  507117
  508730
  508874
  510586
  513171
  514295
  516310
  517369
  527729
  528855
  532090
  552326
  559659
  566710
  567188
  572645
  583146
  588943
  604101
  605952
  614603
]
2.02 ms
(2.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "возле спящей"
]
1.99 ms
(2.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "возл спящ"
]
1.95 ms
(2.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.90%)
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.