Query Metrics
7
Database Queries
7
Different statements
400.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
227.30 ms (56.82%) |
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 823848 828110 486816 680259 706211 650070 662869 677447 664191 583211 602067 643786 594626 600208 627279 797438 798715 786342 755601 731297 731304 736037 758851 752895 725657 729985 750864 622677 640046 703968 713467 717122 794337 809813 403147 578427 710255 794914 788188 803926 559237 472881 530300 808084 820540 820099 468345 529639 529260 533175 695715 711988 646066 778981 739568 725779 426778 522516 555954 514237 769100 539930 545114 647809 716796 620828 589383 811704 754073 759913 765717 609634 632216 806097 642176 618494 733041 812359 341118 816394 817940 819177 468151 481718 533954 518956 533230 497903 499331 559207 580537 562187 711346 716657 720051 658943 663203 675613 695398 713398 581834 629631 620968 628469 588487 590154 592646 594419 606881 611282 635353 636873 638500 786916 790806 791530 799742 801574 784299 801012 ] |
||||||||||||||||||||||||||||||
|
162.92 ms (40.72%) |
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 341118 403147 426778 468151 468345 472881 481718 486816 497903 499331 514237 518956 522516 529260 529639 530300 533175 533230 533954 539930 545114 555954 559207 559237 562187 578427 580537 581834 583211 588487 589383 590154 592646 594419 594626 600208 602067 606881 609634 611282 618494 620828 620968 622677 627279 628469 629631 632216 635353 636873 638500 640046 642176 643786 646066 647809 650070 658943 662869 663203 664191 675613 677447 680259 695398 695715 703968 706211 710255 711346 711988 713398 713467 716657 716796 717122 720051 725657 725779 729985 731297 731304 733041 736037 739568 750864 752895 754073 755601 758851 759913 765717 769100 778981 784299 786342 786916 788188 790806 791530 794337 794914 797438 798715 799742 801012 801574 803926 806097 808084 809813 811704 812359 816394 817940 819177 820099 820540 823848 828110 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (0.61%) |
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 341118 403147 426778 468151 468345 472881 481718 486816 497903 499331 514237 518956 522516 529260 529639 530300 533175 533230 533954 539930 545114 555954 559207 559237 562187 578427 580537 581834 583211 588487 589383 590154 592646 594419 594626 600208 602067 606881 609634 611282 618494 620828 620968 622677 627279 628469 629631 632216 635353 636873 638500 640046 642176 643786 646066 647809 650070 658943 662869 663203 664191 675613 677447 680259 695398 695715 703968 706211 710255 711346 711988 713398 713467 716657 716796 717122 720051 725657 725779 729985 731297 731304 733041 736037 739568 750864 752895 754073 755601 758851 759913 765717 769100 778981 784299 786342 786916 788188 790806 791530 794337 794914 797438 798715 799742 801012 801574 803926 806097 808084 809813 811704 812359 816394 817940 819177 820099 820540 823848 828110 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass doggystyle"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп doggystyle"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп doggystyle"
]
|
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.