Query Metrics
7
Database Queries
7
Different statements
159.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.26 ms (82.31%) |
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 436030 437947 444645 460535 471429 484977 486759 531121 531200 531249 531250 537936 545408 551186 559644 568045 569154 573211 577706 581427 589752 591165 600807 601593 603187 604080 604383 607091 608744 611307 614186 628185 630234 630295 632626 633776 634161 636070 640524 640712 641705 644314 644321 644972 647910 647996 649114 649180 651062 653630 656502 661285 665317 665448 665457 665921 666532 667196 667636 668527 670098 670965 672984 673357 673578 676095 678915 679798 680202 683301 684029 692293 692314 693596 695125 696998 697025 705540 707275 709295 712006 720050 720112 720340 720394 729881 736798 736881 743782 744306 748354 755759 770732 770795 770882 775758 775834 775862 775897 775982 775989 780655 788582 792560 795593 798684 801941 801954 801975 805275 806804 811164 814556 815347 815875 816905 817115 817288 817346 818160 ] |
||||||||||||||||||||||||||||||
|
17.04 ms (10.69%) |
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 818160 815875 531200 537936 573211 680202 683301 720340 673578 676095 679798 720112 661285 705540 720394 581427 611307 641705 601593 607091 775834 801975 755759 736881 770732 604383 707275 712006 775982 775989 806804 436030 471429 437947 604080 460535 569154 816905 817115 644972 814556 815347 817288 817346 531250 531121 531249 551186 545408 559644 651062 665317 665448 665457 666532 667636 672984 647910 647996 649114 649180 656502 665921 667196 670098 670965 678915 684029 693596 696998 653630 668527 673357 692293 692314 695125 697025 720050 628185 640712 600807 634161 589752 591165 603187 608744 614186 633776 644314 644321 630234 630295 632626 775758 795593 805275 811164 775862 780655 736798 788582 792560 729881 743782 744306 770882 748354 770795 636070 640524 709295 775897 801941 801954 444645 486759 798684 577706 568045 484977 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (2.21%) |
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 436030 437947 444645 460535 471429 484977 486759 531121 531200 531249 531250 537936 545408 551186 559644 568045 569154 573211 577706 581427 589752 591165 600807 601593 603187 604080 604383 607091 608744 611307 614186 628185 630234 630295 632626 633776 634161 636070 640524 640712 641705 644314 644321 644972 647910 647996 649114 649180 651062 653630 656502 661285 665317 665448 665457 665921 666532 667196 667636 668527 670098 670965 672984 673357 673578 676095 678915 679798 680202 683301 684029 692293 692314 693596 695125 696998 697025 705540 707275 709295 712006 720050 720112 720340 720394 729881 736798 736881 743782 744306 748354 755759 770732 770795 770882 775758 775834 775862 775897 775982 775989 780655 788582 792560 795593 798684 801941 801954 801975 805275 806804 811164 814556 815347 815875 816905 817115 817288 817346 818160 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double handjob"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.