Query Metrics
7
Database Queries
7
Different statements
177.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.74 ms (85.14%) |
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 148408 457326 458476 462138 464665 466859 488273 493229 496840 504081 512450 523385 524470 526378 532387 533141 533305 540139 541136 545242 553135 554158 555205 555210 555724 557507 557532 560699 560912 561264 562159 564475 567470 568211 571099 571721 576040 580519 580822 581196 581360 583673 587244 592219 593271 596172 598049 604121 604826 604881 609720 611973 612961 614702 615906 633214 634584 635823 636638 636736 641518 643690 643698 645624 647025 649487 651158 652528 656318 658924 659015 664477 664579 666116 667738 670695 684780 687718 690173 694608 699963 706889 707373 712615 715133 717443 726133 727976 731608 739374 743200 750371 751185 753657 753664 755045 755888 757186 761246 761269 767242 769093 771133 779280 780412 781934 784509 784929 785138 788331 790109 790683 791929 796389 801794 810025 811761 812284 812318 ] |
||||||||||||||||||||||||||||||
|
15.68 ms (8.86%) |
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 555205 555210 555724 557532 567470 568211 651158 664477 666116 684780 687718 699963 707373 712615 647025 652528 659015 690173 694608 656318 667738 545242 553135 560912 561264 571099 571721 604121 615906 633214 634584 641518 587244 596172 604881 635823 643690 592219 593271 609720 611973 612961 636736 780412 781934 784509 784929 801794 811761 788331 791929 796389 750371 757186 761246 761269 767242 790109 790683 810025 812284 812318 726133 753657 753664 731608 743200 755045 755888 739374 751185 769093 771133 727976 643698 715133 717443 776051 779280 785138 148408 462138 464665 493229 457326 458476 488273 496840 512450 533305 540139 523385 532387 504081 526378 524470 533141 466859 562159 564475 576040 580822 581360 583673 541136 557507 554158 580519 658924 670695 706889 645624 649487 664579 560699 581196 598049 604826 614702 636638 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.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 148408 457326 458476 462138 464665 466859 488273 493229 496840 504081 512450 523385 524470 526378 532387 533141 533305 540139 541136 545242 553135 554158 555205 555210 555724 557507 557532 560699 560912 561264 562159 564475 567470 568211 571099 571721 576040 580519 580822 581196 581360 583673 587244 592219 593271 596172 598049 604121 604826 604881 609720 611973 612961 614702 615906 633214 634584 635823 636638 636736 641518 643690 643698 645624 647025 649487 651158 652528 656318 658924 659015 664477 664579 666116 667738 670695 684780 687718 690173 694608 699963 706889 707373 712615 715133 717443 726133 727976 731608 739374 743200 750371 751185 753657 753664 755045 755888 757186 761246 761269 767242 769093 771133 779280 780412 781934 784509 784929 785138 788331 790109 790683 791929 796389 801794 810025 811761 812284 812318 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom solo"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван соло"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.92%) |
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.