Query Metrics
7
Database Queries
7
Different statements
187.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.00 ms (87.07%) |
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 466728 466758 467323 468047 487843 489161 508103 510925 514310 523583 524472 524656 526567 529066 532041 533706 533750 537678 537756 540642 569871 570641 574984 584981 588843 592584 592695 594499 596252 597174 605166 606079 606176 608912 611443 616727 617174 621026 622033 623846 630925 636483 665253 697927 703279 707490 709835 720029 726059 726398 727523 730031 731659 733651 736128 738533 738759 739995 740058 744777 745073 745459 747711 749934 750877 756724 757688 757737 757996 758228 758277 758402 759301 760382 760517 760520 760523 760721 760756 761634 761796 761883 763343 766460 768465 768472 770049 775577 776601 777472 781270 782307 782555 782597 783970 784169 786339 790133 790760 791726 791918 792308 795329 796511 797884 797955 797957 798016 798035 799039 800812 802551 802821 802831 804251 809561 809566 810535 811150 811231 ] |
||||||||||||||||||||||||||||||
|
13.64 ms (7.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 569871 570641 574984 608912 622033 636483 605166 606176 594499 596252 597174 616727 630925 588843 592584 592695 606079 611443 621026 623846 776601 781270 783970 790133 796511 809566 811231 777472 782307 784169 786339 791918 797884 797955 797957 798016 798035 799039 800812 802821 811150 736128 739995 740058 744777 758402 760517 760520 760721 760756 761634 761796 768465 770049 782597 790760 802831 804251 809561 810535 730031 738533 750877 757996 758228 759301 766460 726398 727523 768472 726059 745073 745459 747711 756724 757688 760382 763343 731659 733651 738759 749934 757737 758277 760523 761883 617174 697927 703279 707490 709835 720029 775577 782555 791726 792308 795329 802551 466758 487843 584981 665253 466728 467323 468047 489161 510925 524472 524656 526567 532041 533706 537678 540642 514310 523583 529066 533750 537756 508103 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.81%) |
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 466728 466758 467323 468047 487843 489161 508103 510925 514310 523583 524472 524656 526567 529066 532041 533706 533750 537678 537756 540642 569871 570641 574984 584981 588843 592584 592695 594499 596252 597174 605166 606079 606176 608912 611443 616727 617174 621026 622033 623846 630925 636483 665253 697927 703279 707490 709835 720029 726059 726398 727523 730031 731659 733651 736128 738533 738759 739995 740058 744777 745073 745459 747711 749934 750877 756724 757688 757737 757996 758228 758277 758402 759301 760382 760517 760520 760523 760721 760756 761634 761796 761883 763343 766460 768465 768472 770049 775577 776601 777472 781270 782307 782555 782597 783970 784169 786339 790133 790760 791726 791918 792308 795329 796511 797884 797955 797957 798016 798035 799039 800812 802551 802821 802831 804251 809561 809566 810535 811150 811231 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с разговорам"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"разговор"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.79%) |
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.