Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.24 ms
(52.59%)
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
]
111.71 ms
(40.45%)
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
  188447
  358592
  383333
  389932
  389997
  393331
  401137
  401201
  403135
  404185
  415257
  424115
  428131
  439610
  441784
  445550
  447667
  448530
  452324
  452327
  452817
  453131
  455890
  456024
  458907
  464484
  465611
  466167
  466215
  468524
  469911
  473772
  473889
  478830
  479758
  483150
  483742
  495224
  498468
  508185
  529187
  535649
  536443
  547809
  555134
  561645
  561714
  569150
  573725
  575774
  595510
  603933
  613253
  626448
  628068
  635325
  705449
  717213
  800597
  802229
]
10.01 ms
(3.62%)
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
  717213
  800597
  358592
  635325
  535649
  401201
  188447
  393331
  404185
  447667
  705449
  802229
  441784
  389997
  389932
  478830
  569150
  479758
  403135
  547809
  415257
  573725
  465611
  445550
  498468
  508185
  383333
  455890
  483742
  424115
  448530
  428131
  453131
  401137
  555134
  466167
  464484
  529187
  561645
  536443
  458907
  452817
  468524
  469911
  575774
  495224
  452327
  456024
  483150
  439610
  452324
  473889
  466215
  613253
  595510
  626448
  473772
  561714
  628068
  603933
]
3.50 ms
(1.27%)
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
  188447
  358592
  383333
  389932
  389997
  393331
  401137
  401201
  403135
  404185
  415257
  424115
  428131
  439610
  441784
  445550
  447667
  448530
  452324
  452327
  452817
  453131
  455890
  456024
  458907
  464484
  465611
  466167
  466215
  468524
  469911
  473772
  473889
  478830
  479758
  483150
  483742
  495224
  498468
  508185
  529187
  535649
  536443
  547809
  555134
  561645
  561714
  569150
  573725
  575774
  595510
  603933
  613253
  626448
  628068
  635325
  705449
  717213
  800597
  802229
]
1.56 ms
(0.56%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мягк анал"
]
1.48 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мягк анал"
]
1.36 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.