Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
86.78 ms
(51.07%)
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
  397530
  404740
  420767
  421850
  421878
  421879
  421900
  422189
  422195
  422208
  423923
  424200
  426765
  426766
  426987
  426991
  428202
  428533
  430095
  432807
  439534
  439544
  439550
  439564
  439677
  439731
  440548
  452977
  454141
  460370
  475980
  485265
  511369
  514110
  516741
  518959
  519023
  521161
  523767
  523901
  524780
  529143
  532095
  535109
  539739
  543579
  549742
  549841
  560396
  563441
  563456
  566257
  582269
  584739
  603743
  605496
  609238
]
62.49 ms
(36.77%)
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:
[
  "mature mom son"
  "mature mom son"
  "mature mom son"
  20
]
10.70 ms
(6.30%)
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
  532095
  549742
  560396
  566257
  421850
  424200
  426765
  426766
  432807
  439550
  452977
  430095
  439677
  439731
  421878
  421900
  422189
  423923
  454141
  511369
  514110
  521161
  549841
  584739
  524780
  582269
  605496
  485265
  404740
  428533
  420767
  539739
  518959
  529143
  422195
  439544
  439564
  421879
  426987
  440548
  422208
  397530
  460370
  523901
  535109
  563456
  609238
  426991
  563441
  428202
  439534
  516741
  543579
  603743
  475980
  519023
  523767
]
2.79 ms
(1.64%)
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
  397530
  404740
  420767
  421850
  421878
  421879
  421900
  422189
  422195
  422208
  423923
  424200
  426765
  426766
  426987
  426991
  428202
  428533
  430095
  432807
  439534
  439544
  439550
  439564
  439677
  439731
  440548
  452977
  454141
  460370
  475980
  485265
  511369
  514110
  516741
  518959
  519023
  521161
  523767
  523901
  524780
  529143
  532095
  535109
  539739
  543579
  549742
  549841
  560396
  563441
  563456
  566257
  582269
  584739
  603743
  605496
  609238
]
2.20 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature mom son"
]
1.85 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature mom son"
]
1.44 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature mom son"
]

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.