Query Metrics
7
Database Queries
7
Different statements
141.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.68 ms (82.25%) |
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 81656 348918 361978 375930 383583 389255 396971 397089 397093 397182 398773 417221 417751 419356 420348 428517 429280 447658 447925 458920 460512 469571 470234 471368 472610 484872 485713 489678 504010 506308 512350 514730 519142 523390 528493 529201 559122 562676 566244 566532 567412 568429 568451 568509 568516 569219 569511 569547 569550 577407 583591 583967 584045 590165 593552 598104 603211 604082 604307 606106 606251 606374 606605 606616 606619 613726 618839 621360 626133 626752 697220 709517 709756 710002 714644 715497 719899 721748 721749 726728 732580 735484 736481 741998 746052 748587 752800 755375 756737 756863 761592 766606 775046 775766 776015 795137 795142 795581 796450 798918 800028 801542 802113 802585 804178 806473 807885 807889 809934 810472 810744 811118 812926 813904 817070 817722 818283 818797 825112 826800 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (10.41%) |
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 709756 710002 562676 590165 613726 606374 761592 766606 795142 811118 732580 719899 512350 397182 528493 577407 559122 567412 568516 606605 621360 389255 383583 396971 397093 417751 817070 825112 817722 818797 826800 447658 447925 471368 529201 519142 469571 569511 568509 697220 709517 714644 583967 593552 606251 626752 604307 775046 795137 812926 795581 800028 807885 736481 756863 748587 752800 726728 776015 807889 809934 375930 458920 514730 626133 746052 81656 397089 398773 813904 504010 523390 568451 569550 583591 568429 569219 569547 715497 721749 584045 604082 721748 348918 361978 420348 419356 428517 818283 472610 485713 470234 489678 566532 566244 598104 606106 606619 618839 606616 603211 802585 775766 796450 798918 802113 810744 741998 810472 735484 755375 756737 801542 804178 806473 429280 417221 506308 484872 460512 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"german sperm"
]
|
||||||||||||||||||||||||||||||
|
2.27 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 81656 348918 361978 375930 383583 389255 396971 397089 397093 397182 398773 417221 417751 419356 420348 428517 429280 447658 447925 458920 460512 469571 470234 471368 472610 484872 485713 489678 504010 506308 512350 514730 519142 523390 528493 529201 559122 562676 566244 566532 567412 568429 568451 568509 568516 569219 569511 569547 569550 577407 583591 583967 584045 590165 593552 598104 603211 604082 604307 606106 606251 606374 606605 606616 606619 613726 618839 621360 626133 626752 697220 709517 709756 710002 714644 715497 719899 721748 721749 726728 732580 735484 736481 741998 746052 748587 752800 755375 756737 756863 761592 766606 775046 775766 776015 795137 795142 795581 796450 798918 800028 801542 802113 802585 804178 806473 807885 807889 809934 810472 810744 811118 812926 813904 817070 817722 818283 818797 825112 826800 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"german сперм"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"german сперм"
]
|
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.