Query Metrics
7
Database Queries
7
Different statements
166.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.53 ms (88.62%) |
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 31218 107060 387908 390575 390839 396079 397179 398002 398516 402816 411834 413963 441829 448643 450656 461302 472907 480624 500949 509353 512695 513855 514177 514183 522430 526387 536852 540923 542605 549472 559169 577448 579302 580408 583357 585808 591559 600699 603021 609854 610244 618859 625765 627280 629519 630434 630995 638184 642617 644102 656581 658099 671569 677289 680258 680751 680756 683078 683106 685638 686319 698099 699450 701617 703422 703604 707547 707758 709504 709835 710583 710910 711270 711662 712081 715987 717285 718938 719861 720304 721896 722086 727555 734175 737491 741115 747851 749719 750768 750916 753099 753173 757522 759373 767381 770731 773723 773730 781613 784077 787593 788968 794336 794356 794508 796694 797325 799766 800270 806495 806706 811468 812000 812799 812845 812853 813062 813270 813580 814471 ] |
||||||||||||||||||||||||||||||
|
10.87 ms (6.53%) |
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 450656 642617 514183 536852 577448 683078 703422 683106 710583 656581 677289 686319 591559 600699 638184 603021 630995 784077 812845 698099 709835 712081 703604 630434 767381 753099 402816 709504 720304 770731 711270 814471 813580 512695 514177 542605 717285 718938 585808 794508 797325 806706 812853 788968 811468 750768 773730 794356 737491 759373 753173 719861 796694 799766 806495 107060 31218 387908 411834 540923 448643 472907 580408 609854 397179 441829 500949 509353 711662 625765 583357 658099 671569 707758 522430 549472 707547 680258 680751 680756 710910 701617 629519 610244 644102 627280 699450 579302 721896 618859 480624 461302 685638 715987 390575 390839 396079 398002 398516 413963 513855 526387 559169 722086 794336 734175 781613 787593 800270 812799 813062 757522 773723 727555 747851 750916 741115 749719 812000 813270 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.27%) |
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 31218 107060 387908 390575 390839 396079 397179 398002 398516 402816 411834 413963 441829 448643 450656 461302 472907 480624 500949 509353 512695 513855 514177 514183 522430 526387 536852 540923 542605 549472 559169 577448 579302 580408 583357 585808 591559 600699 603021 609854 610244 618859 625765 627280 629519 630434 630995 638184 642617 644102 656581 658099 671569 677289 680258 680751 680756 683078 683106 685638 686319 698099 699450 701617 703422 703604 707547 707758 709504 709835 710583 710910 711270 711662 712081 715987 717285 718938 719861 720304 721896 722086 727555 734175 737491 741115 747851 749719 750768 750916 753099 753173 757522 759373 767381 770731 773723 773730 781613 784077 787593 788968 794336 794356 794508 796694 797325 799766 800270 806495 806706 811468 812000 812799 812845 812853 813062 813270 813580 814471 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina amateur"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская любительск"
]
|
||||||||||||||||||||||||||||||
|
1.15 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.