Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
222.19 ms
(67.21%)
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
  391150
  506021
  465996
  553189
  568293
  545491
  426479
  451090
  509837
  528669
  812279
  495179
  436758
  456627
  521172
  527766
  504279
  566886
  453982
  495489
  426480
  598557
  804422
  547881
  485604
  824683
  478947
  523903
  456634
  405709
  149815
  444662
  557360
  692421
  553601
  482923
  553517
  553591
  482919
  570956
  476428
  553545
  446264
  451089
  550507
  456630
  500508
  553554
  504196
  448925
  516772
  499587
  470535
  557978
  511040
  502858
  667250
  557946
  423913
  426616
  444288
  419198
]
76.67 ms
(23.19%)
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
  149815
  391150
  405709
  419198
  423913
  426479
  426480
  426616
  436758
  444288
  444662
  446264
  448925
  451089
  451090
  453982
  456627
  456630
  456634
  465996
  470535
  476428
  478947
  482919
  482923
  485604
  495179
  495489
  499587
  500508
  502858
  504196
  504279
  506021
  509837
  511040
  516772
  521172
  523903
  527766
  528669
  545491
  547881
  550507
  553189
  553517
  553545
  553554
  553591
  553601
  557360
  557946
  557978
  566886
  568293
  570956
  598557
  667250
  692421
  804422
  812279
  824683
]
22.79 ms
(6.89%)
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:
[
  "hidden girl cam"
  "hidden girl cam"
  "hidden girl cam"
  20
]
2.45 ms
(0.74%)
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
  149815
  391150
  405709
  419198
  423913
  426479
  426480
  426616
  436758
  444288
  444662
  446264
  448925
  451089
  451090
  453982
  456627
  456630
  456634
  465996
  470535
  476428
  478947
  482919
  482923
  485604
  495179
  495489
  499587
  500508
  502858
  504196
  504279
  506021
  509837
  511040
  516772
  521172
  523903
  527766
  528669
  545491
  547881
  550507
  553189
  553517
  553545
  553554
  553591
  553601
  557360
  557946
  557978
  566886
  568293
  570956
  598557
  667250
  692421
  804422
  812279
  824683
]
1.85 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hidden girl cam"
]
1.72 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт девушк cam"
]
1.49 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "скрыт девушк cam"
]
1.45 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.