Query Metrics
7
Database Queries
7
Different statements
159.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.72 ms (82.55%) |
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 187903 191356 381846 382230 384917 396048 405543 407761 409324 411926 414750 417002 419264 422646 423475 432982 437717 437874 446790 448651 450164 459765 462677 463935 469451 473080 474880 478637 483951 485357 485617 488408 490684 496524 501262 502649 503842 505607 507004 508083 511600 518872 520792 521786 523970 524364 524881 526126 528097 531499 532061 532221 534880 542785 544095 547180 551256 552665 554256 554674 556324 559007 561392 564984 571481 577488 585885 590550 593964 596116 596721 599412 600398 604104 604106 609630 616818 618364 629847 652182 659344 662052 671233 673923 678561 685818 689005 692750 693385 696316 696832 700509 703915 704928 705630 706611 708585 712010 721318 723074 723084 724285 725569 726625 731818 740164 740251 747094 758261 762718 763443 782653 790871 800930 809967 812109 812553 814945 818229 818488 ] |
||||||||||||||||||||||||||||||
|
16.97 ms (10.63%) |
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 763443 758261 604104 532221 501262 534880 531499 542785 671233 596116 723084 396048 505607 384917 559007 700509 596721 618364 585885 474880 507004 818488 483951 547180 721318 662052 696316 703915 554674 604106 724285 800930 812553 725569 731818 762718 747094 705630 409324 459765 473080 532061 485357 382230 485617 524881 462677 685818 782653 526126 520792 524364 423475 469451 571481 561392 692750 712010 696832 706611 659344 673923 678561 693385 704928 708585 590550 600398 593964 809967 812109 740164 726625 419264 437717 450164 381846 478637 414750 407761 437874 446790 552665 652182 556324 609630 790871 629847 490684 496524 554256 689005 814945 503842 463935 508083 511600 518872 411926 422646 599412 616818 740251 405543 417002 187903 191356 502649 488408 521786 523970 432982 818229 448651 528097 564984 551256 544095 577488 723074 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (2.04%) |
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 187903 191356 381846 382230 384917 396048 405543 407761 409324 411926 414750 417002 419264 422646 423475 432982 437717 437874 446790 448651 450164 459765 462677 463935 469451 473080 474880 478637 483951 485357 485617 488408 490684 496524 501262 502649 503842 505607 507004 508083 511600 518872 520792 521786 523970 524364 524881 526126 528097 531499 532061 532221 534880 542785 544095 547180 551256 552665 554256 554674 556324 559007 561392 564984 571481 577488 585885 590550 593964 596116 596721 599412 600398 604104 604106 609630 616818 618364 629847 652182 659344 662052 671233 673923 678561 685818 689005 692750 693385 696316 696832 700509 703915 704928 705630 706611 708585 712010 721318 723074 723084 724285 725569 726625 731818 740164 740251 747094 758261 762718 763443 782653 790871 800930 809967 812109 812553 814945 818229 818488 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toy dick"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"toy член"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"toy член"
]
|
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.