Query Metrics
7
Database Queries
7
Different statements
155.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.73 ms (83.21%) |
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 44174 321806 382381 391635 402869 417742 437608 442965 444281 445062 451453 451589 455822 458962 459612 463101 464625 466419 468699 472451 475267 484084 488332 490786 491611 497485 500085 511475 512948 513307 513346 514281 521022 524243 525419 525646 525954 531078 536613 536849 536889 538638 538729 541558 551183 554929 562649 566045 567745 568445 576386 580721 590702 595451 596585 598218 598736 599418 599791 600060 601010 605892 609909 611336 618921 620115 621174 621434 624829 626535 641120 641739 649845 662046 662072 662456 665051 670534 671429 672408 673122 673128 673299 676551 679437 680785 680800 685065 689693 696061 705519 706535 709517 710946 712158 716121 716871 720956 723933 723980 726034 737591 737594 761290 764879 767325 774495 776375 777064 777067 778989 782533 788901 790959 793901 794791 809121 813332 814332 817615 ] |
||||||||||||||||||||||||||||||
|
15.36 ms (9.85%) |
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 451589 513307 444281 455822 484084 459612 437608 525954 531078 817615 814332 566045 696061 709517 673122 716871 605892 609909 778989 774495 777067 723980 809121 737594 764879 726034 451453 600060 536889 576386 513346 490786 44174 536849 488332 580721 680785 662072 662456 679437 716121 601010 621174 737591 794791 767325 788901 813332 468699 475267 442965 321806 445062 466419 472451 525646 500085 512948 514281 538638 524243 464625 562649 673299 689693 720956 665051 685065 705519 706535 670534 676551 680800 710946 598218 598736 596585 641739 590702 595451 611336 618921 620115 624829 626535 641120 777064 790959 761290 776375 782533 382381 417742 497485 391635 402869 458962 463101 491611 521022 525419 538729 511475 536613 541558 568445 567745 554929 649845 662046 671429 712158 673128 672408 551183 599418 599791 621434 793901 723933 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.10%) |
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 44174 321806 382381 391635 402869 417742 437608 442965 444281 445062 451453 451589 455822 458962 459612 463101 464625 466419 468699 472451 475267 484084 488332 490786 491611 497485 500085 511475 512948 513307 513346 514281 521022 524243 525419 525646 525954 531078 536613 536849 536889 538638 538729 541558 551183 554929 562649 566045 567745 568445 576386 580721 590702 595451 596585 598218 598736 599418 599791 600060 601010 605892 609909 611336 618921 620115 621174 621434 624829 626535 641120 641739 649845 662046 662072 662456 665051 670534 671429 672408 673122 673128 673299 676551 679437 680785 680800 685065 689693 696061 705519 706535 709517 710946 712158 716121 716871 720956 723933 723980 726034 737591 737594 761290 764879 767325 774495 776375 777064 777067 778989 782533 788901 790959 793901 794791 809121 813332 814332 817615 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen-car"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen вмашин"
]
|
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.