Query Metrics
7
Database Queries
7
Different statements
169.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.24 ms (85.66%) |
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 409113 492442 538824 538868 541597 542494 542992 544190 544864 548271 550189 550589 553278 560091 560369 563157 566366 566797 566830 567740 568000 570571 573792 573855 573952 574281 580990 581359 581376 581401 586826 587451 592535 597018 603225 605332 617650 618862 618864 620125 621682 622823 628115 629276 630836 630883 644274 644275 644381 645254 646929 648672 648963 649148 649615 651597 651889 652988 654092 667938 668154 668604 670090 670109 671710 671891 672118 673560 674127 681703 685288 690827 690860 691485 691991 692224 692250 692258 692473 694135 694225 694524 695191 695278 696273 696553 697258 697359 698526 698548 698589 699581 699695 699735 699744 699745 699753 700660 703037 703046 703059 703088 703095 703097 703098 703514 705934 714615 716590 717607 722197 726657 729100 730301 763887 765787 770130 784600 811940 817278 ] |
||||||||||||||||||||||||||||||
|
14.11 ms (8.32%) |
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 703098 649615 651889 651597 621682 703046 541597 560369 691485 692258 692473 697258 698548 699695 685288 695191 699753 630883 630836 784600 765787 699735 409113 560091 690827 717607 691991 695278 644274 698589 703059 703514 817278 542494 542992 581359 671710 692250 705934 649148 670109 674127 694524 697359 645254 692224 618862 603225 770130 726657 763887 699745 703037 703095 570571 573792 548271 648672 652988 667938 671891 681703 668154 672118 696273 714615 716590 646929 648963 654092 670090 673560 694225 573855 573952 592535 586826 587451 618864 622823 729100 730301 700660 722197 538868 538824 492442 544864 553278 550189 550589 566366 580990 690860 694135 699581 703088 703097 668604 696553 698526 563157 567740 605332 628115 597018 644381 811940 617650 620125 629276 644275 699744 581401 566830 568000 574281 581376 544190 566797 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (1.83%) |
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 409113 492442 538824 538868 541597 542494 542992 544190 544864 548271 550189 550589 553278 560091 560369 563157 566366 566797 566830 567740 568000 570571 573792 573855 573952 574281 580990 581359 581376 581401 586826 587451 592535 597018 603225 605332 617650 618862 618864 620125 621682 622823 628115 629276 630836 630883 644274 644275 644381 645254 646929 648672 648963 649148 649615 651597 651889 652988 654092 667938 668154 668604 670090 670109 671710 671891 672118 673560 674127 681703 685288 690827 690860 691485 691991 692224 692250 692258 692473 694135 694225 694524 695191 695278 696273 696553 697258 697359 698526 698548 698589 699581 699695 699735 699744 699745 699753 700660 703037 703046 703059 703088 703095 703097 703098 703514 705934 714615 716590 717607 722197 726657 729100 730301 763887 765787 770130 784600 811940 817278 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex retro"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс ретр"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.89%) |
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.