Query Metrics
7
Database Queries
7
Different statements
183.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.23 ms (85.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 154187 154516 154573 154692 154694 154844 340613 352189 382813 386226 393047 393314 398089 398940 402632 403439 411211 413641 413789 414099 414122 416695 421369 429601 445969 446799 455915 469567 476184 479818 482293 487275 487425 497471 506105 526902 529738 530368 530698 530943 531869 531877 531888 532634 532837 532838 534764 536621 536628 541442 544848 547484 550314 550892 554978 561887 562797 574391 576484 576637 580069 580130 582076 584425 590234 607638 607965 609804 617577 624405 625779 627194 627224 629281 634114 638477 644273 655242 660375 660417 664149 669067 669080 670366 671044 672901 673719 687398 695757 700975 706024 713196 713506 713508 722328 738280 742066 742360 742702 745248 752651 758248 758322 770049 770219 770263 770264 774667 780653 782791 787510 792693 796872 799789 805261 808964 809600 811477 827290 ] |
||||||||||||||||||||||||||||||
|
16.03 ms (8.74%) |
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 742066 722328 154187 526902 530368 487275 561887 673719 638477 758248 340613 629281 670366 770263 770264 529738 627224 758322 413641 455915 534764 530943 541442 660375 411211 482293 469567 479818 792693 154573 554978 576484 582076 550892 687398 695757 607965 609804 590234 774667 805261 770049 742702 809600 530698 580069 154844 393314 398089 414099 429601 827290 531877 531888 532634 531869 487425 544848 547484 584425 562797 576637 574391 660417 655242 713508 580130 607638 634114 780653 787510 811477 742360 752651 154694 536628 386226 416695 550314 700975 402632 413789 393047 713506 799789 624405 398940 671044 664149 669067 669080 154516 445969 497471 713196 672901 617577 627194 738280 808964 770219 625779 706024 782791 796872 382813 154692 745248 403439 446799 532838 536621 532837 644273 414122 476184 630427 421369 506105 352189 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.48%) |
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 154187 154516 154573 154692 154694 154844 340613 352189 382813 386226 393047 393314 398089 398940 402632 403439 411211 413641 413789 414099 414122 416695 421369 429601 445969 446799 455915 469567 476184 479818 482293 487275 487425 497471 506105 526902 529738 530368 530698 530943 531869 531877 531888 532634 532837 532838 534764 536621 536628 541442 544848 547484 550314 550892 554978 561887 562797 574391 576484 576637 580069 580130 582076 584425 590234 607638 607965 609804 617577 624405 625779 627194 627224 629281 634114 638477 644273 655242 660375 660417 664149 669067 669080 670366 671044 672901 673719 687398 695757 700975 706024 713196 713506 713508 722328 738280 742066 742360 742702 745248 752651 758248 758322 770049 770219 770263 770264 774667 780653 782791 787510 792693 796872 799789 805261 808964 809600 811477 827290 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge gape"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.78%) |
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.