Query Metrics
7
Database Queries
7
Different statements
167.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.28 ms (86.29%) |
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 190732 382544 383442 384578 385426 392756 396796 397219 400624 404451 418821 454045 459004 460724 462491 465158 465471 469878 474369 483136 484286 486277 488562 489430 492573 496144 497406 501358 501690 504974 515749 520688 527889 533816 533820 534334 536490 538739 544951 561725 562153 567670 567734 570265 576478 576649 583194 596041 608426 619620 622370 623209 624463 626015 635718 668899 669855 670512 679372 680616 680630 683046 695140 698791 710175 715489 720244 721475 726564 726861 727549 727554 729553 731010 732106 733573 736285 738047 739945 742035 744082 753887 758430 761872 767076 771002 771740 772581 774108 775628 780680 785922 788245 788319 789517 793878 797764 800214 800737 801206 802078 803219 804116 804121 807884 808518 808999 810379 810383 811814 812306 817718 817962 818315 823713 823777 824674 825866 828490 828751 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (8.42%) |
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 801206 753887 744082 727549 698791 488562 396796 576478 561725 570265 669855 679372 680616 608426 810379 742035 758430 810383 811814 729553 736285 761872 771740 623209 785922 808518 731010 818315 190732 825866 828490 382544 710175 619620 780680 789517 774108 793878 800737 807884 404451 484286 392756 462491 385426 817718 583194 544951 683046 775628 812306 802078 771002 797764 804121 726564 804116 454045 483136 501690 824674 817962 460724 567734 668899 720244 721475 670512 622370 596041 624463 788245 726861 732106 767076 739945 715489 534334 515749 489430 384578 823713 823777 533816 680630 800214 397219 527889 567670 576649 400624 465471 474369 486277 497406 504974 496144 562153 695140 635718 626015 808999 733573 738047 727554 459004 418821 469878 465158 501358 492573 520688 533820 538739 536490 803219 788319 828751 772581 383442 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.43%) |
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 190732 382544 383442 384578 385426 392756 396796 397219 400624 404451 418821 454045 459004 460724 462491 465158 465471 469878 474369 483136 484286 486277 488562 489430 492573 496144 497406 501358 501690 504974 515749 520688 527889 533816 533820 534334 536490 538739 544951 561725 562153 567670 567734 570265 576478 576649 583194 596041 608426 619620 622370 623209 624463 626015 635718 668899 669855 670512 679372 680616 680630 683046 695140 698791 710175 715489 720244 721475 726564 726861 727549 727554 729553 731010 732106 733573 736285 738047 739945 742035 744082 753887 758430 761872 767076 771002 771740 772581 774108 775628 780680 785922 788245 788319 789517 793878 797764 800214 800737 801206 802078 803219 804116 804121 807884 808518 808999 810379 810383 811814 812306 817718 817962 818315 823713 823777 824674 825866 828490 828751 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits pussy"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ pussy"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ pussy"
]
|
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.