Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
83.33 ms
(71.58%)
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
  388762
  423314
  439027
  450583
  466485
  477429
  499147
  505340
  521988
  533290
  547913
  549646
  569903
  572378
  587725
  590889
  598931
  625244
  625776
  640432
  681039
  681153
  706073
  724586
  730297
  733602
  736141
  736973
  738593
  748665
  757887
  771455
  784643
  785467
  789770
  792309
  795369
  807267
  808623
  809940
  813365
  813622
  813943
  819784
  820080
  824511
]
15.28 ms
(13.12%)
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:
[
  "soft pussy"
  "soft pussy"
  "soft pussy"
  20
]
7.52 ms
(6.46%)
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
  706073
  757887
  789770
  466485
  477429
  807267
  808623
  785467
  784643
  809940
  505340
  824511
  820080
  795369
  423314
  813622
  625776
  813943
  819784
  572378
  813365
  733602
  724586
  681153
  738593
  771455
  730297
  450583
  792309
  736973
  640432
  681039
  587725
  748665
  439027
  547913
  569903
  598931
  736141
  388762
  521988
  625244
  499147
  549646
  590889
  533290
]
2.75 ms
(2.36%)
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
  388762
  423314
  439027
  450583
  466485
  477429
  499147
  505340
  521988
  533290
  547913
  549646
  569903
  572378
  587725
  590889
  598931
  625244
  625776
  640432
  681039
  681153
  706073
  724586
  730297
  733602
  736141
  736973
  738593
  748665
  757887
  771455
  784643
  785467
  789770
  792309
  795369
  807267
  808623
  809940
  813365
  813622
  813943
  819784
  820080
  824511
]
2.02 ms
(1.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "soft pussy"
]
2.02 ms
(1.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "soft pussy"
]
1.59 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "soft pussy"
]

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.