Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
74.67 ms
(48.98%)
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
  406371
  418522
  426816
  428711
  439815
  441099
  451758
  457141
  457998
  464874
  469738
  504389
  510674
  516666
  523757
  528413
  531106
  532645
  536689
  540326
  541440
  545601
  598937
  600026
  600297
  610540
  628399
  628409
  632601
  634765
  636284
  637007
  643112
  644973
  646007
  647975
  648837
  662129
  679717
  679785
  689358
  707250
  725570
  728367
  738531
  740647
  742633
  761463
  769890
  778970
  785761
  796152
  814429
  814431
  815658
  827897
]
58.90 ms
(38.64%)
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:
[
  "anal foot"
  "anal foot"
  "anal foot"
  20
]
9.41 ms
(6.17%)
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
  610540
  457998
  644973
  628399
  738531
  647975
  540326
  637007
  814429
  634765
  728367
  796152
  778970
  742633
  457141
  769890
  725570
  785761
  815658
  464874
  662129
  707250
  827897
  426816
  814431
  740647
  504389
  451758
  689358
  761463
  516666
  510674
  679785
  541440
  598937
  628409
  643112
  528413
  679717
  536689
  418522
  441099
  531106
  545601
  406371
  469738
  646007
  439815
  636284
  600026
  532645
  600297
  632601
  428711
  648837
  523757
]
2.35 ms
(1.54%)
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
  406371
  418522
  426816
  428711
  439815
  441099
  451758
  457141
  457998
  464874
  469738
  504389
  510674
  516666
  523757
  528413
  531106
  532645
  536689
  540326
  541440
  545601
  598937
  600026
  600297
  610540
  628399
  628409
  632601
  634765
  636284
  637007
  643112
  644973
  646007
  647975
  648837
  662129
  679717
  679785
  689358
  707250
  725570
  728367
  738531
  740647
  742633
  761463
  769890
  778970
  785761
  796152
  814429
  814431
  815658
  827897
]
1.98 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal foot"
]
1.85 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал foot"
]
1.75 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал foot"
]

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.