Query Metrics
7
Database Queries
7
Different statements
207.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.65 ms (84.23%) |
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 420736 422223 422408 435477 441747 487466 490757 499578 509163 512032 541301 549012 551693 561282 571437 584469 588531 588885 593153 608609 610252 615215 616438 616509 619084 623918 628923 629554 630976 636436 639238 656147 664225 664689 666890 668060 676673 679602 687147 696984 702280 724889 734289 735899 761954 762647 762655 762661 764748 766591 767335 767871 769137 771576 772010 773780 777106 779150 779785 779891 785737 787263 788150 789174 789385 791089 791287 791335 791530 791636 791818 792454 793076 793084 793518 793905 794111 794117 794201 794394 794571 794712 794757 794893 795118 795751 795826 796490 796623 797661 797665 797901 799698 799741 800769 803311 803614 803736 803795 803943 805106 805297 809716 814421 818763 819290 819447 819889 820534 820561 821600 823178 823201 823430 824669 825607 825676 826368 826437 ] |
||||||||||||||||||||||||||||||
|
23.41 ms (11.29%) |
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 420736 820561 821600 823178 826368 826437 820534 825607 818763 819290 819447 823430 826439 819889 823201 825676 571437 551693 664225 668060 664689 561282 610252 628923 791089 794201 803795 777106 789174 793076 793518 797901 799741 805106 789385 791287 794111 794571 795118 803736 734289 761954 762655 772010 779785 792454 796623 805297 435477 422223 824669 794117 490757 512032 636436 630976 794757 771576 696984 509163 584469 549012 702280 616509 588531 794394 791335 735899 797661 797665 441747 422408 814421 499578 487466 541301 656147 679602 666890 676673 687147 615215 629554 588885 608609 593153 616438 619084 623918 639238 779150 779891 785737 791530 795826 803311 791636 793084 794712 799698 800769 724889 769137 787263 788150 794893 796490 803614 803943 809716 766591 773780 762647 762661 767871 764748 767335 791818 793905 795751 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.03%) |
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 420736 422223 422408 435477 441747 487466 490757 499578 509163 512032 541301 549012 551693 561282 571437 584469 588531 588885 593153 608609 610252 615215 616438 616509 619084 623918 628923 629554 630976 636436 639238 656147 664225 664689 666890 668060 676673 679602 687147 696984 702280 724889 734289 735899 761954 762647 762655 762661 764748 766591 767335 767871 769137 771576 772010 773780 777106 779150 779785 779891 785737 787263 788150 789174 789385 791089 791287 791335 791530 791636 791818 792454 793076 793084 793518 793905 794111 794117 794201 794394 794571 794712 794757 794893 795118 795751 795826 796490 796623 797661 797665 797901 799698 799741 800769 803311 803614 803736 803795 803943 805106 805297 809716 814421 818763 819290 819447 819889 820534 820561 821600 823178 823201 823430 824669 825607 825676 826368 826437 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy sperm pov"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy сперм пов"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy сперм пов"
]
|
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.