Query Metrics
7
Database Queries
7
Different statements
207.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.94 ms (83.90%) |
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 185401 392037 411619 418957 422500 422582 422901 423018 428137 430616 443158 446007 446266 448692 449859 450582 453305 455026 456482 458312 461394 465051 465386 467532 468091 468736 471065 471411 474138 479103 479522 481785 484407 484451 485265 485731 486958 487315 490210 491647 493391 494573 504176 505822 505826 507081 517004 518854 523159 523172 525119 525890 526698 533998 536668 539465 541605 544464 546375 552203 555893 559692 563232 565096 565147 565578 566030 570747 572551 575123 576082 580727 586563 591640 592479 601844 623574 624366 662653 663419 664792 664825 665142 666834 667266 667851 669766 673791 681215 683438 689949 697220 705129 711893 712987 721470 733879 741653 746107 746110 750216 759747 766564 781688 781749 782153 782183 782262 788479 788703 789974 789983 799364 803665 806291 807600 808453 811401 814817 818661 ] |
||||||||||||||||||||||||||||||
|
23.41 ms (11.29%) |
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 624366 789974 781749 782153 782262 789983 746107 705129 788479 788703 803665 507081 555893 681215 443158 814817 453305 446007 448692 468736 471411 518854 533998 570747 544464 563232 673791 665142 546375 565147 572551 586563 601844 479522 428137 458312 461394 467532 468091 411619 455026 471065 479103 430616 486958 484451 539465 523172 525890 484407 490210 185401 418957 818661 552203 566030 663419 666834 667851 669766 697220 712987 664792 721470 664825 667266 689949 782183 799364 807600 808453 811401 766564 781688 806291 741653 750216 759747 746110 465386 450582 392037 494573 485265 422901 422500 423018 422582 446266 523159 536668 525119 576082 541605 559692 580727 662653 683438 711893 565096 575123 591640 592479 623574 733879 481785 465051 487315 491647 517004 474138 493391 456482 485731 449859 505826 526698 504176 505822 565578 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.29%) |
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 185401 392037 411619 418957 422500 422582 422901 423018 428137 430616 443158 446007 446266 448692 449859 450582 453305 455026 456482 458312 461394 465051 465386 467532 468091 468736 471065 471411 474138 479103 479522 481785 484407 484451 485265 485731 486958 487315 490210 491647 493391 494573 504176 505822 505826 507081 517004 518854 523159 523172 525119 525890 526698 533998 536668 539465 541605 544464 546375 552203 555893 559692 563232 565096 565147 565578 566030 570747 572551 575123 576082 580727 586563 591640 592479 601844 623574 624366 662653 663419 664792 664825 665142 666834 667266 667851 669766 673791 681215 683438 689949 697220 705129 711893 712987 721470 733879 741653 746107 746110 750216 759747 766564 781688 781749 782153 782183 782262 788479 788703 789974 789983 799364 803665 806291 807600 808453 811401 814817 818661 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young ван"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young ван"
]
|
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.