Query Metrics
7
Database Queries
7
Different statements
191.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.76 ms (87.13%) |
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 385645 401274 418697 428223 428568 433152 435593 440708 446030 447160 483705 502465 512961 515490 519816 520789 546964 547386 547805 547920 548174 548855 549221 551123 554091 555271 556341 557826 558001 563280 564249 568261 571137 575601 576469 576920 592979 594052 596690 597743 600998 605713 607765 609246 614254 615045 616850 619210 620545 625744 625782 626027 628019 628673 639819 642526 670783 700996 702630 717443 719924 726749 727527 727534 727762 728292 731811 732698 733292 734284 735112 735256 735987 736041 736793 738390 739186 739316 739400 744191 744815 757025 757176 760054 761361 765057 767096 768792 769917 773390 775460 775572 777953 778897 782090 783382 784133 786782 788651 791883 792272 793108 793925 794305 796309 797218 798331 798413 798455 801197 801543 801629 802582 803362 803364 807006 810290 810821 812469 813093 ] |
||||||||||||||||||||||||||||||
|
14.28 ms (7.46%) |
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 547386 548174 548855 555271 557826 563280 564249 576469 597743 600998 614254 616850 615045 620545 626027 628673 642526 594052 596690 605713 607765 625782 628019 609246 619210 625744 775572 782090 796309 810821 812469 775460 777953 778897 783382 786782 791883 793108 793925 798331 798455 801197 802582 803362 803364 807006 734284 735256 739400 744191 744815 760054 768792 788651 797218 810290 727534 731811 736793 728292 738390 765057 767096 726749 727527 732698 733292 739186 739316 773390 727762 735987 736041 757025 757176 761361 769917 717443 719924 792272 794305 798413 801543 813093 568261 639819 735112 702630 801629 435593 571137 385645 554091 670783 784133 446030 592979 401274 418697 428568 433152 440708 428223 483705 447160 512961 515490 520789 502465 519816 549221 556341 575601 546964 547805 558001 576920 700996 547920 551123 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (1.82%) |
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 385645 401274 418697 428223 428568 433152 435593 440708 446030 447160 483705 502465 512961 515490 519816 520789 546964 547386 547805 547920 548174 548855 549221 551123 554091 555271 556341 557826 558001 563280 564249 568261 571137 575601 576469 576920 592979 594052 596690 597743 600998 605713 607765 609246 614254 615045 616850 619210 620545 625744 625782 626027 628019 628673 639819 642526 670783 700996 702630 717443 719924 726749 727527 727534 727762 728292 731811 732698 733292 734284 735112 735256 735987 736041 736793 738390 739186 739316 739400 744191 744815 757025 757176 760054 761361 765057 767096 768792 769917 773390 775460 775572 777953 778897 782090 783382 784133 786782 788651 791883 792272 793108 793925 794305 796309 797218 798331 798413 798455 801197 801543 801629 802582 803362 803364 807006 810290 810821 812469 813093 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большие дырки скачать"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие дырк скача"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 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.