Query Metrics
7
Database Queries
7
Different statements
169.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.24 ms (87.10%) |
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 103649 458356 464235 486145 488450 507536 507835 510860 514226 517290 537619 551660 554953 555430 559226 561908 566355 567940 572219 577602 579478 588121 595131 597220 615277 616019 616604 616771 619282 623804 624132 626840 632172 632788 634995 642259 644000 646726 655939 656518 663567 667120 668713 676757 680253 681530 683670 689239 693767 703247 706031 706555 707774 711585 712634 713833 717147 718130 718326 719473 719486 723819 727725 728964 729842 730419 734560 734778 737915 738962 739724 740646 740681 741854 744075 749628 751543 752647 757866 758395 758477 760217 760461 763785 764241 765759 766514 768337 770273 773445 778085 782774 783737 787490 787590 788378 789455 791601 794477 795053 795095 795302 795739 796778 797741 800118 800149 809698 811598 812785 813288 813720 819289 819964 824132 824325 824571 826220 826614 827166 ] |
||||||||||||||||||||||||||||||
|
12.25 ms (7.24%) |
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 749628 727725 766514 668713 676757 789455 809698 826220 819964 827166 819289 824132 824325 458356 510860 514226 517290 537619 464235 567940 577602 646726 689239 703247 707774 718326 719473 656518 680253 711585 713833 655939 667120 681530 683670 693767 588121 615277 616771 626840 632788 616019 597220 616604 634995 795095 813288 778085 783737 794477 723819 740681 758395 760461 787490 795739 797741 800118 728964 734560 734778 739724 729842 730419 763785 764241 737915 738962 744075 751543 765759 768337 623804 632172 706031 717147 782774 795302 572219 706555 642259 757866 770273 507835 811598 644000 788378 758477 773445 712634 795053 740646 760217 103649 826614 824571 813720 507536 486145 488450 579478 551660 555430 561908 566355 559226 663567 718130 719486 554953 624132 595131 619282 787590 796778 791601 800149 812785 741854 752647 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.78%) |
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 103649 458356 464235 486145 488450 507536 507835 510860 514226 517290 537619 551660 554953 555430 559226 561908 566355 567940 572219 577602 579478 588121 595131 597220 615277 616019 616604 616771 619282 623804 624132 626840 632172 632788 634995 642259 644000 646726 655939 656518 663567 667120 668713 676757 680253 681530 683670 689239 693767 703247 706031 706555 707774 711585 712634 713833 717147 718130 718326 719473 719486 723819 727725 728964 729842 730419 734560 734778 737915 738962 739724 740646 740681 741854 744075 749628 751543 752647 757866 758395 758477 760217 760461 763785 764241 765759 766514 768337 770273 773445 778085 782774 783737 787490 787590 788378 789455 791601 794477 795053 795095 795302 795739 796778 797741 800118 800149 809698 811598 812785 813288 813720 819289 819964 824132 824325 824571 826220 826614 827166 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"will have wife"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"have жен"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"have жен"
]
|
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.