Query Metrics
7
Database Queries
7
Different statements
242.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.09 ms (88.21%) |
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 401919 417212 418363 420427 421353 432751 451974 452061 457783 458555 462208 468071 471356 491021 496100 498551 500716 501248 502794 510396 511023 515715 516612 521723 524986 525864 526553 530912 531155 531182 531420 532645 532662 532667 532751 532812 532816 532975 533014 535460 536538 536582 536584 536633 537863 541379 541419 541661 541740 541752 541831 541833 541886 541888 543652 543771 543918 544800 556046 556778 576726 578397 583982 597739 599160 599833 600218 603258 604517 604902 606577 614308 617422 623261 632571 632585 632595 632641 632663 634774 634784 635215 636033 636320 637036 638298 639818 640751 643103 644986 645861 646176 646901 647932 647948 647960 648241 648820 650155 651674 662020 666527 666894 666906 667748 674982 674983 675010 675020 676016 676428 676638 678153 681637 685701 686843 695122 704531 803455 820762 ] |
||||||||||||||||||||||||||||||
|
18.50 ms (7.62%) |
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 632571 632641 632663 640751 704531 421353 418363 458555 417212 462208 471356 452061 457783 468071 502794 491021 496100 498551 535460 501248 515715 525864 820762 451974 532667 532751 533014 510396 531182 532816 536633 537863 530912 532645 536538 526553 536582 541831 541886 543652 541379 541661 578397 543771 544800 556046 647932 647960 648820 666906 681637 676638 646176 667748 674983 678153 695122 556778 597739 638298 639818 603258 606577 634774 599160 604902 614308 632595 636033 636320 637036 599833 600218 623261 643103 803455 604517 617422 632585 634784 635215 401919 420427 511023 524986 521723 500716 516612 432751 644986 532975 536584 531155 531420 532662 532812 541419 541752 543918 541833 541888 541740 646901 647948 651674 675010 675020 676428 685701 686843 648241 650155 666527 666894 676016 645861 662020 674982 576726 583982 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.21%) |
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 401919 417212 418363 420427 421353 432751 451974 452061 457783 458555 462208 468071 471356 491021 496100 498551 500716 501248 502794 510396 511023 515715 516612 521723 524986 525864 526553 530912 531155 531182 531420 532645 532662 532667 532751 532812 532816 532975 533014 535460 536538 536582 536584 536633 537863 541379 541419 541661 541740 541752 541831 541833 541886 541888 543652 543771 543918 544800 556046 556778 576726 578397 583982 597739 599160 599833 600218 603258 604517 604902 606577 614308 617422 623261 632571 632585 632595 632641 632663 634774 634784 635215 636033 636320 637036 638298 639818 640751 643103 644986 645861 646176 646901 647932 647948 647960 648241 648820 650155 651674 662020 666527 666894 666906 667748 674982 674983 675010 675020 676016 676428 676638 678153 681637 685701 686843 695122 704531 803455 820762 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group mom"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group mom"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group mom"
]
|
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.