Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
74.62 ms
(44.83%)
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
]
71.71 ms
(43.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
  391477
  395910
  424427
  428202
  439560
  450964
  454249
  464580
  466141
  466164
  466275
  466869
  467243
  467496
  469909
  473431
  476261
  477990
  479768
  482536
  484632
  484711
  490427
  490872
  495030
  496505
  504098
  508662
  511534
  520881
  522078
  526748
  528429
  546913
  563442
  565044
  570708
  573741
  590448
  595383
  599468
  599512
  600035
  601851
  609196
  613413
  614058
  614479
  617006
  618889
  622386
  624109
  655697
  721556
  746586
  752685
]
9.75 ms
(5.86%)
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
  391477
  424427
  546913
  395910
  622386
  721556
  746586
  522078
  565044
  752685
  464580
  495030
  490872
  601851
  467243
  477990
  528429
  573741
  439560
  563442
  466164
  467496
  473431
  490427
  466275
  454249
  526748
  496505
  511534
  450964
  469909
  484711
  428202
  482536
  614058
  466141
  476261
  479768
  595383
  520881
  570708
  466869
  504098
  508662
  617006
  655697
  599468
  624109
  590448
  614479
  599512
  613413
  484632
  600035
  618889
  609196
]
3.25 ms
(1.95%)
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
  391477
  395910
  424427
  428202
  439560
  450964
  454249
  464580
  466141
  466164
  466275
  466869
  467243
  467496
  469909
  473431
  476261
  477990
  479768
  482536
  484632
  484711
  490427
  490872
  495030
  496505
  504098
  508662
  511534
  520881
  522078
  526748
  528429
  546913
  563442
  565044
  570708
  573741
  590448
  595383
  599468
  599512
  600035
  601851
  609196
  613413
  614058
  614479
  617006
  618889
  622386
  624109
  655697
  721556
  746586
  752685
]
2.06 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русские очень старые"
]
1.79 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск очен старые"
]
1.64 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.98%)
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.