Query Metrics
7
Database Queries
7
Different statements
203.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.35 ms (87.63%) |
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 92281 385187 407412 410664 441472 530421 540935 549215 552651 575614 585283 595932 608961 610196 613710 616533 616645 628940 630720 635002 636978 645798 657134 658788 661892 669955 680909 688756 702290 706117 713674 714709 716341 716916 716940 717697 720259 720851 724816 726235 726890 729029 729297 729992 733436 734274 734421 734453 738642 740005 744529 745178 751707 759338 760490 762397 762411 762564 763695 765072 766673 767203 769073 771889 771935 773424 774713 775147 776026 777958 779673 779728 781335 783714 783757 787934 789554 791262 791269 792674 793465 794305 794334 795090 795381 795733 796315 797257 797633 798497 799953 800241 800255 801792 805106 805495 810287 817256 817359 818970 819215 820182 825064 825266 825321 825391 825398 825716 825977 826317 826370 826687 826886 826929 827359 827368 827410 828553 ] |
||||||||||||||||||||||||||||||
|
15.68 ms (7.71%) |
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 767203 734274 744529 738642 762564 771889 716916 794334 795090 407412 825064 825391 825266 826929 828553 716940 716341 793465 805495 765072 789554 791269 792674 797633 801792 726890 763695 724816 733436 762397 766673 777958 797257 714709 549215 552651 540935 657134 680909 713674 645798 669955 688756 706117 717697 585283 608961 616645 636978 595932 613710 630720 616533 628940 635002 734421 729297 751707 610196 702290 720259 810287 826317 825398 825716 827410 825321 827359 658788 720851 774713 775147 776026 779673 798497 800241 779728 783757 805106 729029 769073 791262 726235 734453 759338 729992 762411 773424 740005 745178 771935 760490 783714 794305 410664 441472 385187 575614 661892 92281 817359 820182 825977 826687 817256 826886 827368 818970 819215 826370 530421 782835 780466 781335 787934 795381 795733 796315 799953 800255 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.45%) |
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 92281 385187 407412 410664 441472 530421 540935 549215 552651 575614 585283 595932 608961 610196 613710 616533 616645 628940 630720 635002 636978 645798 657134 658788 661892 669955 680909 688756 702290 706117 713674 714709 716341 716916 716940 717697 720259 720851 724816 726235 726890 729029 729297 729992 733436 734274 734421 734453 738642 740005 744529 745178 751707 759338 760490 762397 762411 762564 763695 765072 766673 767203 769073 771889 771935 773424 774713 775147 776026 777958 779673 779728 781335 783714 783757 787934 789554 791262 791269 792674 793465 794305 794334 795090 795381 795733 796315 797257 797633 798497 799953 800241 800255 801792 805106 805495 810287 817256 817359 818970 819215 820182 825064 825266 825321 825391 825398 825716 825977 826317 826370 826687 826886 826929 827359 827368 827410 828553 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep amateur"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"deep любительск"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"deep любительск"
]
|
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.