Query Metrics
7
Database Queries
7
Different statements
197.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.17 ms (86.11%) |
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 91954 136874 154410 386767 387039 389745 404217 410768 414004 417053 445740 450814 455156 456920 463373 463906 469287 470848 489361 489394 492125 505836 509805 516750 516770 516773 516775 518975 524862 525756 530028 530729 530911 531114 531126 531171 531225 531242 532360 532674 532852 533382 534986 534993 534995 535026 536337 537204 544833 545461 548552 551711 553282 562491 565557 568543 590312 590850 591695 596900 597197 599631 601102 604661 615716 617418 617428 617429 617437 631247 632645 632655 632663 634116 634163 635258 639008 639027 640723 640795 641678 644961 651607 653820 666551 674978 675430 676623 676808 678127 681279 681563 684213 716878 717318 718158 727888 741288 754210 756398 759865 766847 771482 774049 788283 789419 804370 810839 812505 814733 818494 821729 821905 822578 822728 822922 823794 828457 828864 ] |
||||||||||||||||||||||||||||||
|
17.62 ms (8.92%) |
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 766847 531171 741288 771482 404217 666551 640795 639008 788283 756398 463906 470848 676808 518975 684213 810839 492125 455156 463373 414004 386767 590312 410768 450814 489394 640723 516770 456920 534986 544833 389745 534993 516750 553282 617429 590850 759865 727888 632655 516775 530911 525756 568543 675430 604661 634163 505836 489361 530729 814733 531114 597197 717318 387039 644961 531242 532852 617418 154410 674978 531225 639027 823794 445740 509805 681563 754210 596900 599631 536337 524862 601102 828864 551711 678127 534995 718158 531126 530028 641678 469287 617437 632645 716878 676623 634116 631247 562491 822993 828457 804370 533382 651607 617428 136874 821905 565557 417053 822578 91954 653820 774049 681279 635258 818494 822728 822922 535026 548552 516773 532674 615716 532360 591695 632663 537204 545461 821729 812505 789419 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.52%) |
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 91954 136874 154410 386767 387039 389745 404217 410768 414004 417053 445740 450814 455156 456920 463373 463906 469287 470848 489361 489394 492125 505836 509805 516750 516770 516773 516775 518975 524862 525756 530028 530729 530911 531114 531126 531171 531225 531242 532360 532674 532852 533382 534986 534993 534995 535026 536337 537204 544833 545461 548552 551711 553282 562491 565557 568543 590312 590850 591695 596900 597197 599631 601102 604661 615716 617418 617428 617429 617437 631247 632645 632655 632663 634116 634163 635258 639008 639027 640723 640795 641678 644961 651607 653820 666551 674978 675430 676623 676808 678127 681279 681563 684213 716878 717318 718158 727888 741288 754210 756398 759865 766847 771482 774049 788283 789419 804370 810839 812505 814733 818494 821729 821905 822578 822728 822922 823794 828457 828864 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black fuck"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black секс"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black секс"
]
|
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.