Query Metrics
7
Database Queries
7
Different statements
137.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.81 ms (84.94%) |
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 541911 543329 546167 546547 546988 547691 550815 551074 553644 559970 561072 561763 566827 569733 569746 571091 571123 575576 579266 583695 588711 590569 597153 598651 601432 601565 605052 609691 610164 610198 614460 620369 620920 626028 628101 628706 633482 634307 639113 651673 654080 660036 665951 666142 669546 669898 670399 670401 670802 671072 671842 672279 672743 673008 678419 679543 679582 683669 690289 692664 692697 693086 695001 701405 705414 707714 713577 715142 721956 722059 722406 729932 731817 733899 739377 744211 746194 747124 752195 752548 754370 754579 755566 758981 761515 769908 772923 779861 783127 784262 784458 784721 786077 786278 787259 788738 788758 789074 790146 792369 792759 794300 794321 796077 796405 798727 800444 801826 803381 803393 804133 804684 805325 807178 808611 810742 810768 811094 811580 ] |
||||||||||||||||||||||||||||||
|
10.98 ms (7.99%) |
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 566827 569746 571091 579266 583695 543329 551074 541911 547691 550815 561072 561763 571123 654080 669546 669898 672743 678419 679543 679582 707714 713577 715142 722059 660036 670399 670401 670802 671072 672279 683669 690289 692697 693086 695001 721956 651673 665951 666142 671842 673008 692664 701405 705414 722406 546167 546547 546988 553644 559970 569733 575576 598651 610164 610198 639113 620920 628706 634307 588711 590569 601565 633482 597153 601432 605052 609691 614460 620369 626028 628101 780402 786278 794300 796405 801826 803393 804133 805325 808611 810742 810768 811580 779861 784262 784458 786077 788758 790146 796077 800444 803381 804684 807178 811094 729932 731817 733899 739377 744211 746194 747124 752195 752548 754370 754579 755566 758981 761515 769908 772923 783127 784721 787259 788738 789074 792369 792759 794321 798727 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.98%) |
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 541911 543329 546167 546547 546988 547691 550815 551074 553644 559970 561072 561763 566827 569733 569746 571091 571123 575576 579266 583695 588711 590569 597153 598651 601432 601565 605052 609691 610164 610198 614460 620369 620920 626028 628101 628706 633482 634307 639113 651673 654080 660036 665951 666142 669546 669898 670399 670401 670802 671072 671842 672279 672743 673008 678419 679543 679582 683669 690289 692664 692697 693086 695001 701405 705414 707714 713577 715142 721956 722059 722406 729932 731817 733899 739377 744211 746194 747124 752195 752548 754370 754579 755566 758981 761515 769908 772923 779861 783127 784262 784458 784721 786077 786278 787259 788738 788758 789074 790146 792369 792759 794300 794321 796077 796405 798727 800444 801826 803381 803393 804133 804684 805325 807178 808611 810742 810768 811094 811580 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex toys"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс toys"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.12%) |
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.