Query Metrics
7
Database Queries
7
Different statements
219.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.11 ms (90.44%) |
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 6699 382270 387374 389610 390255 407538 426632 426730 430455 430460 449249 456426 456775 457475 460965 469498 469720 476610 484016 485039 490941 505187 507975 510827 511638 516188 516984 521745 527214 530855 543848 547572 547623 548884 548886 548888 548900 555829 556431 558367 560265 561755 562381 562816 570991 571312 573226 577134 577570 577594 577876 577963 581177 581501 588716 588825 590455 591996 592636 592763 593330 593360 594411 598697 599230 599940 605025 606035 613956 618471 619088 625208 631975 639991 650489 659066 664562 667257 667338 667944 675148 679245 683262 687150 689156 707974 714105 727458 727531 734345 734371 744822 745281 745307 745310 762500 774156 775587 782769 782774 782775 784925 785607 787983 788804 788867 794486 794522 795885 796473 797643 798117 801027 801608 803149 803166 812316 825973 826592 826759 ] |
||||||||||||||||||||||||||||||
|
11.96 ms (5.46%) |
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 599940 543848 667338 556431 555829 505187 511638 803166 593360 639991 796473 548888 745307 727531 593330 547572 794522 581177 382270 788867 787983 812316 476610 577594 588716 650489 490941 782769 387374 619088 798117 734371 592636 795885 803149 426632 667944 606035 594411 745310 785607 801608 618471 547623 570991 598697 794486 727458 788804 469720 521745 571312 577570 430460 825973 562816 631975 605025 734345 714105 460965 527214 826759 590455 745281 426730 457475 562381 581501 430455 456775 449249 456426 577963 592763 744822 548886 675148 407538 558367 548884 561755 667257 573226 775587 762500 625208 683262 560265 782774 801027 484016 510827 516188 548900 774156 516984 707974 389610 469498 485039 530855 507975 664562 659066 599230 782775 797643 6699 390255 826592 577876 577134 689156 679245 687150 588825 613956 591996 784925 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.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 6699 382270 387374 389610 390255 407538 426632 426730 430455 430460 449249 456426 456775 457475 460965 469498 469720 476610 484016 485039 490941 505187 507975 510827 511638 516188 516984 521745 527214 530855 543848 547572 547623 548884 548886 548888 548900 555829 556431 558367 560265 561755 562381 562816 570991 571312 573226 577134 577570 577594 577876 577963 581177 581501 588716 588825 590455 591996 592636 592763 593330 593360 594411 598697 599230 599940 605025 606035 613956 618471 619088 625208 631975 639991 650489 659066 664562 667257 667338 667944 675148 679245 683262 687150 689156 707974 714105 727458 727531 734345 734371 744822 745281 745307 745310 762500 774156 775587 782769 782774 782775 784925 785607 787983 788804 788867 794486 794522 795885 796473 797643 798117 801027 801608 803149 803166 812316 825973 826592 826759 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"domina facesitting"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован фейсситтинг"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.65%) |
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.