Query Metrics
7
Database Queries
7
Different statements
149.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.44 ms (82.73%) |
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 115206 383595 388198 394309 397679 416795 418714 421742 421968 425712 430796 436523 438410 439300 440671 443162 445779 446997 449891 452751 453987 454679 454901 454905 456606 456900 457146 457940 458331 458533 458872 459002 459016 462287 464400 464833 467066 468833 471672 473177 476592 476911 478537 480780 481788 487854 499484 500506 500594 501334 505591 506861 512121 512876 516874 520615 520800 520980 521546 522313 525615 526319 526517 526812 526815 526942 529207 529919 536940 541479 543879 546754 549513 553732 555191 556010 558643 559799 560748 566255 568064 568077 568445 568637 568654 569084 571261 571735 574913 576262 582072 582704 584611 584799 589469 589513 589568 591767 591916 591990 592619 600466 603997 608716 612080 623835 631676 641096 645300 647721 668463 709816 723369 724869 756694 761136 786005 801790 804259 ] |
||||||||||||||||||||||||||||||
|
17.00 ms (11.39%) |
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 555191 645300 647721 631676 756694 476911 568637 543879 589513 641096 506861 499484 589568 529919 591990 394309 397679 478537 505591 476592 568445 623835 589469 425712 526812 584799 553732 582704 560748 723369 804259 724869 568077 571261 761136 383595 458533 526815 584611 574913 591916 801790 462287 445779 521546 436523 416795 453987 454901 480780 536940 568654 582072 546754 709816 786005 458872 464400 452751 457146 471672 439300 501334 529207 549513 541345 443162 459002 500594 566255 568064 458331 576262 468833 516874 440671 456606 481788 457940 512876 473177 559799 541479 592619 418714 526319 115206 421742 430796 438410 421968 454905 487854 525615 526942 569084 668463 556010 558643 571735 591767 603997 612080 454679 456900 464833 446997 388198 520615 522313 520980 467066 608716 520800 449891 500506 600466 459016 526517 512121 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.49%) |
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 115206 383595 388198 394309 397679 416795 418714 421742 421968 425712 430796 436523 438410 439300 440671 443162 445779 446997 449891 452751 453987 454679 454901 454905 456606 456900 457146 457940 458331 458533 458872 459002 459016 462287 464400 464833 467066 468833 471672 473177 476592 476911 478537 480780 481788 487854 499484 500506 500594 501334 505591 506861 512121 512876 516874 520615 520800 520980 521546 522313 525615 526319 526517 526812 526815 526942 529207 529919 536940 541479 543879 546754 549513 553732 555191 556010 558643 559799 560748 566255 568064 568077 568445 568637 568654 569084 571261 571735 574913 576262 582072 582704 584611 584799 589469 589513 589568 591767 591916 591990 592619 600466 603997 608716 612080 623835 631676 641096 645300 647721 668463 709816 723369 724869 756694 761136 786005 801790 804259 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на йоге"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на йог"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.