Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
65.21 ms
(74.01%)
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
  187443
  385992
  387276
  397977
  423019
  423773
  432663
  443744
  451854
  476243
  488888
  512116
  515749
  540033
  540428
  542429
  550591
  551566
  558148
  564209
  567432
  571834
  589928
  589953
  589991
  614036
  638840
  644623
  714528
  717410
  719407
  730741
  731472
  746575
  759460
  765669
  766441
  774180
  778945
  780624
  781645
  782665
  789693
  790758
  805654
  806839
  808037
  824067
]
7.70 ms
(8.74%)
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
  387276
  823729
  730741
  790758
  638840
  808037
  780624
  397977
  542429
  731472
  782665
  746575
  589991
  644623
  774180
  806839
  550591
  589953
  589928
  778945
  805654
  781645
  759460
  765669
  714528
  423019
  187443
  766441
  423773
  540033
  824067
  789693
  488888
  432663
  540428
  551566
  717410
  564209
  476243
  443744
  558148
  719407
  451854
  385992
  512116
  567432
  614036
  515749
  571834
]
6.58 ms
(7.47%)
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:
[
  "body pantyhose"
  "body pantyhose"
  "body pantyhose"
  20
]
2.11 ms
(2.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "body pantyhose"
]
1.96 ms
(2.22%)
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
  187443
  385992
  387276
  397977
  423019
  423773
  432663
  443744
  451854
  476243
  488888
  512116
  515749
  540033
  540428
  542429
  550591
  551566
  558148
  564209
  567432
  571834
  589928
  589953
  589991
  614036
  638840
  644623
  714528
  717410
  719407
  730741
  731472
  746575
  759460
  765669
  766441
  774180
  778945
  780624
  781645
  782665
  789693
  790758
  805654
  806839
  808037
  824067
]
1.65 ms
(1.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "body pantyhose"
]
1.34 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "body pantyhose"
]

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.