Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
58.04 ms
(64.83%)
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
  541197
  542583
  543627
  543652
  545373
  545409
  582323
  599914
  599945
  600268
  600363
  601584
  619204
  627807
  628332
  628368
  628371
  628382
  628383
  630552
  631194
  632562
  632635
  634115
  634218
  634774
  634790
  635275
  637080
  637413
  639292
  639719
  641700
  642002
  644962
  647936
  650127
  651051
  651599
  651620
  666880
  666892
  666901
  668555
  676428
  680112
  680121
  680126
  683262
  695126
  698133
  704226
  707391
  733840
  733842
  733855
  775958
]
11.26 ms
(12.58%)
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:
[
  "gangbang piss drink"
  "gangbang piss drink"
  "gangbang piss drink"
  20
]
10.17 ms
(11.36%)
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
  680121
  619204
  634218
  680112
  632562
  683262
  733842
  639292
  650127
  637080
  680126
  628368
  651620
  704226
  632635
  635275
  733840
  668555
  644962
  543627
  599945
  733855
  775958
  634115
  582323
  666901
  695126
  601584
  642002
  599914
  600268
  634790
  666880
  628383
  628371
  545373
  666892
  641700
  600363
  628382
  631194
  543652
  634774
  698133
  637413
  651051
  545409
  676428
  707391
  628332
  639719
  630552
  542583
  541197
  651599
  627807
  647936
]
2.44 ms
(2.73%)
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
  541197
  542583
  543627
  543652
  545373
  545409
  582323
  599914
  599945
  600268
  600363
  601584
  619204
  627807
  628332
  628368
  628371
  628382
  628383
  630552
  631194
  632562
  632635
  634115
  634218
  634774
  634790
  635275
  637080
  637413
  639292
  639719
  641700
  642002
  644962
  647936
  650127
  651051
  651599
  651620
  666880
  666892
  666901
  668555
  676428
  680112
  680121
  680126
  683262
  695126
  698133
  704226
  707391
  733840
  733842
  733855
  775958
]
2.00 ms
(2.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gangbang piss drink"
]
2.00 ms
(2.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "gangbang писсинг drink"
]
1.86 ms
(2.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "gangbang писсинг drink"
]

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.