Query Metrics
7
Database Queries
7
Different statements
151.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.48 ms (85.25%) |
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 368335 383700 388350 395724 395861 401333 411868 415790 425657 445714 452487 457943 466690 477110 513817 515693 516012 531137 535611 536299 541568 543983 545342 546785 550380 554752 559360 585726 589208 591353 598306 601043 604306 607464 608569 612188 612816 613122 634528 641847 642075 642659 647882 651077 654919 656206 656521 671701 675006 683826 690091 702619 703141 703437 704928 707308 710530 713405 716750 717724 718041 718784 719026 720713 723643 727810 730315 730759 731243 732804 736412 750545 750554 751627 756216 756236 756241 756642 761326 761555 766523 766650 766860 769894 770402 770543 771620 781320 782657 784396 788847 788856 789961 790387 790974 795147 798509 798929 800108 801267 801542 802845 803655 804014 806243 807352 807402 814343 814630 814876 815062 815142 815151 815508 816319 816529 818438 819104 820586 820888 ] |
||||||||||||||||||||||||||||||
|
12.80 ms (8.43%) |
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 788847 732804 804014 727810 766650 761555 731243 634528 707308 718041 789961 814876 445714 535611 531137 710530 717724 647882 784396 756216 756241 756236 716750 795147 798509 585726 411868 675006 816529 820586 815142 816319 690091 736412 730759 750545 820888 815151 818438 536299 612188 642659 769894 368335 604306 713405 395724 425657 452487 515693 541568 591353 807352 730315 798929 466690 401333 395861 477110 814343 790387 800108 803655 806243 770543 771620 703437 781320 815508 723643 607464 601043 801267 383700 545342 559360 543983 671701 598306 642075 782657 790974 750554 766523 788856 766860 751627 761326 720713 801542 802845 807402 388350 415790 656206 770402 756642 814630 819104 815062 457943 516012 513817 550380 656521 702619 703141 718784 719026 654919 683826 651077 704928 546785 554752 608569 641847 589208 612816 613122 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.64%) |
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 368335 383700 388350 395724 395861 401333 411868 415790 425657 445714 452487 457943 466690 477110 513817 515693 516012 531137 535611 536299 541568 543983 545342 546785 550380 554752 559360 585726 589208 591353 598306 601043 604306 607464 608569 612188 612816 613122 634528 641847 642075 642659 647882 651077 654919 656206 656521 671701 675006 683826 690091 702619 703141 703437 704928 707308 710530 713405 716750 717724 718041 718784 719026 720713 723643 727810 730315 730759 731243 732804 736412 750545 750554 751627 756216 756236 756241 756642 761326 761555 766523 766650 766860 769894 770402 770543 771620 781320 782657 784396 788847 788856 789961 790387 790974 795147 798509 798929 800108 801267 801542 802845 803655 804014 806243 807352 807402 814343 814630 814876 815062 815142 815151 815508 816319 816529 818438 819104 820586 820888 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mom big"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал mom большие"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал mom большие"
]
|
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.