Query Metrics
7
Database Queries
7
Different statements
144.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.83 ms (82.43%) |
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 398429 418514 421762 422030 435872 450331 452736 457505 458021 459076 476891 477066 493770 494734 495887 496891 502011 506473 509612 509933 514918 517186 524820 530977 531293 535290 539669 545011 547799 548149 550537 552429 560026 560897 562238 565801 567531 573827 574185 578331 587001 589720 590945 592638 598688 610946 619906 620977 622275 623379 631522 634371 634687 641007 645755 653456 656556 656582 656647 657228 657567 660341 660346 661632 661787 661973 664120 665770 669500 672264 673776 675389 676660 684375 684410 684503 685955 697462 700055 707044 707143 709931 709993 711249 712582 713598 715919 719303 720146 720419 733555 744053 756105 757158 758673 763034 778932 779979 781355 785979 791285 791324 794004 794173 796872 797061 797071 797079 798996 803090 804565 808819 816654 816810 819252 820083 820875 826589 827929 827955 ] |
||||||||||||||||||||||||||||||
|
14.82 ms (10.28%) |
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 744053 756105 763034 757158 758673 634371 634687 700055 711249 713598 785979 794173 796872 797061 797071 797079 798996 803090 804565 418514 459076 435872 452736 477066 457505 495887 524820 506473 494734 574185 665770 660346 664120 545011 573827 590945 598688 791324 733555 422030 509933 450331 502011 517186 548149 578331 547799 560897 675389 641007 619906 398429 421762 816810 826589 820083 816654 819252 820875 827929 827955 458021 476891 493770 514918 530977 531293 539669 509612 535290 496891 550537 562238 567531 560026 645755 656582 657228 660341 661973 669500 673776 684375 707044 712582 715919 653456 672264 676660 684410 685955 697462 720146 656556 656647 657567 661632 661787 684503 707143 709931 709993 719303 720419 552429 565801 589720 631522 587001 592638 622275 620977 610946 623379 779979 791285 794004 808819 778932 781355 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (2.12%) |
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 398429 418514 421762 422030 435872 450331 452736 457505 458021 459076 476891 477066 493770 494734 495887 496891 502011 506473 509612 509933 514918 517186 524820 530977 531293 535290 539669 545011 547799 548149 550537 552429 560026 560897 562238 565801 567531 573827 574185 578331 587001 589720 590945 592638 598688 610946 619906 620977 622275 623379 631522 634371 634687 641007 645755 653456 656556 656582 656647 657228 657567 660341 660346 661632 661787 661973 664120 665770 669500 672264 673776 675389 676660 684375 684410 684503 685955 697462 700055 707044 707143 709931 709993 711249 712582 713598 715919 719303 720146 720419 733555 744053 756105 757158 758673 763034 778932 779979 781355 785979 791285 791324 794004 794173 796872 797061 797071 797079 798996 803090 804565 808819 816654 816810 819252 820083 820875 826589 827929 827955 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tight vagina"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"tight вагин"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"tight вагин"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.14%) |
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.