Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
83.15 ms
(71.66%)
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
  409667
  418068
  426843
  435917
  440990
  450441
  455645
  466376
  481279
  487648
  489812
  503511
  507512
  508425
  510877
  520044
  523809
  523822
  524587
  531136
  531155
  531251
  532995
  533726
  533738
  534021
  535808
  537114
  540437
  545851
  552458
  555681
  561296
  562754
  564980
  565541
  574095
  579754
  586528
  589290
  637001
  640793
  642407
  675588
  703833
  708045
  780215
]
13.72 ms
(11.82%)
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
  555681
  586528
  552458
  533738
  545851
  561296
  703833
  418068
  440990
  508425
  435917
  589290
  503511
  574095
  780215
  507512
  675588
  708045
  532995
  531251
  535808
  640793
  455645
  426843
  531136
  537114
  481279
  533726
  409667
  562754
  489812
  534021
  637001
  564980
  579754
  540437
  520044
  531155
  524587
  466376
  510877
  565541
  450441
  642407
  523809
  523822
  487648
]
8.63 ms
(7.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:
[
  "cumshot in deepthroat"
  "cumshot in deepthroat"
  "cumshot in deepthroat"
  20
]
2.57 ms
(2.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cumshot in deepthroat"
]
2.27 ms
(1.96%)
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
  409667
  418068
  426843
  435917
  440990
  450441
  455645
  466376
  481279
  487648
  489812
  503511
  507512
  508425
  510877
  520044
  523809
  523822
  524587
  531136
  531155
  531251
  532995
  533726
  533738
  534021
  535808
  537114
  540437
  545851
  552458
  555681
  561296
  562754
  564980
  565541
  574095
  579754
  586528
  589290
  637001
  640793
  642407
  675588
  703833
  708045
  780215
]
2.01 ms
(1.73%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cumshot глубокийминет минет оральн секс"
]
2.00 ms
(1.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cumshot глубокийминет минет оральн секс"
]

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.