Query Metrics
7
Database Queries
7
Different statements
239.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.21 ms (88.99%) |
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 7161 79683 81571 108029 116720 186993 236359 281380 350980 372443 385760 398710 411956 415055 426395 432897 455195 463808 467524 467973 475957 477439 479040 483112 484695 487762 488423 497935 497950 499910 503466 503905 509684 511686 512688 515371 517603 518268 519013 519034 523032 523996 527414 529515 530457 531481 537403 541207 541638 541770 546786 554349 554497 554835 555953 559247 574396 578937 580766 587963 588172 590217 592723 592834 593129 596786 596823 597844 598954 605988 608111 610880 620995 621710 624430 627654 642084 648497 651746 659350 664562 671492 671494 675182 678641 683477 690744 691690 694322 697596 697605 705786 705874 709593 715844 716725 729441 733019 735362 736154 736500 739898 763733 765028 766041 768151 769102 778837 782680 785628 788101 790729 791168 793314 794090 796017 800565 801268 813612 813955 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (6.05%) |
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 477439 523032 515371 108029 554349 467524 530457 499910 479040 484695 610880 517603 593129 488423 509684 523996 467973 518268 813955 592834 735362 519013 624430 574396 651746 411956 497950 546786 578937 671494 736154 415055 715844 791168 463808 627654 642084 236359 519034 541207 605988 537403 765028 281380 705786 675182 736500 768151 683477 455195 678641 559247 580766 596786 554835 487762 588172 739898 350980 608111 598954 620995 503466 555953 596823 527414 531481 729441 529515 497935 541638 503905 664562 691690 709593 597844 793314 511686 766041 690744 81571 512688 733019 796017 186993 782680 788101 398710 483112 475957 587963 79683 554497 716725 648497 697596 671492 705874 801268 778837 790729 763733 769102 697605 432897 541770 7161 621710 592723 659350 590217 785628 794090 800565 385760 116720 372443 426395 813612 694322 ] |
||||||||||||||||||||||||||||||
|
4.09 ms (1.71%) |
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 7161 79683 81571 108029 116720 186993 236359 281380 350980 372443 385760 398710 411956 415055 426395 432897 455195 463808 467524 467973 475957 477439 479040 483112 484695 487762 488423 497935 497950 499910 503466 503905 509684 511686 512688 515371 517603 518268 519013 519034 523032 523996 527414 529515 530457 531481 537403 541207 541638 541770 546786 554349 554497 554835 555953 559247 574396 578937 580766 587963 588172 590217 592723 592834 593129 596786 596823 597844 598954 605988 608111 610880 620995 621710 624430 627654 642084 648497 651746 659350 664562 671492 671494 675182 678641 683477 690744 691690 694322 697596 697605 705786 705874 709593 715844 716725 729441 733019 735362 736154 736500 739898 763733 765028 766041 768151 769102 778837 782680 785628 788101 790729 791168 793314 794090 796017 800565 801268 813612 813955 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в рот как в"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в рот в"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.63%) |
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.