Query Metrics
7
Database Queries
7
Different statements
161.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.69 ms (82.18%) |
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 420109 429742 470101 470142 508945 509005 514120 515300 520460 521791 522427 522920 527390 527721 527867 528578 529339 534568 537194 537248 538793 542420 542542 542559 543161 544488 545262 546419 548833 551038 552525 553495 555930 556213 556552 557165 557382 561283 561454 561937 562045 563705 568042 568174 569117 569549 571130 572827 572968 576199 576340 577056 577603 578128 578438 579350 580982 581348 581989 584809 584833 585767 586378 586426 586700 586763 590382 590727 590753 592824 592841 593792 594415 596514 597182 598346 598365 599735 600581 600851 601213 602698 603142 604093 605459 605855 606165 608173 610314 610716 612346 612581 612614 612801 612933 613878 616754 617863 620072 620750 622264 624884 625008 625088 625283 629764 634246 643194 652558 652940 659775 660860 663389 664777 665325 680746 683595 684996 686207 713651 ] |
||||||||||||||||||||||||||||||
|
18.67 ms (11.57%) |
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 509005 521791 522427 527390 534568 537248 538793 508945 528578 529339 537194 542542 542559 546419 561454 571130 576199 576340 577056 580982 584833 544488 545262 548833 557165 557382 561937 562045 569117 572827 578128 579350 542420 563705 577603 578438 581989 584809 680746 684996 686207 652558 652940 664777 665325 659775 660860 551038 553495 555930 556213 556552 561283 568174 569549 572968 581348 585767 592824 592841 593792 594415 598365 600851 601213 605855 608173 613878 622264 586426 586700 590382 598346 612614 620072 624884 597182 603142 604093 605459 610716 643194 590727 590753 596514 600581 616754 617863 625008 625283 602698 612346 612581 612933 625088 634246 470142 470101 552525 683595 713651 620750 420109 522920 527721 514120 527867 606165 629764 586378 515300 543161 568042 663389 612801 586763 599735 429742 520460 610314 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.42%) |
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 420109 429742 470101 470142 508945 509005 514120 515300 520460 521791 522427 522920 527390 527721 527867 528578 529339 534568 537194 537248 538793 542420 542542 542559 543161 544488 545262 546419 548833 551038 552525 553495 555930 556213 556552 557165 557382 561283 561454 561937 562045 563705 568042 568174 569117 569549 571130 572827 572968 576199 576340 577056 577603 578128 578438 579350 580982 581348 581989 584809 584833 585767 586378 586426 586700 586763 590382 590727 590753 592824 592841 593792 594415 596514 597182 598346 598365 599735 600581 600851 601213 602698 603142 604093 605459 605855 606165 608173 610314 610716 612346 612581 612614 612801 612933 613878 616754 617863 620072 620750 622264 624884 625008 625088 625283 629764 634246 643194 652558 652940 659775 660860 663389 664777 665325 680746 683595 684996 686207 713651 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сосет с яйцами"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сосет яйц"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.11%) |
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.