Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
80.35 ms
(76.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
  439790
  440601
  447320
  454678
  455357
  455392
  466005
  469171
  483259
  492905
  513477
  526569
  530283
  533078
  534616
  535393
  535403
  540794
  549610
  554913
  575172
  576863
  581855
  585078
  602894
  614463
  619872
  634369
  639159
  661364
  709364
  712290
  748135
  751362
  752842
  757337
  767340
  772982
  772987
  783176
  789364
  793577
  804266
  804312
  811277
  817395
  823906
  824713
  825856
]
9.70 ms
(9.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
  767340
  783176
  709364
  824713
  752842
  793577
  804312
  447320
  751362
  534616
  581855
  455357
  823906
  533078
  772982
  530283
  549610
  772987
  712290
  748135
  585078
  576863
  789364
  817395
  757337
  634369
  804266
  825856
  811277
  492905
  469171
  619115
  535393
  661364
  575172
  614463
  526569
  619872
  454678
  602894
  540794
  466005
  483259
  440601
  439790
  535403
  639159
  554913
  455392
  513477
]
5.33 ms
(5.04%)
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:
[
  "transparent panties"
  "transparent panties"
  "transparent panties"
  20
]
3.14 ms
(2.97%)
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
  439790
  440601
  447320
  454678
  455357
  455392
  466005
  469171
  483259
  492905
  513477
  526569
  530283
  533078
  534616
  535393
  535403
  540794
  549610
  554913
  575172
  576863
  581855
  585078
  602894
  614463
  619872
  634369
  639159
  661364
  709364
  712290
  748135
  751362
  752842
  757337
  767340
  772982
  772987
  783176
  789364
  793577
  804266
  804312
  811277
  817395
  823906
  824713
  825856
]
2.15 ms
(2.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "transparent panties"
]
1.82 ms
(1.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.69%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "transparent трусик нижн бел"
]
1.43 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "transparent трусик нижн бел"
]

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.