Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
66.15 ms
(44.97%)
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
  419198
  420515
  426399
  429931
  446745
  448333
  450440
  455943
  455945
  456630
  456633
  460321
  461805
  462415
  464266
  465524
  470089
  470442
  471088
  472155
  476420
  479204
  480226
  480413
  486765
  495565
  500221
  506429
  507514
  516329
  516772
  518159
  524613
  526495
  529988
  530935
  530943
  557946
  561178
  573805
  577392
  584887
  586009
  591294
  599987
  601101
  601529
  603002
  633045
  633163
  648685
  667250
  670745
  707692
  782516
]
60.14 ms
(40.89%)
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:
[
  "on cam sex"
  "on cam sex"
  "on cam sex"
  20
]
10.73 ms
(7.30%)
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
  429931
  461805
  480413
  530943
  480226
  667250
  470089
  479204
  648685
  557946
  450440
  476420
  486765
  577392
  633045
  419198
  707692
  591294
  782516
  518159
  455945
  460321
  500221
  420515
  456633
  516329
  524613
  530935
  448333
  455943
  670745
  471088
  495565
  516772
  426399
  470442
  529988
  586009
  456630
  526495
  446745
  465524
  464266
  472155
  603002
  601529
  507514
  633163
  584887
  462415
  599987
  506429
  561178
  573805
  601101
]
3.07 ms
(2.09%)
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
  419198
  420515
  426399
  429931
  446745
  448333
  450440
  455943
  455945
  456630
  456633
  460321
  461805
  462415
  464266
  465524
  470089
  470442
  471088
  472155
  476420
  479204
  480226
  480413
  486765
  495565
  500221
  506429
  507514
  516329
  516772
  518159
  524613
  526495
  529988
  530935
  530943
  557946
  561178
  573805
  577392
  584887
  586009
  591294
  599987
  601101
  601529
  603002
  633045
  633163
  648685
  667250
  670745
  707692
  782516
]
2.25 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "on cam sex"
]
1.73 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cam секс"
]
1.42 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cam секс"
]

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.