Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
246.01 ms
(74.81%)
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 swap"
  "mature swap"
  "mature swap"
  20
]
60.80 ms
(18.49%)
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
  358437
  387556
  428453
  444736
  446854
  449562
  450386
  452034
  452048
  462208
  466733
  470663
  482243
  484017
  493219
  495703
  496098
  496101
  496118
  499636
  502786
  502819
  504133
  504521
  508584
  514587
  522902
  524896
  525263
  527608
  534319
  534845
  535825
  552306
  568061
  595772
  600218
  603175
  604580
  605736
  642006
  642037
  714938
  727814
  752163
  789983
  804447
  806280
  807399
  820331
]
11.42 ms
(3.47%)
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
  806280
  496101
  534845
  727814
  462208
  358437
  534319
  595772
  789983
  804447
  527608
  820331
  535825
  502786
  444736
  496098
  446854
  502819
  387556
  428453
  508584
  470663
  714938
  603175
  452034
  752163
  604580
  499636
  466733
  449562
  514587
  807399
  496118
  452048
  504133
  482243
  493219
  504521
  522902
  568061
  450386
  525263
  524896
  495703
  552306
  605736
  600218
  642006
  642037
  484017
]
2.48 ms
(0.75%)
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
  358437
  387556
  428453
  444736
  446854
  449562
  450386
  452034
  452048
  462208
  466733
  470663
  482243
  484017
  493219
  495703
  496098
  496101
  496118
  499636
  502786
  502819
  504133
  504521
  508584
  514587
  522902
  524896
  525263
  527608
  534319
  534845
  535825
  552306
  568061
  595772
  600218
  603175
  604580
  605736
  642006
  642037
  714938
  727814
  752163
  789983
  804447
  806280
  807399
  820331
]
2.33 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature swap"
]
2.02 ms
(0.62%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature swap"
]
2.01 ms
(0.61%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature swap"
]

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.