Query Metrics
7
Database Queries
7
Different statements
177.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.05 ms (87.56%) |
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 107046 396908 411228 417530 420381 422957 423247 427083 433883 434491 435406 438398 440855 451175 456212 468007 468594 484097 484431 485040 486690 489603 490804 491611 497212 499900 501656 504740 505878 507945 508857 511706 512877 515710 517264 526233 526912 527625 527880 530350 533028 535743 536684 538982 543855 546262 546780 547276 552632 557437 559197 559669 559676 561061 569728 569729 569766 572011 574803 574805 575769 575786 576047 580852 581134 583412 588048 598859 601472 602287 602783 602883 622048 622117 624230 651088 653520 695124 704601 712222 716774 719804 726306 739859 742159 742856 747925 748746 751496 753980 754462 754750 761494 762896 764500 765742 766422 770712 771347 773265 778357 789614 790903 794523 797118 797720 799160 799881 801826 802495 814250 816768 817021 817036 817077 817085 817185 818257 820168 824819 ] |
||||||||||||||||||||||||||||||
|
13.44 ms (7.59%) |
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 742856 817085 490804 533028 583412 751496 602287 624230 816768 530350 742159 773265 797118 433883 468007 491611 504740 569766 546780 574805 575769 552632 574803 653520 572011 601472 588048 602783 602883 726306 417530 423247 456212 468594 435406 508857 511706 526233 527880 484097 505878 507945 561061 695124 451175 440855 484431 486690 580852 569728 569729 622048 764500 789614 797720 515710 422957 526912 598859 817185 547276 581134 411228 817036 818257 824819 501656 748746 762896 771347 517264 536684 543855 427083 546262 766422 802495 747925 107046 820168 814250 817021 817077 535743 497212 538982 559669 651088 712222 716774 719804 559676 622117 790903 801826 778357 761494 794523 739859 754750 753980 754462 765742 770712 704601 799160 799881 396908 559197 575786 576047 438398 527625 489603 420381 434491 499900 512877 485040 557437 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.40%) |
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 107046 396908 411228 417530 420381 422957 423247 427083 433883 434491 435406 438398 440855 451175 456212 468007 468594 484097 484431 485040 486690 489603 490804 491611 497212 499900 501656 504740 505878 507945 508857 511706 512877 515710 517264 526233 526912 527625 527880 530350 533028 535743 536684 538982 543855 546262 546780 547276 552632 557437 559197 559669 559676 561061 569728 569729 569766 572011 574803 574805 575769 575786 576047 580852 581134 583412 588048 598859 601472 602287 602783 602883 622048 622117 624230 651088 653520 695124 704601 712222 716774 719804 726306 739859 742159 742856 747925 748746 751496 753980 754462 754750 761494 762896 764500 765742 766422 770712 771347 773265 778357 789614 790903 794523 797118 797720 799160 799881 801826 802495 814250 816768 817021 817036 817077 817085 817185 818257 820168 824819 ] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bondage girl"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм девушк"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.79%) |
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.