Query Metrics
7
Database Queries
7
Different statements
170.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.81 ms (88.97%) |
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 91603 182221 208504 383356 418843 438047 455515 456944 488456 492328 493021 508996 524039 528679 531878 531997 534549 535688 542015 544794 554458 557001 562743 563237 564912 576149 577181 584079 585453 585474 585496 585525 589149 591990 600824 600842 600858 601166 607870 612188 612403 612991 619282 626577 632859 637521 643386 648437 663811 675581 678842 680649 683328 689621 689833 689849 694122 695730 695791 701185 701228 702065 709911 710354 714429 715546 716111 716187 716193 716207 716253 718733 721771 721772 723733 730760 736844 742104 746089 750767 751352 752502 754537 757562 758358 759951 760764 760773 762020 763222 765025 766183 766265 769930 770671 771291 771757 780843 782702 785974 787244 788508 788635 790558 791314 791452 791758 794513 795931 795976 796504 799912 800825 803383 805125 811813 814462 817973 826593 827873 ] |
||||||||||||||||||||||||||||||
|
10.69 ms (6.26%) |
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 600824 600842 780843 742104 759951 762020 723733 730760 752502 754537 758358 765025 770671 716187 619282 637521 683328 827873 584079 576149 675581 702065 709911 577181 585474 585496 632859 589149 585525 826593 689621 612991 795931 796504 800825 91603 814462 817973 531878 508996 488456 542015 563237 680649 721772 803383 805125 794513 795976 763222 787244 788635 791452 736844 750767 766265 746089 757562 760764 760773 716193 721771 182221 438047 418843 531997 564912 383356 455515 607870 534549 535688 689833 694122 701228 716207 718733 715546 663811 689849 701185 716111 557001 562743 585453 791758 790558 766183 751352 769930 771291 771757 714429 716253 785974 788508 493021 492328 208504 524039 554458 695730 695791 710354 591990 643386 600858 601166 626577 612403 456944 678842 612188 791314 811813 782702 799912 528679 544794 648437 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.20%) |
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 91603 182221 208504 383356 418843 438047 455515 456944 488456 492328 493021 508996 524039 528679 531878 531997 534549 535688 542015 544794 554458 557001 562743 563237 564912 576149 577181 584079 585453 585474 585496 585525 589149 591990 600824 600842 600858 601166 607870 612188 612403 612991 619282 626577 632859 637521 643386 648437 663811 675581 678842 680649 683328 689621 689833 689849 694122 695730 695791 701185 701228 702065 709911 710354 714429 715546 716111 716187 716193 716207 716253 718733 721771 721772 723733 730760 736844 742104 746089 750767 751352 752502 754537 757562 758358 759951 760764 760773 762020 763222 765025 766183 766265 769930 770671 771291 771757 780843 782702 785974 787244 788508 788635 790558 791314 791452 791758 794513 795931 795976 796504 799912 800825 803383 805125 811813 814462 817973 826593 827873 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur secretary"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.73%) |
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.