Query Metrics
7
Database Queries
7
Different statements
224.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.25 ms (88.86%) |
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 394355 410128 417303 417337 417372 418918 421400 447795 447804 448096 448717 448949 449418 450830 459086 459131 459137 459150 459948 469345 471457 471458 475011 480245 482301 492831 501326 503087 506019 507204 509328 509331 509336 510217 516411 516479 519021 519534 519562 519595 520534 521465 521473 523374 532140 539753 549172 549660 551491 552823 556990 558078 558473 559688 559695 559699 559700 559701 559702 559704 559706 560853 560879 561580 564152 569428 570876 570957 570975 573743 580061 580715 581584 582797 587397 588024 591732 592345 595451 596946 598736 599152 599267 599559 600808 601243 601868 601935 608319 609141 611283 611383 613007 618333 623457 625642 630359 636084 639619 645096 670755 672040 672110 672147 690366 702128 707673 710389 712449 715401 745591 746827 747107 766504 792012 796091 796935 800906 801251 814499 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (6.01%) |
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 601935 448717 448949 417372 492831 712449 569428 447795 670755 596946 559695 588024 417337 450830 601868 516411 459137 581584 630359 599152 570876 421400 519595 570957 469345 509328 582797 394355 623457 611283 516479 672040 611383 600808 792012 796935 418918 814499 702128 715401 608319 766504 459150 552823 573743 747107 449418 506019 558078 672147 609141 745591 471458 800906 561580 591732 507204 559706 690366 707673 639619 636084 801251 710389 459948 559701 559702 559699 570975 459131 501326 519534 520534 564152 459086 448096 592345 471457 523374 509331 551491 559700 672110 601243 539753 410128 559688 549172 598736 599267 595451 746827 625642 796091 503087 521473 519021 560879 480245 482301 509336 560853 417303 521465 519562 559704 580061 618333 599559 475011 532140 587397 447804 549660 613007 510217 556990 558473 645096 580715 ] |
||||||||||||||||||||||||||||||
|
4.78 ms (2.13%) |
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 394355 410128 417303 417337 417372 418918 421400 447795 447804 448096 448717 448949 449418 450830 459086 459131 459137 459150 459948 469345 471457 471458 475011 480245 482301 492831 501326 503087 506019 507204 509328 509331 509336 510217 516411 516479 519021 519534 519562 519595 520534 521465 521473 523374 532140 539753 549172 549660 551491 552823 556990 558078 558473 559688 559695 559699 559700 559701 559702 559704 559706 560853 560879 561580 564152 569428 570876 570957 570975 573743 580061 580715 581584 582797 587397 588024 591732 592345 595451 596946 598736 599152 599267 599559 600808 601243 601868 601935 608319 609141 611283 611383 613007 618333 623457 625642 630359 636084 639619 645096 670755 672040 672110 672147 690366 702128 707673 710389 712449 715401 745591 746827 747107 766504 792012 796091 796935 800906 801251 814499 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"застрял в"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"застря в"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.63%) |
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.