Query Metrics
7
Database Queries
7
Different statements
147.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.47 ms (85.95%) |
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 397063 401926 455888 460298 468399 468422 470427 477076 498642 499179 505758 506283 538805 541433 552430 559846 568500 571415 574935 575618 580462 586010 587908 590842 592161 596245 598539 599572 599889 609290 611662 612905 614354 619590 624176 624209 626803 626880 636955 637851 642335 655293 655919 656274 656576 663551 665511 666583 672041 673813 674770 680259 680353 680391 685480 685534 686581 690326 690396 691212 692423 692502 693536 694582 695093 695109 695380 696412 701753 703542 705753 706256 707309 707562 711094 714667 719932 720731 720788 720952 721223 722447 728372 730744 734964 743961 757180 761080 769737 769754 769763 769771 769774 769804 769841 769880 771715 772449 772783 777233 777737 778850 778878 779730 784533 784852 785480 786199 787883 788178 789107 796916 800415 803466 813005 821008 821265 821576 823192 824069 ] |
||||||||||||||||||||||||||||||
|
12.99 ms (8.83%) |
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 592161 612905 778878 796916 813005 786199 743961 769841 785480 728372 734964 757180 769880 730744 769754 769763 769804 769771 769774 772783 455888 470427 477076 499179 574935 666583 559846 624176 586010 598539 599889 784533 788178 803466 772449 771715 769737 468399 505758 824069 506283 695109 778850 777233 761080 800415 397063 401926 821008 823192 821265 821576 468422 460298 498642 538805 552430 541433 568500 575618 655293 656274 665511 680259 680391 685480 686581 690326 692502 695093 695380 707309 720731 720952 655919 656576 672041 674770 680353 685534 690396 692423 693536 694582 703542 705753 711094 719932 720788 663551 673813 691212 696412 701753 706256 707562 714667 721223 722447 571415 580462 609290 624209 626803 636955 637851 587908 596245 599572 611662 619590 642335 590842 614354 626880 777737 779730 784852 787883 789107 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.56%) |
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 397063 401926 455888 460298 468399 468422 470427 477076 498642 499179 505758 506283 538805 541433 552430 559846 568500 571415 574935 575618 580462 586010 587908 590842 592161 596245 598539 599572 599889 609290 611662 612905 614354 619590 624176 624209 626803 626880 636955 637851 642335 655293 655919 656274 656576 663551 665511 666583 672041 673813 674770 680259 680353 680391 685480 685534 686581 690326 690396 691212 692423 692502 693536 694582 695093 695109 695380 696412 701753 703542 705753 706256 707309 707562 711094 714667 719932 720731 720788 720952 721223 722447 728372 730744 734964 743961 757180 761080 769737 769754 769763 769771 769774 769804 769841 769880 771715 772449 772783 777233 777737 778850 778878 779730 784533 784852 785480 786199 787883 788178 789107 796916 800415 803466 813005 821008 821265 821576 823192 824069 ] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair анал"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair anal"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair анал"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.86%) |
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.