Query Metrics
7
Database Queries
7
Different statements
184.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.02 ms (86.13%) |
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 282494 385111 385267 385909 387423 388401 392216 393660 396786 397104 397475 398577 398882 401317 401939 413258 415254 434709 435664 441430 441567 448543 453790 456469 466061 468603 484070 490982 491487 492553 497454 499774 506548 509892 510687 514946 526136 526765 527507 527514 527550 528985 528988 529061 534127 535664 537686 537958 539099 540705 540922 542453 552171 560696 568478 573839 575647 576051 576316 579455 594381 595458 595501 595873 598013 598539 605329 606792 617653 618072 618449 627835 631311 646439 647634 650692 656938 659282 670760 680200 684393 685523 685525 685531 687718 690346 690446 690455 691911 696004 698435 707278 711422 736841 743188 745142 751500 753339 753360 753761 754214 757017 770577 776918 777643 783748 784260 785404 788309 791770 794924 805228 807545 813599 817400 817596 817602 817673 828593 ] |
||||||||||||||||||||||||||||||
|
14.65 ms (7.93%) |
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 828593 711422 385267 534127 691911 556732 807545 783748 398577 568478 595873 401939 528985 527514 656938 777643 745142 491487 468603 484070 526136 680200 595501 753339 753360 388401 605329 751500 392216 529061 415254 510687 595458 598013 435664 618449 490982 492553 817602 817400 817596 817673 542453 687718 646439 757017 736841 743188 753761 385909 685531 618072 805228 631311 499774 552171 627835 788309 560696 684393 647634 690346 690446 698435 707278 794924 770577 776918 785404 401317 535664 540922 670760 690455 573839 594381 617653 576051 506548 527507 528988 526765 539099 650692 385111 397475 791770 393660 387423 397104 398882 434709 441567 466061 453790 537958 514946 598539 441430 396786 456469 282494 413258 497454 448543 537686 540705 575647 579455 685523 685525 696004 606792 813599 576316 659282 754214 784260 527550 509892 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.69%) |
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 282494 385111 385267 385909 387423 388401 392216 393660 396786 397104 397475 398577 398882 401317 401939 413258 415254 434709 435664 441430 441567 448543 453790 456469 466061 468603 484070 490982 491487 492553 497454 499774 506548 509892 510687 514946 526136 526765 527507 527514 527550 528985 528988 529061 534127 535664 537686 537958 539099 540705 540922 542453 552171 560696 568478 573839 575647 576051 576316 579455 594381 595458 595501 595873 598013 598539 605329 606792 617653 618072 618449 627835 631311 646439 647634 650692 656938 659282 670760 680200 684393 685523 685525 685531 687718 690346 690446 690455 691911 696004 698435 707278 711422 736841 743188 745142 751500 753339 753360 753761 754214 757017 770577 776918 777643 783748 784260 785404 788309 791770 794924 805228 807545 813599 817400 817596 817602 817673 828593 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public 18 teen"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на 18 улиц teen"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на 18 улиц 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.