Query Metrics
7
Database Queries
7
Different statements
277.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
247.04 ms (89.00%) |
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 385826 388077 397393 401641 406941 419273 426264 438053 449514 452744 457571 459323 479707 494890 499832 500519 506487 507798 509578 528600 529136 536268 539213 549516 553636 553679 558865 567672 580180 588708 592700 595107 598295 604001 605283 610484 616843 630666 632405 633225 636261 637507 639116 641328 651310 651323 651441 653047 655602 657143 660004 660692 663298 670623 697327 697690 706215 706432 709700 709741 712086 716534 717123 717922 718287 719310 720443 723656 724583 725413 725432 728040 730280 735637 735654 737121 739646 741199 745323 747942 747951 747952 749047 756779 757294 758572 759812 760160 761314 761461 763869 765755 766519 767358 768889 772345 776270 778383 779779 779973 780873 781102 786271 788662 792440 793311 793741 794585 798619 803556 805626 808514 810720 812296 813196 816654 818623 818678 ] |
||||||||||||||||||||||||||||||
|
19.29 ms (6.95%) |
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 401641 723656 816654 818623 818678 499832 553679 553636 558865 712086 651323 651441 660692 706432 655602 709700 588708 595107 610484 636261 605283 639116 607076 780873 786271 794585 810720 737121 758572 772345 805626 724583 730280 735654 739646 759812 760160 747942 741199 756779 757294 761314 767358 770445 630666 717123 717922 776270 798619 388077 438053 457571 528600 494890 507798 580180 385826 426264 452744 459323 536268 509578 506487 567672 657143 663298 670623 697690 709741 718287 706215 719310 660004 592700 633225 598295 637507 604001 641328 778383 779779 779973 792440 793741 793311 808514 812296 725413 735637 749047 788662 813196 747952 766519 725432 728040 745323 747951 763869 765755 761461 768889 632405 781102 803556 397393 406941 419273 449514 479707 539213 500519 529136 549516 653047 697327 720443 651310 716534 616843 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot huge"
]
|
||||||||||||||||||||||||||||||
|
2.78 ms (1.00%) |
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 385826 388077 397393 401641 406941 419273 426264 438053 449514 452744 457571 459323 479707 494890 499832 500519 506487 507798 509578 528600 529136 536268 539213 549516 553636 553679 558865 567672 580180 588708 592700 595107 598295 604001 605283 610484 616843 630666 632405 633225 636261 637507 639116 641328 651310 651323 651441 653047 655602 657143 660004 660692 663298 670623 697327 697690 706215 706432 709700 709741 712086 716534 717123 717922 718287 719310 720443 723656 724583 725413 725432 728040 730280 735637 735654 737121 739646 741199 745323 747942 747951 747952 749047 756779 757294 758572 759812 760160 761314 761461 763869 765755 766519 767358 768889 772345 776270 778383 779779 779973 780873 781102 786271 788662 792440 793311 793741 794585 798619 803556 805626 808514 810720 812296 813196 816654 818623 818678 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot огромные"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot огромные"
]
|
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.