Query Metrics
7
Database Queries
7
Different statements
191.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.11 ms (85.79%) |
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 73724 392943 396973 401975 410173 411593 500077 515189 515245 525778 537568 537755 543870 544358 545734 547276 547282 549940 550620 562928 566009 574201 574286 581628 592837 600165 611309 629293 629902 631220 649996 655101 655314 656046 656739 657034 658292 658413 659608 663903 665235 665502 667607 670081 670175 671882 681808 682022 683515 683538 683825 685992 686040 686652 689370 689757 693852 694600 695758 696277 700546 701039 702360 702667 703113 704727 712335 712794 712925 715560 718194 718500 720628 721267 722654 723406 728350 734508 737083 737439 737482 739168 744254 744298 744941 745764 746472 748553 756067 759585 759656 759662 766028 766796 779832 788670 789210 789304 794610 795286 800560 801009 803083 803326 804113 809053 810609 814065 815878 817629 817677 817678 818316 818639 818656 823152 823365 823688 825184 827660 ] |
||||||||||||||||||||||||||||||
|
16.97 ms (8.87%) |
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 500077 515189 396973 411593 525778 667607 721267 663903 665235 712335 801009 803326 737083 704727 73724 410173 823152 817677 823688 825184 814065 815878 817629 817678 818316 818639 818656 823365 827660 537755 537568 515245 547276 550620 581628 543870 562928 544358 545734 547282 549940 574286 655314 665502 671882 683515 683538 693852 695758 696277 700546 702360 712925 715560 657034 659608 682022 683825 685992 686040 686652 689757 712794 718194 720628 722654 723406 649996 655101 656046 656739 658292 658413 670081 670175 681808 689370 694600 566009 574201 600165 611309 592837 631220 788670 789210 789304 800560 779832 795286 734508 737482 744254 745764 759585 794610 803083 739168 748553 759656 759662 766028 766796 728350 746472 737439 744298 744941 756067 629293 629902 701039 702667 703113 718500 804113 809053 810609 392943 401975 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.45%) |
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 73724 392943 396973 401975 410173 411593 500077 515189 515245 525778 537568 537755 543870 544358 545734 547276 547282 549940 550620 562928 566009 574201 574286 581628 592837 600165 611309 629293 629902 631220 649996 655101 655314 656046 656739 657034 658292 658413 659608 663903 665235 665502 667607 670081 670175 671882 681808 682022 683515 683538 683825 685992 686040 686652 689370 689757 693852 694600 695758 696277 700546 701039 702360 702667 703113 704727 712335 712794 712925 715560 718194 718500 720628 721267 722654 723406 728350 734508 737083 737439 737482 739168 744254 744298 744941 745764 746472 748553 756067 759585 759656 759662 766028 766796 779832 788670 789210 789304 794610 795286 800560 801009 803083 803326 804113 809053 810609 814065 815878 817629 817677 817678 818316 818639 818656 823152 823365 823688 825184 827660 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young teen boy"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young молодой"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young молодой"
]
|
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.