Query Metrics
7
Database Queries
7
Different statements
148.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.14 ms (83.17%) |
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 33689 394116 398524 400723 403906 441022 454840 464283 470703 474842 482211 484464 485489 485630 494328 495156 496073 497676 504776 505970 507772 509077 524664 526116 530347 541250 545959 548401 557099 557422 558320 561907 565169 567984 574589 579488 581654 586034 586185 588402 593955 595864 595925 604425 605122 606582 612035 615112 617363 618528 624827 626330 627171 628811 633665 644708 658224 658225 662436 671670 686795 691838 693410 714477 714851 716124 716326 716392 722080 726703 728166 731432 735524 737910 738257 738623 738970 740084 741998 745386 747355 753993 754967 755255 759634 759647 761592 765763 765907 771874 774927 776138 789877 790972 793436 798171 799791 804959 805727 810533 816764 817482 817913 819212 819510 821829 821834 821855 821860 821870 825054 825500 825563 825661 825693 825694 825781 826672 827328 827977 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (10.02%) |
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 524664 497676 526116 628811 485630 482211 454840 441022 504776 398524 821860 826672 825500 819212 825054 825781 825563 825661 825693 821829 821834 821855 485489 470703 530347 496073 505970 548401 558320 579488 557422 574589 662436 693410 714477 658224 686795 714851 716326 716392 658225 545959 557099 595925 617363 586034 586185 588402 593955 595864 604425 606582 626330 615112 633665 644708 776138 793436 799791 810533 774927 789877 726703 737910 738257 740084 731432 754967 759634 738623 738970 735524 745386 765763 771874 753993 765907 618528 627171 716124 722080 798171 804959 805727 403906 400723 541250 819510 827977 484464 567984 671670 691838 624827 612035 790972 759647 728166 755255 747355 565169 561907 605122 33689 581654 741998 761592 394116 817482 821870 825694 827328 816764 817913 474842 464283 507772 494328 495156 509077 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (2.04%) |
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 33689 394116 398524 400723 403906 441022 454840 464283 470703 474842 482211 484464 485489 485630 494328 495156 496073 497676 504776 505970 507772 509077 524664 526116 530347 541250 545959 548401 557099 557422 558320 561907 565169 567984 574589 579488 581654 586034 586185 588402 593955 595864 595925 604425 605122 606582 612035 615112 617363 618528 624827 626330 627171 628811 633665 644708 658224 658225 662436 671670 686795 691838 693410 714477 714851 716124 716326 716392 722080 726703 728166 731432 735524 737910 738257 738623 738970 740084 741998 745386 747355 753993 754967 755255 759634 759647 761592 765763 765907 771874 774927 776138 789877 790972 793436 798171 799791 804959 805727 810533 816764 817482 817913 819212 819510 821829 821834 821855 821860 821870 825054 825500 825563 825661 825693 825694 825781 826672 827328 827977 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man amateur"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин любительск"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин любительск"
]
|
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.