Query Metrics
7
Database Queries
7
Different statements
151.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.18 ms (78.47%) |
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 96443 428353 431405 434001 434712 448445 449123 454802 461744 467581 469534 472340 477210 481147 484673 495273 517844 518438 520775 524628 530501 531123 531187 531247 531560 532360 532645 532755 534387 534984 536590 536638 537204 537663 537888 537916 539203 540398 540410 540437 541081 541661 541833 543858 545372 545389 545488 545611 550667 553272 555789 555953 556037 556505 557676 558439 559178 565948 568589 569922 573403 579360 583982 583989 586587 596616 597963 599867 599880 599913 600006 600021 600257 600271 600360 604476 607707 615717 617097 620641 623196 628082 628371 630221 630537 630764 630869 632579 632595 632616 632707 633445 633446 633449 634153 634187 634198 634218 634769 637003 638967 646427 647972 648837 650316 651647 656792 658082 659258 674943 674995 675009 676641 677296 677307 678504 679032 679801 680176 680197 ] |
||||||||||||||||||||||||||||||
|
22.26 ms (14.65%) |
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 434001 517844 540398 537916 530501 481147 541081 558439 678504 679032 568589 569922 599867 599913 634153 607707 600271 461744 531187 679801 680197 628371 534984 537663 532645 534387 556505 543858 579360 651647 658082 615717 632595 632616 495273 537888 573403 656792 680176 545372 634198 597963 630869 634218 484673 96443 431405 659258 472340 448445 454802 536638 532360 536590 537204 540410 583989 648837 676641 632707 596616 630221 633446 520775 428353 531247 550667 541661 677307 557676 623196 604476 634769 628082 467581 532755 565948 477210 539203 540437 545389 545611 553272 674995 677296 650316 674943 555789 599880 634187 600360 617097 600257 630537 632579 633449 449123 531560 559178 469534 434712 524628 531123 541833 555953 545488 583982 620641 600006 600021 637003 638967 518438 556037 646427 647972 675009 633445 630764 586587 ] |
||||||||||||||||||||||||||||||
|
2.44 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 96443 428353 431405 434001 434712 448445 449123 454802 461744 467581 469534 472340 477210 481147 484673 495273 517844 518438 520775 524628 530501 531123 531187 531247 531560 532360 532645 532755 534387 534984 536590 536638 537204 537663 537888 537916 539203 540398 540410 540437 541081 541661 541833 543858 545372 545389 545488 545611 550667 553272 555789 555953 556037 556505 557676 558439 559178 565948 568589 569922 573403 579360 583982 583989 586587 596616 597963 599867 599880 599913 600006 600021 600257 600271 600360 604476 607707 615717 617097 620641 623196 628082 628371 630221 630537 630764 630869 632579 632595 632616 632707 633445 633446 633449 634153 634187 634198 634218 634769 637003 638967 646427 647972 648837 650316 651647 656792 658082 659258 674943 674995 675009 676641 677296 677307 678504 679032 679801 680176 680197 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny anal interracial"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые анал межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
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.