Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
89.25 ms
(46.49%)
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:
[
  "anal gape cosplay"
  "anal gape cosplay"
  "anal gape cosplay"
  20
]
81.53 ms
(42.47%)
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
  420358
  427241
  432929
  434374
  438054
  444069
  445455
  448773
  455855
  457341
  467602
  476753
  484411
  485147
  488734
  499111
  505279
  512928
  515358
  521544
  532755
  532942
  539319
  541671
  541821
  543772
  550265
  550277
  550315
  560086
  560924
  564327
  565281
  573156
  574149
  576219
  579358
  579629
  592377
  593860
  597204
  599888
  615881
  632059
  632628
  636288
  639796
  639810
  645952
  674959
  674978
  674994
  676020
  676634
  677712
  680271
  784152
  806591
  825864
]
11.63 ms
(6.06%)
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
  579629
  592377
  806591
  432929
  674978
  645952
  680271
  639810
  825864
  444069
  476753
  448773
  674959
  550277
  420358
  512928
  574149
  599888
  499111
  636288
  434374
  615881
  579358
  784152
  532942
  564327
  576219
  677712
  457341
  467602
  539319
  455855
  484411
  593860
  445455
  632059
  676634
  550315
  639796
  515358
  597204
  550265
  560086
  573156
  427241
  676020
  521544
  632628
  532755
  488734
  543772
  674994
  438054
  505279
  541821
  541671
  560924
  565281
  485147
]
2.77 ms
(1.44%)
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
  420358
  427241
  432929
  434374
  438054
  444069
  445455
  448773
  455855
  457341
  467602
  476753
  484411
  485147
  488734
  499111
  505279
  512928
  515358
  521544
  532755
  532942
  539319
  541671
  541821
  543772
  550265
  550277
  550315
  560086
  560924
  564327
  565281
  573156
  574149
  576219
  579358
  579629
  592377
  593860
  597204
  599888
  615881
  632059
  632628
  636288
  639796
  639810
  645952
  674959
  674978
  674994
  676020
  676634
  677712
  680271
  784152
  806591
  825864
]
1.96 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal gape cosplay"
]
1.73 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал большая большие дырк коспл"
]
1.57 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.