Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
62.25 ms
(57.90%)
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
  401047
  417045
  419404
  424523
  428603
  451875
  465483
  467642
  486481
  525962
  526405
  529411
  529949
  529963
  529976
  530059
  530318
  531907
  534114
  535049
  541588
  541965
  565391
  573113
  573420
  575121
  575792
  575804
  576360
  582227
  583240
  597152
  597432
  600061
  601101
  602944
  610011
  651572
  652786
  659025
  669192
  694028
  714573
  732771
  740758
  761161
  824624
]
27.45 ms
(25.53%)
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:
[
  "interracial amateur porn"
  "interracial amateur porn"
  "interracial amateur porn"
  20
]
8.14 ms
(7.57%)
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
  824624
  530318
  529976
  652786
  761161
  669192
  714573
  401047
  732771
  529963
  419404
  573420
  740758
  529411
  534114
  541965
  530059
  465483
  575804
  576360
  575792
  651572
  531907
  597152
  602944
  610011
  597432
  694028
  428603
  486481
  573113
  575121
  525962
  451875
  526405
  467642
  583240
  565391
  535049
  424523
  417045
  600061
  659025
  582227
  529949
  601101
  541588
]
2.45 ms
(2.28%)
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
  401047
  417045
  419404
  424523
  428603
  451875
  465483
  467642
  486481
  525962
  526405
  529411
  529949
  529963
  529976
  530059
  530318
  531907
  534114
  535049
  541588
  541965
  565391
  573113
  573420
  575121
  575792
  575804
  576360
  582227
  583240
  597152
  597432
  600061
  601101
  602944
  610011
  651572
  652786
  659025
  669192
  694028
  714573
  732771
  740758
  761161
  824624
]
2.08 ms
(1.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "interracial amateur porn"
]
1.77 ms
(1.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "межрасов любительск porn"
]
1.68 ms
(1.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "межрасов любительск porn"
]

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.