Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
67.05 ms
(51.21%)
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
  239555
  392576
  425043
  425640
  426412
  428192
  429084
  430404
  454558
  463614
  463625
  464487
  465352
  465840
  481942
  487513
  489325
  490916
  492269
  495198
  500796
  506132
  508593
  510301
  514811
  514980
  516712
  518089
  520803
  523387
  523404
  524460
  527447
  528401
  533957
  533958
  535369
  538007
  561086
  573304
  589591
  610635
  643523
  790799
]
42.36 ms
(32.36%)
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:
[
  "blonde mom shower"
  "blonde mom shower"
  "blonde mom shower"
  20
]
12.01 ms
(9.17%)
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
  610635
  392576
  425640
  481942
  516712
  518089
  533958
  523387
  500796
  538007
  239555
  508593
  573304
  561086
  790799
  428192
  426412
  454558
  465352
  489325
  523404
  514811
  533957
  463625
  490916
  643523
  425043
  524460
  535369
  589591
  464487
  463614
  465840
  487513
  528401
  510301
  492269
  495198
  506132
  430404
  527447
  514980
  520803
  429084
]
2.96 ms
(2.26%)
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
  239555
  392576
  425043
  425640
  426412
  428192
  429084
  430404
  454558
  463614
  463625
  464487
  465352
  465840
  481942
  487513
  489325
  490916
  492269
  495198
  500796
  506132
  508593
  510301
  514811
  514980
  516712
  518089
  520803
  523387
  523404
  524460
  527447
  528401
  533957
  533958
  535369
  538007
  561086
  573304
  589591
  610635
  643523
  790799
]
1.86 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blonde mom shower"
]
1.60 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "беловолосая mom shower"
]
1.56 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "беловолосая mom shower"
]
1.52 ms
(1.16%)
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.