Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
65.72 ms
(61.74%)
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
  40835
  40927
  397834
  461240
  461699
  488980
  503408
  510780
  515418
  523928
  560281
  569034
  575315
  580025
  582966
  591065
  597089
  630393
  630887
  656886
  657775
  657788
  662930
  716219
  732585
  734639
  734679
  740665
  746052
  757562
  759973
  760768
  760780
  767984
  781645
  787073
  788974
  795720
  801080
  802110
  806473
  812728
  828310
  828851
]
21.83 ms
(20.51%)
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:
[
  "boots milf"
  "boots milf"
  "boots milf"
  20
]
8.46 ms
(7.94%)
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
  40835
  802110
  828851
  734679
  759973
  801080
  40927
  828310
  716219
  630393
  740665
  760768
  812728
  732585
  397834
  580025
  757562
  734639
  746052
  787073
  781645
  767984
  657788
  575315
  597089
  788974
  795720
  523928
  806473
  461699
  510780
  503408
  515418
  582966
  656886
  662930
  760780
  461240
  560281
  630887
  488980
  569034
  657775
  591065
]
3.01 ms
(2.83%)
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
  40835
  40927
  397834
  461240
  461699
  488980
  503408
  510780
  515418
  523928
  560281
  569034
  575315
  580025
  582966
  591065
  597089
  630393
  630887
  656886
  657775
  657788
  662930
  716219
  732585
  734639
  734679
  740665
  746052
  757562
  759973
  760768
  760780
  767984
  781645
  787073
  788974
  795720
  801080
  802110
  806473
  812728
  828310
  828851
]
1.99 ms
(1.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boots milf"
]
1.90 ms
(1.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "boots milf"
]
1.84 ms
(1.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "boots milf"
]
1.71 ms
(1.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.