Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
84.93 ms
(64.45%)
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
  418941
  422633
  423205
  430444
  434369
  441645
  444660
  464887
  476753
  477773
  481803
  484065
  487435
  491823
  497951
  504765
  509345
  509997
  513736
  517665
  518131
  523492
  524931
  525154
  526906
  530690
  544686
  556037
  556327
  558127
  565256
  569520
  572333
  575197
  579389
  582376
  602519
  603810
  603875
  606002
  606762
  607256
  610404
  621410
  622666
  628126
  628282
  633446
  633449
  634482
  640813
  651938
  652263
  662137
  676020
  688581
]
25.19 ms
(19.12%)
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:
[
  "little dick fuck"
  "little dick fuck"
  "little dick fuck"
  20
]
10.67 ms
(8.10%)
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
  569520
  497951
  476753
  633446
  621410
  441645
  444660
  579389
  688581
  423205
  422633
  504765
  484065
  572333
  526906
  634482
  628282
  524931
  610404
  487435
  509997
  518131
  418941
  509345
  464887
  602519
  622666
  662137
  565256
  606002
  652263
  530690
  556037
  430444
  523492
  676020
  651938
  633449
  513736
  525154
  434369
  640813
  556327
  582376
  481803
  558127
  544686
  517665
  628126
  477773
  603875
  607256
  575197
  491823
  606762
  603810
]
3.41 ms
(2.59%)
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
  418941
  422633
  423205
  430444
  434369
  441645
  444660
  464887
  476753
  477773
  481803
  484065
  487435
  491823
  497951
  504765
  509345
  509997
  513736
  517665
  518131
  523492
  524931
  525154
  526906
  530690
  544686
  556037
  556327
  558127
  565256
  569520
  572333
  575197
  579389
  582376
  602519
  603810
  603875
  606002
  606762
  607256
  610404
  621410
  622666
  628126
  628282
  633446
  633449
  634482
  640813
  651938
  652263
  662137
  676020
  688581
]
1.96 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "little dick fuck"
]
1.89 ms
(1.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(1.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "little член секс"
]
1.86 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "little член секс"
]

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.