Query Metrics
7
Database Queries
7
Different statements
148.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.93 ms (80.11%) |
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 102334 154844 182735 383217 387738 388756 391527 392843 393145 398121 401628 401684 403463 413808 416007 416620 418730 421395 421435 423360 423475 424179 424187 428516 432270 435510 435521 437717 438459 438579 439417 445099 447703 448110 450682 452348 453822 455165 456555 457816 459649 461058 461381 462626 464642 466031 466388 467636 468151 468255 468256 468495 469176 471013 471155 471312 471428 472971 475359 475696 476471 477425 484337 490511 495443 495602 498305 499084 499914 502776 507291 508543 510001 513589 518505 523380 523823 529639 545780 559207 560286 560953 566083 567057 568814 569393 579426 586583 589383 593080 599502 602204 616712 618494 628750 640046 647558 660282 675084 713947 736037 739923 742312 742636 750756 756487 758541 758780 764241 782515 782908 786916 796295 803621 811736 812289 812359 813404 824483 828630 ] |
||||||||||||||||||||||||||||||
|
18.86 ms (12.71%) |
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 628750 736037 640046 182735 499084 459649 393145 388756 428516 423475 523380 566083 599502 758780 782515 739923 750756 713947 391527 424179 468495 435521 472971 416007 418730 448110 647558 439417 392843 824483 452348 466031 468151 508543 529639 559207 545780 786916 782908 742312 424187 475359 450682 495602 567057 438459 445099 457816 461058 461381 510001 438579 471155 468256 502776 499914 490511 387738 421395 477425 495443 475696 660282 560953 602204 589383 618494 796295 813404 764241 812359 471013 398121 455165 462626 758541 421435 432270 447703 498305 513589 464642 675084 560286 586583 593080 803621 811736 403463 471312 476471 828630 154844 102334 401684 413808 423360 469176 453822 467636 579426 568814 569393 812289 756487 401628 468255 416620 435510 437717 456555 471428 466388 484337 518505 616712 523823 742636 507291 383217 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (2.00%) |
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 102334 154844 182735 383217 387738 388756 391527 392843 393145 398121 401628 401684 403463 413808 416007 416620 418730 421395 421435 423360 423475 424179 424187 428516 432270 435510 435521 437717 438459 438579 439417 445099 447703 448110 450682 452348 453822 455165 456555 457816 459649 461058 461381 462626 464642 466031 466388 467636 468151 468255 468256 468495 469176 471013 471155 471312 471428 472971 475359 475696 476471 477425 484337 490511 495443 495602 498305 499084 499914 502776 507291 508543 510001 513589 518505 523380 523823 529639 545780 559207 560286 560953 566083 567057 568814 569393 579426 586583 589383 593080 599502 602204 616712 618494 628750 640046 647558 660282 675084 713947 736037 739923 742312 742636 750756 756487 758541 758780 764241 782515 782908 786916 796295 803621 811736 812289 812359 813404 824483 828630 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ð░ÐüÐéÐâÐÇð▒ð©ÐÇÐâðÁÐé ÐÇð░ð║ð¥ð╝ ð░ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац рак"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.13%) |
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.