Query Metrics

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

Queries

Group similar statements

# Time Info
1 3.81 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.50 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "супер мамка"
]
3 11.52 ms
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
  670763
  634770
  607369
  531724
  555331
  555306
  609697
  628589
  737473
  770836
  755157
  789559
  797449
  644854
  477480
  543759
  710536
  696070
  809246
  571442
  542965
  788260
  448149
  814190
  518887
  563772
  736656
  771516
  796327
  635178
  605841
  636053
  615761
  797680
  736494
  809381
  490638
  580260
  716112
  560908
  569592
  588158
  608827
  620391
  805256
  771355
  790188
  799376
  809736
  811362
  560664
  570867
  591918
  600279
  537670
  604523
  477120
  525434
  521267
  717199
  563550
  616409
  604645
  806086
  605066
  519212
  677974
  495757
  793082
  534625
  535369
  650419
  557163
  484307
  526105
  519701
  534312
  543772
  516885
]
4 2.57 ms
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
  448149
  477120
  477480
  484307
  490638
  495757
  516885
  518887
  519212
  519701
  521267
  525434
  526105
  531724
  534312
  534625
  535369
  537670
  542965
  543759
  543772
  555306
  555331
  557163
  560664
  560908
  563550
  563772
  569592
  570867
  571442
  580260
  588158
  591918
  600279
  604523
  604645
  605066
  605841
  607369
  608827
  609697
  615761
  616409
  620391
  628589
  634770
  635178
  636053
  644854
  650419
  670763
  677974
  696070
  710536
  716112
  717199
  736494
  736656
  737473
  755157
  770836
  771355
  771516
  788260
  789559
  790188
  793082
  796327
  797449
  797680
  799376
  805256
  806086
  809246
  809381
  809736
  811362
  814190
]
5 138.19 ms
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
  448149
  477120
  477480
  484307
  490638
  495757
  516885
  518887
  519212
  519701
  521267
  525434
  526105
  531724
  534312
  534625
  535369
  537670
  542965
  543759
  543772
  555306
  555331
  557163
  560664
  560908
  563550
  563772
  569592
  570867
  571442
  580260
  588158
  591918
  600279
  604523
  604645
  605066
  605841
  607369
  608827
  609697
  615761
  616409
  620391
  628589
  634770
  635178
  636053
  644854
  650419
  670763
  677974
  696070
  710536
  716112
  717199
  736494
  736656
  737473
  755157
  770836
  771355
  771516
  788260
  789559
  790188
  793082
  796327
  797449
  797680
  799376
  805256
  806086
  809246
  809381
  809736
  811362
  814190
]
6 2.52 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "супер мам женщин"
]
7 3.03 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "супер мам женщин"
]
8 17.33 ms
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
]

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.