Query Metrics
7
Database Queries
7
Different statements
174.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.65 ms (82.94%) |
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 66768 74434 79765 124361 152882 187786 187789 188169 188266 205882 232940 233532 236765 358466 358481 361315 366010 384581 388719 388724 388739 388757 389223 389729 390582 391042 391380 391392 391492 391576 391614 391652 392054 393102 397304 397861 397873 397883 398553 398959 401967 402897 403321 407763 409310 411326 411385 411615 411716 411766 411918 413972 428138 448727 451488 457991 460760 466231 466986 468167 469283 470148 470201 471411 472905 476348 480757 484638 484685 510907 546687 546950 547605 563127 563436 565134 591046 612872 619531 622775 623493 645891 650388 678778 678782 695598 696415 697618 705404 714818 714909 716557 720693 726838 726902 728445 728446 742704 742722 765302 766597 766663 769491 770127 777250 781648 788585 789532 789997 790813 793587 793770 794647 807600 811491 814125 818438 818630 823686 824014 ] |
||||||||||||||||||||||||||||||
|
18.67 ms (10.71%) |
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 766597 742722 448727 391042 411385 814125 236765 124361 388739 391652 720693 777250 807600 361315 823686 824014 818438 74434 622775 398959 468167 411326 411615 205882 788585 152882 697618 714818 188266 409310 563436 726838 393102 402897 79765 411716 411766 696415 645891 716557 565134 793770 366010 358481 232940 476348 466986 471411 547605 563127 591046 728446 187786 389729 397861 466231 472905 66768 389223 413972 480757 384581 818630 714909 650388 790813 742704 769491 623493 781648 510907 793587 233532 397304 695598 789997 789532 794647 765302 678778 678782 612872 766663 391492 397873 401967 546687 546950 728445 811491 770127 619531 391576 397883 403321 411918 391380 391614 469283 470148 428138 484638 484685 388719 470201 388724 388757 391392 726902 460760 187789 705404 188169 407763 457991 398553 390582 451488 392054 358466 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.73%) |
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 66768 74434 79765 124361 152882 187786 187789 188169 188266 205882 232940 233532 236765 358466 358481 361315 366010 384581 388719 388724 388739 388757 389223 389729 390582 391042 391380 391392 391492 391576 391614 391652 392054 393102 397304 397861 397873 397883 398553 398959 401967 402897 403321 407763 409310 411326 411385 411615 411716 411766 411918 413972 428138 448727 451488 457991 460760 466231 466986 468167 469283 470148 470201 471411 472905 476348 480757 484638 484685 510907 546687 546950 547605 563127 563436 565134 591046 612872 619531 622775 623493 645891 650388 678778 678782 695598 696415 697618 705404 714818 714909 716557 720693 726838 726902 728445 728446 742704 742722 765302 766597 766663 769491 770127 777250 781648 788585 789532 789997 790813 793587 793770 794647 807600 811491 814125 818438 818630 823686 824014 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature anal old"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature анал old"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature анал old"
]
|
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.