Query Metrics
7
Database Queries
7
Different statements
195.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.70 ms (87.20%) |
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 459236 470462 482144 483573 491317 512182 527240 529518 530529 534750 534751 535272 537243 539260 544703 554340 558889 567126 567138 577918 577919 582670 582705 585263 587566 588469 588635 590401 591228 593788 596584 605976 606893 609090 609479 610968 611611 612250 617051 619011 621431 622879 623624 625567 626235 627763 630017 630651 630773 637061 649139 651227 660042 661682 664658 667339 670003 670315 675418 677133 677581 677604 683689 683802 684196 684197 684683 685916 687071 694052 694810 695706 698015 698039 698088 708209 709556 710479 712231 712935 714650 714656 714954 716365 718369 719225 720798 721429 721982 726393 727637 730335 730973 734121 734799 734923 734929 736534 738160 742837 744703 747154 753753 755588 756261 758012 758684 758819 761235 767308 767868 775783 780508 785584 790511 790761 799650 801320 811951 818042 ] |
||||||||||||||||||||||||||||||
|
14.69 ms (7.50%) |
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 534751 558889 567126 582670 554340 661682 664658 677133 684683 694052 708209 716365 718369 675418 684196 714656 667339 684197 687071 698015 714954 577919 582705 587566 605976 630651 588469 596584 630773 637061 606893 610968 617051 627763 799650 780508 727637 761235 730973 734121 736534 756261 734799 734929 738160 742837 758012 730335 753753 758684 626235 630017 698088 710479 714650 721982 811951 491317 535272 712935 593788 625567 801320 767308 790511 818042 459236 470462 483573 529518 530529 534750 512182 527240 537243 539260 482144 544703 567138 577918 670003 670315 677581 683802 694810 695706 698039 712231 720798 721429 651227 677604 685916 709556 719225 649139 660042 683689 609090 622879 623624 585263 591228 609479 611611 590401 588635 612250 619011 621431 775783 790761 755588 758819 785584 734923 767868 726393 744703 747154 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.54%) |
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 459236 470462 482144 483573 491317 512182 527240 529518 530529 534750 534751 535272 537243 539260 544703 554340 558889 567126 567138 577918 577919 582670 582705 585263 587566 588469 588635 590401 591228 593788 596584 605976 606893 609090 609479 610968 611611 612250 617051 619011 621431 622879 623624 625567 626235 627763 630017 630651 630773 637061 649139 651227 660042 661682 664658 667339 670003 670315 675418 677133 677581 677604 683689 683802 684196 684197 684683 685916 687071 694052 694810 695706 698015 698039 698088 708209 709556 710479 712231 712935 714650 714656 714954 716365 718369 719225 720798 721429 721982 726393 727637 730335 730973 734121 734799 734923 734929 736534 738160 742837 744703 747154 753753 755588 756261 758012 758684 758819 761235 767308 767868 775783 780508 785584 790511 790761 799650 801320 811951 818042 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"new cock"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"new cock"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"new cock"
]
|
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.