Query Metrics
7
Database Queries
7
Different statements
192.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.89 ms (86.81%) |
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 391949 400599 400689 402067 427076 428475 437089 439525 444121 444579 454211 464580 470731 470735 471402 475588 476264 479044 484426 485882 490340 503914 503936 507362 511691 515744 516695 520170 521995 527049 528429 543762 543795 544368 545530 547085 550656 553608 558607 558816 562553 567391 567539 569498 569795 581743 586449 588331 589533 591088 591856 592924 594863 595794 601569 601853 610131 619080 623892 649288 651640 652119 654852 655553 659215 665221 668027 675164 677891 678671 681795 683694 690000 694119 696281 697204 700710 701026 701400 701405 708390 709574 710933 713748 716777 717279 725234 726892 733046 736752 738100 741064 743196 746178 748111 757937 760335 761592 768086 773500 777483 782664 785066 790342 794906 804043 811174 811340 811678 817553 818189 818401 818845 820046 825029 825128 825271 825867 826959 ] |
||||||||||||||||||||||||||||||
|
14.88 ms (7.74%) |
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 694119 716777 553608 558607 567391 569498 588331 595794 586449 591856 811340 811678 785066 768086 726892 708390 710933 794906 400689 402067 427076 444579 454211 470735 476264 479044 464580 470731 485882 503936 511691 528429 484426 690000 826959 818401 665221 545530 581743 601569 471402 439525 521995 760335 777483 543795 567539 544368 623892 591088 594863 444121 437089 527049 659215 543762 547085 550656 562553 649288 654852 675164 701026 651640 655553 681795 683694 696281 709574 652119 668027 677891 700710 701405 569795 589533 619080 610131 725234 733046 748111 757937 697204 701400 817553 790342 767592 825128 825029 746178 738100 741064 804043 516695 601853 782664 391949 515744 520170 428475 761592 811174 678671 592924 400599 818845 818189 820046 825271 825867 713748 717279 773500 736752 507362 558816 475588 490340 503914 743196 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.47%) |
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 391949 400599 400689 402067 427076 428475 437089 439525 444121 444579 454211 464580 470731 470735 471402 475588 476264 479044 484426 485882 490340 503914 503936 507362 511691 515744 516695 520170 521995 527049 528429 543762 543795 544368 545530 547085 550656 553608 558607 558816 562553 567391 567539 569498 569795 581743 586449 588331 589533 591088 591856 592924 594863 595794 601569 601853 610131 619080 623892 649288 651640 652119 654852 655553 659215 665221 668027 675164 677891 678671 681795 683694 690000 694119 696281 697204 700710 701026 701400 701405 708390 709574 710933 713748 716777 717279 725234 726892 733046 736752 738100 741064 743196 746178 748111 757937 760335 761592 768086 773500 777483 782664 785066 790342 794906 804043 811174 811340 811678 817553 818189 818401 818845 820046 825029 825128 825271 825867 826959 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur homemade young"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск домашн любительск young"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск домашн любительск young"
]
|
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.