Query Metrics
7
Database Queries
7
Different statements
187.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.16 ms (87.47%) |
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 562527 569036 571293 585831 588455 591753 592132 593765 593913 594617 596441 598095 606389 614759 617215 620938 625300 630125 631224 636472 642128 644178 653006 658869 664551 668698 674280 685805 701677 701801 704797 707730 707890 708734 709276 713652 714126 714510 717145 717378 718391 720011 721965 725526 726435 729641 730222 730543 733409 734069 734194 734258 734594 735904 736894 739787 739950 740280 741677 746175 747046 748773 749414 750768 753744 753745 753760 756526 759131 762155 762366 762572 764156 764565 765900 766534 767441 767496 767654 767667 768652 768657 768745 769600 769911 770324 770417 771281 772125 773793 774918 775048 775853 777349 778222 783248 783737 784320 785526 787152 787172 787194 792779 793782 795970 795976 796510 796811 801976 802073 807122 808700 809200 810785 810921 811599 812580 813319 ] |
||||||||||||||||||||||||||||||
|
12.95 ms (6.90%) |
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 707730 720011 658869 685805 708734 714126 717378 718391 653006 664551 668698 674280 701677 704797 707890 709276 721965 562527 569036 571293 592132 593913 594617 606389 642128 585831 596441 625300 636472 644178 591753 593765 598095 617215 588455 620938 631224 774918 775048 785526 787152 787194 793782 801976 807122 808700 809200 810785 811599 775853 778222 783248 783737 795970 795976 796510 729641 730222 746175 747046 750768 753760 762572 766534 771281 784320 792779 796811 810921 812580 734069 736894 740280 756526 762155 762366 765900 768657 770417 725526 730543 733409 734258 739950 741677 753744 759131 764565 769911 734194 735904 739787 748773 753745 767441 767496 767667 768652 768745 772125 726435 734594 749414 764156 767654 768922 769600 770324 771930 773793 614759 630125 701801 713652 714510 717145 777349 787172 802073 813319 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.39%) |
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 562527 569036 571293 585831 588455 591753 592132 593765 593913 594617 596441 598095 606389 614759 617215 620938 625300 630125 631224 636472 642128 644178 653006 658869 664551 668698 674280 685805 701677 701801 704797 707730 707890 708734 709276 713652 714126 714510 717145 717378 718391 720011 721965 725526 726435 729641 730222 730543 733409 734069 734194 734258 734594 735904 736894 739787 739950 740280 741677 746175 747046 748773 749414 750768 753744 753745 753760 756526 759131 762155 762366 762572 764156 764565 765900 766534 767441 767496 767654 767667 768652 768657 768745 769600 769911 770324 770417 771281 772125 773793 774918 775048 775853 777349 778222 783248 783737 784320 785526 787152 787172 787194 792779 793782 795970 795976 796510 796811 801976 802073 807122 808700 809200 810785 810921 811599 812580 813319 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дрочит женская"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк женск"
]
|
||||||||||||||||||||||||||||||
|
1.72 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.