Query Metrics
7
Database Queries
7
Different statements
152.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.82 ms (82.52%) |
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 136874 154410 386650 386767 387039 387447 389473 389745 404217 405799 414004 426604 443456 445740 445751 456920 460135 463906 465480 468473 468525 470848 505836 516750 516764 516768 516770 518975 525756 530028 531114 531126 531171 531225 531229 531242 532852 532902 534986 534993 534995 536927 544833 545337 545353 550846 553282 562491 564392 590312 590850 597197 599631 599971 617417 617429 617437 631247 632645 632655 634163 637133 639008 639027 640723 640795 641678 644961 649560 658992 666551 666819 673619 674978 675430 676808 678127 681687 683158 684213 692069 716745 716878 717318 718158 721983 727888 741288 746980 746994 750881 754210 756092 756398 759865 766847 766880 770314 771482 771649 776164 780574 782659 785291 788283 790381 804370 805069 809239 809302 810839 814733 814796 818494 821905 822728 822922 823794 828457 ] |
||||||||||||||||||||||||||||||
|
16.77 ms (11.00%) |
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 531229 673619 617417 516764 639008 387447 790381 809239 460135 531171 545353 666551 640795 468473 756092 470848 536927 564392 456920 426604 649560 750881 414004 637133 389745 443456 516768 683158 805069 465480 545337 776164 782659 814796 550846 534986 516750 531114 721983 387039 404217 463906 532902 640723 518975 553282 617429 632655 386767 716745 746980 746994 525756 675430 634163 597197 599971 785291 809302 771649 154410 770314 766847 814733 658992 766880 741288 771482 717318 681687 756398 666819 718158 531126 684213 389473 780574 644961 531242 532852 674978 531225 639027 692069 823794 445751 136874 468525 788283 754210 676808 810839 534995 516770 617437 632645 544833 590850 590312 821905 562491 386650 678127 530028 641678 505836 716878 631247 822993 828457 804370 818494 822728 822922 599631 445740 534993 759865 727888 405799 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.89%) |
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 136874 154410 386650 386767 387039 387447 389473 389745 404217 405799 414004 426604 443456 445740 445751 456920 460135 463906 465480 468473 468525 470848 505836 516750 516764 516768 516770 518975 525756 530028 531114 531126 531171 531225 531229 531242 532852 532902 534986 534993 534995 536927 544833 545337 545353 550846 553282 562491 564392 590312 590850 597197 599631 599971 617417 617429 617437 631247 632645 632655 634163 637133 639008 639027 640723 640795 641678 644961 649560 658992 666551 666819 673619 674978 675430 676808 678127 681687 683158 684213 692069 716745 716878 717318 718158 721983 727888 741288 746980 746994 750881 754210 756092 756398 759865 766847 766880 770314 771482 771649 776164 780574 782659 785291 788283 790381 804370 805069 809239 809302 810839 814733 814796 818494 821905 822728 822922 823794 828457 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black blowjob"
]
|
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.