Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.82 ms
(60.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "oral anal"
]
66.01 ms
(18.92%)
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
  12411
  390680
  401100
  401313
  414960
  428958
  435400
  437789
  447253
  451132
  451928
  451980
  452131
  452156
  452161
  452305
  459661
  471951
  475972
  485511
  486336
  491823
  497950
  521204
  521887
  521992
  526908
  537254
  541084
  555064
  570310
  573607
  582566
  590460
  597073
  598133
  616800
  616816
  625546
  635117
  644168
  670197
  677347
  677952
  679457
  679461
  685789
  686168
  694441
  696355
  698735
  712549
  728083
  733289
  736228
  750795
  771343
  795632
  802826
]
52.71 ms
(15.10%)
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:
[
  "oral anal"
  "oral anal"
  "oral anal"
  20
]
10.61 ms
(3.04%)
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
  733289
  771343
  728083
  625546
  521992
  677952
  497950
  685789
  686168
  696355
  736228
  677347
  698735
  635117
  750795
  555064
  401100
  694441
  537254
  570310
  573607
  12411
  435400
  795632
  644168
  475972
  521887
  712549
  597073
  401313
  485511
  452156
  451980
  447253
  802826
  452305
  526908
  471951
  459661
  521204
  390680
  679457
  590460
  428958
  452161
  452131
  451132
  670197
  679461
  414960
  541084
  582566
  598133
  616816
  437789
  486336
  616800
  491823
  451928
]
2.58 ms
(0.74%)
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
  12411
  390680
  401100
  401313
  414960
  428958
  435400
  437789
  447253
  451132
  451928
  451980
  452131
  452156
  452161
  452305
  459661
  471951
  475972
  485511
  486336
  491823
  497950
  521204
  521887
  521992
  526908
  537254
  541084
  555064
  570310
  573607
  582566
  590460
  597073
  598133
  616800
  616816
  625546
  635117
  644168
  670197
  677347
  677952
  679457
  679461
  685789
  686168
  694441
  696355
  698735
  712549
  728083
  733289
  736228
  750795
  771343
  795632
  802826
]
1.89 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "oral анал"
]
1.68 ms
(0.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "oral анал"
]

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.