Query Metrics
7
Database Queries
7
Different statements
143.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.82 ms (83.52%) |
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 387670 389579 391451 394161 394490 397102 397427 397760 402084 402195 402398 404443 413584 420083 421369 424387 426675 428107 433164 436316 439323 439769 441383 441401 447146 447434 447435 447438 447486 447499 447514 447807 464181 475237 476962 492822 496090 505130 513313 519841 528999 531631 532286 535706 536505 538239 538604 538709 538740 541920 542990 556573 566973 567729 568127 570046 575999 580853 594213 597818 605323 609898 609926 617490 623200 631620 633533 634155 634499 637122 637425 641677 642044 642687 645887 650232 655021 657431 662131 665900 666865 666968 668532 671446 676328 677450 678339 678985 680127 684320 687000 687512 688019 691362 692214 692502 693174 693859 694432 699038 701152 703248 713285 713880 715379 718714 720915 796916 805302 811275 818183 818787 821917 827279 828128 828431 828433 828443 828764 ] |
||||||||||||||||||||||||||||||
|
13.91 ms (9.69%) |
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 680127 666968 570046 605323 623200 634155 637122 597818 633533 637425 594213 634499 609898 609926 436316 441383 441401 447807 475237 404443 413584 420083 426675 464181 476962 397427 421369 424387 433164 447438 447514 439769 447146 447434 447435 447486 447499 492822 505130 496090 513313 519841 666865 642044 642687 532286 536505 567729 556573 568127 676328 713880 631620 641677 617490 811275 805302 394490 391451 580853 796916 718714 402195 439323 394161 389579 387670 397102 397760 402084 402398 428107 827279 818183 818787 821917 828764 828128 828433 828652 828431 828443 538709 538740 531631 535706 538239 538604 528999 566973 542990 541920 575999 650232 657431 662131 665900 668532 684320 688019 691362 692502 693174 693859 701152 713285 720915 655021 677450 678339 678985 687000 703248 715379 645887 671446 687512 692214 694432 699038 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (2.10%) |
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 387670 389579 391451 394161 394490 397102 397427 397760 402084 402195 402398 404443 413584 420083 421369 424387 426675 428107 433164 436316 439323 439769 441383 441401 447146 447434 447435 447438 447486 447499 447514 447807 464181 475237 476962 492822 496090 505130 513313 519841 528999 531631 532286 535706 536505 538239 538604 538709 538740 541920 542990 556573 566973 567729 568127 570046 575999 580853 594213 597818 605323 609898 609926 617490 623200 631620 633533 634155 634499 637122 637425 641677 642044 642687 645887 650232 655021 657431 662131 665900 666865 666968 668532 671446 676328 677450 678339 678985 680127 684320 687000 687512 688019 691362 692214 692502 693174 693859 694432 699038 701152 703248 713285 713880 715379 718714 720915 796916 805302 811275 818183 818787 821917 827279 828128 828431 828433 828443 828764 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural teen"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные teen"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные teen"
]
|
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.