Query Metrics
7
Database Queries
7
Different statements
174.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.00 ms (86.50%) |
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 78709 142598 184359 210661 381811 387885 391897 392967 394543 398995 403245 403938 410873 423350 454395 456896 457230 464534 470047 470514 470611 470924 475104 475897 483371 495043 504201 530286 530289 532681 533050 534640 535612 536063 536219 542770 543658 545014 547966 555152 555653 557069 567462 572219 575667 575689 578413 579569 583955 587629 588116 592708 595805 603449 603625 604698 605410 605583 606471 606772 619275 621777 622089 624985 625117 630264 630668 630818 631986 632048 633179 635384 636550 640233 641134 642524 643927 648984 650815 651287 653620 653628 660084 667075 671243 676788 679415 681530 691675 691731 693789 694346 696794 702302 705322 705398 712501 713444 714126 714548 716564 719726 720208 721932 721972 721982 724324 725096 726311 732652 732792 732838 734368 734413 736727 739956 748436 749548 762269 787676 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (7.84%) |
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 423350 454395 456896 595805 464534 475104 475897 470047 470924 470514 470611 483371 391897 398995 410873 530289 536219 567462 572219 650815 702302 705322 653628 691731 714548 545014 587629 588116 603625 604698 606772 630668 592708 640233 605410 631986 725096 734368 734413 732792 732652 748436 643927 578413 542770 495043 504201 184359 394543 392967 381811 387885 403245 534640 536063 530286 532681 533050 535612 543658 547966 575667 555152 583955 651287 660084 671243 676788 693789 694346 712501 719726 648984 667075 679415 705398 714126 716564 720208 721972 653620 681530 696794 557069 575689 621777 625117 632048 633179 635384 642524 603449 622089 605583 606471 624985 630264 630818 787676 726311 749548 724324 736727 762269 732838 636550 713444 721932 721982 142598 210661 403938 457230 78709 691675 555653 579569 739956 619275 641134 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.76%) |
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 78709 142598 184359 210661 381811 387885 391897 392967 394543 398995 403245 403938 410873 423350 454395 456896 457230 464534 470047 470514 470611 470924 475104 475897 483371 495043 504201 530286 530289 532681 533050 534640 535612 536063 536219 542770 543658 545014 547966 555152 555653 557069 567462 572219 575667 575689 578413 579569 583955 587629 588116 592708 595805 603449 603625 604698 605410 605583 606471 606772 619275 621777 622089 624985 625117 630264 630668 630818 631986 632048 633179 635384 636550 640233 641134 642524 643927 648984 650815 651287 653620 653628 660084 667075 671243 676788 679415 681530 691675 691731 693789 694346 696794 702302 705322 705398 712501 713444 714126 714548 716564 719726 720208 721932 721972 721982 724324 725096 726311 732652 732792 732838 734368 734413 736727 739956 748436 749548 762269 787676 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife swingers"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен свингер"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен свингер"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.83%) |
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.