Query Metrics
7
Database Queries
7
Different statements
397.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
373.57 ms (93.95%) |
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 182110 209216 384588 398124 403850 410356 418132 423861 433418 434885 437950 444081 444430 444485 446579 449297 450874 452997 478992 498554 521799 523751 525293 537166 540590 541043 551600 554693 561052 565834 574125 577023 581930 583727 589545 602023 627414 631246 636493 642999 646074 648931 655452 659429 664181 665076 666981 669320 669858 671559 676555 680597 683257 689057 689871 692914 693267 693695 695549 701235 702639 704587 704629 710092 712303 713750 717145 719422 734251 739908 749564 760093 760170 768725 773291 773747 775624 775647 780028 780080 780099 782535 783707 784125 786500 788874 789236 792940 795012 795370 795889 796375 796589 798769 801842 803026 803385 804699 809715 809731 809917 810174 810182 810372 810381 812296 812695 813359 813643 818722 819842 819891 820011 820020 823719 824554 826832 827394 827439 827578 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (3.84%) |
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 773291 602023 642999 701235 775624 775647 780028 783707 786500 789236 792940 795370 796589 798769 801842 804699 809715 809731 810174 810182 810372 810381 812695 813359 209216 565834 444081 437950 418132 452997 449297 384588 182110 398124 410356 444485 819842 525293 574125 780080 795012 796375 803026 803385 739908 749564 760170 704587 712303 717145 782535 784125 809917 423861 433418 434885 444430 446579 450874 478992 523751 521799 683257 664181 666981 627414 636493 631246 780099 795889 812296 734251 760093 768725 773747 788874 403850 813643 818722 820011 824554 826832 827439 827578 827394 819891 820020 823719 540590 498554 537166 551600 577023 581930 541043 554693 561052 655452 665076 671559 680597 693267 702639 713750 646074 669320 669858 689057 692914 693695 704629 710092 648931 659429 676555 689871 695549 719422 583727 589545 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.59%) |
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 182110 209216 384588 398124 403850 410356 418132 423861 433418 434885 437950 444081 444430 444485 446579 449297 450874 452997 478992 498554 521799 523751 525293 537166 540590 541043 551600 554693 561052 565834 574125 577023 581930 583727 589545 602023 627414 631246 636493 642999 646074 648931 655452 659429 664181 665076 666981 669320 669858 671559 676555 680597 683257 689057 689871 692914 693267 693695 695549 701235 702639 704587 704629 710092 712303 713750 717145 719422 734251 739908 749564 760093 760170 768725 773291 773747 775624 775647 780028 780080 780099 782535 783707 784125 786500 788874 789236 792940 795012 795370 795889 796375 796589 798769 801842 803026 803385 804699 809715 809731 809917 810174 810182 810372 810381 812296 812695 813359 813643 818722 819842 819891 820011 820020 823719 824554 826832 827394 827439 827578 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam masturbation orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер мастурбац orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер мастурбац orgasm"
]
|
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.