Query Metrics
7
Database Queries
7
Different statements
173.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.13 ms (84.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 382881 385341 408657 417639 421030 421963 424517 425727 435931 435933 437547 440707 447275 448733 452199 452577 453704 453982 472665 480801 481666 482895 484217 485967 488368 497656 498110 498326 503774 504779 508217 511897 512381 513095 513953 515853 517065 522525 524148 525252 525632 526216 526939 527355 527643 542300 552048 555720 557932 560941 562598 563037 563062 564524 565931 566813 567211 567583 569579 569824 571672 576718 578606 578816 588139 599720 602676 604467 606731 606759 616521 616559 617614 621198 621456 622390 622785 624139 628956 631980 638561 663854 666021 671660 680906 710223 711497 714153 720462 722536 736652 738771 745037 745827 748766 756190 756861 759373 759576 760202 765347 768663 769378 778277 780571 785288 786163 788607 788896 789213 789857 795594 797871 798954 804763 808603 810197 810564 810747 814120 ] |
||||||||||||||||||||||||||||||
|
16.80 ms (9.70%) |
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 759373 435933 508217 564524 680906 720462 756861 425727 382881 385341 435931 552048 569579 453982 617614 798954 563037 616521 498326 789213 786163 789857 810564 745037 748766 622390 711497 484217 515853 567583 602676 797871 482895 408657 447275 448733 666021 578606 588139 745827 517065 621456 621198 788607 814120 525252 542300 569824 671660 710223 756190 785288 759576 714153 810197 417639 424517 453704 557932 578816 622785 638561 616559 503774 722536 780571 765347 769378 778277 804763 481666 599720 624139 808603 485967 524148 527643 497656 768663 488368 571672 631980 810747 736652 738771 795594 452577 440707 437547 512381 563062 565931 567211 628956 421963 526939 526216 576718 511897 562598 421030 472665 555720 788896 760202 480801 560941 513095 525632 498110 504779 513953 663854 606731 522525 527355 452199 566813 606759 604467 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.34%) |
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 382881 385341 408657 417639 421030 421963 424517 425727 435931 435933 437547 440707 447275 448733 452199 452577 453704 453982 472665 480801 481666 482895 484217 485967 488368 497656 498110 498326 503774 504779 508217 511897 512381 513095 513953 515853 517065 522525 524148 525252 525632 526216 526939 527355 527643 542300 552048 555720 557932 560941 562598 563037 563062 564524 565931 566813 567211 567583 569579 569824 571672 576718 578606 578816 588139 599720 602676 604467 606731 606759 616521 616559 617614 621198 621456 622390 622785 624139 628956 631980 638561 663854 666021 671660 680906 710223 711497 714153 720462 722536 736652 738771 745037 745827 748766 756190 756861 759373 759576 760202 765347 768663 769378 778277 780571 785288 786163 788607 788896 789213 789857 795594 797871 798954 804763 808603 810197 810564 810747 814120 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife cheats"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен cheats"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен cheats"
]
|
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.