Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.65 ms
(62.75%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
64.41 ms
(19.01%)
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
  404724
  410663
  457298
  464679
  481275
  481301
  496410
  501528
  506025
  520626
  521928
  523152
  524796
  528742
  530096
  544333
  546393
  546465
  549945
  555918
  556268
  557853
  565383
  566117
  574101
  578792
  580153
  581179
  591446
  591513
  611321
  627533
  642672
  676213
  693325
  703915
  704335
  719099
  726850
  728982
  752798
  754470
  764657
  765218
  769317
  785498
  798213
  800537
  811746
  818521
  819235
  823257
  826054
]
46.64 ms
(13.76%)
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:
[
  "counter sex"
  "counter sex"
  "counter sex"
  20
]
7.84 ms
(2.31%)
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
  481275
  726850
  703915
  457298
  769317
  754470
  506025
  764657
  544333
  818521
  798213
  823257
  826054
  676213
  556268
  765218
  549945
  752798
  704335
  530096
  728982
  800537
  528742
  578792
  410663
  481301
  811746
  627533
  819235
  591446
  555918
  565383
  611321
  591513
  546393
  693325
  574101
  719099
  524796
  521928
  520626
  566117
  501528
  557853
  785498
  404724
  580153
  464679
  496410
  642672
  546465
  523152
  581179
]
2.03 ms
(0.60%)
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
  404724
  410663
  457298
  464679
  481275
  481301
  496410
  501528
  506025
  520626
  521928
  523152
  524796
  528742
  530096
  544333
  546393
  546465
  549945
  555918
  556268
  557853
  565383
  566117
  574101
  578792
  580153
  581179
  591446
  591513
  611321
  627533
  642672
  676213
  693325
  703915
  704335
  719099
  726850
  728982
  752798
  754470
  764657
  765218
  769317
  785498
  798213
  800537
  811746
  818521
  819235
  823257
  826054
]
2.00 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "counter sex"
]
1.83 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "counter секс"
]
1.45 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "counter секс"
]

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.