Query Metrics
7
Database Queries
7
Different statements
431.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.01 ms (48.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur rough"
]
|
||||||||||||||||||||||||||||||
|
197.14 ms (45.69%) |
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 386856 398370 399041 402340 418533 423714 427850 437723 440667 441822 444819 445331 458655 459647 465540 487389 501690 510841 515218 517223 518887 522950 544927 555101 571359 586014 590356 591568 591832 596946 602862 604643 609381 611563 613929 617089 619168 624795 639959 641485 642926 652451 660006 660059 660713 662806 675585 696916 702518 710455 710969 712877 714258 716529 717088 720187 721128 721230 723369 724978 726252 726887 729955 731615 732852 734424 734731 737553 738527 739548 740702 742288 745596 745617 746364 751083 753193 757564 757673 759955 761597 761793 762780 765768 766223 770541 770958 773480 777260 780925 782505 785491 786806 787891 789511 789837 790038 790719 792175 792376 794088 794917 794983 797226 798169 798618 799045 803038 805107 805536 805995 808971 809249 810726 813424 818045 819361 821836 823760 825466 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (3.41%) |
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 782505 792175 797226 810726 777260 734731 737553 745617 761793 762780 773480 787891 726252 731615 745596 757564 726887 729955 742288 739548 759955 765768 751083 785491 813424 402340 437723 465540 522950 639959 662806 798169 660713 675585 702518 710969 660059 714258 596946 609381 590356 591568 591832 641485 604643 617089 517223 427850 423714 445331 819361 823760 818045 487389 510841 515218 501690 716529 717088 586014 602862 642926 794088 794983 789511 792376 798618 808971 724978 734424 786806 794917 803038 805107 746364 761597 738527 770958 757673 770541 753193 766223 720187 780925 790038 790719 799045 805536 805995 809249 386856 440667 459647 444819 398370 544927 696916 619168 613929 611563 740702 399041 789837 732852 624795 418533 441822 821836 825466 458655 518887 571359 555101 721128 723369 652451 660006 710455 712877 721230 ] |
||||||||||||||||||||||||||||||
|
4.04 ms (0.94%) |
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 386856 398370 399041 402340 418533 423714 427850 437723 440667 441822 444819 445331 458655 459647 465540 487389 501690 510841 515218 517223 518887 522950 544927 555101 571359 586014 590356 591568 591832 596946 602862 604643 609381 611563 613929 617089 619168 624795 639959 641485 642926 652451 660006 660059 660713 662806 675585 696916 702518 710455 710969 712877 714258 716529 717088 720187 721128 721230 723369 724978 726252 726887 729955 731615 732852 734424 734731 737553 738527 739548 740702 742288 745596 745617 746364 751083 753193 757564 757673 759955 761597 761793 762780 765768 766223 770541 770958 773480 777260 780925 782505 785491 786806 787891 789511 789837 790038 790719 792175 792376 794088 794917 794983 797226 798169 798618 799045 803038 805107 805536 805995 808971 809249 810726 813424 818045 819361 821836 823760 825466 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск rough"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск rough"
]
|
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.