Query Metrics
7
Database Queries
7
Different statements
153.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.50 ms (81.34%) |
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 187349 401070 401228 407791 412180 414070 416009 418720 419459 419640 419765 426258 428100 428603 428767 434411 434859 435734 435745 437592 443452 447231 449231 450250 452843 452847 454865 459398 464642 464659 468250 469543 470841 471067 473302 474596 477688 478995 481367 489579 493361 494298 499699 505078 510522 511153 511951 512477 513588 514097 516024 517422 518756 519476 520618 520972 523796 524562 525474 526073 526789 535353 550402 550623 552991 554124 555899 559367 562856 565768 569082 569784 570697 570870 574240 574893 575486 575708 579396 587919 589795 590602 598842 602008 602957 605015 605529 613708 615821 617445 618199 618591 622348 630558 630910 633216 637247 648877 657136 659981 663294 665990 674474 675427 683973 698457 699160 712684 718513 726517 726547 761293 765712 783291 803317 803463 808060 812043 813427 826218 ] |
||||||||||||||||||||||||||||||
|
17.93 ms (11.71%) |
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 550402 683973 698457 718513 659981 665990 674474 570697 574240 598842 637247 617445 618199 615821 618591 630558 813427 726517 761293 803463 726547 765712 630910 633216 699160 783291 803317 419640 468250 434411 469543 471067 443452 435734 519476 401070 419459 452847 535353 550623 570870 648877 524562 435745 450250 464659 520618 481367 565768 657136 473302 511951 526073 516024 517422 414070 452843 493361 478995 675427 518756 510522 412180 437592 419765 826218 447231 449231 470841 523796 494298 512477 513588 526789 575708 579396 569784 559367 562856 712684 555899 569082 605015 605529 590602 602957 622348 812043 187349 428603 418720 511153 520972 407791 428767 459398 464642 474596 575486 574893 554124 499699 489579 602008 428100 514097 525474 552991 663294 613708 587919 589795 808060 434859 454865 416009 477688 505078 401228 426258 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.97%) |
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 187349 401070 401228 407791 412180 414070 416009 418720 419459 419640 419765 426258 428100 428603 428767 434411 434859 435734 435745 437592 443452 447231 449231 450250 452843 452847 454865 459398 464642 464659 468250 469543 470841 471067 473302 474596 477688 478995 481367 489579 493361 494298 499699 505078 510522 511153 511951 512477 513588 514097 516024 517422 518756 519476 520618 520972 523796 524562 525474 526073 526789 535353 550402 550623 552991 554124 555899 559367 562856 565768 569082 569784 570697 570870 574240 574893 575486 575708 579396 587919 589795 590602 598842 602008 602957 605015 605529 613708 615821 617445 618199 618591 622348 630558 630910 633216 637247 648877 657136 659981 663294 665990 674474 675427 683973 698457 699160 712684 718513 726517 726547 761293 765712 783291 803317 803463 808060 812043 813427 826218 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"watch at ass"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"watch жоп"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"watch жоп"
]
|
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.