Query Metrics
7
Database Queries
7
Different statements
166.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.22 ms (84.33%) |
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 354122 386671 395520 397639 410193 415309 417046 417716 420882 439922 445766 453062 457645 464137 466675 470480 472966 486274 486698 490586 495303 496051 503109 504024 504853 506083 506978 507141 508740 514700 522674 525951 525979 534663 542321 546820 548321 551949 554052 554704 555661 555677 556593 556673 559785 562032 564242 564262 565826 569538 577545 577679 579455 580125 580956 581621 582514 594872 599791 603019 605225 606636 607244 614455 615014 615831 623352 627894 635223 642962 643668 644905 649913 661339 662480 663836 664655 669899 669905 685523 687616 695662 695674 696004 697934 701604 701628 707281 718600 719062 720474 732926 733506 734429 738352 739347 747187 748483 751422 753517 765577 769019 792623 798169 798821 798922 802122 802883 804636 808295 814715 823121 823794 824269 828266 828311 828371 828533 828643 ] |
||||||||||||||||||||||||||||||
|
16.54 ms (9.95%) |
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 386671 814715 562032 546559 555677 685523 695674 649913 663836 669899 696004 720474 669905 697934 701628 718600 623352 769019 765577 739347 486698 445766 542321 580956 551949 556673 606636 599791 607244 615831 490586 555661 695662 662480 614455 734429 751422 701604 644905 823121 507141 472966 546820 581621 635223 627894 804636 719062 417046 504024 823794 828266 828533 828643 738352 569538 661339 664655 615014 753517 506083 748483 495303 354122 747187 564262 732926 415309 457645 496051 453062 397639 582514 577679 556593 417716 514700 522674 525979 565826 554052 802122 580125 420882 470480 534663 504853 525951 577545 603019 439922 503109 643668 395520 506978 486274 579455 687616 707281 594872 798169 798821 808295 605225 410193 559785 554704 564242 824269 828371 828311 548321 792623 733506 508740 466675 464137 642962 802883 798922 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.57%) |
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 354122 386671 395520 397639 410193 415309 417046 417716 420882 439922 445766 453062 457645 464137 466675 470480 472966 486274 486698 490586 495303 496051 503109 504024 504853 506083 506978 507141 508740 514700 522674 525951 525979 534663 542321 546820 548321 551949 554052 554704 555661 555677 556593 556673 559785 562032 564242 564262 565826 569538 577545 577679 579455 580125 580956 581621 582514 594872 599791 603019 605225 606636 607244 614455 615014 615831 623352 627894 635223 642962 643668 644905 649913 661339 662480 663836 664655 669899 669905 685523 687616 695662 695674 696004 697934 701604 701628 707281 718600 719062 720474 732926 733506 734429 738352 739347 747187 748483 751422 753517 765577 769019 792623 798169 798821 798922 802122 802883 804636 808295 814715 823121 823794 824269 828266 828311 828371 828533 828643 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public agen big"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на agen улиц большие"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на agen улиц большие"
]
|
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.