Query Metrics
7
Database Queries
7
Different statements
307.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
279.87 ms (91.16%) |
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 387328 390917 400636 416192 417135 420337 429931 430474 430816 442967 443662 446645 447513 450573 451156 456661 458751 459113 461146 467605 469630 473641 480918 482076 483638 484521 485192 485251 487921 488096 489463 489676 490482 491372 492198 494094 498795 499618 499777 504384 510573 510581 512044 515847 516160 519687 519993 522017 523966 525608 527868 528639 531156 534126 534166 537926 538354 542089 544386 550051 556045 558849 559524 560206 560583 560791 560845 561673 565264 568604 569666 569683 570054 571504 574794 576270 581637 581681 590992 597146 597793 599974 601358 603911 604142 611339 614054 616967 618476 620277 621354 623291 624755 632084 633512 633524 634155 635225 637065 640708 642750 644674 644762 650177 655725 670279 672338 672711 673330 682866 688374 712978 724176 732061 750751 774708 783311 789002 800630 821145 ] |
||||||||||||||||||||||||||||||
|
16.55 ms (5.39%) |
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 417135 443662 821145 446645 469630 492198 450573 484521 534126 538354 504384 510573 519687 485192 485251 558849 561673 569666 570054 571504 581637 569683 682866 688374 650177 670279 672338 559524 560206 560791 574794 599974 601358 614054 633512 635225 623291 642750 616967 597793 624755 750751 800630 774708 458751 387328 390917 430474 473641 482076 451156 459113 480918 420337 483638 487921 488096 489463 490482 498795 512044 489676 491372 494094 499618 510581 523966 528639 568604 655725 611339 590992 597146 467605 603911 618476 519993 542089 556045 525608 527868 461146 531156 534166 499777 522017 516160 537926 515847 544386 560845 581681 576270 712978 672711 673330 550051 560583 565264 632084 637065 640708 620277 634155 644762 604142 621354 783311 732061 724176 633524 644674 789002 447513 400636 416192 429931 442967 456661 430816 ] |
||||||||||||||||||||||||||||||
|
3.45 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 387328 390917 400636 416192 417135 420337 429931 430474 430816 442967 443662 446645 447513 450573 451156 456661 458751 459113 461146 467605 469630 473641 480918 482076 483638 484521 485192 485251 487921 488096 489463 489676 490482 491372 492198 494094 498795 499618 499777 504384 510573 510581 512044 515847 516160 519687 519993 522017 523966 525608 527868 528639 531156 534126 534166 537926 538354 542089 544386 550051 556045 558849 559524 560206 560583 560791 560845 561673 565264 568604 569666 569683 570054 571504 574794 576270 581637 581681 590992 597146 597793 599974 601358 603911 604142 611339 614054 616967 618476 620277 621354 623291 624755 632084 633512 633524 634155 635225 637065 640708 642750 644674 644762 650177 655725 670279 672338 672711 673330 682866 688374 712978 724176 732061 750751 774708 783311 789002 800630 821145 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милая красивая"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sweet and beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"милая красивая"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.