Query Metrics
7
Database Queries
7
Different statements
154.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.93 ms (84.36%) |
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 384558 407602 417865 422524 422557 422618 422920 423264 443693 445057 446267 446298 453122 472223 480376 482818 491670 493931 495374 509920 514574 519682 520629 523184 524664 526116 529035 531429 531430 536676 547061 550374 550377 550379 550408 551394 553276 554068 558049 561471 566158 568579 574192 579668 580185 580776 582548 589268 591137 611565 611933 612207 612946 615796 615978 638346 641677 644078 644493 644956 650657 651881 652187 665027 665296 667311 667614 667679 667900 668888 671832 672588 673371 680185 694048 700659 703100 705404 705717 709636 709732 712332 714167 714171 715528 715722 716181 716528 717645 717689 718236 719102 720384 722330 722596 725363 725564 727698 730313 732420 732425 735821 736408 737070 741966 742031 742610 743021 744995 747604 754141 758986 760034 765710 766851 773683 789845 804751 814070 826327 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (8.95%) |
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 509920 524664 491670 495374 493931 526116 514574 417865 644956 826327 520629 566158 665027 671832 703100 651881 667311 717645 718236 650657 668888 673371 712332 717689 720384 722596 551394 561471 579668 611565 638346 641677 644493 589268 591137 612207 612946 615796 644078 789845 804751 727698 730313 736408 743021 747604 758986 760034 765710 766851 725363 732425 741966 742031 742610 744995 725564 732420 735821 737070 754141 773683 611933 715528 715722 716181 443693 536676 615978 529035 568579 680185 446267 384558 422618 423264 407602 422524 445057 422920 422557 814070 482818 453122 446298 519682 531429 531430 523184 472223 480376 550374 553276 558049 580776 582548 547061 550377 550379 550408 554068 574192 580185 652187 667900 700659 709732 714167 716528 719102 722330 665296 667614 667679 672588 694048 705404 705717 709636 714171 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг old"
]
|
||||||||||||||||||||||||||||||
|
2.30 ms (1.49%) |
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 384558 407602 417865 422524 422557 422618 422920 423264 443693 445057 446267 446298 453122 472223 480376 482818 491670 493931 495374 509920 514574 519682 520629 523184 524664 526116 529035 531429 531430 536676 547061 550374 550377 550379 550408 551394 553276 554068 558049 561471 566158 568579 574192 579668 580185 580776 582548 589268 591137 611565 611933 612207 612946 615796 615978 638346 641677 644078 644493 644956 650657 651881 652187 665027 665296 667311 667614 667679 667900 668888 671832 672588 673371 680185 694048 700659 703100 705404 705717 709636 709732 712332 714167 714171 715528 715722 716181 716528 717645 717689 718236 719102 720384 722330 722596 725363 725564 727698 730313 732420 732425 735821 736408 737070 741966 742031 742610 743021 744995 747604 754141 758986 760034 765710 766851 773683 789845 804751 814070 826327 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting old"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг old"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.07%) |
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.