Query Metrics
7
Database Queries
7
Different statements
174.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.32 ms (84.08%) |
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 388544 398008 462406 480065 495308 511615 530553 532414 547898 550276 555555 555708 563565 567240 577989 592538 594441 609578 615628 623056 629727 630379 631222 642085 643149 651535 652424 667178 675157 675178 677542 680667 680669 682227 683698 691326 693875 695788 700056 700151 713734 715036 718134 718143 724455 724834 724971 727309 729348 729676 729705 730707 733657 734671 735245 735831 736680 738021 738729 740624 740837 741500 743555 747302 750106 751306 752951 753494 753543 754047 754869 754873 755577 759337 760521 761824 763977 766056 766098 766163 768708 772262 772560 776235 778825 779854 781640 782146 783359 783563 785366 786796 786886 787890 788045 788552 789591 790172 790237 791223 791869 792014 792873 793026 793128 793920 797812 798860 803980 807160 807319 809599 810205 812668 816807 817497 821772 825377 ] |
||||||||||||||||||||||||||||||
|
16.01 ms (9.20%) |
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 555555 783563 789591 782146 790237 740837 766056 797812 741500 729676 752951 729348 754869 754873 738021 743555 783359 788045 790172 791869 398008 594441 462406 550276 675157 691326 683698 700056 651535 652424 667178 675178 677542 682227 693875 567240 577989 592538 615628 623056 631222 643149 727309 630379 700151 480065 530553 713734 695788 609578 754047 761824 495308 816807 821772 532414 563565 547898 555708 680669 718143 718134 642085 629727 785366 792873 776235 778825 786796 729705 736680 766098 772262 772560 793128 793920 809599 751306 759337 766163 738729 753494 753543 734671 735831 740624 760521 768708 724834 747302 768119 715036 781640 793026 388544 825377 817497 807319 680667 694097 511615 779854 787890 788552 791223 792014 798860 807160 812668 786886 803980 730707 733657 810205 735245 724455 724971 750106 755577 763977 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.74%) |
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 388544 398008 462406 480065 495308 511615 530553 532414 547898 550276 555555 555708 563565 567240 577989 592538 594441 609578 615628 623056 629727 630379 631222 642085 643149 651535 652424 667178 675157 675178 677542 680667 680669 682227 683698 691326 693875 695788 700056 700151 713734 715036 718134 718143 724455 724834 724971 727309 729348 729676 729705 730707 733657 734671 735245 735831 736680 738021 738729 740624 740837 741500 743555 747302 750106 751306 752951 753494 753543 754047 754869 754873 755577 759337 760521 761824 763977 766056 766098 766163 768708 772262 772560 776235 778825 779854 781640 782146 783359 783563 785366 786796 786886 787890 788045 788552 789591 790172 790237 791223 791869 792014 792873 793026 793128 793920 797812 798860 803980 807160 807319 809599 810205 812668 816807 817497 821772 825377 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск student"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск student"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur student"
]
|
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.