Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
77.45 ms
(64.41%)
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
  402729
  421420
  492488
  512465
  515143
  515392
  526951
  533432
  533915
  537312
  542346
  542370
  546317
  546341
  546541
  547698
  548882
  548891
  548892
  548893
  548905
  555826
  556450
  556453
  556456
  573200
  575397
  576165
  583180
  584361
  593364
  607184
  613689
  614625
  614654
  617796
  627849
  628402
  633124
  641623
  648257
  652963
  667338
  716611
  717246
  717259
  728730
  745277
  745279
  745306
  745310
  745311
  746616
  756258
  761192
  766143
  769210
  811336
]
23.56 ms
(19.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:
[
  "spitting girl"
  "spitting girl"
  "spitting girl"
  20
]
9.46 ms
(7.87%)
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
  627849
  613689
  402729
  607184
  667338
  811336
  745277
  745279
  716611
  546341
  614625
  546317
  769210
  533432
  548882
  593364
  745311
  556456
  537312
  548892
  761192
  555826
  556453
  512465
  717259
  548891
  746616
  515392
  548893
  745310
  542346
  769261
  548905
  556450
  547698
  617796
  614654
  542370
  717246
  576165
  766143
  745306
  583180
  728730
  652963
  421420
  492488
  584361
  756258
  546541
  573200
  515143
  575397
  641623
  633124
  628402
  526951
  648257
  533915
]
2.57 ms
(2.14%)
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
  402729
  421420
  492488
  512465
  515143
  515392
  526951
  533432
  533915
  537312
  542346
  542370
  546317
  546341
  546541
  547698
  548882
  548891
  548892
  548893
  548905
  555826
  556450
  556453
  556456
  573200
  575397
  576165
  583180
  584361
  593364
  607184
  613689
  614625
  614654
  617796
  627849
  628402
  633124
  641623
  648257
  652963
  667338
  716611
  717246
  717259
  728730
  745277
  745279
  745306
  745310
  745311
  746616
  756258
  761192
  766143
  769210
  811336
]
2.11 ms
(1.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "spitting girl"
]
1.80 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "spitting девушк"
]
1.77 ms
(1.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "spitting девушк"
]
1.51 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.