Query Metrics
5
Database Queries
5
Different statements
1285.36 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.98 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
| 2 | 654.19 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 360
Parameters:
[ 1 2 0 10 0 ] |
| 3 | 2.81 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 832913 824693 828876 826783 831184 826378 833398 832405 828416 827167 829775 829864 832937 829929 833550 824742 825539 826710 828347 824783 832602 833657 826933 824382 827207 830273 827856 833467 827413 826543 832554 825366 832952 831411 833275 828485 829722 833067 829733 827402 832227 824764 831203 830269 829788 827229 829902 827957 830211 823956 826528 833578 824213 833829 829253 824519 828601 826911 831752 831240 831922 830668 825412 826996 825223 833165 825808 831170 826611 833441 833764 829882 833885 830290 824868 823882 830299 832353 833709 827840 832477 825416 826314 829820 831604 830539 826892 824958 830141 829693 831931 828811 830043 826235 824994 825394 831158 829772 831092 825068 824175 833867 833265 831927 827273 826164 825404 831810 824634 828810 828691 828682 830030 828801 831751 832482 826161 833266 824140 833368 ] |
| 4 | 130.65 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 832913 824693 828876 826783 831184 826378 833398 832405 828416 827167 829775 829864 832937 829929 833550 824742 825539 826710 828347 824783 832602 833657 826933 824382 827207 830273 827856 833467 827413 826543 832554 825366 832952 831411 833275 828485 829722 833067 829733 827402 832227 824764 831203 830269 829788 827229 829902 827957 830211 823956 826528 833578 824213 833829 829253 824519 828601 826911 831752 831240 831922 830668 825412 826996 825223 833165 825808 831170 826611 833441 833764 829882 833885 830290 824868 823882 830299 832353 833709 827840 832477 825416 826314 829820 831604 830539 826892 824958 830141 829693 831931 828811 830043 826235 824994 825394 831158 829772 831092 825068 824175 833867 833265 831927 827273 826164 825404 831810 824634 828810 828691 828682 830030 828801 831751 832482 826161 833266 824140 833368 ] |
| 5 | 495.73 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.