Query Metrics
7
Database Queries
7
Different statements
214.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.77 ms (87.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 389497 402599 430247 435647 439349 440292 452600 455582 463614 465316 504331 527197 530409 533479 553433 562645 568367 572228 579227 579615 581715 582197 591049 593598 594108 596427 602707 606931 612601 613922 616679 619103 621347 622308 623749 625254 633412 636587 639170 639225 649440 659389 659401 663165 668789 685068 687942 689525 695087 696455 696567 701247 702312 704174 707744 709503 709914 714097 716182 716921 716935 719443 724642 725709 726390 727147 730904 736130 736378 736379 736664 738525 739792 743429 743463 746267 746497 755695 756797 756973 758594 759675 762235 763077 764711 769550 771490 772444 773681 773797 775271 777096 777270 778109 780752 780810 782503 782877 784191 786216 787636 793494 793528 794807 795363 795753 796214 796915 799071 799983 805030 807453 808859 811632 811919 813752 817070 821761 ] |
||||||||||||||||||||||||||||||
|
16.98 ms (7.92%) |
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 811919 736130 782877 794807 796214 808859 724642 736664 746267 758594 773681 736379 778109 799983 439349 581715 533479 504331 553433 649440 707744 714097 687942 702312 594108 593598 633412 622308 619103 621347 659389 709914 639170 786216 775271 743429 726390 738525 772444 435647 430247 821761 636587 782503 799071 805030 807453 811632 725709 739792 762235 764711 771490 784191 793528 796915 452600 695087 602707 709503 696567 701247 697943 389497 465316 716921 689525 716935 579615 623749 591049 777096 756973 730904 727147 769550 773797 756797 639225 527197 572228 668789 685068 719443 704174 663165 579227 596427 625254 606931 613922 787636 568367 582197 659401 696455 616679 795363 755695 743463 736517 746497 780752 463614 612601 402599 440292 813752 817070 455582 530409 562645 716182 777270 780810 793494 795753 736378 759675 763077 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.12%) |
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 389497 402599 430247 435647 439349 440292 452600 455582 463614 465316 504331 527197 530409 533479 553433 562645 568367 572228 579227 579615 581715 582197 591049 593598 594108 596427 602707 606931 612601 613922 616679 619103 621347 622308 623749 625254 633412 636587 639170 639225 649440 659389 659401 663165 668789 685068 687942 689525 695087 696455 696567 701247 702312 704174 707744 709503 709914 714097 716182 716921 716935 719443 724642 725709 726390 727147 730904 736130 736378 736379 736664 738525 739792 743429 743463 746267 746497 755695 756797 756973 758594 759675 762235 763077 764711 769550 771490 772444 773681 773797 775271 777096 777270 778109 780752 780810 782503 782877 784191 786216 787636 793494 793528 794807 795363 795753 796214 796915 799071 799983 805030 807453 808859 811632 811919 813752 817070 821761 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step amateur"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step любительск"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step любительск"
]
|
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.