Query Metrics
7
Database Queries
7
Different statements
168.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.90 ms (84.30%) |
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 388180 397437 423936 428229 428282 434324 435535 435591 435593 439059 439531 439572 440891 441099 445745 449377 450572 453601 454304 456222 456238 457512 460533 461704 462553 462840 466475 467872 467886 487428 496149 505575 505600 505661 507951 508556 510781 510997 511864 513639 517272 519699 521139 524147 525700 534561 537237 541275 542704 546150 547785 547788 548157 552819 554997 556339 556877 556888 556909 560533 582775 592650 597534 601338 605378 605711 609071 610256 610280 619272 619322 624925 661933 662046 669880 679972 680801 681798 704990 705007 715792 716086 735888 738501 742355 742703 743893 744408 750723 757860 767462 768240 778220 778720 782846 784294 789459 789479 792681 792689 792693 792697 792710 792713 792724 792730 792740 792753 794293 794307 796332 796876 796883 801606 805144 805341 806976 818103 825439 827653 ] |
||||||||||||||||||||||||||||||
|
16.36 ms (9.72%) |
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 805144 610280 792693 661933 552819 556339 556888 548157 554997 592650 609071 619322 597534 466475 450572 505661 517272 704990 806976 789479 445745 679972 818103 462553 435535 511864 556909 662046 456238 460533 487428 496149 513639 542704 716086 705007 778220 789459 792710 767462 757860 742355 439572 624925 439531 534561 519699 537237 680801 546150 792724 792753 796883 792681 794293 796876 605711 556877 456222 434324 428229 507951 715792 750723 743893 610256 778720 796332 744408 768240 735888 435593 441099 453601 541275 582775 461704 467886 457512 524147 525700 505600 669880 510781 784294 435591 619272 801606 792713 805341 792697 397437 462840 440891 827653 508556 547785 782846 794307 792730 738501 792689 792740 742703 388180 423936 454304 505575 681798 601338 605378 467872 428282 439059 521139 449377 547788 510997 825439 560533 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.91%) |
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 388180 397437 423936 428229 428282 434324 435535 435591 435593 439059 439531 439572 440891 441099 445745 449377 450572 453601 454304 456222 456238 457512 460533 461704 462553 462840 466475 467872 467886 487428 496149 505575 505600 505661 507951 508556 510781 510997 511864 513639 517272 519699 521139 524147 525700 534561 537237 541275 542704 546150 547785 547788 548157 552819 554997 556339 556877 556888 556909 560533 582775 592650 597534 601338 605378 605711 609071 610256 610280 619272 619322 624925 661933 662046 669880 679972 680801 681798 704990 705007 715792 716086 735888 738501 742355 742703 743893 744408 750723 757860 767462 768240 778220 778720 782846 784294 789459 789479 792681 792689 792693 792697 792710 792713 792724 792730 792740 792753 794293 794307 796332 796876 796883 801606 805144 805341 806976 818103 825439 827653 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur russian fisting"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск русск фистинг"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.92%) |
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.