Query Metrics
7
Database Queries
7
Different statements
161.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.76 ms (84.72%) |
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 384593 385137 393424 395705 396456 397548 399195 399889 410147 411184 413299 415897 418375 418578 420133 428724 428977 428987 429906 445568 446780 447150 447152 461624 468712 472246 475472 479689 486301 489005 491673 498619 515070 516429 519079 524763 525222 528901 532340 533216 534269 538361 542681 547570 549519 552998 554387 554704 556203 557931 560474 560487 564000 564583 564784 564799 566282 568150 568560 573384 573530 589200 593128 593775 595025 596659 597441 597547 600587 603833 604063 607728 609870 611265 613778 617308 617825 625206 630569 644078 654132 655121 672335 672588 673074 674400 674688 678980 680260 680743 683587 693166 693935 724050 729933 744790 757442 762594 766818 776988 789887 799008 807243 807606 808046 809238 810191 810967 811511 813471 813914 814046 814657 818282 820336 820346 820422 821120 821201 823527 ] |
||||||||||||||||||||||||||||||
|
14.16 ms (8.77%) |
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 479689 418578 461624 486301 491673 429906 428987 399195 813914 821120 823527 820336 820422 446780 532340 573530 564784 560474 674688 693935 683587 566282 630569 593128 593775 597441 607728 597547 644078 724050 729933 744790 789887 810191 813471 762594 617825 799008 807243 413299 393424 420133 472246 418375 525222 519079 447152 447150 596659 397548 428724 516429 384593 385137 395705 396456 399889 410147 428977 415897 411184 814657 821201 818282 820346 814046 468712 445568 475472 489005 498619 524763 515070 528901 534269 538361 533216 542681 557931 564583 568150 573384 549519 560487 564799 552998 564000 568560 673074 680743 655121 672588 674400 678980 693166 654132 672335 680260 547570 554387 554704 556203 595025 609870 611265 613778 603833 604063 625206 600587 589200 617308 776988 807606 808046 810967 811511 809238 766818 757442 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.81%) |
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 384593 385137 393424 395705 396456 397548 399195 399889 410147 411184 413299 415897 418375 418578 420133 428724 428977 428987 429906 445568 446780 447150 447152 461624 468712 472246 475472 479689 486301 489005 491673 498619 515070 516429 519079 524763 525222 528901 532340 533216 534269 538361 542681 547570 549519 552998 554387 554704 556203 557931 560474 560487 564000 564583 564784 564799 566282 568150 568560 573384 573530 589200 593128 593775 595025 596659 597441 597547 600587 603833 604063 607728 609870 611265 613778 617308 617825 625206 630569 644078 654132 655121 672335 672588 673074 674400 674688 678980 680260 680743 683587 693166 693935 724050 729933 744790 757442 762594 766818 776988 789887 799008 807243 807606 808046 809238 810191 810967 811511 813471 813914 814046 814657 818282 820336 820346 820422 821120 821201 823527 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская худые"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina skinny"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.06%) |
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.