Query Metrics
7
Database Queries
7
Different statements
174.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.07 ms (84.45%) |
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 21108 88031 88286 117610 154310 154463 159370 188560 321277 352211 383924 397197 398089 398376 407436 413673 415874 415876 415879 416522 416536 416580 416583 416639 416670 416676 416683 416742 417348 424765 426284 432674 432933 437723 452800 454804 455080 464497 467585 468949 471122 473437 475420 483742 487293 489331 493861 500288 512852 513830 514233 514316 515423 515588 518550 523176 525279 525468 529034 530438 531929 534447 538066 541533 545242 550891 550892 550897 552069 554675 556139 557720 559775 564070 564463 569593 573268 574038 576951 588617 595464 600887 600938 621562 638674 642013 643159 648960 650246 666857 676689 701285 738494 740926 744024 744805 745292 749656 752654 752932 754947 758508 770397 778108 779866 780329 780387 780390 782614 782998 786888 791920 794303 798297 799069 803554 806451 808611 827967 ] |
||||||||||||||||||||||||||||||
|
16.02 ms (9.20%) |
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 574038 794303 556139 437723 398376 416522 666857 676689 791920 758508 600938 154310 21108 473437 530438 531929 538066 550892 701285 550897 417348 514316 564070 648960 650246 621562 588152 808611 778108 782614 799069 744805 745292 754947 738494 744024 749656 779866 780390 806451 500288 415874 416583 416742 416536 416580 416639 416670 464497 454804 468949 475420 564463 569593 588617 770397 432933 471122 416676 416683 426284 529034 483742 489331 525279 117610 352211 523176 534447 550891 638674 643159 397197 383924 88031 554675 541533 545242 559775 595464 786888 798297 752654 752932 780329 780387 782998 803554 432674 552069 487293 513830 515423 493861 600887 740926 642013 512852 576951 827967 154463 321277 415879 424765 452800 455080 467585 515588 514233 557720 573268 88286 407436 525468 518550 159370 188560 398089 413673 415876 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.62%) |
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 21108 88031 88286 117610 154310 154463 159370 188560 321277 352211 383924 397197 398089 398376 407436 413673 415874 415876 415879 416522 416536 416580 416583 416639 416670 416676 416683 416742 417348 424765 426284 432674 432933 437723 452800 454804 455080 464497 467585 468949 471122 473437 475420 483742 487293 489331 493861 500288 512852 513830 514233 514316 515423 515588 518550 523176 525279 525468 529034 530438 531929 534447 538066 541533 545242 550891 550892 550897 552069 554675 556139 557720 559775 564070 564463 569593 573268 574038 576951 588617 595464 600887 600938 621562 638674 642013 643159 648960 650246 666857 676689 701285 738494 740926 744024 744805 745292 749656 752654 752932 754947 758508 770397 778108 779866 780329 780387 780390 782614 782998 786888 791920 794303 798297 799069 803554 806451 808611 827967 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl and dildo"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк дилд"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк дилд"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.04%) |
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.