Query Metrics
7
Database Queries
7
Different statements
226.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
200.23 ms (88.47%) |
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 49767 385608 386671 390397 404101 446139 463644 466670 495761 504101 506444 513057 522561 523044 524648 525734 527665 530397 533711 534619 540101 540705 540708 541194 542460 546164 549781 552283 552497 553707 555677 555826 556093 560164 560166 561203 561387 562032 569024 575663 577679 582461 582514 616457 616839 617789 618662 618955 622283 623352 626411 628623 631136 633408 635519 644850 649905 649913 661357 661577 663836 663893 669857 669899 669905 681546 685523 685525 695674 696004 696052 696685 697934 698709 700906 701628 702350 702372 708090 713145 713951 714042 717600 718600 718703 720474 721918 730499 735838 738950 741078 760856 765796 767437 772500 774084 779614 783656 787485 790395 798922 798938 798959 802927 812228 813338 814096 814715 817620 819240 820920 823038 823155 825633 828021 828114 828139 828140 828263 ] |
||||||||||||||||||||||||||||||
|
15.50 ms (6.85%) |
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 828140 828139 828114 390397 819240 825633 820920 814096 817620 823038 823155 828021 828263 540101 541194 542460 561203 702350 702372 713951 708090 635519 790395 798922 798938 812228 783656 787485 813338 735838 741078 767437 772500 774084 730499 760856 738950 765796 618662 717600 798959 802927 49767 385608 446139 524648 522561 527665 534619 495761 466670 582514 569024 714042 649905 681546 577679 633408 463644 386671 404101 644850 814715 513057 530397 540705 525734 533711 540708 504101 506444 523044 549781 552283 552497 555826 560166 561387 562032 546559 553707 560164 575663 546164 555677 556093 661357 685523 685525 695674 649913 663836 663893 669857 669899 696004 696052 696685 700906 713145 718703 720474 661577 669905 697934 698709 701628 718600 721918 582461 616457 626411 628623 622283 616839 631136 617789 618955 623352 779614 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"улице"
]
|
||||||||||||||||||||||||||||||
|
2.75 ms (1.22%) |
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 49767 385608 386671 390397 404101 446139 463644 466670 495761 504101 506444 513057 522561 523044 524648 525734 527665 530397 533711 534619 540101 540705 540708 541194 542460 546164 549781 552283 552497 553707 555677 555826 556093 560164 560166 561203 561387 562032 569024 575663 577679 582461 582514 616457 616839 617789 618662 618955 622283 623352 626411 628623 631136 633408 635519 644850 649905 649913 661357 661577 663836 663893 669857 669899 669905 681546 685523 685525 695674 696004 696052 696685 697934 698709 700906 701628 702350 702372 708090 713145 713951 714042 717600 718600 718703 720474 721918 730499 735838 738950 741078 760856 765796 767437 772500 774084 779614 783656 787485 790395 798922 798938 798959 802927 812228 813338 814096 814715 817620 819240 820920 823038 823155 825633 828021 828114 828139 828140 828263 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"улиц"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.65%) |
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.