Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
83.90 ms
(72.91%)
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
  7133
  414779
  432703
  432723
  444831
  466808
  466830
  466902
  496255
  496464
  506076
  512227
  514101
  518477
  525085
  526573
  548254
  550479
  555946
  556680
  557091
  573300
  580425
  590719
  591760
  595800
  616528
  627361
  645169
  649268
  653070
  668766
  671230
  673430
  674587
  675149
  703632
  715152
  730212
  739592
  741777
  742775
  743340
  744757
  746512
  750932
  760965
  766331
  784436
  788559
  788869
  793841
  802397
  805255
  808449
  810420
  826045
  826560
]
12.86 ms
(11.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:
[
  "fill her up"
  "fill her up"
  "fill her up"
  20
]
8.38 ms
(7.28%)
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
  7133
  675149
  616528
  595800
  645169
  808449
  802397
  550479
  715152
  496464
  784436
  805255
  826045
  788869
  730212
  653070
  466902
  750932
  826560
  746512
  739592
  793841
  766331
  649268
  512227
  671230
  466830
  788559
  742775
  668766
  703632
  573300
  810420
  741777
  743340
  744757
  432703
  526573
  673430
  760965
  525085
  674587
  557091
  444831
  432723
  466808
  496255
  506076
  580425
  591760
  414779
  590719
  556680
  627361
  514101
  548254
  518477
  555946
]
2.49 ms
(2.17%)
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
  7133
  414779
  432703
  432723
  444831
  466808
  466830
  466902
  496255
  496464
  506076
  512227
  514101
  518477
  525085
  526573
  548254
  550479
  555946
  556680
  557091
  573300
  580425
  590719
  591760
  595800
  616528
  627361
  645169
  649268
  653070
  668766
  671230
  673430
  674587
  675149
  703632
  715152
  730212
  739592
  741777
  742775
  743340
  744757
  746512
  750932
  760965
  766331
  784436
  788559
  788869
  793841
  802397
  805255
  808449
  810420
  826045
  826560
]
2.42 ms
(2.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fill her up"
]
1.87 ms
(1.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fill her up"
]
1.64 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fill her up"
]
1.50 ms
(1.30%)
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.