Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
60.56 ms
(63.58%)
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
  154240
  387026
  387749
  417674
  420515
  439960
  452363
  456131
  463090
  470726
  475199
  480457
  480501
  483739
  489376
  497696
  505891
  513808
  523181
  523762
  525519
  527360
  528452
  534839
  535404
  541409
  541440
  549800
  550942
  553832
  579677
  586713
  587272
  590102
  593034
  597123
  604286
  608491
  613356
  617003
  618514
  642403
  646167
  670372
  671043
  704222
  709215
  744947
  782892
  783312
  798685
  803524
  808655
  812757
  825864
]
17.46 ms
(18.33%)
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:
[
  "red stockings solo"
  "red stockings solo"
  "red stockings solo"
  20
]
8.21 ms
(8.62%)
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
  480457
  525519
  535404
  550942
  646167
  671043
  670372
  597123
  593034
  617003
  618514
  812757
  782892
  783312
  798685
  744947
  709215
  463090
  470726
  480501
  489376
  497689
  613356
  483739
  439960
  417674
  452363
  534839
  541409
  549800
  608491
  604286
  642403
  808655
  803524
  387026
  527360
  523762
  586713
  523181
  387749
  825864
  456131
  497696
  541440
  590102
  475199
  505891
  579677
  587272
  704222
  420515
  553832
  154240
  513808
  528452
]
2.22 ms
(2.33%)
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
  154240
  387026
  387749
  417674
  420515
  439960
  452363
  456131
  463090
  470726
  475199
  480457
  480501
  483739
  489376
  497696
  505891
  513808
  523181
  523762
  525519
  527360
  528452
  534839
  535404
  541409
  541440
  549800
  550942
  553832
  579677
  586713
  587272
  590102
  593034
  597123
  604286
  608491
  613356
  617003
  618514
  642403
  646167
  670372
  671043
  704222
  709215
  744947
  782892
  783312
  798685
  803524
  808655
  812757
  825864
]
1.93 ms
(2.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "red stockings solo"
]
1.76 ms
(1.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "red чулк нижн бел соло"
]
1.46 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "red чулк нижн бел соло"
]

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.