Query Metrics
7
Database Queries
7
Different statements
503.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
263.30 ms (52.28%) |
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 98711 135519 301402 384047 386923 398837 403214 419842 422273 423842 424224 426818 432433 433740 437381 438605 441125 441479 441806 445290 446282 447783 453527 454629 468266 475457 475887 482599 485925 509145 513815 519954 520804 521032 521218 524216 526919 528658 528847 529579 530617 533508 533540 535900 536497 548136 549277 551493 551967 556843 559748 561755 565453 566005 571127 573224 574984 577174 581974 587108 587152 587582 589579 589977 591512 592142 593137 593241 596569 601189 602164 603508 604190 607533 615316 618329 618341 618947 619890 623501 626470 629509 629594 632790 639060 644034 644108 662863 669320 687108 690952 706436 714376 725418 748594 749608 750407 753004 755511 756538 757459 758583 766926 768419 776643 778248 784359 784651 786530 788337 794028 802307 803146 804088 804131 805791 810221 813363 813365 813367 ] |
||||||||||||||||||||||||||||||
|
230.03 ms (45.67%) |
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 438605 602164 424224 433740 524216 565453 687108 520804 521032 441125 437381 528847 604190 423842 441806 632790 422273 593137 526919 591512 445290 447783 536497 623501 519954 587152 766926 426818 776643 403214 577174 813367 748594 753004 725418 804131 587108 644034 559748 135519 802307 513815 639060 301402 98711 453527 475457 573224 662863 805791 758583 784359 786530 794028 454629 468266 706436 603508 750407 757459 607533 528658 384047 419842 521218 629509 529579 548136 561755 669320 714376 596569 619890 589977 629594 601189 618341 788337 813365 755511 804088 756538 386923 566005 482599 530617 581974 587582 784651 749608 533508 535900 475887 551493 556843 690952 509145 533540 549277 593241 441479 485925 551967 589579 810221 768419 615316 432433 398837 446282 571127 574984 626470 644108 592142 618329 618947 778248 803146 813363 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (0.79%) |
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 98711 135519 301402 384047 386923 398837 403214 419842 422273 423842 424224 426818 432433 433740 437381 438605 441125 441479 441806 445290 446282 447783 453527 454629 468266 475457 475887 482599 485925 509145 513815 519954 520804 521032 521218 524216 526919 528658 528847 529579 530617 533508 533540 535900 536497 548136 549277 551493 551967 556843 559748 561755 565453 566005 571127 573224 574984 577174 581974 587108 587152 587582 589579 589977 591512 592142 593137 593241 596569 601189 602164 603508 604190 607533 615316 618329 618341 618947 619890 623501 626470 629509 629594 632790 639060 644034 644108 662863 669320 687108 690952 706436 714376 725418 748594 749608 750407 753004 755511 756538 757459 758583 766926 768419 776643 778248 784359 784651 786530 788337 794028 802307 803146 804088 804131 805791 810221 813363 813365 813367 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жопой трется"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп трет"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.28%) |
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.