Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
67.49 ms
(64.62%)
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
  397114
  398849
  416123
  416241
  417258
  434886
  447204
  449349
  468058
  468470
  469622
  473525
  475487
  488551
  489840
  503105
  503122
  513358
  530916
  530962
  542256
  545957
  557238
  557838
  562966
  578740
  606032
  636367
  647132
  659429
  675838
  681538
  687366
  698258
  703019
  703314
  708748
  709217
  718806
  737146
  737310
  740648
  747427
  759036
  761540
  771911
  774663
  776035
  821784
  824032
  824634
  825400
]
17.18 ms
(16.45%)
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:
[
  "pussy leaking"
  "pussy leaking"
  "pussy leaking"
  20
]
9.08 ms
(8.70%)
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
  530916
  434886
  562966
  826427
  740648
  774663
  759036
  398849
  708748
  709217
  718806
  545957
  776035
  824032
  825400
  647132
  557838
  675838
  681538
  687366
  703019
  771911
  397114
  542256
  659429
  698258
  747427
  821784
  530962
  703314
  824634
  578740
  737310
  737146
  489840
  447204
  606032
  761540
  416241
  468470
  557238
  417258
  449349
  473525
  468058
  469622
  416123
  503122
  503105
  636367
  475487
  488551
  513358
]
2.92 ms
(2.79%)
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
  397114
  398849
  416123
  416241
  417258
  434886
  447204
  449349
  468058
  468470
  469622
  473525
  475487
  488551
  489840
  503105
  503122
  513358
  530916
  530962
  542256
  545957
  557238
  557838
  562966
  578740
  606032
  636367
  647132
  659429
  675838
  681538
  687366
  698258
  703019
  703314
  708748
  709217
  718806
  737146
  737310
  740648
  747427
  759036
  761540
  771911
  774663
  776035
  821784
  824032
  824634
  825400
]
2.23 ms
(2.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy leaking"
]
2.09 ms
(2.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy leaking"
]
1.69 ms
(1.62%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy leaking"
]

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.