Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
69.18 ms
(56.98%)
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
  421164
  431448
  432077
  445471
  451866
  486336
  496270
  508437
  515568
  519617
  520737
  522382
  524508
  526203
  528923
  530696
  539203
  545409
  545418
  556741
  582631
  590444
  599835
  599966
  602655
  604016
  604289
  604364
  616994
  625533
  628333
  628371
  628383
  630550
  632978
  634230
  641975
  647837
  647854
  648575
  666894
  666895
  677783
  695123
  707391
]
31.09 ms
(25.60%)
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:
[
  "18 rough teen"
  "18 rough teen"
  "18 rough teen"
  20
]
11.85 ms
(9.76%)
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
  641975
  431448
  432077
  496270
  648575
  604289
  539203
  545409
  582631
  508437
  707391
  647837
  590444
  599835
  445471
  528923
  524508
  530696
  647854
  666895
  677783
  599966
  630550
  604016
  632978
  421164
  602655
  451866
  556741
  666894
  695123
  628383
  628371
  604364
  545418
  628333
  522382
  634230
  625533
  520737
  515568
  519617
  486336
  616994
  526203
]
2.52 ms
(2.07%)
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
  421164
  431448
  432077
  445471
  451866
  486336
  496270
  508437
  515568
  519617
  520737
  522382
  524508
  526203
  528923
  530696
  539203
  545409
  545418
  556741
  582631
  590444
  599835
  599966
  602655
  604016
  604289
  604364
  616994
  625533
  628333
  628371
  628383
  630550
  632978
  634230
  641975
  647837
  647854
  648575
  666894
  666895
  677783
  695123
  707391
]
1.87 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 rough teen"
]
1.77 ms
(1.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 rough teen"
]
1.55 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 rough teen"
]

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.