Query Metrics
7
Database Queries
7
Different statements
208.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.44 ms (88.91%) |
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 4199 58325 145603 145667 146078 233941 247954 383110 385494 385779 386068 389142 389504 390928 391405 391437 407387 408701 413283 415452 428502 429142 429936 437878 444113 446792 452908 453105 460611 466466 469360 472698 479771 480481 487937 488363 488982 496842 502062 507616 508706 511061 512223 520187 525355 531593 535314 539335 539770 545167 550514 550516 552688 557348 557814 563112 573596 591045 591161 593060 593634 599737 600700 609551 611280 612160 623955 624788 629806 641807 665197 665224 665294 666080 666160 668699 672717 685509 685527 695835 705999 708743 714332 715722 716516 722457 724762 725564 726590 726859 726860 729972 730847 733265 735947 739759 739778 740586 742777 744209 749486 750511 750536 753738 781917 783417 787756 787860 793716 795915 801825 802382 804630 814374 824224 824533 824633 824732 824765 826594 ] |
||||||||||||||||||||||||||||||
|
12.90 ms (6.18%) |
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 512223 390928 672717 557348 750511 750536 4199 391405 472698 460611 247954 611280 389504 413283 452908 469360 480481 488982 520187 535314 539335 552688 550516 666160 685509 695835 665224 666080 668699 685527 665294 557814 591045 599737 612160 593060 781917 802382 726859 729972 724762 742777 739778 740586 705999 793716 391437 453105 58325 408701 496842 531593 539770 563112 714332 665197 624788 629806 795915 801825 804630 730847 733265 744209 749486 725564 726590 715722 787860 437878 466466 726860 511061 479771 488363 383110 233941 591161 507616 429142 446792 429936 407387 824224 824765 783417 385779 415452 502062 146078 145603 145667 824732 826594 824533 824633 735947 814374 487937 550514 641807 787756 739759 428502 525355 573596 508706 753738 716516 545167 600700 385494 389142 593634 609551 386068 444113 623955 708743 722457 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.63%) |
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 4199 58325 145603 145667 146078 233941 247954 383110 385494 385779 386068 389142 389504 390928 391405 391437 407387 408701 413283 415452 428502 429142 429936 437878 444113 446792 452908 453105 460611 466466 469360 472698 479771 480481 487937 488363 488982 496842 502062 507616 508706 511061 512223 520187 525355 531593 535314 539335 539770 545167 550514 550516 552688 557348 557814 563112 573596 591045 591161 593060 593634 599737 600700 609551 611280 612160 623955 624788 629806 641807 665197 665224 665294 666080 666160 668699 672717 685509 685527 695835 705999 708743 714332 715722 716516 722457 724762 725564 726590 726859 726860 729972 730847 733265 735947 739759 739778 740586 742777 744209 749486 750511 750536 753738 781917 783417 787756 787860 793716 795915 801825 802382 804630 814374 824224 824533 824633 824732 824765 826594 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits natural hairy"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ натуральная натуральные волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.