Query Metrics
7
Database Queries
7
Different statements
220.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.04 ms (89.66%) |
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 397490 416407 416878 417846 418389 425749 426934 427573 429321 431709 435180 444009 444387 446918 449743 455788 467742 473145 476001 483882 485826 486257 489096 490757 494323 506423 508298 509377 512148 516101 525557 527764 529121 529629 541333 542908 543149 544090 555628 556991 575189 578008 581793 585168 590095 599606 601955 604313 609819 610938 613732 615580 616858 618700 625340 626375 631871 672902 673187 674068 678222 683978 695002 697129 698285 699267 716796 720656 726790 728051 746708 756724 756868 761959 762090 762970 766002 768155 768818 771742 775731 775771 777956 778326 778927 779256 779909 783794 784762 784920 785211 786901 788080 788142 788374 790470 791818 792308 792446 794712 795661 801503 805101 805361 805685 805777 807728 809433 810559 811549 812436 812720 814271 818081 818094 821764 823949 825674 825689 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (6.10%) |
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 616858 775771 777956 778927 783794 795661 805101 812720 778326 794712 810559 784762 788374 726790 761959 762090 728051 746708 768818 768155 771742 697129 779909 791818 801503 418389 425749 397490 427573 444009 467742 446918 449743 473145 506423 489096 542908 578008 544090 555628 575189 581793 556991 416407 426934 435180 416878 444387 483882 529121 508298 509377 417846 818081 818094 823949 825674 821764 485826 525557 527764 516101 543149 673187 674068 683978 699267 672902 678222 695002 716796 585168 615580 590095 599606 626375 618700 625340 786901 788142 792446 805361 811549 756868 766002 766558 756724 762970 601955 609819 720656 775731 779256 784920 785211 788080 790470 792308 805685 812436 486257 529629 698285 490757 512148 541333 610938 613732 604313 631871 805777 807728 809433 476001 431709 455788 494323 429321 814271 825689 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.20%) |
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 397490 416407 416878 417846 418389 425749 426934 427573 429321 431709 435180 444009 444387 446918 449743 455788 467742 473145 476001 483882 485826 486257 489096 490757 494323 506423 508298 509377 512148 516101 525557 527764 529121 529629 541333 542908 543149 544090 555628 556991 575189 578008 581793 585168 590095 599606 601955 604313 609819 610938 613732 615580 616858 618700 625340 626375 631871 672902 673187 674068 678222 683978 695002 697129 698285 699267 716796 720656 726790 728051 746708 756724 756868 761959 762090 762970 766002 768155 768818 771742 775731 775771 777956 778326 778927 779256 779909 783794 784762 784920 785211 786901 788080 788142 788374 790470 791818 792308 792446 794712 795661 801503 805101 805361 805685 805777 807728 809433 810559 811549 812436 812720 814271 818081 818094 821764 823949 825674 825689 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping pov"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ пов"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.67%) |
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.