Query Metrics
7
Database Queries
7
Different statements
141.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.25 ms (83.54%) |
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 460298 520616 526681 528979 528999 529037 530415 537283 542001 546757 548965 552430 555731 555769 559538 583175 583432 584620 588819 589326 592802 602684 610493 613989 614552 614915 620468 620488 622485 624784 628574 632793 637123 637609 639299 640899 643783 649548 657130 659471 660321 664454 667084 667331 669343 670255 672676 682884 685232 685515 690676 695093 700097 704464 705224 717099 717666 718957 721102 724072 725313 728122 731324 732611 734732 737426 738995 742216 744477 747491 748795 750550 750604 751021 752890 753912 756102 757043 760894 762792 764120 765452 765816 766372 766684 767016 767019 767363 769850 770285 770777 772193 776013 777609 779019 779977 781025 781057 786992 790384 790984 791004 792734 794636 795899 798419 798944 800439 800713 801024 801784 803487 804731 807077 810290 810333 811332 813447 813592 813648 ] |
||||||||||||||||||||||||||||||
|
12.20 ms (8.62%) |
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 790384 798944 800439 800713 801024 813447 725313 756102 762792 769850 770777 810290 724072 728122 732611 744477 750550 765452 767016 734732 737426 738995 742216 753912 757043 760894 764120 766372 766684 748795 751021 765816 772193 731324 747491 750604 752890 767019 767363 770285 624784 721102 777609 779977 781025 781057 786992 790984 792734 794636 801784 807077 546757 637123 813648 813592 460298 520616 529037 526681 528979 537283 528999 530415 552430 555769 542001 559538 584620 555731 583432 659471 664454 669343 672676 682884 690676 695093 717099 649548 657130 667084 667331 685232 700097 704464 705224 660321 670255 685515 717666 718957 548965 583175 628574 610493 620468 620488 622485 637609 639299 588819 592802 613989 614915 632793 589326 602684 614552 640899 643783 776013 779019 791004 795899 798419 803487 804731 810333 811332 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (2.14%) |
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 460298 520616 526681 528979 528999 529037 530415 537283 542001 546757 548965 552430 555731 555769 559538 583175 583432 584620 588819 589326 592802 602684 610493 613989 614552 614915 620468 620488 622485 624784 628574 632793 637123 637609 639299 640899 643783 649548 657130 659471 660321 664454 667084 667331 669343 670255 672676 682884 685232 685515 690676 695093 700097 704464 705224 717099 717666 718957 721102 724072 725313 728122 731324 732611 734732 737426 738995 742216 744477 747491 748795 750550 750604 751021 752890 753912 756102 757043 760894 762792 764120 765452 765816 766372 766684 767016 767019 767363 769850 770285 770777 772193 776013 777609 779019 779977 781025 781057 786992 790384 790984 791004 792734 794636 795899 798419 798944 800439 800713 801024 801784 803487 804731 807077 810290 810333 811332 813447 813592 813648 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с первым"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"перв"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.33%) |
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.