Query Metrics
7
Database Queries
7
Different statements
196.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.46 ms (87.58%) |
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 191179 397508 408644 417940 418594 439514 443242 455360 467882 469615 475404 475943 477097 481602 486831 488551 488897 496484 497675 498391 507661 512934 514837 521256 522112 528055 530484 531106 531118 531124 531136 532743 534019 534032 534993 534999 535005 537654 555106 556876 569213 570740 580160 580174 581938 583085 586294 590367 594338 599981 600218 600274 600356 604080 606143 614597 620211 621482 625189 627362 628396 630524 633451 637021 641975 642006 642037 642066 643098 645276 648846 675002 678127 692718 694953 695815 696582 698879 716596 722677 725624 727739 727959 733594 735446 736643 736850 739178 741935 748609 764654 765357 770405 771171 778531 779781 779859 782301 783271 783812 783831 785500 786791 787414 790317 792408 794090 796155 796218 797461 798307 800565 802057 803466 806688 808155 808426 810388 825764 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (7.42%) |
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 534019 534032 514837 534999 556876 580160 580174 808155 806688 770405 727959 417940 455360 469615 475943 488897 522112 783271 600218 537654 531124 531106 678127 637021 642066 716596 722677 570740 625189 620211 786791 725624 741935 736850 739178 802057 735446 191179 397508 408644 418594 443242 498391 534993 535005 507661 521256 530484 555106 583085 648846 675002 621482 604080 785500 807580 467882 481602 439514 475404 486831 488551 497675 512934 528055 477097 642006 642037 532743 496484 694953 692718 581938 586294 599981 600274 600356 590367 594338 606143 794090 796155 798307 800565 782301 803466 810388 797461 748609 765357 771171 764654 778531 779859 531118 531136 696582 645276 630524 628396 633451 643098 641975 627362 733594 727739 614597 825764 569213 695815 698879 779781 796218 783831 787414 790317 783812 792408 808426 736643 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.23%) |
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 191179 397508 408644 417940 418594 439514 443242 455360 467882 469615 475404 475943 477097 481602 486831 488551 488897 496484 497675 498391 507661 512934 514837 521256 522112 528055 530484 531106 531118 531124 531136 532743 534019 534032 534993 534999 535005 537654 555106 556876 569213 570740 580160 580174 581938 583085 586294 590367 594338 599981 600218 600274 600356 604080 606143 614597 620211 621482 625189 627362 628396 630524 633451 637021 641975 642006 642037 642066 643098 645276 648846 675002 678127 692718 694953 695815 696582 698879 716596 722677 725624 727739 727959 733594 735446 736643 736850 739178 741935 748609 764654 765357 770405 771171 778531 779781 779859 782301 783271 783812 783831 785500 786791 787414 790317 792408 794090 796155 796218 797461 798307 800565 802057 803466 806688 808155 808426 810388 825764 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum extreme"
]
|
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.