Query Metrics
7
Database Queries
7
Different statements
243.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
224.21 ms (91.97%) |
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 31422 414749 543869 544781 545728 546798 547984 548459 563470 564794 569372 569709 571960 581296 583447 593524 596290 599849 609246 614576 623281 626174 626853 627200 629218 631403 636372 636783 642293 642410 648221 648741 651840 652841 652905 660763 664450 668158 668552 670463 670783 671769 672029 677001 681456 683269 683485 683897 690769 693340 693448 693878 695602 696141 698233 701202 707602 710463 710918 713414 713498 715179 716948 721082 726054 730498 732611 734269 736819 737547 737895 739588 744015 744796 746826 749074 751030 753689 753969 754710 754733 754805 758630 759809 762068 766329 767242 767908 768191 768915 770931 775287 776814 777085 777339 777997 778439 780414 781954 783537 784181 784829 784868 785759 791349 792019 793067 793093 795405 798281 799078 800391 803777 805246 805394 805817 806678 810958 811579 811784 ] |
||||||||||||||||||||||||||||||
|
10.81 ms (4.44%) |
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 569372 569709 543869 547984 548459 571960 581296 583447 672029 681456 690769 693448 693878 710463 713498 648221 651840 668158 668552 670463 670783 677001 695602 696141 710918 715179 721082 648741 652841 660763 664450 671769 683269 683485 683897 698233 707602 544781 631403 623281 626174 636372 593524 596290 599849 614576 636783 642410 609246 629218 780414 791349 800391 805246 806678 811579 775287 776814 778439 784868 792019 795405 803777 805394 810958 734269 737895 744015 749074 753689 754733 767242 781954 793093 805817 732611 736819 737547 744796 754805 762068 739588 758630 766329 767908 770931 726054 730498 751030 754710 759809 746826 753969 768191 768915 627200 642293 701202 713414 777085 777339 777997 784829 785759 793067 798281 799078 811784 414749 31422 545728 546798 563470 564794 652905 693340 716948 626853 783537 784181 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.08%) |
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 31422 414749 543869 544781 545728 546798 547984 548459 563470 564794 569372 569709 571960 581296 583447 593524 596290 599849 609246 614576 623281 626174 626853 627200 629218 631403 636372 636783 642293 642410 648221 648741 651840 652841 652905 660763 664450 668158 668552 670463 670783 671769 672029 677001 681456 683269 683485 683897 690769 693340 693448 693878 695602 696141 698233 701202 707602 710463 710918 713414 713498 715179 716948 721082 726054 730498 732611 734269 736819 737547 737895 739588 744015 744796 746826 749074 751030 753689 753969 754710 754733 754805 758630 759809 762068 766329 767242 767908 768191 768915 770931 775287 776814 777085 777339 777997 778439 780414 781954 783537 784181 784829 784868 785759 791349 792019 793067 793093 795405 798281 799078 800391 803777 805246 805394 805817 806678 810958 811579 811784 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные секс toys"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long sex toys"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.30 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"длинные секс toys"
]
|
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.