Query Metrics
7
Database Queries
7
Different statements
167.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.40 ms (84.60%) |
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 3 4073 27635 28382 28397 29242 34170 35405 40927 58516 61866 69704 123457 172024 185428 191207 194652 223442 228398 326189 350664 359723 362958 372986 382212 382383 382540 382602 383315 383498 383763 385269 385728 385781 388124 389158 389517 391101 391315 391526 393792 396535 397424 397498 397700 398423 398697 401940 403281 409121 409174 413245 418723 428423 455865 457796 460147 461590 461773 462964 469802 477141 488586 502252 503061 503570 504542 528720 528772 528999 533157 537003 572424 573565 611782 614217 663358 663960 664804 665103 667640 668899 670514 671094 672422 694432 705746 710511 716516 717721 718002 720834 725518 725922 727352 728246 728681 734379 735375 735716 742126 748126 748177 753397 757045 757606 761151 761303 761968 766458 771963 776605 787893 788488 791363 818671 818786 820523 821538 821661 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (9.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 717721 191207 460147 40927 185428 383498 61866 3 573565 362958 385269 194652 382540 385728 123457 391526 398423 409174 409121 503061 528772 528999 537003 716516 664804 665103 668899 672422 663960 694432 718002 572424 727352 728681 791363 742126 771963 734379 725518 725922 735716 748126 761151 761303 787893 788488 382602 389517 350664 413245 393792 401940 428423 457796 35405 383315 398697 385781 383763 372986 382383 391101 396535 397498 818786 820523 528720 670514 671094 705746 710511 663358 667640 720834 611782 614217 776605 757045 748177 766458 761968 728246 753397 757606 735375 34170 228398 388124 69704 391315 397700 403281 488586 27635 28382 29242 455865 462964 4073 359723 461590 469802 461773 397424 382212 389158 418723 504542 172024 326189 28397 58516 223442 821661 818671 821538 477141 533157 502252 503570 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.75%) |
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 3 4073 27635 28382 28397 29242 34170 35405 40927 58516 61866 69704 123457 172024 185428 191207 194652 223442 228398 326189 350664 359723 362958 372986 382212 382383 382540 382602 383315 383498 383763 385269 385728 385781 388124 389158 389517 391101 391315 391526 393792 396535 397424 397498 397700 398423 398697 401940 403281 409121 409174 413245 418723 428423 455865 457796 460147 461590 461773 462964 469802 477141 488586 502252 503061 503570 504542 528720 528772 528999 533157 537003 572424 573565 611782 614217 663358 663960 664804 665103 667640 668899 670514 671094 672422 694432 705746 710511 716516 717721 718002 720834 725518 725922 727352 728246 728681 734379 735375 735716 742126 748126 748177 753397 757045 757606 761151 761303 761968 766458 771963 776605 787893 788488 791363 818671 818786 820523 821538 821661 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пикап ххх"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пикап ххх"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
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.