Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
71.16 ms
(69.78%)
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
  437994
  438044
  442735
  478571
  488465
  511245
  526255
  532351
  534624
  536478
  540660
  551457
  553683
  557810
  561552
  562436
  583924
  589196
  593857
  595090
  635641
  654891
  677892
  710808
  710936
  718527
  724671
  725252
  726379
  726455
  729003
  732586
  732735
  749309
  751472
  753981
  763623
  773539
  775258
  777322
  777627
  783390
  784014
  785329
  790183
  791954
  793763
  794971
  795860
  805643
  818307
  821834
  821852
  823927
  826293
  827163
]
11.96 ms
(11.73%)
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:
[
  "amateur cumslut"
  "amateur cumslut"
  "amateur cumslut"
  20
]
8.26 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
  763623
  724671
  589196
  557810
  751472
  710808
  777322
  785329
  827163
  795860
  561552
  790183
  534624
  783390
  793763
  710936
  635641
  823816
  794971
  791954
  777627
  729003
  583924
  726379
  718527
  732586
  562436
  654891
  818307
  749309
  437994
  488465
  595090
  725252
  753981
  805643
  826293
  540660
  823927
  775258
  821834
  551457
  593857
  784014
  726455
  438044
  553683
  677892
  821852
  536478
  773539
  478571
  511245
  732735
  442735
  532351
  526255
]
3.30 ms
(3.24%)
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
  437994
  438044
  442735
  478571
  488465
  511245
  526255
  532351
  534624
  536478
  540660
  551457
  553683
  557810
  561552
  562436
  583924
  589196
  593857
  595090
  635641
  654891
  677892
  710808
  710936
  718527
  724671
  725252
  726379
  726455
  729003
  732586
  732735
  749309
  751472
  753981
  763623
  773539
  775258
  777322
  777627
  783390
  784014
  785329
  790183
  791954
  793763
  794971
  795860
  805643
  818307
  821834
  821852
  823927
  826293
  827163
]
2.14 ms
(2.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur cumslut"
]
1.79 ms
(1.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск cumslut"
]
1.71 ms
(1.67%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск cumslut"
]

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.