Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.79 ms
(50.39%)
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
  417366
  472299
  491579
  495364
  529848
  547538
  570145
  621548
  669251
  717469
  724057
  731234
  731261
  731328
  731346
  731354
  734800
  734805
  736198
  736199
  736204
  736208
  736250
  736257
  736695
  736921
  738127
  738147
  740274
  740673
  740678
  740721
  740726
  740773
  748044
  761568
  762758
  762764
  762779
  762809
  771163
  771301
  788550
  794752
  794807
  795469
  800613
  810387
  814502
  816670
  816679
]
108.09 ms
(43.30%)
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:
[
  "desi girl anal"
  "desi girl anal"
  "desi girl anal"
  20
]
6.15 ms
(2.46%)
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
  740274
  731328
  731234
  731261
  731354
  761568
  731346
  736199
  800613
  738127
  810387
  762779
  762758
  816679
  724057
  814502
  734805
  736921
  740678
  736695
  740726
  762809
  717469
  736208
  762764
  740773
  491579
  788550
  736250
  794752
  738147
  740673
  529848
  417366
  736198
  736204
  495364
  771301
  795469
  734800
  740721
  748044
  794807
  547538
  771163
  736257
  621548
  816670
  570145
  669251
  472299
]
3.11 ms
(1.25%)
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
  417366
  472299
  491579
  495364
  529848
  547538
  570145
  621548
  669251
  717469
  724057
  731234
  731261
  731328
  731346
  731354
  734800
  734805
  736198
  736199
  736204
  736208
  736250
  736257
  736695
  736921
  738127
  738147
  740274
  740673
  740678
  740721
  740726
  740773
  748044
  761568
  762758
  762764
  762779
  762809
  771163
  771301
  788550
  794752
  794807
  795469
  800613
  810387
  814502
  816670
  816679
]
1.70 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "desi девушк анал"
]
1.70 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "desi девушк анал"
]
1.59 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "desi girl anal"
]
1.50 ms
(0.60%)
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.