Query Metrics
7
Database Queries
7
Different statements
216.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.70 ms (90.37%) |
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 390671 415745 429911 460979 469097 488633 530081 535705 535939 536895 543105 545224 551594 560255 573134 573288 573734 574342 575299 579180 582013 587144 590835 593196 595077 596044 598009 598640 604846 604847 604872 604892 607519 610158 613722 615697 617729 617793 618934 625032 637303 639904 641319 647214 648569 660620 664604 669989 672836 679296 680754 680925 681766 684677 684678 688696 688703 689885 692831 693378 698381 704152 708597 709379 709761 711096 711347 714223 717300 721204 729466 730055 730230 738087 740527 740540 740775 742312 747334 749207 749579 749594 751004 751335 751345 751784 751843 753021 754171 757189 757222 758068 758541 760569 765808 767709 774117 774646 777346 778862 782534 783169 783246 783248 783250 783375 785655 789797 791344 796753 803594 807564 807648 810889 812365 813710 813741 813943 824831 ] |
||||||||||||||||||||||||||||||
|
10.50 ms (4.85%) |
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 573734 415745 469097 488633 390671 607519 460979 681766 618934 604892 596044 639904 738087 791344 582013 664604 684678 625032 573288 787903 757189 777346 704152 740540 749579 767709 535939 693378 714223 672836 615697 684677 688696 751004 749594 648569 803594 604847 617729 604846 590835 593196 551594 530081 711347 730055 774646 637303 598640 783375 688703 824831 813741 730230 536895 679296 692831 613722 604872 598009 807648 789797 783250 810889 751345 711096 560255 785655 740775 774117 807564 812365 751784 751843 709761 778862 573134 689885 587144 758541 680925 574342 543105 575299 698381 641319 783248 749207 753021 757222 783169 796753 751335 765808 721204 813943 742312 758068 717300 783246 708597 740527 754171 782534 535705 579180 647214 610158 747334 680754 709379 595077 617793 760569 669989 729466 429911 813710 545224 660620 ] |
||||||||||||||||||||||||||||||
|
4.03 ms (1.86%) |
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 390671 415745 429911 460979 469097 488633 530081 535705 535939 536895 543105 545224 551594 560255 573134 573288 573734 574342 575299 579180 582013 587144 590835 593196 595077 596044 598009 598640 604846 604847 604872 604892 607519 610158 613722 615697 617729 617793 618934 625032 637303 639904 641319 647214 648569 660620 664604 669989 672836 679296 680754 680925 681766 684677 684678 688696 688703 689885 692831 693378 698381 704152 708597 709379 709761 711096 711347 714223 717300 721204 729466 730055 730230 738087 740527 740540 740775 742312 747334 749207 749579 749594 751004 751335 751345 751784 751843 753021 754171 757189 757222 758068 758541 760569 765808 767709 774117 774646 777346 778862 782534 783169 783246 783248 783250 783375 785655 789797 791344 796753 803594 807564 807648 810889 812365 813710 813741 813943 824831 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск соло"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск соло"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home made solo"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.66%) |
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.