Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.19 ms
(85.53%)
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
  387270
  425679
  442624
  443463
  445780
  459497
  459504
  462835
  466367
  486082
  492673
  504840
  506423
  519931
  525386
  540317
  540319
  540932
  541605
  552695
  558042
  564408
  564420
  564424
  566750
  567922
  569140
  571446
  581681
  603144
  628375
  662796
  665908
  677322
  709036
  714444
  721310
  721373
  722764
  722805
  722869
  761033
  782521
  785606
  786211
  786802
  795547
  826667
]
8.43 ms
(5.37%)
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
  761033
  786211
  722805
  826667
  540319
  786802
  722764
  445780
  709036
  566750
  782521
  540317
  721373
  721310
  714444
  722869
  492673
  425679
  558042
  571446
  564408
  567922
  677322
  662796
  665908
  785606
  795547
  442624
  443463
  387270
  564424
  552695
  564420
  603144
  628375
  462835
  459504
  506423
  525386
  569140
  459497
  581681
  466367
  486082
  540932
  541605
  519931
  504840
]
5.58 ms
(3.56%)
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:
[
  "skinny teenage"
  "skinny teenage"
  "skinny teenage"
  20
]
2.61 ms
(1.66%)
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
  387270
  425679
  442624
  443463
  445780
  459497
  459504
  462835
  466367
  486082
  492673
  504840
  506423
  519931
  525386
  540317
  540319
  540932
  541605
  552695
  558042
  564408
  564420
  564424
  566750
  567922
  569140
  571446
  581681
  603144
  628375
  662796
  665908
  677322
  709036
  714444
  721310
  721373
  722764
  722805
  722869
  761033
  782521
  785606
  786211
  786802
  795547
  826667
]
1.77 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny teenage"
]
1.65 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые teenage"
]
1.39 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые teenage"
]
1.27 ms
(0.81%)
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.