Query Metrics
7
Database Queries
7
Different statements
168.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.03 ms (80.33%) |
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 95915 96347 96872 118234 154257 183506 187786 196624 388470 389623 390653 391916 391994 395707 397302 398426 415548 417386 421604 424294 430432 439071 441733 441925 448887 458819 465177 470126 474891 479668 491114 494295 495321 510264 513992 526061 526653 526938 545434 548465 580069 591805 598115 601542 604427 605172 606503 613021 613825 614026 615946 618267 619108 619996 624197 626575 626803 628113 628485 630096 632663 639810 660369 664166 668690 670360 671008 672913 672952 683284 695249 695871 695887 699397 712553 713508 716522 717859 722388 724309 725400 740844 742304 742318 742320 749090 750668 751609 752598 752641 752651 752666 752679 752697 757350 758785 758786 759370 761608 761719 762774 782789 784308 791930 794669 795404 795420 796333 796675 796703 796859 796905 799362 801414 803243 806864 806943 807597 809811 818387 ] |
||||||||||||||||||||||||||||||
|
22.96 ms (13.66%) |
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 660369 670360 671008 672952 716522 717859 664166 668690 695249 695871 695887 713508 545434 548465 580069 605172 606503 598115 601542 613021 619996 624197 591805 615946 628113 628485 614026 619108 795404 796703 782789 794669 795420 796333 807597 742320 749090 752641 752697 784308 806943 809811 752679 758785 752666 758786 724309 725400 742304 742318 751609 757350 761608 750668 752598 752651 759370 604427 613825 722388 791930 796675 796905 799362 95915 391994 397302 417386 196624 474891 154257 183506 395707 96872 118234 391916 441925 458819 465177 470126 526938 495321 510264 526653 494295 526061 683284 801414 740844 672913 630096 415548 712553 626575 626803 803243 762774 761719 421604 390653 398426 699397 639810 632663 448887 513992 479668 187786 389623 491114 796859 806864 618267 96347 388470 439071 424294 430432 441733 818387 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.62%) |
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 95915 96347 96872 118234 154257 183506 187786 196624 388470 389623 390653 391916 391994 395707 397302 398426 415548 417386 421604 424294 430432 439071 441733 441925 448887 458819 465177 470126 474891 479668 491114 494295 495321 510264 513992 526061 526653 526938 545434 548465 580069 591805 598115 601542 604427 605172 606503 613021 613825 614026 615946 618267 619108 619996 624197 626575 626803 628113 628485 630096 632663 639810 660369 664166 668690 670360 671008 672913 672952 683284 695249 695871 695887 699397 712553 713508 716522 717859 722388 724309 725400 740844 742304 742318 742320 749090 750668 751609 752598 752641 752651 752666 752679 752697 757350 758785 758786 759370 761608 761719 762774 782789 784308 791930 794669 795404 795420 796333 796675 796703 796859 796905 799362 801414 803243 806864 806943 807597 809811 818387 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жесткое с мамкам"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.95%) |
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.