Query Metrics
7
Database Queries
7
Different statements
425.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.86 ms (49.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал real"
]
|
||||||||||||||||||||||||||||||
|
191.65 ms (45.00%) |
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 382432 395735 401264 401757 420254 420877 423516 427544 432743 432745 440274 440414 440749 440902 440947 440963 441984 451629 455745 457146 458443 459650 462681 464853 465540 468749 487987 499083 505725 516692 520790 525039 537958 541755 552697 560966 562225 564750 577678 581384 590029 598623 599072 604221 608070 610434 610517 610522 614880 615841 619797 621979 626688 631117 633455 636951 641153 647060 656597 659324 665831 668097 685843 692817 695882 696198 696536 707569 712374 712393 713676 719225 720449 721978 724048 727805 727882 731224 731361 732579 735005 740009 748334 757715 760214 761030 761531 762199 766588 769291 769683 771858 784288 784292 786578 789273 790972 791416 792184 793075 793597 796183 796194 798675 800975 801290 801737 805643 807419 813016 815174 815729 816052 816359 816544 818833 820164 823359 824320 824868 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (3.89%) |
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 735005 816052 731224 732579 815174 818833 815729 816359 816544 695882 696198 621979 641153 590029 784292 786578 792184 731361 769683 789273 440963 824320 459650 499083 516692 564750 712374 720449 665831 656597 685843 696536 793075 796183 801737 793597 761531 766588 796194 762199 771858 631117 791416 805643 692817 401264 441984 487987 619797 727805 455745 432743 824868 525039 713676 659324 740009 761030 440947 465540 440749 427544 440902 541755 610522 633455 598623 610517 636951 608070 807419 760214 813016 727882 707569 382432 820164 721978 719225 668097 560966 610434 626688 790972 800975 801290 798675 784288 748334 757715 712393 423516 464853 468749 537958 562225 581384 647060 599072 604221 615841 769291 401757 395735 458443 457146 505725 552697 823359 451629 462681 577678 614880 724048 420254 440274 440414 432745 420877 520790 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (0.71%) |
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 382432 395735 401264 401757 420254 420877 423516 427544 432743 432745 440274 440414 440749 440902 440947 440963 441984 451629 455745 457146 458443 459650 462681 464853 465540 468749 487987 499083 505725 516692 520790 525039 537958 541755 552697 560966 562225 564750 577678 581384 590029 598623 599072 604221 608070 610434 610517 610522 614880 615841 619797 621979 626688 631117 633455 636951 641153 647060 656597 659324 665831 668097 685843 692817 695882 696198 696536 707569 712374 712393 713676 719225 720449 721978 724048 727805 727882 731224 731361 732579 735005 740009 748334 757715 760214 761030 761531 762199 766588 769291 769683 771858 784288 784292 786578 789273 790972 791416 792184 793075 793597 796183 796194 798675 800975 801290 801737 805643 807419 813016 815174 815729 816052 816359 816544 818833 820164 823359 824320 824868 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal real"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал real"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.34%) |
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.