Query Metrics
7
Database Queries
7
Different statements
169.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.75 ms (84.75%) |
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 38263 80821 355294 382165 385829 386451 387160 388253 392785 423892 423950 440871 449194 455003 473697 478759 489225 492543 493020 494570 502752 509278 519921 521719 521721 533454 536125 544017 545476 546841 549577 552767 553664 557936 563597 568675 569316 569436 570869 576182 579768 584609 586262 589580 590331 590538 597090 599323 614782 614840 614842 623714 623755 627314 646748 659945 660292 664608 666483 672903 678706 687851 692696 695543 695544 706494 707073 709117 713730 719964 725166 725432 725995 727002 729220 731152 731160 736392 741235 743797 744399 744418 744426 746143 746478 746669 748045 749403 753135 753489 754361 755687 755918 758297 758301 759382 760425 762338 763595 766341 767653 769708 773969 787370 787678 793766 794625 795306 796720 800042 801491 803431 806690 807037 808859 809777 810319 811531 817978 826375 ] |
||||||||||||||||||||||||||||||
|
15.95 ms (9.40%) |
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 741235 746143 758301 766341 767653 773969 800042 807037 808859 810319 736392 744418 744426 746478 759382 744399 754361 769708 725432 755687 731160 748045 755918 614782 627314 719964 801491 80821 387160 423950 386451 478759 355294 388253 440871 817978 826375 449194 489225 455003 533454 584609 544017 563597 576182 672903 678706 695543 707073 664608 687851 706494 709117 597090 614840 623755 590331 599323 590538 623714 787678 795306 796720 803431 731152 746669 753135 753489 760425 806690 725166 725995 743797 729220 762338 727002 749403 758297 763595 614842 787370 794625 809777 811531 423892 392785 473697 502752 492543 493020 521719 385829 382165 38263 509278 519921 536125 494570 521721 549577 557936 569316 569436 570869 579768 568675 552767 553664 646748 659945 660292 692696 695544 713730 666483 545476 546841 586262 589580 793766 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.88%) |
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 38263 80821 355294 382165 385829 386451 387160 388253 392785 423892 423950 440871 449194 455003 473697 478759 489225 492543 493020 494570 502752 509278 519921 521719 521721 533454 536125 544017 545476 546841 549577 552767 553664 557936 563597 568675 569316 569436 570869 576182 579768 584609 586262 589580 590331 590538 597090 599323 614782 614840 614842 623714 623755 627314 646748 659945 660292 664608 666483 672903 678706 687851 692696 695543 695544 706494 707073 709117 713730 719964 725166 725432 725995 727002 729220 731152 731160 736392 741235 743797 744399 744418 744426 746143 746478 746669 748045 749403 753135 753489 754361 755687 755918 758297 758301 759382 760425 762338 763595 766341 767653 769708 773969 787370 787678 793766 794625 795306 796720 800042 801491 803431 806690 807037 808859 809777 810319 811531 817978 826375 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"jerks of"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"jerks"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"jerks"
]
|
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.