Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
57.82 ms
(52.26%)
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
  391891
  397024
  407127
  411400
  420769
  437901
  446131
  448987
  453063
  453716
  455507
  459054
  462272
  468046
  470565
  470584
  470634
  474404
  477046
  492690
  509852
  509853
  509861
  520500
  522092
  526329
  533146
  540733
  543428
  543721
  546532
  546664
  546667
  547958
  563400
  567555
  567581
  578017
  579317
  590206
  590230
  619058
  619060
  619064
  671501
  686373
  740318
  760460
]
35.07 ms
(31.69%)
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:
[
  "сексвайф минет"
  "сексвайф минет"
  "сексвайф минет"
  20
]
8.80 ms
(7.95%)
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
  540733
  543428
  590206
  619058
  671501
  619060
  509852
  533146
  453063
  686373
  760460
  391891
  543721
  407127
  437901
  546667
  411400
  470634
  462272
  546664
  740318
  474404
  453716
  547958
  526329
  522092
  619064
  470565
  459054
  397024
  563400
  546532
  509861
  468046
  509853
  520500
  470584
  455507
  446131
  567581
  420769
  492690
  578017
  579317
  567555
  448987
  477046
  590230
]
2.14 ms
(1.93%)
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
  391891
  397024
  407127
  411400
  420769
  437901
  446131
  448987
  453063
  453716
  455507
  459054
  462272
  468046
  470565
  470584
  470634
  474404
  477046
  492690
  509852
  509853
  509861
  520500
  522092
  526329
  533146
  540733
  543428
  543721
  546532
  546664
  546667
  547958
  563400
  567555
  567581
  578017
  579317
  590206
  590230
  619058
  619060
  619064
  671501
  686373
  740318
  760460
]
2.02 ms
(1.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сексвайф минет"
]
1.83 ms
(1.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сексвайф минет оральн секс"
]
1.53 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.44 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.