Query Metrics
7
Database Queries
7
Different statements
379.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
350.77 ms (92.38%) |
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 246261 421488 423869 423953 426177 426805 441838 446682 450910 450966 453801 457338 458086 476517 487217 488773 497212 499179 499368 500053 500062 500311 501991 505755 507626 508966 509557 509792 514030 515710 517223 520933 521199 524794 527717 535562 538982 540928 545959 546258 549191 551721 553024 554002 555248 555675 556970 558640 559669 559676 561008 561392 561898 562211 562544 562786 565304 565825 567725 572264 575343 578925 579547 580338 584613 590713 592589 593108 594553 606493 610726 620244 622048 622117 622841 631044 649291 651088 651425 685305 704601 704979 706457 713455 713983 726503 735727 740656 747231 747236 757024 762896 763297 764484 764500 773265 780533 784286 784775 785484 794523 795385 796202 796740 797118 797720 797810 802947 810035 811508 811773 812573 817140 817186 817747 818257 821845 827280 827551 827718 ] |
||||||||||||||||||||||||||||||
|
19.26 ms (5.07%) |
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 521199 535562 565304 575343 593108 561898 558640 747231 453801 476517 421488 500053 509792 524794 509557 501991 594553 517223 572264 446682 794523 500311 457338 488773 549191 827551 818257 796740 762896 817747 795385 784775 811773 505755 562544 713983 704979 610726 497212 562786 649291 622048 606493 757024 764500 785484 797720 810035 423869 423953 500062 553024 565825 620244 747236 426805 450966 622841 555675 554002 631044 827718 780533 763297 538982 551721 559669 685305 651088 651425 559676 578925 584613 622117 592589 704601 821845 555248 713455 735727 740656 773265 797118 508966 579547 546258 426177 817140 507626 580338 784286 802947 811508 487217 515710 527717 567725 556970 450910 514030 797810 246261 817186 827280 441838 458086 499368 499179 520933 562211 540928 561392 706457 545959 561008 590713 796202 812573 726503 764484 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (0.75%) |
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 246261 421488 423869 423953 426177 426805 441838 446682 450910 450966 453801 457338 458086 476517 487217 488773 497212 499179 499368 500053 500062 500311 501991 505755 507626 508966 509557 509792 514030 515710 517223 520933 521199 524794 527717 535562 538982 540928 545959 546258 549191 551721 553024 554002 555248 555675 556970 558640 559669 559676 561008 561392 561898 562211 562544 562786 565304 565825 567725 572264 575343 578925 579547 580338 584613 590713 592589 593108 594553 606493 610726 620244 622048 622117 622841 631044 649291 651088 651425 685305 704601 704979 706457 713455 713983 726503 735727 740656 747231 747236 757024 762896 763297 764484 764500 773265 780533 784286 784775 785484 794523 795385 796202 796740 797118 797720 797810 802947 810035 811508 811773 812573 817140 817186 817747 818257 821845 827280 827551 827718 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade bondage"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.41%) |
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.