Query Metrics
7
Database Queries
7
Different statements
167.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.97 ms (85.12%) |
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 238875 278236 385510 395405 400434 420781 421137 428846 439055 442898 445507 448329 450473 460230 460646 463197 465815 465997 469804 470068 470578 473217 477968 481576 486828 491472 503500 504732 510111 522124 522371 524207 526398 551927 553725 560017 570988 579170 582597 583586 587885 588290 588365 588559 588868 589617 590217 590308 590595 590624 590900 592736 592821 593033 593754 594760 594912 594995 595239 595404 595712 596409 596517 598445 601041 601184 602927 602962 604789 605481 606683 606896 607522 609254 610054 610765 612937 613848 614658 617121 617672 618795 621955 622061 625116 626366 629760 630077 630203 630648 630984 631875 632123 632413 633701 635144 637306 639626 644004 647629 651306 651765 653227 659658 664612 672753 675394 679677 683008 684226 689133 689136 690693 693926 695828 773467 780046 800906 805460 811745 ] |
||||||||||||||||||||||||||||||
|
13.55 ms (8.07%) |
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 690693 647629 651306 651765 653227 659658 664612 672753 675394 679677 683008 684226 689133 689136 693926 695828 551927 553725 560017 570988 579170 582597 583586 587885 588365 590308 592736 593754 595404 595712 601041 602927 621955 622061 626366 629760 631875 637306 639626 588290 588559 589617 590624 594760 595239 596517 604789 606683 613848 630648 632123 633701 590595 590900 592821 594912 601184 614658 617121 618795 625116 630077 644004 588868 590217 593033 594995 596409 598445 602962 605481 606896 607522 609254 612937 617672 630984 632413 805460 811745 773467 610054 610765 630203 635144 780046 800906 428846 460230 463197 465815 238875 278236 400434 469804 385510 395405 439055 442898 465997 473217 477968 481576 448329 460646 420781 421137 445507 450473 470068 470578 504732 522371 486828 491472 503500 510111 522124 524207 526398 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.87%) |
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 238875 278236 385510 395405 400434 420781 421137 428846 439055 442898 445507 448329 450473 460230 460646 463197 465815 465997 469804 470068 470578 473217 477968 481576 486828 491472 503500 504732 510111 522124 522371 524207 526398 551927 553725 560017 570988 579170 582597 583586 587885 588290 588365 588559 588868 589617 590217 590308 590595 590624 590900 592736 592821 593033 593754 594760 594912 594995 595239 595404 595712 596409 596517 598445 601041 601184 602927 602962 604789 605481 606683 606896 607522 609254 610054 610765 612937 613848 614658 617121 617672 618795 621955 622061 625116 626366 629760 630077 630203 630648 630984 631875 632123 632413 633701 635144 637306 639626 644004 647629 651306 651765 653227 659658 664612 672753 675394 679677 683008 684226 689133 689136 690693 693926 695828 773467 780046 800906 805460 811745 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"за голову"
]
|
||||||||||||||||||||||||||||||
|
2.22 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"голов"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.04%) |
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.