Query Metrics
7
Database Queries
7
Different statements
193.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.45 ms (86.19%) |
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 335455 402643 403685 404077 404084 417833 418616 432864 443143 449133 450021 452592 461393 494920 497203 507799 513218 518595 533398 541494 545743 548411 549154 553225 554916 556622 563937 579850 579997 583458 587997 590525 597766 603606 608664 610468 615409 630044 630662 630696 639915 643187 645698 646076 652786 653066 653126 653838 654899 661955 662920 666686 668813 675185 675356 678644 679236 693703 696498 697006 707408 707939 714616 715571 717660 717664 718191 718639 719916 724837 726527 727724 732701 736642 739604 740476 740768 742674 742766 744430 752625 752650 755704 756421 756673 758654 762819 763809 764002 765424 767680 768499 774299 776822 778736 778770 783600 785088 785708 790086 792693 793803 794183 795792 800729 802048 802276 803909 804587 807748 809781 810310 813751 813858 814186 816101 819454 819644 824162 825818 ] |
||||||||||||||||||||||||||||||
|
14.51 ms (7.52%) |
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 697006 417833 785708 824162 449133 507799 553225 696498 807748 776822 794183 752650 726527 707408 461393 450021 756421 452592 533398 804587 809781 774299 678644 661955 630044 630662 404084 816101 819644 813751 819454 813858 563937 579850 579997 548411 556622 541494 652786 653066 654899 666686 668813 646076 653126 675185 679236 693703 714616 653838 707939 718191 590525 610468 615409 643187 597766 639915 778736 785088 792693 800729 778770 752625 758654 763809 765424 768499 783600 803909 724837 740476 755704 742674 764002 767680 736642 744430 762819 740768 608664 715571 717660 718639 719916 802048 513218 443143 335455 825818 549154 554916 583458 717664 675356 630696 802276 732701 756673 742766 403685 432864 587997 603606 810310 727724 494920 545743 662920 645698 790086 795792 793803 739604 518595 497203 402643 404077 418616 814186 ] |
||||||||||||||||||||||||||||||
|
4.29 ms (2.22%) |
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 335455 402643 403685 404077 404084 417833 418616 432864 443143 449133 450021 452592 461393 494920 497203 507799 513218 518595 533398 541494 545743 548411 549154 553225 554916 556622 563937 579850 579997 583458 587997 590525 597766 603606 608664 610468 615409 630044 630662 630696 639915 643187 645698 646076 652786 653066 653126 653838 654899 661955 662920 666686 668813 675185 675356 678644 679236 693703 696498 697006 707408 707939 714616 715571 717660 717664 718191 718639 719916 724837 726527 727724 732701 736642 739604 740476 740768 742674 742766 744430 752625 752650 755704 756421 756673 758654 762819 763809 764002 765424 767680 768499 774299 776822 778736 778770 783600 785088 785708 790086 792693 793803 794183 795792 800729 802048 802276 803909 804587 807748 809781 810310 813751 813858 814186 816101 819454 819644 824162 825818 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking my wife"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking my жен"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking my жен"
]
|
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.