Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.60 ms
(45.36%)
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
  95988
  417333
  468166
  473541
  476255
  513303
  514801
  531109
  532172
  532764
  535038
  536691
  542203
  561831
  565265
  599833
  599945
  600019
  600185
  600219
  600334
  600344
  600363
  601514
  601579
  601595
  601600
  602902
  605802
  610538
  615058
  616222
  626685
  627305
  627308
  631171
  636284
  644272
  647343
  648832
  648837
  648846
  648870
  649566
  657219
  664536
  670286
  673364
  733849
  766096
  785335
  805545
  806583
  815071
  815126
  815132
  818406
  821545
  822119
]
55.26 ms
(41.37%)
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:
[
  "lina anal"
  "lina anal"
  "lina anal"
  20
]
8.97 ms
(6.72%)
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
  561831
  514801
  664536
  805545
  610538
  785335
  815071
  815126
  532764
  815132
  649566
  733849
  600344
  468166
  600219
  565265
  670286
  601514
  535038
  631171
  600334
  473541
  599945
  600185
  531109
  532172
  601579
  600019
  636284
  601595
  601600
  599833
  615058
  647343
  600363
  644272
  542203
  616222
  536691
  95988
  821545
  822119
  602902
  627308
  818406
  806583
  626685
  657219
  627305
  605802
  476255
  417333
  648846
  766096
  673364
  648832
  648870
  648837
  513303
]
2.28 ms
(1.71%)
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
  95988
  417333
  468166
  473541
  476255
  513303
  514801
  531109
  532172
  532764
  535038
  536691
  542203
  561831
  565265
  599833
  599945
  600019
  600185
  600219
  600334
  600344
  600363
  601514
  601579
  601595
  601600
  602902
  605802
  610538
  615058
  616222
  626685
  627305
  627308
  631171
  636284
  644272
  647343
  648832
  648837
  648846
  648870
  649566
  657219
  664536
  670286
  673364
  733849
  766096
  785335
  805545
  806583
  815071
  815126
  815132
  818406
  821545
  822119
]
1.87 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "lina анал"
]
1.58 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "lina анал"
]
1.47 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "lina anal"
]

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.