Query Metrics
5
Database Queries
5
Different statements
1180.57 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.77 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
| 2 | 566.46 ms |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, 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.type = ? AND p.status = ? AND p.sexual_orientation = ? ORDER BY published_at DESC LIMIT 120 OFFSET 480
Parameters:
[ 1 2 0 10 0 ] |
| 3 | 2.42 ms |
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 829970 830243 833963 826770 832968 831579 829424 831618 832271 830238 824756 830622 832553 832663 824410 830629 826098 826586 823826 824865 832459 830287 832187 825484 829019 830106 827562 833425 832220 832733 828237 828719 824899 824854 833663 832984 823952 832331 828263 831797 831578 829413 829720 826536 832114 831827 825732 832528 829377 824787 832391 827243 831472 823972 833248 828677 825738 829835 831806 830339 833305 831349 825973 825125 823275 823517 828252 829386 825211 829958 830820 828673 831506 830352 826116 824115 828668 833141 831102 829186 824470 833684 826834 824099 830742 827676 825563 831315 830070 827960 830506 829350 831904 832925 824792 824028 823400 828619 831400 824067 831504 826464 829729 832341 824459 826233 830648 822735 831530 830182 823365 826100 826616 831124 831528 832894 828643 829778 827081 825260 ] |
| 4 | 115.62 ms |
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 829970 830243 833963 826770 832968 831579 829424 831618 832271 830238 824756 830622 832553 832663 824410 830629 826098 826586 823826 824865 832459 830287 832187 825484 829019 830106 827562 833425 832220 832733 828237 828719 824899 824854 833663 832984 823952 832331 828263 831797 831578 829413 829720 826536 832114 831827 825732 832528 829377 824787 832391 827243 831472 823972 833248 828677 825738 829835 831806 830339 833305 831349 825973 825125 823275 823517 828252 829386 825211 829958 830820 828673 831506 830352 826116 824115 828668 833141 831102 829186 824470 833684 826834 824099 830742 827676 825563 831315 830070 827960 830506 829350 831904 832925 824792 824028 823400 828619 831400 824067 831504 826464 829729 832341 824459 826233 830648 822735 831530 830182 823365 826100 826616 831124 831528 832894 828643 829778 827081 825260 ] |
| 5 | 494.31 ms |
SELECT COUNT(*) 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.type = ? AND p.status = ? AND p.sexual_orientation = ?
Parameters:
[ 1 2 0 10 0 ] |
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.