Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
68.06 ms
(59.08%)
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
  389983
  396952
  401224
  401794
  413091
  428139
  429084
  449228
  452975
  453451
  455206
  460281
  464025
  481815
  490427
  497447
  502794
  510222
  512483
  513765
  518176
  518504
  520792
  528815
  532182
  554387
  561087
  563856
  567363
  580088
  591615
  593815
  605545
  609524
  632258
  643020
  644381
  650844
  684216
  717009
  717669
  756463
  780340
  781971
  782777
  789261
  789750
  790019
  802833
  803160
  803306
  807013
  807353
  807401
  817274
  817510
]
27.79 ms
(24.12%)
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:
[
  "mom birthday"
  "mom birthday"
  "mom birthday"
  20
]
10.56 ms
(9.17%)
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
  452975
  490427
  428139
  781971
  817274
  807013
  780340
  591615
  789750
  802833
  413091
  389983
  401794
  717009
  644381
  396952
  453451
  512483
  580088
  401224
  554387
  609524
  807353
  807401
  803160
  717669
  481815
  513765
  817510
  803306
  782777
  789261
  756463
  520792
  449228
  528815
  593815
  518176
  518504
  532182
  510222
  567363
  684216
  790019
  561087
  650844
  464025
  460281
  455206
  497447
  563856
  632258
  502794
  643020
  605545
  429084
]
2.39 ms
(2.07%)
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
  389983
  396952
  401224
  401794
  413091
  428139
  429084
  449228
  452975
  453451
  455206
  460281
  464025
  481815
  490427
  497447
  502794
  510222
  512483
  513765
  518176
  518504
  520792
  528815
  532182
  554387
  561087
  563856
  567363
  580088
  591615
  593815
  605545
  609524
  632258
  643020
  644381
  650844
  684216
  717009
  717669
  756463
  780340
  781971
  782777
  789261
  789750
  790019
  802833
  803160
  803306
  807013
  807353
  807401
  817274
  817510
]
1.71 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom birthday"
]
1.63 ms
(1.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom birthday"
]
1.48 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom birthday"
]

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.