Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
73.33 ms
(72.24%)
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
  422805
  425473
  448121
  451038
  455207
  480069
  481379
  481766
  482190
  483231
  484870
  489780
  493310
  496147
  496593
  498036
  498646
  500503
  500795
  512992
  517455
  520272
  526154
  526327
  529144
  531543
  536657
  542052
  544668
  550680
  551450
  554649
  566542
  575924
  587886
  588745
  589786
  590460
  591855
  592884
  598921
  599450
  603604
  603652
  604746
  607146
  611902
  612030
  654840
  659715
]
9.96 ms
(9.81%)
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
  604746
  520272
  496147
  483231
  489780
  566542
  575924
  607146
  592884
  611902
  526327
  554649
  603652
  612030
  481379
  500503
  425473
  588745
  493310
  529144
  481766
  448121
  598921
  422805
  542052
  512992
  498646
  496593
  531543
  517455
  451038
  500795
  480069
  659715
  591855
  590460
  603604
  654840
  482190
  526154
  551450
  589786
  455207
  599450
  587886
  484870
  536657
  550680
  498036
  544668
]
8.60 ms
(8.47%)
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:
[
  "handjob stranger"
  "handjob stranger"
  "handjob stranger"
  20
]
2.70 ms
(2.66%)
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
  422805
  425473
  448121
  451038
  455207
  480069
  481379
  481766
  482190
  483231
  484870
  489780
  493310
  496147
  496593
  498036
  498646
  500503
  500795
  512992
  517455
  520272
  526154
  526327
  529144
  531543
  536657
  542052
  544668
  550680
  551450
  554649
  566542
  575924
  587886
  588745
  589786
  590460
  591855
  592884
  598921
  599450
  603604
  603652
  604746
  607146
  611902
  612030
  654840
  659715
]
1.84 ms
(1.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "handjob stranger"
]
1.82 ms
(1.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член stranger"
]
1.57 ms
(1.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дрочк член stranger"
]

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.