Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
82.52 ms
(70.44%)
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
  454706
  467122
  472299
  484260
  520474
  524325
  528915
  537531
  538264
  542537
  543434
  547525
  551935
  555942
  557438
  561345
  564504
  570151
  571469
  573536
  575710
  577101
  583662
  589664
  590265
  590975
  592318
  610138
  615145
  629276
  640148
  660687
  661580
  666114
  667253
  716965
  717274
  717278
  725408
  730110
  732009
  736226
  736509
  738175
  742535
  751667
  782015
  796822
  800445
  803154
  803292
  820096
]
15.08 ms
(12.87%)
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:
[
  "desi mother"
  "desi mother"
  "desi mother"
  20
]
9.17 ms
(7.83%)
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
  736226
  732009
  820096
  542537
  666114
  661580
  800445
  751667
  717274
  589664
  454706
  524325
  538264
  660687
  583662
  640148
  610138
  629276
  782015
  484260
  730110
  736509
  742535
  803154
  467122
  575710
  520474
  577101
  564504
  571469
  570151
  717278
  573536
  803292
  738175
  590975
  528915
  537531
  551935
  667253
  555942
  590265
  725408
  716965
  796822
  472299
  592318
  561345
  557438
  615145
  547525
  543434
]
2.99 ms
(2.55%)
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
  454706
  467122
  472299
  484260
  520474
  524325
  528915
  537531
  538264
  542537
  543434
  547525
  551935
  555942
  557438
  561345
  564504
  570151
  571469
  573536
  575710
  577101
  583662
  589664
  590265
  590975
  592318
  610138
  615145
  629276
  640148
  660687
  661580
  666114
  667253
  716965
  717274
  717278
  725408
  730110
  732009
  736226
  736509
  738175
  742535
  751667
  782015
  796822
  800445
  803154
  803292
  820096
]
2.25 ms
(1.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "desi mother"
]
1.93 ms
(1.64%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.39%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "desi мам женщин"
]
1.59 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "desi мам женщин"
]

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.