Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
94.32 ms
(71.57%)
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
  425168
  427174
  435449
  457162
  468035
  471165
  512447
  512512
  527915
  530369
  530492
  532666
  532738
  533370
  534021
  534645
  536633
  536653
  537199
  541635
  542192
  542549
  542864
  545437
  545480
  545604
  598105
  614029
  617418
  617420
  617422
  630536
  630635
  632635
  634208
  634818
  635171
  637001
  637148
  638967
  640739
  641950
  647355
  674983
  676016
  679019
  702163
]
17.71 ms
(13.44%)
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:
[
  "double dildo deepthroat"
  "double dildo deepthroat"
  "double dildo deepthroat"
  20
]
10.11 ms
(7.67%)
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
  532738
  537199
  545604
  640739
  632635
  457162
  468035
  425168
  512512
  614029
  541635
  530369
  532666
  702163
  534021
  674983
  637001
  598105
  427174
  542549
  542864
  630635
  635171
  617422
  527915
  641950
  617418
  634818
  634208
  638967
  545437
  637148
  530492
  542192
  630536
  534645
  435449
  536653
  533370
  471165
  647355
  536633
  512447
  676016
  545480
  679019
  617420
]
2.20 ms
(1.67%)
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
  425168
  427174
  435449
  457162
  468035
  471165
  512447
  512512
  527915
  530369
  530492
  532666
  532738
  533370
  534021
  534645
  536633
  536653
  537199
  541635
  542192
  542549
  542864
  545437
  545480
  545604
  598105
  614029
  617418
  617420
  617422
  630536
  630635
  632635
  634208
  634818
  635171
  637001
  637148
  638967
  640739
  641950
  647355
  674983
  676016
  679019
  702163
]
2.09 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "double дилд глубокийминет минет оральн секс"
]
2.05 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "double dildo deepthroat"
]
1.85 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "double дилд глубокийминет минет оральн секс"
]
1.45 ms
(1.10%)
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.