Query Metrics
5
Database Queries
5
Different statements
787.03 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.53 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
| 2 | 12.72 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 max_ctr DESC LIMIT 120 OFFSET 240
Parameters:
[ 1 2 0 10 0 ] |
| 3 | 3.06 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 758239 757140 756273 746037 745771 745243 743749 737046 731088 722493 712832 711337 710524 677689 662897 659164 656633 629887 610076 609040 587989 583138 559199 555847 549955 549940 544981 520148 517901 516366 491637 471434 460608 452107 417362 381848 693849 692454 672982 515319 553547 759366 549971 455339 718974 643214 762951 746460 742306 583906 525582 413223 131776 624002 515024 385655 629560 571754 552327 690040 538735 759577 515455 765612 684235 664390 524560 446298 515258 452634 768955 745696 745685 667146 664658 661897 544920 469042 550592 408765 520994 789061 704727 505384 464266 454873 397256 737133 576564 563894 485773 415566 534939 518948 384493 514730 526701 750684 691201 387716 385632 524882 693816 523654 400656 385449 483368 415746 384084 485774 782043 780760 779166 776503 775250 773791 771038 768822 767996 767797 ] |
| 4 | 233.52 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 758239 757140 756273 746037 745771 745243 743749 737046 731088 722493 712832 711337 710524 677689 662897 659164 656633 629887 610076 609040 587989 583138 559199 555847 549955 549940 544981 520148 517901 516366 491637 471434 460608 452107 417362 381848 693849 692454 672982 515319 553547 759366 549971 455339 718974 643214 762951 746460 742306 583906 525582 413223 131776 624002 515024 385655 629560 571754 552327 690040 538735 759577 515455 765612 684235 664390 524560 446298 515258 452634 768955 745696 745685 667146 664658 661897 544920 469042 550592 408765 520994 789061 704727 505384 464266 454873 397256 737133 576564 563894 485773 415566 534939 518948 384493 514730 526701 750684 691201 387716 385632 524882 693816 523654 400656 385449 483368 415746 384084 485774 782043 780760 779166 776503 775250 773791 771038 768822 767996 767797 ] |
| 5 | 536.21 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.