Query Metrics
7
Database Queries
7
Different statements
388.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.96 ms (55.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп cumshot"
]
|
||||||||||||||||||||||||||||||
|
153.34 ms (39.45%) |
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 389788 389793 391101 392524 397188 398579 416116 416952 420322 427062 432483 480077 499832 507459 510739 528600 537666 540453 542186 553636 553806 559334 563237 587394 590105 602675 606512 613942 614740 616039 620968 621289 627854 629653 629660 633225 634892 641328 642274 655602 660779 662195 662401 667993 669315 676552 676660 677981 678593 689085 689488 689524 693643 696118 697247 702305 708170 714958 717155 721811 721916 730078 731007 736088 738441 741111 741789 746187 747431 749853 750183 756673 761115 761207 761461 764242 767684 770084 770819 775878 776984 779891 783627 785207 786096 787868 789927 790949 791157 791881 792440 793853 793865 794828 795101 795977 797134 797203 799438 799590 801424 803436 804662 808448 810993 811734 812587 813308 813991 813995 817283 819690 820006 820347 824825 826378 826590 826683 826710 827709 ] |
||||||||||||||||||||||||||||||
|
13.44 ms (3.46%) |
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 432483 528600 391101 397188 820347 826683 826590 826710 813991 819690 820006 824825 507459 540453 553806 559334 542186 667993 676552 662195 669315 677981 689524 708170 616039 620968 642274 627854 776984 779891 790949 799590 801424 775878 786096 793853 793865 797134 741789 747431 785207 803436 808448 741111 746187 736088 756673 767684 738441 749853 761207 770084 614740 810993 813995 827709 389793 416952 702305 693643 696118 606512 590105 621289 629660 641328 787868 791881 812587 750183 761115 721916 783627 427062 416116 795977 392524 389788 398579 420322 587394 633225 792440 811734 794828 797203 764242 761461 770819 795101 826378 817283 480077 499832 510739 537666 563237 553636 662401 689488 697247 717155 676660 689085 721811 655602 660779 678593 714958 634892 613942 629653 602675 789927 791157 799438 813308 804662 730078 731007 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (0.75%) |
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 389788 389793 391101 392524 397188 398579 416116 416952 420322 427062 432483 480077 499832 507459 510739 528600 537666 540453 542186 553636 553806 559334 563237 587394 590105 602675 606512 613942 614740 616039 620968 621289 627854 629653 629660 633225 634892 641328 642274 655602 660779 662195 662401 667993 669315 676552 676660 677981 678593 689085 689488 689524 693643 696118 697247 702305 708170 714958 717155 721811 721916 730078 731007 736088 738441 741111 741789 746187 747431 749853 750183 756673 761115 761207 761461 764242 767684 770084 770819 775878 776984 779891 783627 785207 786096 787868 789927 790949 791157 791881 792440 793853 793865 794828 795101 795977 797134 797203 799438 799590 801424 803436 804662 808448 810993 811734 812587 813308 813991 813995 817283 819690 820006 820347 824825 826378 826590 826683 826710 827709 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.