Query Metrics
7
Database Queries
7
Different statements
252.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
223.05 ms (88.34%) |
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 31432 33236 220792 246488 340613 383681 385121 386846 387287 389891 389966 391507 393585 396983 397205 402009 404415 407531 413254 415452 418354 428362 428616 431667 435613 443164 444475 445623 446533 447656 449096 449097 457097 457119 460626 462911 465076 467036 469276 469290 470184 470195 470989 471012 477552 477556 478484 491453 493411 502280 506835 507832 510938 519818 524639 529004 531673 538179 538858 544487 545246 546618 558314 562153 562420 570314 570941 571187 577079 581267 587964 590724 590958 621051 622626 624734 627052 629311 629773 629799 630254 641769 642797 643426 660098 663509 665142 667496 674722 681298 682543 683842 685785 689868 691821 698930 701094 722438 726133 730659 735622 737208 742335 743227 750135 754317 758462 759377 768180 771698 776412 784993 804749 805816 806000 810010 810097 812094 814112 823914 ] |
||||||||||||||||||||||||||||||
|
17.52 ms (6.94%) |
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 538179 538858 529004 531673 570314 571187 577079 581267 660098 674722 691821 682543 685785 698930 683842 689868 722438 570941 629311 641769 622626 642797 805816 810097 804749 730659 737208 743227 758462 806000 810010 812094 726133 735622 754317 759377 768180 742335 771698 750135 627052 643426 701094 776412 784993 823914 383681 391507 397205 443164 444475 477552 457119 465076 491453 544487 545246 546618 630254 621051 340613 413254 449097 470195 33236 246488 457097 469290 428362 507832 389891 428616 431667 407531 477556 471012 524639 510938 519818 506835 562420 558314 562153 667496 663509 665142 681298 590724 587964 590958 629773 629799 31432 415452 435613 467036 624734 389966 393585 493411 386846 385121 220792 387287 396983 402009 404415 418354 814112 445623 446533 449096 470989 447656 460626 462911 470184 502280 469276 478484 ] |
||||||||||||||||||||||||||||||
|
4.22 ms (1.67%) |
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 31432 33236 220792 246488 340613 383681 385121 386846 387287 389891 389966 391507 393585 396983 397205 402009 404415 407531 413254 415452 418354 428362 428616 431667 435613 443164 444475 445623 446533 447656 449096 449097 457097 457119 460626 462911 465076 467036 469276 469290 470184 470195 470989 471012 477552 477556 478484 491453 493411 502280 506835 507832 510938 519818 524639 529004 531673 538179 538858 544487 545246 546618 558314 562153 562420 570314 570941 571187 577079 581267 587964 590724 590958 621051 622626 624734 627052 629311 629773 629799 630254 641769 642797 643426 660098 663509 665142 667496 674722 681298 682543 683842 685785 689868 691821 698930 701094 722438 726133 730659 735622 737208 742335 743227 750135 754317 758462 759377 768180 771698 776412 784993 804749 805816 806000 810010 810097 812094 814112 823914 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette hairy"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.63%) |
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.