Query Metrics
7
Database Queries
7
Different statements
207.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.66 ms (85.03%) |
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 346141 382404 401799 410690 419200 421052 435005 446032 450579 451752 454009 462377 464188 464445 464844 467867 467886 467945 469755 478055 486768 496339 509019 510905 511379 516510 516652 521831 526189 526544 530428 531181 532732 535279 537894 538963 539875 540509 541501 547543 552898 552912 554818 555288 555297 557873 558725 566320 581609 582005 584267 586557 586662 592696 593974 594293 600200 604891 606346 606831 627225 636487 636666 639108 639823 647905 648241 648744 671560 680475 696584 699325 708518 713163 713176 713185 722029 725747 728540 731204 744021 746087 748614 749106 750285 751410 752759 756708 758780 767286 773252 776086 780653 782547 785589 786876 786879 787438 788344 790804 791093 792412 795404 796681 797088 797139 797771 798775 799636 802315 803019 808842 810382 811119 811709 815396 815778 821195 825864 ] |
||||||||||||||||||||||||||||||
|
19.80 ms (9.53%) |
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 796681 382404 786876 496339 454009 464188 521831 639823 516652 478055 647905 538963 713176 648241 555288 584267 648744 558725 593974 748614 756708 746087 725747 797088 511379 516510 435005 531181 526544 639108 594293 467867 464445 811119 791093 555297 557873 671560 636666 792412 535279 566320 600200 586662 401799 450579 532732 540509 486768 547543 699325 606346 780653 786879 795404 810382 797139 728540 749106 752759 751410 825864 469755 419200 462377 526189 530428 552912 713163 696584 586557 636487 782547 803019 776086 799636 802315 744021 627225 537894 821195 815778 815396 464844 446032 539875 510905 467945 541501 554818 582005 713185 680475 708518 722029 581609 592696 604891 606831 785589 787438 731204 758780 790804 797771 808842 811709 773252 750285 767286 798775 451752 509019 410690 421052 467886 552898 788344 787989 346141 ] |
||||||||||||||||||||||||||||||
|
3.74 ms (1.80%) |
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 346141 382404 401799 410690 419200 421052 435005 446032 450579 451752 454009 462377 464188 464445 464844 467867 467886 467945 469755 478055 486768 496339 509019 510905 511379 516510 516652 521831 526189 526544 530428 531181 532732 535279 537894 538963 539875 540509 541501 547543 552898 552912 554818 555288 555297 557873 558725 566320 581609 582005 584267 586557 586662 592696 593974 594293 600200 604891 606346 606831 627225 636487 636666 639108 639823 647905 648241 648744 671560 680475 696584 699325 708518 713163 713176 713185 722029 725747 728540 731204 744021 746087 748614 749106 750285 751410 752759 756708 758780 767286 773252 776086 780653 782547 785589 786876 786879 787438 788344 790804 791093 792412 795404 796681 797088 797139 797771 798775 799636 802315 803019 808842 810382 811119 811709 815396 815778 821195 825864 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сквирт большая игрушк…"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм большая большие игрушк"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.80%) |
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.