Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
57.24 ms
(56.45%)
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
  406089
  413651
  417015
  434353
  434601
  439625
  439664
  439739
  458718
  459151
  463780
  470539
  475960
  480757
  482308
  486110
  489955
  512554
  513960
  516155
  516727
  519387
  519945
  523636
  524896
  526055
  541751
  546117
  549103
  549693
  555154
  556009
  563068
  563472
  565673
  571308
  574258
  574384
  577437
  593269
  597866
  599353
  609953
  614743
  620216
]
21.20 ms
(20.91%)
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:
[
  "mature stockings kitchen"
  "mature stockings kitchen"
  "mature stockings kitchen"
  20
]
13.55 ms
(13.37%)
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
  459151
  417015
  593269
  486110
  480757
  439664
  513960
  413651
  489955
  519387
  546117
  563068
  571308
  470539
  475960
  439739
  519945
  523636
  574384
  609953
  614743
  512554
  565673
  597866
  406089
  516155
  526055
  549693
  549103
  555154
  577437
  439625
  482308
  620216
  541751
  563472
  463780
  458718
  556009
  434353
  516727
  524896
  599353
  434601
  574258
]
2.46 ms
(2.42%)
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
  406089
  413651
  417015
  434353
  434601
  439625
  439664
  439739
  458718
  459151
  463780
  470539
  475960
  480757
  482308
  486110
  489955
  512554
  513960
  516155
  516727
  519387
  519945
  523636
  524896
  526055
  541751
  546117
  549103
  549693
  555154
  556009
  563068
  563472
  565673
  571308
  574258
  574384
  577437
  593269
  597866
  599353
  609953
  614743
  620216
]
1.95 ms
(1.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature stockings kitchen"
]
1.85 ms
(1.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(1.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature чулк нижн бел кухн"
]
1.57 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature чулк нижн бел кухн"
]

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.