Query Metrics
7
Database Queries
7
Different statements
187.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.28 ms (89.72%) |
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 197574 370332 385386 386784 435388 436462 443417 466333 470117 499020 506504 512592 517966 519330 527819 527845 532642 536245 540728 544089 545029 551622 552903 553663 555346 557574 560263 561534 562566 563252 564806 578352 587655 589648 590537 591229 599352 600741 601897 603389 603752 615042 619964 637507 640905 659350 659353 660276 662074 664455 674587 674603 675193 682943 690744 695432 696395 696764 702636 704955 707786 710041 713753 715964 717949 717977 719109 719302 723429 724887 726143 728756 731062 731160 731697 733155 734465 740997 742768 755048 755918 756661 762994 763146 763173 765084 766361 767669 769443 770509 778748 778837 779008 779973 780388 782969 785056 785422 786080 787308 787801 787982 789483 789726 789859 790558 790701 790839 793653 793739 795575 795985 796008 796017 796023 796158 796214 800956 803685 810373 ] |
||||||||||||||||||||||||||||||
|
9.09 ms (4.84%) |
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 800956 197574 443417 435388 470117 536245 512592 540728 517966 532642 552903 544089 551622 545029 560263 563252 675193 682943 717977 659353 664455 695432 696395 696764 715964 719302 660276 662074 707786 710041 717949 557574 589648 637507 600741 601897 603752 619964 779008 779973 780388 782969 789726 790701 793653 793739 796158 778837 785422 786080 787308 787801 789483 789859 790839 795985 796023 803685 733155 734465 755048 762994 769443 770509 785056 790558 795575 796214 763173 731062 742768 766361 767669 763146 724887 726143 728756 731160 731697 740997 755918 756661 765084 702636 713753 723429 778748 796017 810373 386784 385386 553663 506504 519330 561534 659350 599352 527845 555346 690744 590537 591229 615042 640905 370332 499020 578352 719109 674603 704955 787982 436462 527819 466333 562566 674587 564806 587655 603389 796008 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.46%) |
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 197574 370332 385386 386784 435388 436462 443417 466333 470117 499020 506504 512592 517966 519330 527819 527845 532642 536245 540728 544089 545029 551622 552903 553663 555346 557574 560263 561534 562566 563252 564806 578352 587655 589648 590537 591229 599352 600741 601897 603389 603752 615042 619964 637507 640905 659350 659353 660276 662074 664455 674587 674603 675193 682943 690744 695432 696395 696764 702636 704955 707786 710041 713753 715964 717949 717977 719109 719302 723429 724887 726143 728756 731062 731160 731697 733155 734465 740997 742768 755048 755918 756661 762994 763146 763173 765084 766361 767669 769443 770509 778748 778837 779008 779973 780388 782969 785056 785422 786080 787308 787801 787982 789483 789726 789859 790558 790701 790839 793653 793739 795575 795985 796008 796017 796023 796158 796214 800956 803685 810373 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм рот"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сперма для рот"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм рот"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.94%) |
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.