Query Metrics
7
Database Queries
7
Different statements
370.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
336.31 ms (90.89%) |
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 391582 396070 403628 403770 411958 413518 417454 419423 426490 427399 431893 435503 435929 437157 437556 438004 441659 441912 446498 447597 448859 449647 450473 450876 453533 455733 455947 456311 456538 457067 457926 458504 458835 464475 468991 471830 475385 477244 479518 480114 480626 481356 489553 491653 493443 493937 495851 497201 497756 498699 498854 499414 500263 506356 509945 512948 514353 523935 524719 526487 529474 540587 541868 542640 555754 563653 572203 587299 595278 597072 597917 602634 604924 624893 629569 633322 651376 664543 666164 667901 677910 684053 696493 700732 707510 707531 714944 719115 722020 729548 730381 735392 736631 747454 751410 756252 757152 757232 759121 760567 762886 768387 783036 786081 790843 791132 793923 795600 798329 800706 800851 801026 804554 812058 812979 817571 822042 822228 822694 823326 ] |
||||||||||||||||||||||||||||||
|
23.82 ms (6.44%) |
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 587299 629569 801026 736631 714944 403628 391582 471830 396070 822042 822228 458504 458835 457067 526487 497756 475385 696493 604924 602634 800851 812979 729548 759121 751410 757232 624893 437556 489553 529474 498699 441912 426490 427399 411958 441659 435929 823326 822694 464475 477244 481356 498854 540587 500263 512948 468991 493937 542640 684053 700732 563653 595278 597072 795600 786081 757152 735392 762886 760567 719115 790843 455733 457926 479518 450876 480114 437157 449647 456311 480626 417454 446498 450473 523935 491653 524719 499414 509945 495851 497201 817571 541868 555754 664543 666164 707531 707510 722020 651376 677910 633322 783036 793923 798329 800706 730381 747454 768387 791132 812058 447597 438004 597917 804554 435503 453533 756252 455947 419423 506356 403770 413518 431893 448859 456538 493443 514353 572203 667901 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (0.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 391582 396070 403628 403770 411958 413518 417454 419423 426490 427399 431893 435503 435929 437157 437556 438004 441659 441912 446498 447597 448859 449647 450473 450876 453533 455733 455947 456311 456538 457067 457926 458504 458835 464475 468991 471830 475385 477244 479518 480114 480626 481356 489553 491653 493443 493937 495851 497201 497756 498699 498854 499414 500263 506356 509945 512948 514353 523935 524719 526487 529474 540587 541868 542640 555754 563653 572203 587299 595278 597072 597917 602634 604924 624893 629569 633322 651376 664543 666164 667901 677910 684053 696493 700732 707510 707531 714944 719115 722020 729548 730381 735392 736631 747454 751410 756252 757152 757232 759121 760567 762886 768387 783036 786081 790843 791132 793923 795600 798329 800706 800851 801026 804554 812058 812979 817571 822042 822228 822694 823326 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ride"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие ride"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие ride"
]
|
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.