Query Metrics
7
Database Queries
7
Different statements
139.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.93 ms (81.84%) |
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 11718 21500 61536 389863 391976 395664 404384 413044 415988 419991 422947 428786 429385 432687 443603 445431 447426 451867 458605 465527 467955 468666 473184 487188 488750 493256 497454 498988 511262 511265 512219 523536 527109 527484 528308 530045 532798 542207 543874 550747 554425 554866 558380 566007 566908 568501 574141 579721 583210 584339 586034 586619 586668 597823 619439 621029 625360 630280 633746 639783 645525 646339 646776 647619 650944 651611 656626 662133 667755 669570 672248 680260 692714 695278 697354 697789 698597 699755 699775 700282 709880 712722 714304 717899 721719 722519 724285 726665 733882 738640 738686 739445 739480 740500 752759 758867 761466 761467 761490 761565 761572 765721 766603 767057 767327 770424 771177 785568 788187 800531 803450 805431 810813 813226 815024 815674 820070 826182 827971 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (11.89%) |
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 498988 554866 584339 645525 597823 767327 740500 739480 697789 422947 646776 527484 800531 639783 619439 662133 761565 738686 528308 465527 429385 487188 523536 568501 692714 697354 788187 724285 813226 391976 493256 527109 733882 488750 566007 574141 667755 650944 695278 579721 621029 810813 767057 633746 709880 443603 630280 473184 395664 61536 21500 586619 451867 543874 554425 404384 432687 815024 445431 512219 532798 511265 583210 712722 717899 647619 651611 672248 669570 680260 550747 586034 805431 803450 761466 761490 761572 726665 752759 739445 761467 419991 458605 11718 511262 413044 566908 827917 625360 738640 714304 389863 815674 827971 699775 700282 698597 646339 699755 722519 785568 770424 771177 721719 428786 826182 820070 530045 542207 586668 765721 766603 415988 497454 758867 656626 468666 447426 558380 467955 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.70%) |
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 11718 21500 61536 389863 391976 395664 404384 413044 415988 419991 422947 428786 429385 432687 443603 445431 447426 451867 458605 465527 467955 468666 473184 487188 488750 493256 497454 498988 511262 511265 512219 523536 527109 527484 528308 530045 532798 542207 543874 550747 554425 554866 558380 566007 566908 568501 574141 579721 583210 584339 586034 586619 586668 597823 619439 621029 625360 630280 633746 639783 645525 646339 646776 647619 650944 651611 656626 662133 667755 669570 672248 680260 692714 695278 697354 697789 698597 699755 699775 700282 709880 712722 714304 717899 721719 722519 724285 726665 733882 738640 738686 739445 739480 740500 752759 758867 761466 761467 761490 761565 761572 765721 766603 767057 767327 770424 771177 785568 788187 800531 803450 805431 810813 813226 815024 815674 820070 826182 827971 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк анал азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian anal asian"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.