Query Metrics
7
Database Queries
7
Different statements
165.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.73 ms (84.54%) |
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 65883 413805 448853 464523 507446 511462 521702 534583 534639 562434 566265 574019 581980 589657 615886 620707 624665 627881 635522 636099 645499 651347 653368 660445 668674 684513 688411 689977 698824 702993 703807 704144 712665 715838 717074 717288 718119 722089 723463 725658 726283 728538 728936 729005 729078 732955 732991 733041 734701 736987 737453 737978 738509 740593 742314 742984 743870 745782 749741 750382 751216 751275 753665 753999 757486 758391 759933 761524 762500 766800 769278 773777 776993 778338 778597 778711 781163 782370 782479 783528 785343 785597 785975 786411 788964 789082 789578 789701 789725 789801 791040 792474 794784 795064 795640 795665 799998 800979 801101 803200 803590 806646 807400 807474 810955 812977 816641 817661 818926 819044 819479 820156 820585 821831 823183 824253 824504 826144 826288 827941 ] |
||||||||||||||||||||||||||||||
|
14.09 ms (8.52%) |
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 732991 733041 507446 769278 745782 753665 740593 715838 819044 823183 566265 794784 729005 785343 821831 819479 820585 534583 660445 723463 689977 704144 627881 789701 789725 791040 792474 786411 795064 800979 732955 738509 742984 751275 759933 728936 778338 795665 65883 824504 820156 826288 511462 702993 645499 615886 789578 795640 737453 761524 729078 757486 750382 758391 718119 778597 799998 827941 812977 824253 816641 534639 574019 562434 581980 653368 688411 712665 703807 635522 636099 782479 726283 736987 737978 782370 785975 789082 806646 751216 773777 725658 743870 722089 413805 789801 749741 807474 717288 684513 589657 781163 801101 728538 785597 698824 776993 788964 742314 810955 803200 624665 734701 778711 448853 464523 521702 651347 807400 717074 766800 817661 668674 620707 803590 783528 753999 762500 826144 818926 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.88%) |
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 65883 413805 448853 464523 507446 511462 521702 534583 534639 562434 566265 574019 581980 589657 615886 620707 624665 627881 635522 636099 645499 651347 653368 660445 668674 684513 688411 689977 698824 702993 703807 704144 712665 715838 717074 717288 718119 722089 723463 725658 726283 728538 728936 729005 729078 732955 732991 733041 734701 736987 737453 737978 738509 740593 742314 742984 743870 745782 749741 750382 751216 751275 753665 753999 757486 758391 759933 761524 762500 766800 769278 773777 776993 778338 778597 778711 781163 782370 782479 783528 785343 785597 785975 786411 788964 789082 789578 789701 789725 789801 791040 792474 794784 795064 795640 795665 799998 800979 801101 803200 803590 806646 807400 807474 810955 812977 816641 817661 818926 819044 819479 820156 820585 821831 823183 824253 824504 826144 826288 827941 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck me"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс me"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс me"
]
|
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.