Query Metrics
7
Database Queries
7
Different statements
153.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.54 ms (83.66%) |
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 33974 59488 91890 194224 377154 382594 389479 392037 394931 395515 395686 410712 413499 439640 441017 445833 450635 455733 458199 462490 462691 462785 473799 475220 482367 485481 486298 486672 487092 491406 503828 503944 504854 506049 506467 510617 513751 520545 521454 525100 525102 525109 526188 530779 531614 539109 539192 543144 547065 550589 551640 553109 564154 565455 566046 566047 571999 573184 574162 574179 577399 578814 586628 588309 589761 591875 594920 597142 600035 604159 605892 605930 611249 618895 618906 619773 621504 621543 623279 625417 632356 638346 640892 662456 665468 667860 670501 673330 679444 687121 689622 689634 694387 696311 723828 734375 738917 744315 748255 757040 778724 789170 789325 789997 794791 798901 798905 799016 799020 800864 802233 807313 814159 817394 817396 817413 817463 818733 818777 818789 ] |
||||||||||||||||||||||||||||||
|
15.60 ms (10.15%) |
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 458199 445833 382594 818777 687121 798901 789170 513751 521454 525100 475220 577399 547065 689622 632356 591875 506467 503828 551640 640892 462490 450635 503944 510617 395515 817396 531614 670501 565455 605930 778724 723828 757040 734375 623279 91890 504854 564154 600035 395686 410712 413499 491406 530779 571999 574162 543144 673330 566047 597142 604159 621543 611249 594920 618895 748255 441017 486672 525109 487092 814159 818789 550589 667860 605892 789997 789325 799020 738917 798905 33974 392037 473799 439640 744315 817394 506049 539109 662456 696311 638346 794791 807313 799016 485481 462785 526188 539192 574179 566046 689634 589761 621504 625417 588309 618906 389479 525102 482367 462691 394931 817413 818733 817463 553109 573184 679444 694387 665468 578814 619773 800864 802233 377154 455733 59488 194224 520545 586628 486298 ] |
||||||||||||||||||||||||||||||
|
2.89 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 33974 59488 91890 194224 377154 382594 389479 392037 394931 395515 395686 410712 413499 439640 441017 445833 450635 455733 458199 462490 462691 462785 473799 475220 482367 485481 486298 486672 487092 491406 503828 503944 504854 506049 506467 510617 513751 520545 521454 525100 525102 525109 526188 530779 531614 539109 539192 543144 547065 550589 551640 553109 564154 565455 566046 566047 571999 573184 574162 574179 577399 578814 586628 588309 589761 591875 594920 597142 600035 604159 605892 605930 611249 618895 618906 619773 621504 621543 623279 625417 632356 638346 640892 662456 665468 667860 670501 673330 679444 687121 689622 689634 694387 696311 723828 734375 738917 744315 748255 757040 778724 789170 789325 789997 794791 798901 798905 799016 799020 800864 802233 807313 814159 817394 817396 817413 817463 818733 818777 818789 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"car young"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вмашин young"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.93%) |
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.