Query Metrics
7
Database Queries
7
Different statements
169.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.77 ms (87.58%) |
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 394406 464775 496371 519235 531916 531924 531960 532110 533162 537009 538112 538536 539374 543486 545333 546562 553309 563862 571439 582611 592003 592668 604612 615519 619343 619602 628302 629642 629662 630026 632450 638184 639153 639525 648697 648894 651262 656834 661428 664169 664663 668866 678192 679089 679125 679138 682991 685308 690900 692306 692788 692802 693029 694062 694454 694499 694550 695392 696268 696275 697560 697615 697775 698554 699425 699706 701414 703718 707695 708325 715542 716445 716876 717097 718138 719309 720153 720185 723216 725545 726044 727413 728112 728131 731316 733206 733484 733648 734014 736384 737478 742551 743893 746147 746885 751174 755054 755395 760191 762280 764550 764570 768338 768470 768750 778221 781137 786314 789686 793153 793251 795325 799013 799481 802873 810033 810361 810368 827068 ] |
||||||||||||||||||||||||||||||
|
11.29 ms (6.65%) |
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 694550 604612 781137 802873 764550 768470 632450 799013 539374 537009 533162 694499 728112 746147 755395 543486 592003 563862 685308 746885 795325 538112 755054 726044 743893 394406 553309 648697 697775 718138 699425 733648 768750 697615 810361 496371 546562 696268 668866 734014 760191 703718 810368 519235 538536 545333 793251 733484 763063 751174 723216 531916 727413 715542 720153 720185 656834 690900 701414 639525 628302 725545 731316 615519 619343 630026 639153 697560 827068 651262 592668 786314 789686 768338 810033 733206 762280 764570 582611 464775 531960 678192 629662 619602 629642 799481 793153 736384 728131 737478 778221 571439 707695 532110 531924 638184 742551 716876 717097 648894 661428 679089 694062 695392 696275 698554 708325 719309 664663 679138 692306 692788 664169 679125 682991 692802 693029 694454 699706 716445 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.49%) |
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 394406 464775 496371 519235 531916 531924 531960 532110 533162 537009 538112 538536 539374 543486 545333 546562 553309 563862 571439 582611 592003 592668 604612 615519 619343 619602 628302 629642 629662 630026 632450 638184 639153 639525 648697 648894 651262 656834 661428 664169 664663 668866 678192 679089 679125 679138 682991 685308 690900 692306 692788 692802 693029 694062 694454 694499 694550 695392 696268 696275 697560 697615 697775 698554 699425 699706 701414 703718 707695 708325 715542 716445 716876 717097 718138 719309 720153 720185 723216 725545 726044 727413 728112 728131 731316 733206 733484 733648 734014 736384 737478 742551 743893 746147 746885 751174 755054 755395 760191 762280 764550 764570 768338 768470 768750 778221 781137 786314 789686 793153 793251 795325 799013 799481 802873 810033 810361 810368 827068 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2 хуя"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"два член"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.92%) |
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.