Query Metrics
7
Database Queries
7
Different statements
182.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.64 ms (85.85%) |
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 386918 388341 423538 423625 425894 434345 435323 435529 438353 441654 449408 451317 452827 453219 453924 459496 461070 461075 466624 482040 489115 496582 496714 500433 502941 506512 507488 510224 510729 511323 514845 530468 534441 536320 538289 544022 545743 547734 551242 552839 568823 577091 582774 582894 583739 584075 588900 589390 591195 591857 600941 605651 611192 615307 618461 628682 635384 641812 647175 648696 649571 661582 665892 667639 669680 677918 687339 696484 696498 706575 707408 710165 714833 726816 727459 727571 729888 732203 733143 733224 733253 733271 742303 745488 746190 749889 757020 757318 757366 758756 760448 762163 765381 780188 782001 785255 786604 790854 791282 794774 796076 796084 796091 796767 796950 801627 801791 802580 808559 810037 810752 810811 812328 813558 814140 814356 815210 816115 816451 ] |
||||||||||||||||||||||||||||||
|
15.57 ms (8.54%) |
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 534441 538289 661582 648696 647175 641812 615307 796076 732203 710165 461070 760448 727459 814356 726816 816451 677918 758756 544022 545743 635384 810752 791282 801791 729888 733253 745488 765381 746190 386918 423625 461075 425894 813558 706575 780188 796767 742303 453219 496582 500433 507488 669680 628682 786867 801627 812328 727571 757318 757366 810037 388341 489115 551242 714833 667639 591857 618461 810811 785255 762163 782001 796091 423538 814140 815210 530468 568823 582894 665892 600941 591195 757020 611192 435323 451317 506512 496714 733224 452827 536320 552839 577091 584075 649571 696498 588900 589390 796950 808559 802580 733143 749889 707408 790854 453924 435529 459496 466624 502941 510729 511323 514845 733271 438353 816115 510224 696484 434345 441654 449408 582774 583739 547734 687339 605651 786604 794774 796084 482040 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.65%) |
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 386918 388341 423538 423625 425894 434345 435323 435529 438353 441654 449408 451317 452827 453219 453924 459496 461070 461075 466624 482040 489115 496582 496714 500433 502941 506512 507488 510224 510729 511323 514845 530468 534441 536320 538289 544022 545743 547734 551242 552839 568823 577091 582774 582894 583739 584075 588900 589390 591195 591857 600941 605651 611192 615307 618461 628682 635384 641812 647175 648696 649571 661582 665892 667639 669680 677918 687339 696484 696498 706575 707408 710165 714833 726816 727459 727571 729888 732203 733143 733224 733253 733271 742303 745488 746190 749889 757020 757318 757366 758756 760448 762163 765381 780188 782001 785255 786604 790854 791282 794774 796076 796084 796091 796767 796950 801627 801791 802580 808559 810037 810752 810811 812328 813558 814140 814356 815210 816115 816451 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucking pussy"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucking pussy"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucking pussy"
]
|
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.