Query Metrics
7
Database Queries
7
Different statements
177.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.63 ms (86.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 398057 414062 448082 469602 520764 529753 530958 531794 534477 534538 535185 535552 538505 546057 546836 548940 548947 548957 550904 568210 568289 573734 584164 586005 588854 588929 590806 594267 599134 602233 604181 604659 607963 623207 628205 632125 633300 634067 639315 639363 641231 642165 655211 656851 656875 657528 658785 658850 660043 660384 660580 660831 663317 664572 664717 673947 679643 681746 683494 687399 691286 692943 705798 707867 710236 711133 711628 712174 713858 717553 722284 722403 726164 731595 737055 740909 742297 745113 745448 745457 748653 749268 750565 751438 752595 752647 756830 759474 761430 770258 770400 783740 783948 783962 784743 785549 785813 787505 789219 790134 792064 792092 793255 793292 793297 796486 800540 803124 803633 806631 807586 808328 809351 813195 816184 819418 820071 824766 824927 826941 ] |
||||||||||||||||||||||||||||||
|
12.71 ms (7.14%) |
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 642165 824927 826941 819418 820071 531794 534477 529753 535185 546836 568289 656851 683494 722284 548940 548947 623207 783740 745113 756830 783948 792064 588854 660384 664572 663317 639315 604659 785813 803633 731595 632125 785549 657528 816184 687399 722403 809351 789219 796486 448082 530958 568210 660831 656875 660580 633300 705798 711133 713858 573734 398057 414062 824766 469602 546057 550904 584164 658850 658785 673947 691286 710236 660043 664717 711628 548957 641231 634067 639363 588929 590806 808328 745448 748653 751438 752595 752647 787505 726164 770258 742297 749268 750565 770400 793292 792092 534538 599134 745457 602233 586005 535552 717553 655211 793255 761430 783962 759474 737055 538505 793297 800540 806631 790134 807586 740909 803124 813195 520764 679643 692943 681746 604181 594267 712174 784743 707867 628205 607963 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.88%) |
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 398057 414062 448082 469602 520764 529753 530958 531794 534477 534538 535185 535552 538505 546057 546836 548940 548947 548957 550904 568210 568289 573734 584164 586005 588854 588929 590806 594267 599134 602233 604181 604659 607963 623207 628205 632125 633300 634067 639315 639363 641231 642165 655211 656851 656875 657528 658785 658850 660043 660384 660580 660831 663317 664572 664717 673947 679643 681746 683494 687399 691286 692943 705798 707867 710236 711133 711628 712174 713858 717553 722284 722403 726164 731595 737055 740909 742297 745113 745448 745457 748653 749268 750565 751438 752595 752647 756830 759474 761430 770258 770400 783740 783948 783962 784743 785549 785813 787505 789219 790134 792064 792092 793255 793292 793297 796486 800540 803124 803633 806631 807586 808328 809351 813195 816184 819418 820071 824766 824927 826941 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade anal solo"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск анал соло"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск анал соло"
]
|
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.