Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
109.52 ms
(68.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
  12068
  185353
  384269
  384775
  385984
  386974
  421366
  442552
  446397
  453801
  455377
  462268
  462550
  462722
  473330
  482068
  483340
  484516
  488692
  493479
  495166
  495982
  501442
  503870
  509430
  518722
  520953
  524929
  561427
  561882
  568351
  569886
  570896
  571557
  580029
  580640
  598688
  610374
  614671
  621294
  643456
  651929
  655348
  655624
  657375
  671458
  686089
  689978
  693302
  697126
  722799
  730782
  758760
  770599
  791442
  799728
  810463
  814175
  824735
]
30.87 ms
(19.33%)
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:
[
  "nice pussy russian"
  "nice pussy russian"
  "nice pussy russian"
  20
]
10.71 ms
(6.70%)
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
  12068
  799728
  730782
  758760
  657375
  185353
  810463
  386974
  568351
  385984
  484516
  722799
  598688
  384775
  462722
  655624
  571557
  580640
  561882
  524929
  824735
  697126
  610374
  791442
  580029
  655348
  482068
  421366
  671458
  693302
  462550
  561427
  770599
  446397
  473330
  520953
  488692
  495166
  453801
  503870
  442552
  493479
  483340
  686089
  614671
  384269
  455377
  501442
  495982
  462268
  518722
  569886
  689978
  643456
  509430
  814175
  570896
  621294
  651929
]
2.71 ms
(1.70%)
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
  12068
  185353
  384269
  384775
  385984
  386974
  421366
  442552
  446397
  453801
  455377
  462268
  462550
  462722
  473330
  482068
  483340
  484516
  488692
  493479
  495166
  495982
  501442
  503870
  509430
  518722
  520953
  524929
  561427
  561882
  568351
  569886
  570896
  571557
  580029
  580640
  598688
  610374
  614671
  621294
  643456
  651929
  655348
  655624
  657375
  671458
  686089
  689978
  693302
  697126
  722799
  730782
  758760
  770599
  791442
  799728
  810463
  814175
  824735
]
1.59 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "nice pussy русск"
]
1.55 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "nice pussy russian"
]
1.43 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "nice pussy русск"
]

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.