Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.08 ms
(77.51%)
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
  182139
  182238
  183036
  275948
  382078
  385653
  401799
  414090
  414662
  415758
  415877
  416600
  416711
  417787
  418817
  420116
  421369
  433002
  438464
  443103
  443236
  446225
  451713
  452729
  458772
  465704
  468128
  470073
  475411
  475414
  480477
  480478
  482704
  483762
  486761
  486763
  492906
  493258
  494492
  500912
  509984
  517710
  518191
  518892
  518915
  520763
  522171
  522174
  538669
  544799
  560408
  588697
  588846
  609027
  621635
  669215
  734840
  740935
  741157
  808988
]
11.68 ms
(7.54%)
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
  740935
  275948
  475411
  443236
  415877
  588697
  734840
  385653
  493258
  182139
  741157
  182238
  517710
  609027
  446225
  452729
  544799
  621635
  420116
  183036
  382078
  414662
  416711
  451713
  470073
  588846
  808988
  458772
  480477
  522171
  492906
  509984
  518892
  486761
  443103
  475414
  468128
  520763
  414090
  522174
  483762
  465704
  418817
  518915
  560408
  438464
  433002
  415758
  480478
  416600
  518191
  669215
  421369
  486763
  500912
  401799
  417787
  482704
  494492
  538669
]
10.13 ms
(6.54%)
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:
[
  "blonde machine"
  "blonde machine"
  "blonde machine"
  20
]
5.16 ms
(3.33%)
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
  182139
  182238
  183036
  275948
  382078
  385653
  401799
  414090
  414662
  415758
  415877
  416600
  416711
  417787
  418817
  420116
  421369
  433002
  438464
  443103
  443236
  446225
  451713
  452729
  458772
  465704
  468128
  470073
  475411
  475414
  480477
  480478
  482704
  483762
  486761
  486763
  492906
  493258
  494492
  500912
  509984
  517710
  518191
  518892
  518915
  520763
  522171
  522174
  538669
  544799
  560408
  588697
  588846
  609027
  621635
  669215
  734840
  740935
  741157
  808988
]
2.46 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde machine"
]
1.86 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая machine"
]
1.69 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая machine"
]

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.