Query Metrics
7
Database Queries
7
Different statements
140.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.24 ms (81.30%) |
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 522914 522915 538824 540076 540656 541379 544754 548278 562829 563530 563540 566860 571434 574222 576713 583873 593878 605333 605342 621698 624163 628326 643007 644288 644306 644321 644327 644330 644894 645283 649129 649152 649190 649947 650833 651630 653376 669570 670096 670097 670108 670110 670114 671721 671724 671734 671743 671748 671760 672130 672138 672144 672151 672181 672184 674107 677706 677723 690827 690872 690885 692188 693049 693980 694192 694201 694221 694554 694563 695234 695278 696250 697361 697364 697369 698550 699606 699755 700281 703038 703051 703070 703093 703432 703436 703523 703537 703540 703547 705537 705791 705875 708099 708433 708462 708525 711907 712715 716177 717607 717862 717903 719058 719142 720385 720795 720819 721715 723527 733071 741097 748529 748551 750064 770268 788969 789841 789844 790814 808093 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (11.18%) |
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 583873 628326 593878 720795 522915 672184 674107 690872 750064 671748 522914 703038 719142 670096 548278 748551 571434 576713 671743 733071 690885 770268 671760 538824 671734 644894 649152 669570 703547 649947 703070 653376 670114 677706 672144 670110 719058 672181 644327 621698 644321 712715 690827 717607 695278 703523 788969 695234 566860 671724 672151 720819 644330 708462 672138 563540 703051 717862 717903 644306 703432 649129 705791 677723 708525 741097 693980 696250 697364 672130 693049 699755 789841 748529 720385 703540 721715 705875 562829 574222 790814 697361 692188 544754 711907 540656 624163 650833 541379 703537 670097 698550 540076 670108 694554 694221 705537 808093 703436 723527 694201 671721 699606 643007 789844 645283 651630 694192 694563 700281 703093 649190 708433 644288 605342 708099 716177 563530 697369 605333 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.95%) |
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 522914 522915 538824 540076 540656 541379 544754 548278 562829 563530 563540 566860 571434 574222 576713 583873 593878 605333 605342 621698 624163 628326 643007 644288 644306 644321 644327 644330 644894 645283 649129 649152 649190 649947 650833 651630 653376 669570 670096 670097 670108 670110 670114 671721 671724 671734 671743 671748 671760 672130 672138 672144 672151 672181 672184 674107 677706 677723 690827 690872 690885 692188 693049 693980 694192 694201 694221 694554 694563 695234 695278 696250 697361 697364 697369 698550 699606 699755 700281 703038 703051 703070 703093 703432 703436 703523 703537 703540 703547 705537 705791 705875 708099 708433 708462 708525 711907 712715 716177 717607 717862 717903 719058 719142 720385 720795 720819 721715 723527 733071 741097 748529 748551 750064 770268 788969 789841 789844 790814 808093 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vintage anal threesome"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"vintage анал секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"vintage анал секс втро"
]
|
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.