Query Metrics
7
Database Queries
7
Different statements
208.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
183.32 ms (87.74%) |
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 408327 420781 422453 423060 427077 431740 433489 435420 436765 438692 441420 441615 443020 446388 448198 453310 453514 455067 457316 458056 462116 464268 466847 469740 480884 484011 488283 489084 492341 494603 499952 500649 502201 502852 503721 504846 509773 510331 514150 520337 523655 523716 524092 539475 541713 543330 545485 553142 553441 556977 562558 566129 570757 571370 577831 577887 579159 579855 582713 585835 587959 588568 591290 591936 594760 598885 599472 601218 602874 603792 603910 606668 608273 609992 615936 617211 618528 620812 624941 625037 625924 634229 642442 645369 648762 650075 661306 672851 673858 676432 685055 685131 687408 689191 696389 719573 727040 727673 729836 732774 738756 739905 743514 766342 766453 773926 776248 777823 784110 788905 799775 800003 803142 805254 806635 808380 810747 812774 817733 ] |
||||||||||||||||||||||||||||||
|
15.64 ms (7.49%) |
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 588568 598885 591936 594760 601218 606668 602874 608273 805254 603910 620812 625924 509773 817733 514150 520337 539475 566129 577887 645369 685131 648762 687408 799775 812774 784110 800003 766453 729836 738756 739905 766342 803142 806635 441420 422453 453514 462116 510331 525060 484011 503721 502201 571370 579159 562558 577831 672851 689191 661306 685055 696389 615936 624941 625037 587959 591290 603792 617211 469740 489084 499952 524092 541713 408327 423060 441615 488283 500649 523716 543330 545485 553441 579855 556977 570757 673858 650075 676432 553142 582713 585835 634229 642442 599472 609992 810747 776248 727673 773926 743514 727040 732774 618528 719573 777823 788905 808380 431740 443020 446388 453310 458056 466847 433489 435420 427077 457316 464268 420781 480884 504846 523655 502852 494603 492341 436765 438692 448198 455067 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.60%) |
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 408327 420781 422453 423060 427077 431740 433489 435420 436765 438692 441420 441615 443020 446388 448198 453310 453514 455067 457316 458056 462116 464268 466847 469740 480884 484011 488283 489084 492341 494603 499952 500649 502201 502852 503721 504846 509773 510331 514150 520337 523655 523716 524092 539475 541713 543330 545485 553142 553441 556977 562558 566129 570757 571370 577831 577887 579159 579855 582713 585835 587959 588568 591290 591936 594760 598885 599472 601218 602874 603792 603910 606668 608273 609992 615936 617211 618528 620812 624941 625037 625924 634229 642442 645369 648762 650075 661306 672851 673858 676432 685055 685131 687408 689191 696389 719573 727040 727673 729836 732774 738756 739905 743514 766342 766453 773926 776248 777823 784110 788905 799775 800003 803142 805254 806635 808380 810747 812774 817733 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade student"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск student"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск student"
]
|
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.