Query Metrics
7
Database Queries
7
Different statements
143.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.60 ms (82.87%) |
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 423845 448319 453037 456298 459438 480514 481317 483907 484150 485676 486197 488719 491624 492210 499720 503401 505932 506901 512043 512824 513087 514598 515543 516385 518500 518826 522545 523137 524513 525959 527276 527522 529298 529515 529539 535058 535220 541130 541948 542535 542719 543984 545232 546085 546843 547427 549445 549631 550077 550290 551032 551210 552282 553227 555378 556149 556593 558104 558374 558388 559110 559130 560160 560412 560911 561260 561589 561602 562029 562506 562618 565370 566091 566687 568126 569082 569419 569632 570462 570741 572095 573880 574421 574645 574648 575716 578499 580140 580259 580967 581619 583658 586107 587164 588033 588202 589265 594505 599394 600267 600980 604645 606156 606518 614348 615602 616234 630686 632177 636528 638459 646748 647212 650020 651641 651678 668382 680962 690309 749633 ] |
||||||||||||||||||||||||||||||
|
15.17 ms (10.60%) |
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 575716 558104 499720 535220 560160 566091 542535 562618 569632 581619 615602 525959 524513 492210 529539 552282 572095 583658 568126 630686 589265 614348 559110 542719 513087 514598 574421 588033 588202 512043 486197 551210 586107 636528 529515 562506 578499 546085 549445 559130 580140 580967 646748 680962 647212 651641 600267 600980 749633 632177 448319 522545 574648 545232 550077 558374 558388 541130 561260 606156 505932 668382 690309 546843 569419 604645 587164 512824 650020 527276 556593 606518 518500 547427 560412 550290 503401 506901 527522 529298 535058 515543 516385 488719 541948 555378 574645 543984 566687 561602 565370 570462 573880 638459 599394 456298 481317 484150 453037 491624 580259 562029 523137 570741 561589 651678 423845 459438 518826 551032 549631 553227 560911 556149 569082 616234 594505 480514 483907 485676 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.77%) |
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 423845 448319 453037 456298 459438 480514 481317 483907 484150 485676 486197 488719 491624 492210 499720 503401 505932 506901 512043 512824 513087 514598 515543 516385 518500 518826 522545 523137 524513 525959 527276 527522 529298 529515 529539 535058 535220 541130 541948 542535 542719 543984 545232 546085 546843 547427 549445 549631 550077 550290 551032 551210 552282 553227 555378 556149 556593 558104 558374 558388 559110 559130 560160 560412 560911 561260 561589 561602 562029 562506 562618 565370 566091 566687 568126 569082 569419 569632 570462 570741 572095 573880 574421 574645 574648 575716 578499 580140 580259 580967 581619 583658 586107 587164 588033 588202 589265 594505 599394 600267 600980 604645 606156 606518 614348 615602 616234 630686 632177 636528 638459 646748 647212 650020 651641 651678 668382 680962 690309 749633 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"touch in public"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трога на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.85%) |
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.