Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
226.51 ms
(72.31%)
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:
[
  "nipples tits"
  "nipples tits"
  "nipples tits"
  20
]
67.54 ms
(21.56%)
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
  387534
  399209
  422652
  427311
  445314
  446977
  467830
  467845
  468232
  469223
  486863
  487946
  490080
  490514
  504787
  504791
  507455
  508071
  509449
  515869
  516263
  516718
  518473
  519905
  519907
  521867
  523253
  524492
  527822
  528452
  550864
  556593
  559116
  564743
  570933
  574243
  583221
  593032
  595328
  597857
  603053
  603937
  608716
  623150
  731063
  745312
  794214
  807899
  810616
]
10.62 ms
(3.39%)
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
  508071
  595328
  467830
  570933
  731063
  515869
  810616
  593032
  490514
  556593
  504787
  597857
  807899
  509449
  521867
  527822
  507455
  487946
  794214
  467845
  490080
  745312
  550864
  603053
  468232
  559116
  574243
  486863
  504791
  387534
  445314
  603937
  519905
  399209
  427311
  608716
  623150
  516718
  583221
  469223
  422652
  446977
  564743
  528452
  516263
  523253
  519907
  518473
  524492
]
2.60 ms
(0.83%)
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
  387534
  399209
  422652
  427311
  445314
  446977
  467830
  467845
  468232
  469223
  486863
  487946
  490080
  490514
  504787
  504791
  507455
  508071
  509449
  515869
  516263
  516718
  518473
  519905
  519907
  521867
  523253
  524492
  527822
  528452
  550864
  556593
  559116
  564743
  570933
  574243
  583221
  593032
  595328
  597857
  603053
  603937
  608716
  623150
  731063
  745312
  794214
  807899
  810616
]
1.90 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "nipples tits"
]
1.44 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "nipples сиськ"
]
1.34 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.29 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "nipples сиськ"
]

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.