Query Metrics
7
Database Queries
7
Different statements
162.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.79 ms (86.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 491814 519639 530392 537525 538668 539519 542976 543822 544270 544301 544356 547340 547345 547642 548562 549912 550612 552900 559705 563877 566681 572575 572578 577161 580664 585169 602573 612842 619430 622178 626543 626755 628300 635897 644696 648487 652600 652991 655685 655691 656381 657730 657949 658066 658419 659601 665247 665512 666810 667244 670074 673985 675729 675737 677459 677543 681862 682091 683505 683524 684224 684238 684943 684965 685632 685891 686794 688370 688591 694536 695921 696508 701297 701384 701444 702656 702683 702958 708101 711894 712829 712906 712913 712923 715832 716391 717649 718627 719989 721434 721574 734715 739478 741019 743158 751500 755735 787951 788448 788963 792698 799760 802824 807724 812119 813941 814074 814915 815259 817309 817335 818821 819191 819550 819595 820087 820427 821625 823024 824012 ] |
||||||||||||||||||||||||||||||
|
12.22 ms (7.52%) |
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 813941 814074 815259 819550 823024 824012 814915 817309 817335 818821 819191 819595 820087 820427 821625 539519 519639 530392 537525 538668 491814 542976 543822 550612 572578 547642 548562 549912 566681 577161 544270 544301 544356 563877 580664 648487 652600 657730 658066 665512 666810 677459 677543 681862 682091 688370 696508 701384 701444 708101 655691 657949 658419 667244 673985 675729 684965 685632 686794 694536 695921 701297 702656 702958 711894 712829 712913 715832 716391 717649 652991 655685 656381 659601 665247 670074 675737 683505 683524 684224 684238 684943 685891 688591 702683 712906 712923 718627 719989 721434 721574 547340 547345 552900 559705 572575 628300 635897 644696 585169 602573 612842 619430 622178 626543 626755 787951 788448 799760 807724 812119 788963 792698 802824 734715 739478 741019 743158 751500 755735 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.63%) |
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 491814 519639 530392 537525 538668 539519 542976 543822 544270 544301 544356 547340 547345 547642 548562 549912 550612 552900 559705 563877 566681 572575 572578 577161 580664 585169 602573 612842 619430 622178 626543 626755 628300 635897 644696 648487 652600 652991 655685 655691 656381 657730 657949 658066 658419 659601 665247 665512 666810 667244 670074 673985 675729 675737 677459 677543 681862 682091 683505 683524 684224 684238 684943 684965 685632 685891 686794 688370 688591 694536 695921 696508 701297 701384 701444 702656 702683 702958 708101 711894 712829 712906 712913 712923 715832 716391 717649 718627 719989 721434 721574 734715 739478 741019 743158 751500 755735 787951 788448 788963 792698 799760 802824 807724 812119 813941 814074 814915 815259 817309 817335 818821 819191 819550 819595 820087 820427 821625 823024 824012 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young teen boy"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young молодой"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young молодой"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.88%) |
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.