Query Metrics
7
Database Queries
7
Different statements
158.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.50 ms (85.65%) |
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 397932 398138 398733 410905 486044 487872 505591 529841 530092 530280 530651 532402 533700 533712 534862 535371 536053 536079 536082 540165 541944 542722 545798 547070 547445 547763 551891 552519 555319 561511 562157 563408 564860 570941 574656 578937 579523 589374 593661 595029 596549 599705 600778 612985 626831 634369 634712 641479 643668 644974 647200 651328 661329 666476 666708 676756 682956 683766 691112 691847 694121 695005 695652 695980 695997 696009 696061 697079 704387 707264 708297 709517 713779 724318 726049 728188 731399 735118 736507 736924 740148 741582 743872 747634 751242 751408 752145 754644 755737 757557 758155 758942 761483 764879 777156 778140 778925 780210 780649 780742 782745 783750 790433 792990 793019 793940 798812 799822 800448 802816 804881 809742 809972 812669 813802 820475 824239 828036 828050 828149 ] |
||||||||||||||||||||||||||||||
|
11.26 ms (7.12%) |
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 486044 579523 547763 547070 574656 708297 778925 804881 780742 736924 755737 783750 728188 741582 747634 751408 758155 764879 724318 752145 736507 754644 726049 634712 410905 545798 792990 802816 812669 793940 809972 643668 595029 530092 626831 740148 487872 828050 828036 644974 813802 820475 695652 695980 695997 696009 696061 709517 666476 563408 641479 589374 780649 761483 697079 793019 505591 534862 529841 533712 535371 532402 676756 647200 661329 612985 593661 599705 735118 824239 828149 536082 530651 533700 547445 778140 780210 790433 731399 757557 743872 777156 758942 398733 799822 800448 809742 798812 398138 683766 634369 694121 782745 751242 564860 691847 397932 530280 536053 540165 536079 541944 561511 542722 552519 562157 578937 707264 651328 666708 695005 704387 713779 682956 691112 551891 555319 570941 600778 596549 ] |
||||||||||||||||||||||||||||||
|
3.86 ms (2.44%) |
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 397932 398138 398733 410905 486044 487872 505591 529841 530092 530280 530651 532402 533700 533712 534862 535371 536053 536079 536082 540165 541944 542722 545798 547070 547445 547763 551891 552519 555319 561511 562157 563408 564860 570941 574656 578937 579523 589374 593661 595029 596549 599705 600778 612985 626831 634369 634712 641479 643668 644974 647200 651328 661329 666476 666708 676756 682956 683766 691112 691847 694121 695005 695652 695980 695997 696009 696061 697079 704387 707264 708297 709517 713779 724318 726049 728188 731399 735118 736507 736924 740148 741582 743872 747634 751242 751408 752145 754644 755737 757557 758155 758942 761483 764879 777156 778140 778925 780210 780649 780742 782745 783750 790433 792990 793019 793940 798812 799822 800448 802816 804881 809742 809972 812669 813802 820475 824239 828036 828050 828149 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public amateur"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц любительск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.12%) |
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.