Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.94 ms
(71.31%)
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
  145635
  423812
  475379
  475420
  477619
  514731
  518822
  520524
  526544
  535543
  556756
  557050
  559216
  570868
  573289
  577823
  579381
  595548
  600125
  604846
  624751
  630879
  641319
  643488
  671558
  677914
  699877
  713240
  733428
  742671
  744188
  746103
  746774
  751111
  764268
  777006
  781945
  783247
  783290
  783564
  787133
  789492
  790485
  790710
  813895
  814363
  825366
  826714
]
9.13 ms
(9.17%)
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:
[
  "sexy masturbate"
  "sexy masturbate"
  "sexy masturbate"
  20
]
8.70 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
  145635
  570868
  783247
  595548
  641319
  751111
  423812
  789492
  825366
  813895
  630879
  746103
  744188
  826714
  677914
  699877
  604846
  783564
  787133
  783290
  814363
  520524
  671558
  624751
  733428
  764268
  713240
  781945
  556756
  579381
  573289
  557050
  600125
  777006
  742671
  790485
  790710
  514731
  526544
  535543
  559216
  643488
  477619
  518822
  475420
  746774
  475379
  577823
]
3.62 ms
(3.64%)
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
  145635
  423812
  475379
  475420
  477619
  514731
  518822
  520524
  526544
  535543
  556756
  557050
  559216
  570868
  573289
  577823
  579381
  595548
  600125
  604846
  624751
  630879
  641319
  643488
  671558
  677914
  699877
  713240
  733428
  742671
  744188
  746103
  746774
  751111
  764268
  777006
  781945
  783247
  783290
  783564
  787133
  789492
  790485
  790710
  813895
  814363
  825366
  826714
]
1.90 ms
(1.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy masturbate"
]
1.88 ms
(1.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy masturbate"
]
1.47 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy masturbate"
]

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.