Query Metrics
7
Database Queries
7
Different statements
288.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
265.93 ms (92.07%) |
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 220876 395449 400969 411508 417100 432405 435657 442464 444163 444644 446916 447687 450765 453778 459529 464047 464475 464485 467682 467686 469680 470399 477420 478749 478764 484007 493217 496805 503713 514769 514775 514779 516453 517375 518024 521361 522509 524251 525140 532832 543623 543970 551803 553256 557111 557529 559443 560519 561209 565879 566701 569655 572210 574251 584689 585761 591901 592799 602671 623956 626366 628812 655505 670749 673513 674266 674590 696526 698199 700635 703503 709496 709894 712617 714327 716002 722071 727153 730941 734932 743670 744049 748120 752135 753693 758890 759361 760397 761501 766365 767993 770742 771139 772859 775407 776241 777897 780469 787882 793554 793626 794177 801055 808251 810632 817989 818392 818748 820214 823554 823600 823724 824125 824877 825176 825208 825278 827254 827264 827634 ] |
||||||||||||||||||||||||||||||
|
12.43 ms (4.31%) |
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 467686 560519 432405 469680 493217 514779 794177 623956 517375 543623 551803 626366 823724 823554 818392 801055 793626 808251 766365 787882 817989 825176 825278 557529 777897 780469 727153 748120 759361 734932 771139 767993 770742 417100 532832 522509 496805 572210 561209 574251 709894 655505 670749 674266 712617 674590 696526 700635 714327 557111 566701 585761 591901 628812 592799 776241 775407 743670 772859 698199 703503 709496 569655 602671 464485 516453 730941 744049 722071 442464 444644 453778 450765 478764 467682 478749 400969 514769 753693 752135 761501 827264 559443 464047 524251 395449 411508 444163 459529 464475 470399 446916 518024 584689 543970 553256 565879 435657 447687 477420 503713 484007 514775 521361 525140 673513 758890 760397 220876 820214 823600 825208 827254 824125 824877 818748 827634 716002 793554 810632 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.03%) |
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 220876 395449 400969 411508 417100 432405 435657 442464 444163 444644 446916 447687 450765 453778 459529 464047 464475 464485 467682 467686 469680 470399 477420 478749 478764 484007 493217 496805 503713 514769 514775 514779 516453 517375 518024 521361 522509 524251 525140 532832 543623 543970 551803 553256 557111 557529 559443 560519 561209 565879 566701 569655 572210 574251 584689 585761 591901 592799 602671 623956 626366 628812 655505 670749 673513 674266 674590 696526 698199 700635 703503 709496 709894 712617 714327 716002 722071 727153 730941 734932 743670 744049 748120 752135 753693 758890 759361 760397 761501 766365 767993 770742 771139 772859 775407 776241 777897 780469 787882 793554 793626 794177 801055 808251 810632 817989 818392 818748 820214 823554 823600 823724 824125 824877 825176 825208 825278 827254 827264 827634 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping homemade"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"спящ домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.56%) |
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.