Query Metrics
7
Database Queries
7
Different statements
361.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.76 ms (56.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
136.54 ms (37.82%) |
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 396802 452594 546700 550552 554120 565233 565239 566465 567314 575043 584040 585228 587739 592289 599085 601386 602008 610124 610726 619611 621280 626509 632547 634975 642109 642640 643268 643800 645721 647405 647766 650032 650650 660352 661638 661669 665638 666075 667804 674949 685930 686999 688738 689119 694991 697187 698803 699129 699265 704345 704979 708071 708986 710141 710242 711117 712442 712621 713295 714505 717038 717476 719410 719933 725280 733075 733796 737700 737884 738188 739933 740137 748859 757489 757698 757943 758344 763449 765811 769194 774032 782038 783796 789263 789867 792198 792263 795112 795189 795586 796754 797569 801525 801694 803337 816162 817559 818285 818401 818837 819347 819430 819912 823948 824296 824387 824701 825549 825589 825638 825702 826064 826731 826982 826999 827817 828563 828582 828676 ] |
||||||||||||||||||||||||||||||
|
11.63 ms (3.22%) |
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 825638 546700 554120 575043 584040 645721 711117 717476 647405 647766 689119 710242 714505 650032 665638 666075 688738 719410 565233 643268 599085 634975 610124 795189 795586 801694 733075 733796 737700 758344 774032 725280 737884 740137 738188 632547 717038 826731 819347 819430 825702 826982 826999 818837 818401 823948 825589 828676 699265 587739 792198 796754 757943 763449 748859 757698 782038 789263 792263 396802 817559 818285 819912 816162 826064 826432 827817 828582 828563 789867 795112 797569 801525 719933 824701 739933 602008 452594 565239 567314 550552 566465 661638 710141 713295 660352 661669 667804 674949 694991 704345 704979 708986 712621 650650 685930 686999 697187 698803 708071 712442 592289 621280 642640 585228 619611 601386 626509 642109 643800 803337 783796 769194 757489 765811 610726 699129 824387 824296 825549 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (0.82%) |
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 396802 452594 546700 550552 554120 565233 565239 566465 567314 575043 584040 585228 587739 592289 599085 601386 602008 610124 610726 619611 621280 626509 632547 634975 642109 642640 643268 643800 645721 647405 647766 650032 650650 660352 661638 661669 665638 666075 667804 674949 685930 686999 688738 689119 694991 697187 698803 699129 699265 704345 704979 708071 708986 710141 710242 711117 712442 712621 713295 714505 717038 717476 719410 719933 725280 733075 733796 737700 737884 738188 739933 740137 748859 757489 757698 757943 758344 763449 765811 769194 774032 782038 783796 789263 789867 792198 792263 795112 795189 795586 796754 797569 801525 801694 803337 816162 817559 818285 818401 818837 819347 819430 819912 823948 824296 824387 824701 825549 825589 825638 825702 826064 826731 826982 826999 827817 828563 828582 828676 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur fucked"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск fucked"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск fucked"
]
|
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.