Query Metrics
7
Database Queries
7
Different statements
572.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
415.43 ms (72.56%) |
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 130289 142493 191356 385970 409783 420427 426403 443066 443748 456137 468071 477230 483547 486799 496100 496101 501248 510396 513949 516612 517794 521418 530479 531182 532645 532667 532751 532816 533014 533373 534647 536291 536582 536633 537863 537932 541379 541661 541863 541886 543652 543771 544800 556046 558431 559111 569922 577368 583981 597739 599160 599863 599867 599913 599955 599961 599976 600019 600022 600029 600218 600296 601613 603255 603258 604517 606577 612412 617422 617424 623261 630678 632571 632595 632641 632663 632671 632693 633123 633491 634472 634774 634784 635215 636033 636320 636991 637036 637092 638298 639818 641700 642063 643103 646176 646899 647859 647932 647960 648235 648820 651634 662137 666906 667748 668505 674983 676638 678117 678153 680130 681637 695122 704531 716870 720923 761073 803455 803459 820762 ] |
||||||||||||||||||||||||||||||
|
129.13 ms (22.55%) |
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 130289 142493 191356 385970 409783 420427 426403 443066 443748 456137 468071 477230 483547 486799 496100 496101 501248 510396 513949 516612 517794 521418 530479 531182 532645 532667 532751 532816 533014 533373 534647 536291 536582 536633 537863 537932 541379 541661 541863 541886 543652 543771 544800 556046 558431 559111 569922 577368 583981 597739 599160 599863 599867 599913 599955 599961 599976 600019 600022 600029 600218 600296 601613 603255 603258 604517 606577 612412 617422 617424 623261 630678 632571 632595 632641 632663 632671 632693 633123 633491 634472 634774 634784 635215 636033 636320 636991 637036 637092 638298 639818 641700 642063 643103 646176 646899 647859 647932 647960 648235 648820 651634 662137 666906 667748 668505 674983 676638 678117 678153 680130 681637 695122 704531 716870 720923 761073 803455 803459 820762 ] |
||||||||||||||||||||||||||||||
|
21.09 ms (3.68%) |
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 483547 533373 541863 559111 583981 648235 678117 651634 646899 647859 668505 569922 599867 600029 600296 634472 641700 599863 599913 599961 632671 632693 633491 633123 600019 600022 601613 617424 632571 632663 704531 530479 599955 468071 496100 558431 517794 496101 577368 662137 599976 642063 637092 632641 501248 477230 513949 603255 443066 541886 603258 541379 667748 536633 597739 803455 191356 676638 678153 634774 623261 420427 385970 532816 532645 543652 666906 674983 695122 638298 637036 634784 536291 720923 761073 820762 532667 532751 510396 531182 537863 536582 544800 681637 639818 606577 599160 636320 130289 426403 486799 680130 142493 541661 543771 556046 647932 632595 636033 600218 643103 604517 617422 635215 516612 409783 456137 534647 537932 716870 630678 612412 636991 803459 443748 521418 533014 647960 648820 646176 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милф группов секс"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"милфа групповуха"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.26%) |
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.