Query Metrics
7
Database Queries
7
Different statements
149.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.98 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 86568 386198 397663 397687 400540 422010 455639 460827 464269 477578 479070 482059 483758 493328 496140 501155 504242 512390 512398 514197 520855 529629 530461 531332 531575 531648 531665 531674 531726 531972 532175 532181 532388 532402 532633 533078 533162 533180 533208 533225 533317 533666 535194 535653 535806 535844 536079 536113 536144 536856 537166 537189 537641 538040 538476 538493 538789 538799 539180 539384 540417 540935 541137 541917 541932 542245 542246 542571 542618 542647 543271 546251 548832 551693 553868 555147 557719 575900 579057 588562 592280 594052 600659 604037 604487 628489 631003 631009 633430 633918 634190 634616 636894 640671 642125 644086 645481 665897 707415 719742 723024 726258 727288 732164 733256 733361 735311 736981 737326 738400 739882 752854 757639 761686 761718 769710 772037 782050 783386 823174 ] |
||||||||||||||||||||||||||||||
|
12.14 ms (8.12%) |
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 529629 530461 531575 531972 532175 533078 533666 535844 537189 537641 538476 538493 501155 531648 531726 532181 532633 533208 533225 535806 536113 536144 539384 540417 496140 504242 512398 520855 531665 531674 532388 532402 533162 533180 533317 535194 535653 536079 536856 538040 538789 538799 539180 460827 464269 479070 483758 493328 542245 542618 542647 540935 541917 541932 543271 557719 575900 542571 546251 548832 551693 555147 645481 719742 665897 553868 579057 588562 628489 634190 636894 600659 642125 644086 594052 631003 592280 604037 631009 633430 633918 634616 640671 782050 737326 761686 772037 783386 735311 726258 727288 733361 752854 769710 732164 738400 757639 739882 761718 604487 723024 397687 397663 400540 422010 823174 477578 512390 514197 531332 537166 541137 542246 733256 736981 707415 386198 86568 455639 482059 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (2.07%) |
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 86568 386198 397663 397687 400540 422010 455639 460827 464269 477578 479070 482059 483758 493328 496140 501155 504242 512390 512398 514197 520855 529629 530461 531332 531575 531648 531665 531674 531726 531972 532175 532181 532388 532402 532633 533078 533162 533180 533208 533225 533317 533666 535194 535653 535806 535844 536079 536113 536144 536856 537166 537189 537641 538040 538476 538493 538789 538799 539180 539384 540417 540935 541137 541917 541932 542245 542246 542571 542618 542647 543271 546251 548832 551693 553868 555147 557719 575900 579057 588562 592280 594052 600659 604037 604487 628489 631003 631009 633430 633918 634190 634616 636894 640671 642125 644086 645481 665897 707415 719742 723024 726258 727288 732164 733256 733361 735311 736981 737326 738400 739882 752854 757639 761686 761718 769710 772037 782050 783386 823174 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife white"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен white"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен white"
]
|
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.