Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
53.39 ms
(64.35%)
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
  405700
  406931
  411667
  418312
  419192
  420058
  420878
  422464
  428356
  434319
  446943
  452095
  474379
  476231
  476448
  476782
  476813
  477884
  483690
  489474
  489671
  489818
  492530
  493073
  493469
  495629
  499506
  500216
  503361
  503807
  509965
  511144
  511600
  511622
  512349
  512429
  516249
  516919
  518427
  519542
  520126
  520440
  523214
  523645
  526773
  563801
  599113
  608756
  624011
  624039
  775789
  775831
]
10.46 ms
(12.61%)
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 wow girls"
  "18 wow girls"
  "18 wow girls"
  20
]
10.16 ms
(12.25%)
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
  608756
  775789
  518427
  624011
  523214
  775831
  624039
  489671
  483690
  523645
  476231
  411667
  511144
  563801
  406931
  489818
  476813
  418312
  512429
  493073
  512349
  499506
  428356
  477884
  446943
  511622
  520126
  493469
  476782
  500216
  516919
  495629
  511600
  503361
  489474
  599113
  474379
  434319
  405700
  422464
  492530
  452095
  420878
  509965
  516249
  420058
  503807
  476448
  519542
  520440
  419192
  526773
]
2.03 ms
(2.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
  405700
  406931
  411667
  418312
  419192
  420058
  420878
  422464
  428356
  434319
  446943
  452095
  474379
  476231
  476448
  476782
  476813
  477884
  483690
  489474
  489671
  489818
  492530
  493073
  493469
  495629
  499506
  500216
  503361
  503807
  509965
  511144
  511600
  511622
  512349
  512429
  516249
  516919
  518427
  519542
  520126
  520440
  523214
  523645
  526773
  563801
  599113
  608756
  624011
  624039
  775789
  775831
]
1.85 ms
(2.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(2.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 wow girls"
]
1.71 ms
(2.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 wowgirls"
]
1.58 ms
(1.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 wowgirls"
]

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.