Query Metrics
7
Database Queries
7
Different statements
223.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.43 ms (89.28%) |
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 400906 440681 454519 474816 488466 495333 509054 509967 514444 530257 545861 564022 583232 585343 590029 592149 599318 609107 616604 617074 621548 627253 627690 630345 634066 634648 634697 637882 642992 647217 653006 657737 660851 668765 668944 677265 681961 685432 691388 693881 695552 695882 698144 705691 710066 712875 715800 719949 720612 721978 723189 723776 723819 728494 729789 730819 731197 732242 734354 740145 740173 741824 745565 745782 750314 760241 761349 761650 764179 765084 765518 766062 767354 767381 768227 768472 768657 768660 768739 768745 768758 771442 777738 778078 778492 778637 782307 784267 784292 784735 785229 785650 786137 786227 786232 787286 788359 791059 791246 791306 793566 793597 793821 794082 794713 795003 795896 796734 799446 799659 801018 803981 804872 806965 809745 810383 811531 819874 825201 ] |
||||||||||||||||||||||||||||||
|
12.16 ms (5.44%) |
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 647217 657737 660851 668765 668944 677265 693881 695552 681961 685432 592149 634066 634648 634697 621548 590029 616604 585343 627253 630345 637882 801018 782307 750314 766062 771442 731197 768227 734354 768758 617074 627690 642992 710066 474816 495333 712875 705691 786137 723776 795003 819874 488466 721978 796734 799446 765084 400906 440681 530257 545861 564022 698144 653006 609107 599318 787286 794713 804872 785229 791246 729789 767381 768660 740145 740173 768657 745782 768472 768745 583232 778492 793566 730819 810383 728494 745565 764179 732242 764440 793821 811531 786227 454519 509054 793597 741824 761650 767354 768739 791059 723189 778078 788359 514444 825201 509967 691388 695882 719949 715800 720612 778637 784267 777738 784292 784735 791306 806965 809745 723819 760241 761349 765518 785650 786232 794082 795896 799659 803981 ] |
||||||||||||||||||||||||||||||
|
4.87 ms (2.18%) |
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 400906 440681 454519 474816 488466 495333 509054 509967 514444 530257 545861 564022 583232 585343 590029 592149 599318 609107 616604 617074 621548 627253 627690 630345 634066 634648 634697 637882 642992 647217 653006 657737 660851 668765 668944 677265 681961 685432 691388 693881 695552 695882 698144 705691 710066 712875 715800 719949 720612 721978 723189 723776 723819 728494 729789 730819 731197 732242 734354 740145 740173 741824 745565 745782 750314 760241 761349 761650 764179 765084 765518 766062 767354 767381 768227 768472 768657 768660 768739 768745 768758 771442 777738 778078 778492 778637 782307 784267 784292 784735 785229 785650 786137 786227 786232 787286 788359 791059 791246 791306 793566 793597 793821 794082 794713 795003 795896 796734 799446 799659 801018 803981 804872 806965 809745 810383 811531 819874 825201 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade real"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск real"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск real"
]
|
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.