Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
108.26 ms
(81.66%)
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
  501283
  519690
  524564
  530681
  536666
  537900
  540294
  557541
  557544
  559961
  593992
  614029
  632042
  635185
  637664
  637751
  639292
  639938
  646239
  647860
  662144
  666899
  666901
  666902
  666903
  666904
  679826
  708519
  717318
  744869
  747646
  747658
  748531
  769773
  769866
  770370
  770376
  770388
  770389
  770392
  770393
  771364
  771816
  771829
  775899
  776054
  778593
  787344
  789873
  799647
  801278
  803085
  804953
  820762
  820775
  821851
  825689
]
9.42 ms
(7.11%)
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
  769773
  789873
  540294
  804953
  770388
  801278
  662144
  744869
  770393
  537900
  557541
  635185
  639938
  778593
  770370
  747658
  770389
  771364
  747646
  769866
  770376
  799647
  632042
  770392
  771829
  708519
  776054
  787344
  557544
  530681
  666899
  666903
  748531
  717318
  536666
  646239
  666904
  666901
  666902
  639292
  803085
  593992
  825689
  775899
  614029
  771816
  559961
  637664
  519690
  820775
  821851
  637751
  679826
  501283
  524564
  820762
  647860
]
5.17 ms
(3.90%)
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:
[
  "eden ivy 2022"
  "eden ivy 2022"
  "eden ivy 2022"
  20
]
2.61 ms
(1.97%)
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
  501283
  519690
  524564
  530681
  536666
  537900
  540294
  557541
  557544
  559961
  593992
  614029
  632042
  635185
  637664
  637751
  639292
  639938
  646239
  647860
  662144
  666899
  666901
  666902
  666903
  666904
  679826
  708519
  717318
  744869
  747646
  747658
  748531
  769773
  769866
  770370
  770376
  770388
  770389
  770392
  770393
  771364
  771816
  771829
  775899
  776054
  778593
  787344
  789873
  799647
  801278
  803085
  804953
  820762
  820775
  821851
  825689
]
2.11 ms
(1.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "eden ivy 2022"
]
1.78 ms
(1.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "edenivy"
]
1.69 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "edenivy"
]

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.