Query Metrics
7
Database Queries
7
Different statements
213.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.93 ms (90.97%) |
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 29148 385884 396375 408842 414229 414241 444614 454749 462220 475457 506070 515267 529083 529753 530424 531631 533292 534477 535185 536035 536108 536111 536267 537997 538326 538505 539197 539706 540287 540516 541655 541920 548100 548940 548947 548965 549550 551051 552109 552751 553807 554697 556061 556194 557921 562577 566739 568500 575999 584295 584341 585802 627200 628602 645508 645681 646286 649361 650232 652591 655304 656851 657537 657561 658840 662131 662803 666410 669282 669930 670760 671819 672323 675409 676944 678897 682926 683494 684843 684855 684888 691362 693084 702985 703255 705210 705389 708716 711147 715377 717322 719425 722284 722399 736841 739300 740820 742231 744949 745119 747592 749118 750947 751020 751625 751741 752747 752835 753101 753599 755347 757017 766173 788506 819958 820071 822975 823317 825133 826941 ] |
||||||||||||||||||||||||||||||
|
10.37 ms (4.86%) |
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 749118 750947 751020 757017 766173 736841 745119 751625 752747 752835 753599 755347 739300 742231 747592 751741 740820 744949 753101 627200 702985 703255 788506 414241 444614 557921 628602 414229 454749 506070 385884 29148 396375 408842 822975 823317 826941 819958 820071 825133 462220 475457 530424 536035 536108 536111 536267 539706 529083 534477 538505 540287 515267 531631 537997 539197 540516 529753 533292 535185 538326 552751 553807 566739 584341 548100 568500 541655 541920 551051 552109 556061 575999 645508 645681 650232 656851 657537 657561 658840 662131 683494 684888 691362 711147 715377 646286 662803 666410 670760 675409 705389 708716 722284 649361 652591 655304 669282 669930 671819 672323 676944 678897 682926 684843 684855 693084 705210 717322 719425 722399 548940 548947 548965 549550 554697 556194 562577 584295 585802 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.33%) |
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 29148 385884 396375 408842 414229 414241 444614 454749 462220 475457 506070 515267 529083 529753 530424 531631 533292 534477 535185 536035 536108 536111 536267 537997 538326 538505 539197 539706 540287 540516 541655 541920 548100 548940 548947 548965 549550 551051 552109 552751 553807 554697 556061 556194 557921 562577 566739 568500 575999 584295 584341 585802 627200 628602 645508 645681 646286 649361 650232 652591 655304 656851 657537 657561 658840 662131 662803 666410 669282 669930 670760 671819 672323 675409 676944 678897 682926 683494 684843 684855 684888 691362 693084 702985 703255 705210 705389 708716 711147 715377 717322 719425 722284 722399 736841 739300 740820 742231 744949 745119 747592 749118 750947 751020 751625 751741 752747 752835 753101 753599 755347 757017 766173 788506 819958 820071 822975 823317 825133 826941 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen solo teen"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen соло teen"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen соло teen"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.57%) |
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.