Query Metrics
7
Database Queries
7
Different statements
359.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.78 ms (59.75%) |
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 398206 401810 412852 416415 416454 420317 420380 421304 421619 427143 427455 432977 434804 438984 439291 439396 439572 439669 446893 453646 454732 456319 458019 460306 461381 482609 489781 493271 494609 506743 522771 523171 526948 528548 530544 531730 540894 550226 550585 556516 566892 568776 576859 601539 602626 603061 603622 603646 615041 616312 621463 624140 625017 627163 641534 643226 657489 662084 663785 664498 664524 666964 668525 674916 675495 675581 679472 686465 690625 693648 695023 697216 698818 700707 701439 701705 705462 713134 716640 717853 725271 728964 729905 729933 732984 734108 734630 740131 741222 744966 750391 756074 757863 773318 778082 779611 782292 786729 787043 790207 792749 795130 795606 800084 800901 801709 802371 802937 803159 803658 804701 806584 810878 814147 817727 818180 820032 824735 ] |
||||||||||||||||||||||||||||||
|
124.05 ms (34.51%) |
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 398206 401810 412852 416415 416454 420317 420380 421304 421619 427143 427455 432977 434804 438984 439291 439396 439572 439669 446893 453646 454732 456319 458019 460306 461381 482609 489781 493271 494609 506743 522771 523171 526948 528548 530544 531730 540894 550226 550585 556516 566892 568776 576859 601539 602626 603061 603622 603646 615041 616312 621463 624140 625017 627163 641534 643226 657489 662084 663785 664498 664524 666964 668525 674916 675495 675581 679472 686465 690625 693648 695023 697216 698818 700707 701439 701705 705462 713134 716640 717853 725271 728964 729905 729933 732984 734108 734630 740131 741222 744966 750391 756074 757863 773318 778082 779611 782292 786729 787043 790207 792749 795130 795606 800084 800901 801709 802371 802937 803159 803658 804701 806584 810878 814147 817727 818180 820032 824735 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (3.84%) |
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 530544 550226 675495 686465 675581 662084 695023 705462 603646 625017 601539 800084 779611 734108 740131 750391 786729 802937 460306 438984 432977 664524 416454 668525 621463 439396 729905 401810 420380 427143 824735 454732 458019 489781 549533 701705 717853 701439 713134 556516 778082 782292 803658 741222 756074 757863 700707 421619 439291 421304 494609 522771 439572 439669 427455 434804 818180 817727 820032 446893 716640 679472 697216 698818 616312 795606 800901 725271 734630 803159 728964 732984 795130 802371 416415 482609 531730 657489 806584 792749 420317 526948 603622 576859 663785 690625 643226 641534 804701 790207 729933 773318 801709 461381 456319 528548 398206 412852 540894 744966 493271 523171 814147 453646 506743 550585 566892 568776 674916 693648 664498 666964 603061 602626 624140 615041 627163 775358 787043 810878 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam young girls"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.