Query Metrics
7
Database Queries
7
Different statements
173.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.71 ms (86.72%) |
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 481072 529509 530454 533108 533298 533400 535144 535706 536324 537141 537448 540563 541915 543682 545236 546809 546836 547520 547979 550541 554888 555208 555226 557060 558541 561520 566822 571756 574019 584830 587837 588223 599765 629440 629655 631021 635281 635624 637901 641789 641804 652162 655575 660397 665802 667024 667360 667439 667440 669869 671204 686540 692094 698149 699496 702315 703927 705210 707589 708001 709673 711161 711194 713948 717578 717698 720275 722284 722294 723934 728466 729322 730309 731593 731790 733962 736686 737891 740727 742080 742093 750882 751341 752435 753565 754528 755704 759411 764067 768475 768513 769089 772820 775523 776158 778122 780708 781265 783457 783710 784474 786259 788987 789284 792237 797032 797146 799917 802000 803975 806255 811219 817993 819181 819805 820171 823750 824674 826599 827148 ] |
||||||||||||||||||||||||||||||
|
12.48 ms (7.18%) |
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 629440 631021 637901 641789 699496 709673 711161 584830 667439 797032 729322 742080 533400 537448 540563 557060 660397 655575 703927 665802 698149 705210 550541 587837 635281 641804 806255 717578 817993 819181 824674 826599 823750 827148 819805 820171 533298 535144 536324 533108 535706 529509 530454 537141 481072 545236 546836 555226 566822 574019 543682 547520 561520 541915 547979 554888 652162 702315 713948 720275 667024 667360 669869 671204 686540 692094 707589 711194 717698 722284 667440 708001 722294 546809 555208 558541 571756 588223 599765 635624 629655 775523 778122 783710 786259 792237 797146 802000 776158 780708 781265 784474 788987 789284 799917 733962 737891 751341 752435 754528 769089 783457 803975 811219 728466 730309 731593 736686 740727 742093 750882 753565 755704 759411 764067 768475 768513 772820 723934 731790 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.61%) |
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 481072 529509 530454 533108 533298 533400 535144 535706 536324 537141 537448 540563 541915 543682 545236 546809 546836 547520 547979 550541 554888 555208 555226 557060 558541 561520 566822 571756 574019 584830 587837 588223 599765 629440 629655 631021 635281 635624 637901 641789 641804 652162 655575 660397 665802 667024 667360 667439 667440 669869 671204 686540 692094 698149 699496 702315 703927 705210 707589 708001 709673 711161 711194 713948 717578 717698 720275 722284 722294 723934 728466 729322 730309 731593 731790 733962 736686 737891 740727 742080 742093 750882 751341 752435 753565 754528 755704 759411 764067 768475 768513 769089 772820 775523 776158 778122 780708 781265 783457 783710 784474 786259 788987 789284 792237 797032 797146 799917 802000 803975 806255 811219 817993 819181 819805 820171 823750 824674 826599 827148 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation amateur"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац любительск"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.91%) |
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.