Query Metrics
7
Database Queries
7
Different statements
187.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.77 ms (86.05%) |
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 25021 310295 386451 386767 388738 390623 396601 399757 404478 410867 413049 418451 420441 430732 450241 460672 469406 469582 481668 483038 491228 508949 520455 522775 528173 530079 530304 530397 531603 531604 531614 532182 533011 534831 534841 534855 535817 536547 538043 538790 553494 565038 569162 575349 591591 591702 591893 599908 599957 604497 604516 604572 604589 610283 625447 629888 633855 634215 634500 636290 638543 648815 665932 681640 687251 687880 696450 698959 701341 702684 719847 720344 724564 725606 725612 727699 730753 732625 733570 735805 738475 739668 744472 744575 744593 749032 752689 752713 756230 762663 764340 776861 781815 785663 785676 790859 796443 797382 797384 797409 798363 800696 802181 802337 804483 804673 805271 807037 808079 809254 809276 813731 814660 815493 817857 820780 823566 823593 828112 828863 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (7.89%) |
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 808079 532182 533011 696450 553494 599908 404478 820780 450241 491228 483038 469582 591893 805271 756230 701341 413049 481668 430732 25021 390623 399757 410867 823593 813731 823566 530397 534831 531614 534855 528173 569162 665932 681640 698959 687880 575349 591591 634500 591702 638543 785663 800696 804483 809276 797409 798363 739668 807037 735805 738475 764340 725612 727699 732625 744575 752689 633855 702684 719847 396601 386451 418451 815493 814660 817857 460672 469406 522775 531604 534841 538790 530304 536547 538043 508949 531603 535817 720344 687251 604497 604516 604572 610283 634215 625447 781815 796443 797384 802181 785676 790859 724564 725606 730753 733570 749032 797382 804673 809254 752713 762663 744593 744472 604589 776861 388738 828863 565038 648815 599957 629888 636290 828112 530079 802337 386767 420441 520455 310295 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc milf"
]
|
||||||||||||||||||||||||||||||
|
2.69 ms (1.43%) |
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 25021 310295 386451 386767 388738 390623 396601 399757 404478 410867 413049 418451 420441 430732 450241 460672 469406 469582 481668 483038 491228 508949 520455 522775 528173 530079 530304 530397 531603 531604 531614 532182 533011 534831 534841 534855 535817 536547 538043 538790 553494 565038 569162 575349 591591 591702 591893 599908 599957 604497 604516 604572 604589 610283 625447 629888 633855 634215 634500 636290 638543 648815 665932 681640 687251 687880 696450 698959 701341 702684 719847 720344 724564 725606 725612 727699 730753 732625 733570 735805 738475 739668 744472 744575 744593 749032 752689 752713 756230 762663 764340 776861 781815 785663 785676 790859 796443 797382 797384 797409 798363 800696 802181 802337 804483 804673 805271 807037 808079 809254 809276 813731 814660 815493 817857 820780 823566 823593 828112 828863 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc and milf"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc milf"
]
|
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.