Query Metrics
7
Database Queries
7
Different statements
284.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
261.92 ms (92.22%) |
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 30883 197599 230821 346150 361382 413076 420703 442037 450835 451309 457721 478804 479682 487604 488342 490291 501541 503020 506306 511870 511950 524212 524744 535688 539078 540766 541963 542464 544540 544550 544552 545679 548412 549065 551660 551689 552429 554479 555302 555443 556172 556404 558799 559473 559890 559895 560304 560686 562032 562299 562450 563709 563710 564789 567750 568042 569811 570296 577084 580953 582056 583439 584773 587026 587060 592271 595326 596884 602177 607340 607533 611518 612516 616519 622309 622579 626213 635212 636049 636050 640503 645260 647534 647586 648378 654794 655628 655760 656027 659105 659250 662807 666966 675473 679078 684430 685926 687506 689113 689743 701188 704351 719033 722928 723071 748901 755000 763840 763861 766584 771951 779275 782597 785326 787585 790323 793782 797926 800900 810535 ] |
||||||||||||||||||||||||||||||
|
11.58 ms (4.08%) |
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 552429 562450 635212 636050 587026 587060 592271 595326 612516 596884 622579 626213 787585 790323 793782 779275 763840 763861 766584 771951 782597 797926 810535 755000 748901 607340 607533 640503 704351 722928 723071 785326 800900 197599 230821 361382 346150 30883 420703 442037 413076 450835 479682 457721 487604 490291 451309 503020 524744 540766 511870 524212 535688 506306 501541 511950 539078 478804 488342 541963 548412 551689 558799 562032 562299 567750 580953 583439 542464 544540 544552 545679 551660 555302 555443 556172 556404 559473 559895 563710 564789 582056 544550 549065 559890 560304 560686 568042 569811 577084 584773 648378 655628 659105 659250 662807 679078 689113 689743 701188 647534 655760 675473 684430 685926 687506 719033 645260 647586 654794 656027 666966 554479 563709 570296 602177 616519 636049 611518 622309 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (1.17%) |
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 30883 197599 230821 346150 361382 413076 420703 442037 450835 451309 457721 478804 479682 487604 488342 490291 501541 503020 506306 511870 511950 524212 524744 535688 539078 540766 541963 542464 544540 544550 544552 545679 548412 549065 551660 551689 552429 554479 555302 555443 556172 556404 558799 559473 559890 559895 560304 560686 562032 562299 562450 563709 563710 564789 567750 568042 569811 570296 577084 580953 582056 583439 584773 587026 587060 592271 595326 596884 602177 607340 607533 611518 612516 616519 622309 622579 626213 635212 636049 636050 640503 645260 647534 647586 648378 654794 655628 655760 656027 659105 659250 662807 666966 675473 679078 684430 685926 687506 689113 689743 701188 704351 719033 722928 723071 748901 755000 763840 763861 766584 771951 779275 782597 785326 787585 790323 793782 797926 800900 810535 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"обратно"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"обратн"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"обратн"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.