Query Metrics
7
Database Queries
7
Different statements
165.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.10 ms (85.47%) |
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 13035 408446 435602 448907 458552 488158 503061 505165 509949 510309 511493 516101 517236 519916 520148 530993 533924 534102 534509 535929 535959 536009 537990 541962 543802 544121 546188 549496 551859 554072 554127 556239 556244 557587 558094 562503 565620 566818 567862 567938 568227 568231 568782 576618 577128 577214 579739 584360 584387 584529 586332 586994 587112 588035 588096 592306 593798 597219 600699 612306 613220 614078 618334 620793 621611 623898 629638 632496 636483 636708 639913 646074 650297 650691 651681 654865 659375 671256 678216 687850 689889 690726 691935 700539 701781 704785 710827 712680 713442 727708 729856 730622 732090 735777 745031 745789 746832 748117 749754 749776 752458 761820 764210 770365 774143 780780 782693 784168 784187 792653 794515 799251 800938 802821 804842 811157 811921 812919 ] |
||||||||||||||||||||||||||||||
|
13.32 ms (8.07%) |
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 659375 621666 620793 799251 784187 804842 520148 519916 543802 584387 605785 612306 811157 746832 764210 537990 782693 408446 488158 541962 556244 654865 687850 700539 639913 812919 761820 748117 749776 729856 618334 505165 568227 568231 704785 646074 691935 597219 636708 587112 735777 556239 577128 458552 732090 533924 448907 517236 544121 549496 701781 710827 713442 650297 678216 712680 566818 584529 593798 614078 586332 623898 745789 770365 745031 784168 13035 511493 534509 503061 551859 554127 577214 650691 651681 689889 546188 567938 629638 621611 632496 780780 811921 792653 774143 794515 749754 727708 730622 800938 435602 536009 510309 600699 671256 568782 588096 802821 752458 613220 586994 535959 530993 562503 509949 534102 535929 516101 558094 579739 554072 557587 567862 690726 565620 576618 584360 588035 592306 636483 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (2.06%) |
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 13035 408446 435602 448907 458552 488158 503061 505165 509949 510309 511493 516101 517236 519916 520148 530993 533924 534102 534509 535929 535959 536009 537990 541962 543802 544121 546188 549496 551859 554072 554127 556239 556244 557587 558094 562503 565620 566818 567862 567938 568227 568231 568782 576618 577128 577214 579739 584360 584387 584529 586332 586994 587112 588035 588096 592306 593798 597219 600699 612306 613220 614078 618334 620793 621611 623898 629638 632496 636483 636708 639913 646074 650297 650691 651681 654865 659375 671256 678216 687850 689889 690726 691935 700539 701781 704785 710827 712680 713442 727708 729856 730622 732090 735777 745031 745789 746832 748117 749754 749776 752458 761820 764210 770365 774143 780780 782693 784168 784187 792653 794515 799251 800938 802821 804842 811157 811921 812919 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl telephone"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк телефон"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.