Query Metrics
7
Database Queries
7
Different statements
137.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.11 ms (85.93%) |
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 73413 149622 185353 322187 323129 357886 381984 382436 383029 386697 387006 390249 390499 393848 397477 401361 401871 404032 406017 406416 406425 408150 409125 413247 420341 435701 448357 448945 456856 490169 494392 510049 512981 516032 521265 525251 539750 543063 550956 551316 551354 559851 564627 565941 566671 575549 590743 608232 610142 610257 610260 610262 611356 612926 613854 621105 625036 626152 628987 629008 636515 642797 643426 648491 661099 661130 661788 661789 662851 662989 663690 663695 664866 664868 665166 666347 669136 670162 682654 701492 705689 707360 716318 716346 719274 723174 736371 738877 738960 739538 742897 748331 749284 749550 750941 754193 758218 759772 759782 765482 771358 771380 771678 772007 772642 776798 784897 785716 787015 795298 796820 799316 799738 800009 803160 804671 811760 813053 814793 820017 ] |
||||||||||||||||||||||||||||||
|
10.88 ms (7.92%) |
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 383029 559851 610257 397477 820017 669136 664866 629008 590743 636515 796820 512981 665166 771380 643426 784897 185353 406425 625036 393848 516032 381984 814793 551316 626152 804671 772007 663695 666347 719274 663690 723174 661099 661789 670162 610260 613854 799316 787015 748331 754193 408150 716346 707360 811760 759772 551354 564627 612926 813053 621105 448357 435701 539750 566671 765482 401361 413247 409125 387006 510049 322187 406416 705689 799738 749284 772642 716318 795298 420341 149622 610262 776798 800009 738960 771358 448945 610142 494392 543063 661130 701492 661788 608232 642797 736371 742897 749550 771678 785716 738877 739538 750941 758218 628987 390499 401871 456856 550956 682654 565941 611356 406017 386697 73413 521265 803160 759782 323129 525251 664868 357886 404032 382436 390249 490169 575549 662851 648491 662989 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.60%) |
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 73413 149622 185353 322187 323129 357886 381984 382436 383029 386697 387006 390249 390499 393848 397477 401361 401871 404032 406017 406416 406425 408150 409125 413247 420341 435701 448357 448945 456856 490169 494392 510049 512981 516032 521265 525251 539750 543063 550956 551316 551354 559851 564627 565941 566671 575549 590743 608232 610142 610257 610260 610262 611356 612926 613854 621105 625036 626152 628987 629008 636515 642797 643426 648491 661099 661130 661788 661789 662851 662989 663690 663695 664866 664868 665166 666347 669136 670162 682654 701492 705689 707360 716318 716346 719274 723174 736371 738877 738960 739538 742897 748331 749284 749550 750941 754193 758218 759772 759782 765482 771358 771380 771678 772007 772642 776798 784897 785716 787015 795298 796820 799316 799738 800009 803160 804671 811760 813053 814793 820017 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage big"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж большие"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.05%) |
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.