Query Metrics
7
Database Queries
7
Different statements
194.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.23 ms (86.47%) |
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 357499 391944 391959 398095 398113 416527 416531 417334 423837 429902 434350 435512 436639 437708 437874 439112 439281 446798 446949 448604 452810 453170 455918 459203 460015 464951 468269 469636 472835 476046 480450 480656 481418 499388 510945 511866 522148 527503 529583 531588 531839 531850 539741 544140 545453 547236 547471 547809 547858 554215 558736 564501 566586 568485 571166 576503 576517 592330 592396 597534 605033 605208 607296 609887 618808 628115 641946 643080 650727 655458 657556 662049 670356 670357 670360 672944 695096 695875 703586 735140 739132 740809 742318 748291 749084 749672 750359 751571 752598 752603 752639 752656 752687 752712 757435 757492 758780 761621 765684 769293 776997 778721 782351 782449 782836 783709 784743 785580 785868 787508 792078 795655 796682 800473 802925 803108 803494 806788 812322 824868 ] |
||||||||||||||||||||||||||||||
|
17.27 ms (8.88%) |
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 739132 749672 752639 752656 757435 605033 776997 782449 783709 796682 802925 803108 803494 806788 812322 499388 795655 398113 398095 416527 416531 423837 446798 510945 545453 566586 695096 439281 437708 460015 740809 748291 769293 824868 476046 511866 529583 522148 531588 531839 531850 544140 547858 554215 547236 576517 650727 662049 670357 703586 695875 564501 605208 592396 607296 618808 628115 609887 592330 782836 782351 752603 752687 784743 800473 752712 761621 735140 749084 751571 757492 765684 641946 778721 453170 469636 539741 464951 576503 568485 655458 672944 657556 670356 670360 547471 571166 643080 785580 792078 758780 785868 742318 750359 752598 787508 391959 357499 459203 448604 527503 391944 437874 435512 434350 480656 468269 455918 547809 558736 597534 429902 439112 446949 452810 480450 417334 436639 472835 481418 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.26%) |
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 357499 391944 391959 398095 398113 416527 416531 417334 423837 429902 434350 435512 436639 437708 437874 439112 439281 446798 446949 448604 452810 453170 455918 459203 460015 464951 468269 469636 472835 476046 480450 480656 481418 499388 510945 511866 522148 527503 529583 531588 531839 531850 539741 544140 545453 547236 547471 547809 547858 554215 558736 564501 566586 568485 571166 576503 576517 592330 592396 597534 605033 605208 607296 609887 618808 628115 641946 643080 650727 655458 657556 662049 670356 670357 670360 672944 695096 695875 703586 735140 739132 740809 742318 748291 749084 749672 750359 751571 752598 752603 752639 752656 752687 752712 757435 757492 758780 761621 765684 769293 776997 778721 782351 782449 782836 783709 784743 785580 785868 787508 792078 795655 796682 800473 802925 803108 803494 806788 812322 824868 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation solo anal"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац соло анал"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.