Query Metrics
7
Database Queries
7
Different statements
195.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.19 ms (88.44%) |
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 205910 382803 393727 393770 393781 397138 400689 419559 425061 425656 426606 429529 434562 435657 437258 439382 443370 443957 443979 444098 444759 445221 446923 447108 451420 451705 453790 454860 454863 454868 456934 458478 459613 459767 461611 463232 466734 467173 467673 470809 471460 472759 475385 482807 484216 485028 486632 486846 493188 509329 510530 510688 510694 511229 511696 515389 516603 517552 519967 523914 527997 532045 533403 538143 541011 548195 565721 572931 579418 580155 581092 586456 587967 588529 595613 596828 599729 613551 618670 619127 622521 627556 629189 644083 662220 677524 679638 682328 684012 689561 719353 740671 743009 746618 748129 749582 751409 756088 759567 759578 763062 765683 767957 768687 772684 776586 777007 777762 780925 784716 784806 785195 799722 799949 806866 812758 814122 820106 823707 827776 ] |
||||||||||||||||||||||||||||||
|
13.22 ms (6.75%) |
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 777007 785195 799722 746618 763062 768687 751409 429529 467673 463232 382803 820106 466734 486632 684012 677524 682328 588529 595613 587967 622521 806866 765683 780925 205910 454863 510530 397138 425061 814122 827776 470809 565721 580155 618670 599729 759567 784716 759578 749582 784806 458478 509329 486846 393727 425656 443370 451705 493188 453790 532045 538143 519967 548195 662220 596828 772684 748129 756088 767957 743009 719353 456934 459613 447108 511696 485028 484216 444759 419559 823707 446923 471460 511229 533403 517552 461611 475385 541011 581092 679638 689561 572931 613551 619127 586456 777762 776586 740671 627556 629189 812758 454868 435657 437258 454860 510688 527997 445221 459767 482807 510694 523914 644083 799949 451420 400689 443957 467173 439382 443979 472759 426606 515389 393781 516603 579418 434562 393770 444098 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.26%) |
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 205910 382803 393727 393770 393781 397138 400689 419559 425061 425656 426606 429529 434562 435657 437258 439382 443370 443957 443979 444098 444759 445221 446923 447108 451420 451705 453790 454860 454863 454868 456934 458478 459613 459767 461611 463232 466734 467173 467673 470809 471460 472759 475385 482807 484216 485028 486632 486846 493188 509329 510530 510688 510694 511229 511696 515389 516603 517552 519967 523914 527997 532045 533403 538143 541011 548195 565721 572931 579418 580155 581092 586456 587967 588529 595613 596828 599729 613551 618670 619127 622521 627556 629189 644083 662220 677524 679638 682328 684012 689561 719353 740671 743009 746618 748129 749582 751409 756088 759567 759578 763062 765683 767957 768687 772684 776586 777007 777762 780925 784716 784806 785195 799722 799949 806866 812758 814122 820106 823707 827776 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"daddy and girls"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"daddy девушк"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"daddy девушк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.