Query Metrics
7
Database Queries
7
Different statements
152.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.44 ms (82.93%) |
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 395452 427012 428609 433749 433761 441077 446049 450166 455745 456529 461194 464512 469644 478529 482064 482566 482833 487636 505764 517908 518317 521380 521699 535037 544426 544531 547657 549691 550517 558539 562558 563551 565672 565784 567485 569320 571708 573533 575017 575854 576441 584045 587296 588372 594246 594442 594555 597634 599072 603085 605369 606503 607161 607481 612858 614805 618768 623692 625922 638000 643614 648683 648776 662836 686917 689804 692658 709747 710308 712765 712803 714484 718049 725696 727087 727673 732016 732169 732911 734140 737995 740512 742358 744061 747597 747819 748337 748464 749398 749520 751260 751968 754137 756601 757885 759554 760058 760608 760626 761705 767106 768812 776703 777750 779769 780715 784746 785849 787826 790865 793070 793534 797036 797954 798015 799081 804448 805066 805970 813177 ] |
||||||||||||||||||||||||||||||
|
15.52 ms (10.18%) |
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 804448 395452 455745 482064 433749 482833 450166 544531 563551 712765 567485 597634 607161 725696 744061 751260 784746 464512 478529 612858 805066 732016 790865 623692 594555 427012 433761 518317 648683 441077 428609 482566 461194 469644 487636 446049 456529 517908 505764 521380 521699 535037 544426 550517 565672 565784 571708 576441 549691 575017 562558 569320 575854 689804 692658 712803 648776 710308 662836 686917 714484 547657 558539 573533 584045 588372 594442 606503 599072 607481 605369 643614 587296 594246 603085 614805 625922 777750 779769 787826 797036 798015 799081 813177 727087 727673 732169 734140 754137 759554 761705 793534 797954 805970 740512 747819 748337 749520 751968 760058 767106 742358 747597 756601 757885 768812 732911 737995 748464 749398 760608 760626 618768 638000 709747 718049 776703 780715 785849 793070 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.99%) |
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 395452 427012 428609 433749 433761 441077 446049 450166 455745 456529 461194 464512 469644 478529 482064 482566 482833 487636 505764 517908 518317 521380 521699 535037 544426 544531 547657 549691 550517 558539 562558 563551 565672 565784 567485 569320 571708 573533 575017 575854 576441 584045 587296 588372 594246 594442 594555 597634 599072 603085 605369 606503 607161 607481 612858 614805 618768 623692 625922 638000 643614 648683 648776 662836 686917 689804 692658 709747 710308 712765 712803 714484 718049 725696 727087 727673 732016 732169 732911 734140 737995 740512 742358 744061 747597 747819 748337 748464 749398 749520 751260 751968 754137 756601 757885 759554 760058 760608 760626 761705 767106 768812 776703 777750 779769 780715 784746 785849 787826 790865 793070 793534 797036 797954 798015 799081 804448 805066 805970 813177 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"так хочет жена"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хочет жен"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.14%) |
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.