Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.71 ms
(58.67%)
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
  395685
  405485
  415878
  418270
  419475
  426456
  432637
  433047
  438424
  462483
  467088
  469470
  479798
  492133
  492268
  498404
  500716
  502306
  503967
  513357
  516034
  516885
  516975
  519198
  520986
  521381
  523226
  523761
  526601
  528399
  528710
  536726
  537487
  537591
  542505
  545779
  550579
  556830
  560664
  564726
  565782
  568641
  580223
  583553
  601077
  603831
  608049
  610661
  614097
  618394
  644748
  657543
  726543
  726553
  792558
  809930
  810933
  814901
  820938
]
102.92 ms
(28.52%)
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
  395685
  405485
  415878
  418270
  419475
  426456
  432637
  433047
  438424
  462483
  467088
  469470
  479798
  492133
  492268
  498404
  500716
  502306
  503967
  513357
  516034
  516885
  516975
  519198
  520986
  521381
  523226
  523761
  526601
  528399
  528710
  536726
  537487
  537591
  542505
  545779
  550579
  556830
  560664
  564726
  565782
  568641
  580223
  583553
  601077
  603831
  608049
  610661
  614097
  618394
  644748
  657543
  726543
  726553
  792558
  809930
  810933
  814901
  820938
]
27.90 ms
(7.73%)
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:
[
  "hot milf latina"
  "hot milf latina"
  "hot milf latina"
  20
]
11.46 ms
(3.18%)
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
  432637
  479798
  469470
  526601
  536726
  502306
  516034
  516975
  523226
  545779
  564726
  568641
  565782
  614097
  618394
  601077
  792558
  395685
  492133
  583553
  500716
  820938
  426456
  513357
  520986
  492268
  560664
  580223
  603831
  644748
  726543
  726553
  419475
  433047
  467088
  498404
  521381
  537487
  550579
  610661
  462483
  438424
  657543
  608049
  814901
  503967
  809930
  415878
  537591
  542505
  418270
  523761
  528399
  516885
  556830
  519198
  405485
  528710
  810933
]
1.86 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot milf латинская"
]
1.65 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot milf latina"
]
1.50 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot milf латинская"
]

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.