Query Metrics
7
Database Queries
7
Different statements
143.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.15 ms (83.72%) |
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 538824 538868 542494 542992 544190 544276 544864 548271 550189 550589 553278 556985 560091 563157 563210 566366 566797 566830 567740 568000 570571 573792 573855 573952 574281 576641 580990 581359 581376 582760 586826 587451 592535 597018 603225 605332 617650 618862 618864 620125 621682 622823 628115 629276 644274 644275 644381 645254 645895 646929 648206 648672 648963 649105 649148 649989 651597 651889 652988 654092 662397 667938 668154 668441 668604 670090 670109 670114 671710 671760 671891 672118 673560 674127 681703 690827 690860 691991 692224 692250 693862 694135 694225 694524 694564 695278 696273 696553 697359 698526 698589 699581 699686 699723 699744 699745 700660 703037 703046 703059 703088 703095 703097 703514 703521 703523 705934 710847 714615 716590 716879 717607 722197 726657 729100 730301 763887 770130 811940 817278 ] |
||||||||||||||||||||||||||||||
|
13.88 ms (9.67%) |
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 651889 670114 699686 651597 671760 621682 703046 560091 690827 668441 699723 717607 691991 694564 695278 703523 644274 698589 703059 703514 703521 570571 573792 548271 648672 652988 667938 671891 681703 668154 672118 696273 714615 716590 646929 648963 654092 670090 673560 694225 710847 573855 573952 592535 586826 587451 618864 622823 729100 730301 700660 722197 817278 542494 542992 581359 671710 692250 705934 649148 670109 674127 694524 697359 645254 692224 618862 603225 770130 726657 763887 699745 703037 703095 716879 538868 538824 544864 553278 550189 550589 566366 580990 648206 690860 694135 699581 703088 703097 668604 696553 698526 563157 567740 605332 628115 597018 644381 811940 617650 620125 629276 644275 699744 566830 568000 574281 581376 544190 566797 576641 544276 556985 563210 582760 645895 649105 649989 662397 693862 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.98%) |
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 538824 538868 542494 542992 544190 544276 544864 548271 550189 550589 553278 556985 560091 563157 563210 566366 566797 566830 567740 568000 570571 573792 573855 573952 574281 576641 580990 581359 581376 582760 586826 587451 592535 597018 603225 605332 617650 618862 618864 620125 621682 622823 628115 629276 644274 644275 644381 645254 645895 646929 648206 648672 648963 649105 649148 649989 651597 651889 652988 654092 662397 667938 668154 668441 668604 670090 670109 670114 671710 671760 671891 672118 673560 674127 681703 690827 690860 691991 692224 692250 693862 694135 694225 694524 694564 695278 696273 696553 697359 698526 698589 699581 699686 699723 699744 699745 700660 703037 703046 703059 703088 703095 703097 703514 703521 703523 705934 710847 714615 716590 716879 717607 722197 726657 729100 730301 763887 770130 811940 817278 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс vintage"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex vintage"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс vintage"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (1.00%) |
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.