Query Metrics
7
Database Queries
7
Different statements
177.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.15 ms (86.21%) |
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 31583 199865 210106 309095 396765 409984 413262 415796 425405 429252 457073 460395 466671 475983 504641 513482 514719 515062 516220 523943 527602 530082 533179 534368 534723 534864 535413 536079 539787 541102 541190 541986 542722 546336 546839 550172 551567 553235 554706 555979 556090 557048 558531 567575 573989 574711 577002 586351 588293 589728 592719 595029 601220 606206 613579 613608 621168 627851 628730 632224 634855 635720 640870 647126 650037 660115 661347 661357 667436 668538 672354 672369 681234 683568 690415 690441 691227 691231 692436 693541 696046 696664 696687 708671 717052 717224 718029 718904 720510 734028 736489 738976 740614 741580 745998 747535 751242 752926 754635 758942 758949 761069 761159 761160 768606 771990 772435 775815 784252 799590 803366 810621 811853 811857 820442 820983 821477 822634 823343 ] |
||||||||||||||||||||||||||||||
|
14.40 ms (8.11%) |
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 741580 754635 761160 696664 696687 708671 534864 573989 541190 717224 650037 621168 635720 751242 758949 758942 627851 775815 595029 523943 513482 516220 555979 628730 466671 31583 429252 556090 667436 588293 613608 606206 752926 199865 309095 551567 514719 460395 475983 696046 672369 660115 613579 718904 557048 589728 820442 821477 828355 811853 527602 661357 734028 409984 539787 546336 541102 550172 574711 567575 668538 634855 799590 803366 810621 745998 425405 504641 515062 592719 541986 554706 681234 691231 693541 661347 647126 690441 691227 692436 717052 632224 747535 761069 535413 534368 534723 546839 553235 577002 718029 683568 586351 601220 772435 740614 720510 413262 457073 533179 558531 784252 736489 530082 672354 396765 820983 823343 822634 536079 542722 690415 640870 768606 771990 738976 761159 811857 415796 210106 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.61%) |
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 31583 199865 210106 309095 396765 409984 413262 415796 425405 429252 457073 460395 466671 475983 504641 513482 514719 515062 516220 523943 527602 530082 533179 534368 534723 534864 535413 536079 539787 541102 541190 541986 542722 546336 546839 550172 551567 553235 554706 555979 556090 557048 558531 567575 573989 574711 577002 586351 588293 589728 592719 595029 601220 606206 613579 613608 621168 627851 628730 632224 634855 635720 640870 647126 650037 660115 661347 661357 667436 668538 672354 672369 681234 683568 690415 690441 691227 691231 692436 693541 696046 696664 696687 708671 717052 717224 718029 718904 720510 734028 736489 738976 740614 741580 745998 747535 751242 752926 754635 758942 758949 761069 761159 761160 768606 771990 772435 775815 784252 799590 803366 810621 811853 811857 820442 820983 821477 822634 823343 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public agen big"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на agen улиц большие"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на agen улиц большие"
]
|
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.