Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
79.84 ms
(74.03%)
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
  17180
  33714
  191057
  263752
  383650
  389208
  405806
  414781
  420566
  424502
  426375
  448363
  454667
  454679
  454710
  464424
  478036
  480383
  480397
  515768
  537873
  565467
  591087
  593425
  603344
  606863
  720405
  788815
  790799
  814750
  814753
  814779
  814802
  814832
  814841
  814874
  814879
  814918
  814932
  815270
  815333
  815368
  815388
  815424
  815683
  815695
  815797
  815798
  815895
  815913
  815962
  816209
  816536
  816952
  827848
]
9.90 ms
(9.18%)
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:
[
  "danny d brazzers"
  "danny d brazzers"
  "danny d brazzers"
  20
]
8.16 ms
(7.56%)
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
  814841
  814874
  814918
  720405
  814750
  815895
  603344
  814879
  814802
  405806
  593425
  814932
  814779
  537873
  814753
  790799
  814832
  788815
  191057
  426375
  815368
  515768
  606863
  263752
  815424
  454667
  815913
  815962
  815683
  815797
  17180
  816952
  815333
  816209
  827848
  815798
  815388
  816536
  591087
  33714
  815270
  815695
  414781
  389208
  383650
  480383
  454679
  424502
  478036
  480397
  420566
  454710
  565467
  448363
  464424
]
3.05 ms
(2.83%)
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
  17180
  33714
  191057
  263752
  383650
  389208
  405806
  414781
  420566
  424502
  426375
  448363
  454667
  454679
  454710
  464424
  478036
  480383
  480397
  515768
  537873
  565467
  591087
  593425
  603344
  606863
  720405
  788815
  790799
  814750
  814753
  814779
  814802
  814832
  814841
  814874
  814879
  814918
  814932
  815270
  815333
  815368
  815388
  815424
  815683
  815695
  815797
  815798
  815895
  815913
  815962
  816209
  816536
  816952
  827848
]
2.01 ms
(1.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "danny d brazzers"
]
1.83 ms
(1.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dannyd brazzers"
]
1.57 ms
(1.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dannyd brazzers"
]

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.