Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
213.06 ms
(66.39%)
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
  418897
  442188
  442194
  442596
  465247
  475653
  477461
  481815
  485582
  493361
  502381
  504171
  507182
  515728
  520039
  525980
  527782
  530867
  530873
  530907
  535084
  539839
  539846
  539851
  544649
  544661
  550352
  550875
  550958
  551016
  562590
  562592
  563638
  566431
  572219
  574803
  575338
  585754
  586245
  586442
  588404
  604706
  605007
  617373
  624775
  633842
  653052
  692456
  715522
  726842
  732592
  771527
  802063
  803784
  807667
  827575
]
77.24 ms
(24.07%)
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
  418897
  442188
  442194
  442596
  465247
  475653
  477461
  481815
  485582
  493361
  502381
  504171
  507182
  515728
  520039
  525980
  527782
  530867
  530873
  530907
  535084
  539839
  539846
  539851
  544649
  544661
  550352
  550875
  550958
  551016
  562590
  562592
  563638
  566431
  572219
  574803
  575338
  585754
  586245
  586442
  588404
  604706
  605007
  617373
  624775
  633842
  653052
  692456
  715522
  726842
  732592
  771527
  802063
  803784
  807667
  827575
]
11.47 ms
(3.58%)
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
  692456
  624775
  827575
  550958
  715522
  562590
  807667
  544661
  633842
  544649
  732592
  442188
  477461
  520039
  572219
  539846
  585754
  726842
  539851
  550875
  530867
  551016
  802063
  771527
  588404
  527782
  530907
  418897
  475653
  485582
  550352
  563638
  604706
  617373
  539839
  530873
  586245
  481815
  566431
  502381
  575338
  803784
  465247
  504171
  525980
  562592
  586442
  605007
  515728
  442596
  507182
  493361
  574803
  442194
  653052
  535084
]
11.27 ms
(3.51%)
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:
[
  "homemade cuckolding"
  "homemade cuckolding"
  "homemade cuckolding"
  20
]
2.26 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade cuckolding"
]
1.94 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(0.58%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск cuckolding"
]
1.79 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск cuckolding"
]

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.