Query Metrics
7
Database Queries
7
Different statements
376.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
351.87 ms (93.43%) |
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 395393 441814 507549 537351 539802 545734 545744 550786 553439 556373 575684 579507 583625 585222 589017 594547 600960 607190 610252 612216 612270 612272 612787 612797 613351 615110 616517 624974 631024 631547 634699 639041 645494 647096 647805 657134 674527 674957 676213 681939 683359 691422 693669 696406 698739 701557 703402 706199 710312 712620 713313 716375 716920 717685 718615 723012 723082 725240 729007 730319 730835 732515 732963 733169 733184 734890 737051 739521 740182 742283 744356 745299 748406 749461 753119 753208 755583 756908 757119 759813 760266 760867 763787 765422 767294 771488 771911 772047 772059 778475 778483 780708 781009 781125 784695 785174 794141 794150 794417 794854 795463 797179 800547 801940 802787 803779 809861 812203 813703 823712 823860 823973 823974 824913 826103 826289 827099 827341 827483 ] |
||||||||||||||||||||||||||||||
|
15.58 ms (4.14%) |
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 723082 823712 827483 781009 795463 801940 800547 748406 794141 681939 683359 701557 710312 823973 579507 556373 645494 647805 657134 706199 716375 674527 674957 696406 585222 600960 607190 612270 615110 610252 612797 613351 740182 765422 634699 703402 624974 827099 827341 826103 545734 781125 772047 797179 729007 744356 734890 763787 753119 778483 812203 395393 826289 823860 823974 553439 785843 794150 794854 784695 802787 745299 732963 759813 550786 676213 691422 537351 539802 575684 647096 698739 713313 717685 718615 639041 594547 612216 612272 612787 616517 589017 631547 730319 760266 749461 730835 767294 712620 583625 545744 693669 723012 631024 778475 780708 785174 809861 756908 771488 772059 725240 757119 760867 733184 755583 732515 733169 739521 742283 771911 737051 753208 716920 794417 441814 824913 813703 507549 803779 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (0.62%) |
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 395393 441814 507549 537351 539802 545734 545744 550786 553439 556373 575684 579507 583625 585222 589017 594547 600960 607190 610252 612216 612270 612272 612787 612797 613351 615110 616517 624974 631024 631547 634699 639041 645494 647096 647805 657134 674527 674957 676213 681939 683359 691422 693669 696406 698739 701557 703402 706199 710312 712620 713313 716375 716920 717685 718615 723012 723082 725240 729007 730319 730835 732515 732963 733169 733184 734890 737051 739521 740182 742283 744356 745299 748406 749461 753119 753208 755583 756908 757119 759813 760266 760867 763787 765422 767294 771488 771911 772047 772059 778475 778483 780708 781009 781125 784695 785174 794141 794150 794417 794854 795463 797179 800547 801940 802787 803779 809861 812203 813703 823712 823860 823973 823974 824913 826103 826289 827099 827341 827483 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur missionary"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск missionary"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск missionary"
]
|
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.