Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.76 ms
(40.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf brandilove"
]
208.34 ms
(40.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf brandilove"
]
59.18 ms
(11.53%)
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
  314128
  331209
  383326
  383343
  389661
  392766
  395518
  399639
  400042
  402593
  402906
  404340
  405490
  407557
  408197
  409330
  410640
  410695
  416970
  417978
  418339
  421071
  425609
  425625
  425633
  425647
  427452
  430703
  431765
  444041
  445932
  453903
  456611
  463833
  465500
  468726
  471824
  472214
  482987
  499839
  500331
  518734
  578473
  590861
  605298
  626335
  626336
  626343
  687980
  769641
  793757
]
22.33 ms
(4.35%)
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:
[
  "milf brandi love"
  "milf brandi love"
  "milf brandi love"
  20
]
7.91 ms
(1.54%)
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
  626335
  769641
  402593
  395518
  410695
  408197
  518734
  409330
  430703
  383343
  402906
  410640
  383326
  405490
  465500
  418339
  314128
  425633
  389661
  425625
  482987
  392766
  404340
  331209
  444041
  500331
  793757
  590861
  463833
  425647
  626343
  427452
  626336
  407557
  687980
  605298
  400042
  499839
  468726
  472214
  453903
  399639
  416970
  456611
  425609
  431765
  578473
  445932
  417978
  421071
  471824
]
2.32 ms
(0.45%)
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
  314128
  331209
  383326
  383343
  389661
  392766
  395518
  399639
  400042
  402593
  402906
  404340
  405490
  407557
  408197
  409330
  410640
  410695
  416970
  417978
  418339
  421071
  425609
  425625
  425633
  425647
  427452
  430703
  431765
  444041
  445932
  453903
  456611
  463833
  465500
  468726
  471824
  472214
  482987
  499839
  500331
  518734
  578473
  590861
  605298
  626335
  626336
  626343
  687980
  769641
  793757
]
1.93 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf brandi love"
]
1.33 ms
(0.26%)
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.