Query Metrics
7
Database Queries
7
Different statements
163.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.32 ms (86.69%) |
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 6864 57952 337704 383000 385928 392391 392902 395465 398376 398413 398446 405705 407108 416737 421590 440094 441838 445011 445413 446274 457228 457451 462006 465582 467885 467938 468169 469759 474749 474968 477055 480065 480450 480656 483615 497906 503166 510102 530698 537648 543648 544108 547236 547472 547476 555601 568261 573270 578298 582277 584164 587260 588929 591206 597502 600358 600444 604316 605155 623379 628656 632565 634067 636948 649960 654901 659035 661148 668449 670357 670360 696593 699624 702033 709850 710659 712174 713185 713987 720216 722937 729231 736218 736741 736971 740849 745503 748309 751040 752595 752687 756841 761087 761621 765480 766788 776048 777847 780404 781568 782351 782650 782789 783364 785582 787113 788486 797478 799683 799695 799696 799697 799699 799861 800577 803092 804317 813597 817613 826043 ] |
||||||||||||||||||||||||||||||
|
12.31 ms (7.55%) |
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 649960 537648 722937 668449 799699 817613 582277 632565 776048 799697 748309 604316 480065 783364 781568 799683 547472 584164 600444 634067 605155 785582 752595 745503 392391 555601 57952 457228 659035 468169 782650 765480 813597 568261 799695 756841 799861 740849 712174 337704 826043 547236 670357 782351 407108 661148 787113 547476 696593 457451 720216 654901 623379 636948 421590 702033 803092 467885 474749 530698 600358 578298 670360 445011 440094 483615 469759 543648 395465 416737 446274 544108 710659 713185 709850 597502 777847 782789 729231 385928 713987 761087 398413 477055 398446 628656 588929 804317 780404 6864 800577 751040 797478 405705 480450 510102 497906 736218 591206 467938 736741 503166 699624 788486 799696 766788 398376 392902 441838 462006 465582 573270 587260 445413 474968 752687 761621 736971 383000 480656 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.77%) |
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 6864 57952 337704 383000 385928 392391 392902 395465 398376 398413 398446 405705 407108 416737 421590 440094 441838 445011 445413 446274 457228 457451 462006 465582 467885 467938 468169 469759 474749 474968 477055 480065 480450 480656 483615 497906 503166 510102 530698 537648 543648 544108 547236 547472 547476 555601 568261 573270 578298 582277 584164 587260 588929 591206 597502 600358 600444 604316 605155 623379 628656 632565 634067 636948 649960 654901 659035 661148 668449 670357 670360 696593 699624 702033 709850 710659 712174 713185 713987 720216 722937 729231 736218 736741 736971 740849 745503 748309 751040 752595 752687 756841 761087 761621 765480 766788 776048 777847 780404 781568 782351 782650 782789 783364 785582 787113 788486 797478 799683 799695 799696 799697 799699 799861 800577 803092 804317 813597 817613 826043 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал дырк"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал дырк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в жопу через дырку"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.