Query Metrics
7
Database Queries
7
Different statements
169.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.20 ms (87.86%) |
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 417836 437705 453194 475821 476774 490342 594576 597093 600855 610590 613288 614578 615085 615586 617471 618065 624583 631253 632224 635832 642456 696894 706642 711362 719914 721860 724631 724859 725766 727317 728492 728884 729897 730805 730826 730923 730964 731142 731968 732827 733109 733132 734425 734627 734629 734691 734707 735591 735607 736067 736179 738753 740211 741234 742776 744216 745983 745996 747416 747621 748826 749747 749833 750631 750843 752540 752548 753757 754729 757236 759024 759051 759916 760194 761797 762387 765922 765980 766243 766468 767755 768192 768921 768993 776679 778205 778363 778437 780527 780536 780712 782176 786431 788678 789482 789627 789890 790236 792759 793895 793998 794476 794882 794948 795090 795097 795375 796043 796575 796971 800078 800941 801435 802096 802930 805317 810805 811144 811721 812121 ] |
||||||||||||||||||||||||||||||
|
10.95 ms (6.45%) |
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 642456 632224 594576 597093 600855 613288 614578 615085 624583 635832 615586 617471 631253 778363 778437 780536 780712 782176 789627 789890 793895 794476 794882 794948 800941 802096 805317 810805 778205 789482 790236 795097 796575 796971 801435 730826 730923 730964 734627 736179 742776 747416 749747 749833 752540 752548 759024 760194 792759 795375 800078 802930 811144 732827 734425 740211 741234 744216 727317 733109 733132 738753 745983 747621 748826 750631 759051 759916 766468 767755 725766 728492 728884 729897 730805 731142 731968 734707 735607 750843 761797 762387 765980 724631 724859 734629 734691 735591 736067 745996 753757 754729 757236 765922 766243 768192 768921 768993 610590 618065 696894 706642 711362 719914 721860 776679 780527 786431 788678 793998 795090 796043 811721 812121 417836 437705 476774 453194 475821 490342 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.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 417836 437705 453194 475821 476774 490342 594576 597093 600855 610590 613288 614578 615085 615586 617471 618065 624583 631253 632224 635832 642456 696894 706642 711362 719914 721860 724631 724859 725766 727317 728492 728884 729897 730805 730826 730923 730964 731142 731968 732827 733109 733132 734425 734627 734629 734691 734707 735591 735607 736067 736179 738753 740211 741234 742776 744216 745983 745996 747416 747621 748826 749747 749833 750631 750843 752540 752548 753757 754729 757236 759024 759051 759916 760194 761797 762387 765922 765980 766243 766468 767755 768192 768921 768993 776679 778205 778363 778437 780527 780536 780712 782176 786431 788678 789482 789627 789890 790236 792759 793895 793998 794476 794882 794948 795090 795097 795375 796043 796575 796971 800078 800941 801435 802096 802930 805317 810805 811144 811721 812121 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam hidden"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.79%) |
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.