Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
61.90 ms
(58.55%)
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
  404116
  443663
  455977
  456445
  458031
  458905
  459086
  465378
  469764
  484722
  495192
  506211
  517654
  524943
  533703
  535306
  542790
  544636
  544977
  554518
  572582
  590579
  590627
  593870
  595811
  609512
  622123
  622183
  644917
  645822
  653527
  691616
  692438
  702286
  732730
  761136
  787017
  788658
  792580
  819346
]
25.20 ms
(23.84%)
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:
[
  "wife two guys"
  "wife two guys"
  "wife two guys"
  20
]
8.94 ms
(8.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
  691616
  788658
  609512
  792580
  595811
  787017
  732730
  653527
  819346
  544636
  692438
  622183
  572582
  622123
  404116
  590627
  443663
  544977
  533703
  702286
  459086
  495192
  761136
  644917
  456445
  542790
  593870
  590579
  645822
  535306
  458905
  458031
  455977
  465378
  524943
  506211
  484722
  517654
  469764
  554518
]
3.02 ms
(2.86%)
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
  404116
  443663
  455977
  456445
  458031
  458905
  459086
  465378
  469764
  484722
  495192
  506211
  517654
  524943
  533703
  535306
  542790
  544636
  544977
  554518
  572582
  590579
  590627
  593870
  595811
  609512
  622123
  622183
  644917
  645822
  653527
  691616
  692438
  702286
  732730
  761136
  787017
  788658
  792580
  819346
]
1.91 ms
(1.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife two guys"
]
1.66 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен two guys"
]
1.56 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен two guys"
]
1.52 ms
(1.44%)
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.