Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
73.39 ms
(69.68%)
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
  415602
  418919
  424566
  433434
  440312
  453653
  453952
  455313
  456421
  458066
  458091
  461163
  463004
  464253
  464711
  469887
  473268
  479294
  480656
  482927
  489725
  490260
  490518
  490903
  495451
  506906
  507653
  508153
  508687
  510350
  514378
  514402
  514934
  517872
  520356
  520360
  520426
  524376
  543611
  552137
  560802
  566304
  571249
  573782
  581868
  626014
  654753
  655320
  659564
  674650
  689964
  712346
  734175
]
14.38 ms
(13.65%)
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
]
9.21 ms
(8.75%)
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
  674650
  482927
  560802
  461163
  689964
  734175
  712346
  489725
  424566
  510350
  552137
  440312
  517872
  581868
  463004
  458091
  458066
  469887
  453653
  464711
  464253
  490903
  508687
  480656
  453952
  543611
  456421
  479294
  455313
  473268
  508153
  490518
  520360
  514378
  514934
  573782
  571249
  415602
  418919
  490260
  507653
  524376
  655320
  520426
  506906
  495451
  514402
  520356
  433434
  659564
  626014
  566304
  654753
]
2.52 ms
(2.39%)
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
  415602
  418919
  424566
  433434
  440312
  453653
  453952
  455313
  456421
  458066
  458091
  461163
  463004
  464253
  464711
  469887
  473268
  479294
  480656
  482927
  489725
  490260
  490518
  490903
  495451
  506906
  507653
  508153
  508687
  510350
  514378
  514402
  514934
  517872
  520356
  520360
  520426
  524376
  543611
  552137
  560802
  566304
  571249
  573782
  581868
  626014
  654753
  655320
  659564
  674650
  689964
  712346
  734175
]
1.68 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хоч женскийрод"
]
1.56 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "хочу бабу"
]
1.33 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хоч женскийрод"
]
1.27 ms
(1.20%)
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.