Query Metrics
7
Database Queries
7
Different statements
176.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.59 ms (85.14%) |
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 11330 11870 154015 188613 346082 396093 397103 397780 398104 400897 401267 404690 407885 410062 410402 413183 426512 432810 434947 439439 440813 442665 445577 447527 448084 454184 456469 458086 458609 460449 460697 461739 463960 464347 473428 474593 478256 485140 494409 510102 516730 517848 520844 526273 526904 528475 531326 533331 535528 535793 537404 537452 537464 544142 558205 560917 565909 580597 580623 586905 592161 596408 597898 600433 605154 613122 620752 626292 640408 661967 670338 671652 687583 692068 695803 703604 713048 720631 722538 724854 728049 731862 732272 732774 737552 742316 744450 744632 747443 756681 758498 758502 759757 761030 765266 766628 766637 766647 768727 770129 772809 775219 776184 784488 788837 791567 791808 794104 794162 795295 797191 800456 803537 808052 811119 812588 816970 817311 819252 823041 ] |
||||||||||||||||||||||||||||||
|
16.84 ms (9.52%) |
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 410402 458086 454184 461739 463960 533331 464347 474593 670338 692068 613122 791567 812588 794162 791808 797191 800456 742316 724854 737552 770129 732774 758498 626292 413183 154015 397103 400897 494409 661967 823041 188613 597898 605154 401267 535793 526904 816970 819252 720631 759757 761030 478256 520844 620752 772809 732272 756681 713048 447527 410062 592161 580597 426512 439439 516730 784488 580623 600433 565909 442665 517848 560917 596408 586905 440813 510102 404690 458609 803537 744632 766647 456469 11870 407885 817311 703604 728049 731862 776184 808052 346082 11330 398104 744450 445577 448084 434947 473428 537452 794104 811119 766628 788837 396093 558205 460697 485140 535528 537464 531326 526273 528475 537404 687583 766637 795295 460449 695803 671652 758502 765266 640408 544142 722538 775219 768727 747443 397780 432810 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.63%) |
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 11330 11870 154015 188613 346082 396093 397103 397780 398104 400897 401267 404690 407885 410062 410402 413183 426512 432810 434947 439439 440813 442665 445577 447527 448084 454184 456469 458086 458609 460449 460697 461739 463960 464347 473428 474593 478256 485140 494409 510102 516730 517848 520844 526273 526904 528475 531326 533331 535528 535793 537404 537452 537464 544142 558205 560917 565909 580597 580623 586905 592161 596408 597898 600433 605154 613122 620752 626292 640408 661967 670338 671652 687583 692068 695803 703604 713048 720631 722538 724854 728049 731862 732272 732774 737552 742316 744450 744632 747443 756681 758498 758502 759757 761030 765266 766628 766637 766647 768727 770129 772809 775219 776184 784488 788837 791567 791808 794104 794162 795295 797191 800456 803537 808052 811119 812588 816970 817311 819252 823041 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big anal ass"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие анал жоп"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.81%) |
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.