Query Metrics
7
Database Queries
7
Different statements
159.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.89 ms (86.98%) |
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 381975 397136 453284 459884 521808 529760 530647 530968 536821 538580 538709 539960 542429 543056 543075 548097 551106 551794 554017 556140 558673 559296 577260 584140 587479 589881 589916 589933 589941 589963 589965 590295 590346 592740 594758 609769 616705 618026 629123 629581 634454 635693 637538 639169 641218 645538 645550 650068 653974 662125 667803 673818 674900 675598 675775 676513 685180 705017 705347 708495 708541 708614 708955 713030 713767 715988 716417 717438 725022 729348 733809 738279 742310 743248 745054 745149 745616 748674 749380 750882 752085 752191 752771 754515 754872 758583 758867 763804 767480 768834 777522 778045 780449 780961 781066 783057 786624 787410 790240 791122 792108 794967 797845 798487 805360 805699 806652 810755 811279 812221 812475 817982 819098 819400 819784 819891 822103 825002 825857 827413 ] |
||||||||||||||||||||||||||||||
|
11.47 ms (7.19%) |
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 587479 589916 589933 616705 792108 745149 758583 729348 754515 754872 629581 806652 538709 530647 542429 554017 551106 713030 713767 715988 559296 590346 639169 777522 805699 812475 749380 748674 733809 752771 810755 551794 558673 825002 827413 548097 675775 716417 589963 594758 589881 589965 634454 780449 794967 781066 805360 725022 745616 758867 629123 641218 717438 529760 589941 397136 819400 822103 817982 459884 536821 543075 577260 675598 685180 645550 676513 673818 637538 609769 787410 797845 811279 798487 752085 750882 768834 745054 763804 618026 708541 708955 786624 819098 819784 453284 584140 556140 662125 674900 590295 592740 783057 790240 708495 819891 530968 539960 650068 653974 635693 780961 791122 752191 767480 812221 742310 738279 743248 778045 381975 825857 538580 521808 543056 708614 667803 705017 705347 645538 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.55%) |
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 381975 397136 453284 459884 521808 529760 530647 530968 536821 538580 538709 539960 542429 543056 543075 548097 551106 551794 554017 556140 558673 559296 577260 584140 587479 589881 589916 589933 589941 589963 589965 590295 590346 592740 594758 609769 616705 618026 629123 629581 634454 635693 637538 639169 641218 645538 645550 650068 653974 662125 667803 673818 674900 675598 675775 676513 685180 705017 705347 708495 708541 708614 708955 713030 713767 715988 716417 717438 725022 729348 733809 738279 742310 743248 745054 745149 745616 748674 749380 750882 752085 752191 752771 754515 754872 758583 758867 763804 767480 768834 777522 778045 780449 780961 781066 783057 786624 787410 790240 791122 792108 794967 797845 798487 805360 805699 806652 810755 811279 812221 812475 817982 819098 819400 819784 819891 822103 825002 825857 827413 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"body girl"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"body девушк"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"body девушк"
]
|
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.