Query Metrics
7
Database Queries
7
Different statements
197.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.60 ms (87.29%) |
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 95788 96819 100449 103696 193662 251147 337190 382697 386194 388821 393673 396709 476838 479067 516646 530289 532717 533034 533646 533689 534133 537005 537104 538141 538814 538883 539018 540122 547980 549312 554876 559212 562588 562591 566394 606535 622116 623525 633965 638654 639075 643927 646240 648996 649947 650815 650852 651313 651423 653603 653624 653628 653634 654481 654574 655994 656677 659589 663902 663977 665114 666798 666841 679079 691497 692336 694555 697447 699531 699779 702877 703070 710212 712887 715534 716202 716829 732597 733020 733179 741207 743414 745208 748384 748436 749269 749639 752076 758298 758599 759910 761506 766568 770840 771723 773947 775899 775904 776528 784331 787575 789708 789961 800007 801093 805304 809941 814946 815667 817341 817618 818932 819311 821857 823976 824228 825690 827873 827896 828865 ] |
||||||||||||||||||||||||||||||
|
15.35 ms (7.76%) |
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 784331 743414 758599 800007 805304 752076 745208 773947 748436 643927 702877 715534 809941 382697 386194 100449 251147 393673 95788 396709 817341 819311 814946 818932 533689 538814 539018 559212 562588 646240 649947 650815 653634 654574 679079 650852 651313 653628 663977 691497 694555 699531 699779 653603 656677 666841 692336 697447 710212 712887 716202 716829 639075 606535 622116 633965 638654 775904 789708 801093 775899 749639 758298 759910 766568 787575 732597 749269 733020 733179 761506 770840 741207 748384 771723 623525 703070 776528 789961 96819 476838 388821 103696 193662 337190 817618 815667 823976 824228 821857 825690 828865 827873 827896 530289 532717 540122 533034 534133 537005 537104 538883 533646 538141 516646 479067 547980 566394 549312 554876 562591 648996 651423 653624 654481 655994 659589 663902 665114 666798 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.52%) |
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 95788 96819 100449 103696 193662 251147 337190 382697 386194 388821 393673 396709 476838 479067 516646 530289 532717 533034 533646 533689 534133 537005 537104 538141 538814 538883 539018 540122 547980 549312 554876 559212 562588 562591 566394 606535 622116 623525 633965 638654 639075 643927 646240 648996 649947 650815 650852 651313 651423 653603 653624 653628 653634 654481 654574 655994 656677 659589 663902 663977 665114 666798 666841 679079 691497 692336 694555 697447 699531 699779 702877 703070 710212 712887 715534 716202 716829 732597 733020 733179 741207 743414 745208 748384 748436 749269 749639 752076 758298 758599 759910 761506 766568 770840 771723 773947 775899 775904 776528 784331 787575 789708 789961 800007 801093 805304 809941 814946 815667 817341 817618 818932 819311 821857 823976 824228 825690 827873 827896 828865 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мжм 2005"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.79%) |
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.