Query Metrics
7
Database Queries
7
Different statements
181.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.11 ms (85.78%) |
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 3793 4123 91433 392225 397115 397652 442429 447779 450285 451225 452320 460933 467603 469898 471086 476892 484234 494313 494893 500182 501435 502934 504219 508650 511652 525714 525788 526683 532200 533269 537765 539145 550268 555685 557919 560276 562544 562709 565676 565833 566926 568025 578135 579721 581927 583743 586607 591939 592654 593701 593785 597678 598594 600537 602635 603564 605765 610477 612987 617953 618360 622894 639083 639124 644524 650649 660454 663721 671901 674387 680302 689048 692345 698780 701879 705428 707149 712449 712610 718332 719772 723302 725656 726897 727874 729115 730361 732500 733786 735276 736198 740815 740961 742648 742754 748846 749621 751842 752046 752083 752487 757943 762622 763475 764095 769296 771316 777009 777757 778415 778847 779360 779659 787011 795195 796055 799830 809755 814696 ] |
||||||||||||||||||||||||||||||
|
15.38 ms (8.45%) |
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 692345 809755 539145 603564 600537 639124 639083 799830 796055 452320 500182 593701 392225 718332 752046 757943 593785 3793 469898 533269 557919 562544 581927 674387 671901 689048 568025 583743 591939 612987 622894 592654 610477 725656 735276 644524 701879 723302 787011 618360 752487 795195 4123 707149 476892 511652 532200 494313 566926 550268 565833 555685 560276 663721 712449 680302 562709 579721 617953 586607 597678 602635 598594 749621 501435 504219 525714 508650 763475 565676 705428 698780 397115 537765 712610 748846 762622 764095 778415 442429 526683 502934 578135 650649 660454 719772 605765 777757 779360 779659 769296 783461 733786 736198 726897 730361 752083 729115 740961 751842 771316 727874 732500 740815 742648 742754 777009 778847 447779 450285 467603 451225 525788 494893 91433 397652 814696 471086 484234 460933 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.59%) |
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 3793 4123 91433 392225 397115 397652 442429 447779 450285 451225 452320 460933 467603 469898 471086 476892 484234 494313 494893 500182 501435 502934 504219 508650 511652 525714 525788 526683 532200 533269 537765 539145 550268 555685 557919 560276 562544 562709 565676 565833 566926 568025 578135 579721 581927 583743 586607 591939 592654 593701 593785 597678 598594 600537 602635 603564 605765 610477 612987 617953 618360 622894 639083 639124 644524 650649 660454 663721 671901 674387 680302 689048 692345 698780 701879 705428 707149 712449 712610 718332 719772 723302 725656 726897 727874 729115 730361 732500 733786 735276 736198 740815 740961 742648 742754 748846 749621 751842 752046 752083 752487 757943 762622 763475 764095 769296 771316 777009 777757 778415 778847 779360 779659 787011 795195 796055 799830 809755 814696 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade doggy"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск рак"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.89%) |
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.