Query Metrics
7
Database Queries
7
Different statements
146.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.11 ms (84.13%) |
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 32999 118109 187709 188462 368335 382947 385562 385974 386866 389653 390728 395704 398969 403322 407759 411333 411338 411349 413081 439574 443334 443771 450809 451937 452121 452234 460906 464341 465825 465834 467469 471417 471449 474080 474095 474104 474106 474478 474485 474506 474680 474824 474843 477718 477730 479102 479103 479136 484379 484435 485775 487318 490193 499553 502724 503431 503811 520867 526208 561042 589662 591877 591910 601869 609689 645822 665406 665414 665415 665461 666111 667196 696312 702179 710531 710560 714199 716221 719898 720264 720290 720599 721974 721983 724233 724702 725537 725561 726838 728142 728237 728445 732258 732373 735484 736399 742249 742433 743780 743803 744993 745196 745397 746168 748206 748234 748238 760976 761012 761326 769491 772459 789552 790813 811475 814125 818449 820309 824265 827583 ] |
||||||||||||||||||||||||||||||
|
13.77 ms (9.41%) |
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 665414 665415 696312 716221 719898 667196 714199 721983 665461 720264 589662 591910 591877 728445 748206 748234 748238 726838 736399 772459 745397 725537 732373 724233 743803 411333 188462 411338 474824 479136 474485 403322 411349 407759 385974 386866 118109 187709 474843 601869 790813 724702 728237 735484 743780 769491 742433 761012 761326 710531 720599 390728 490193 502724 474506 721974 742249 745196 382947 32999 452234 477718 526208 710560 811475 398969 474478 484435 814125 818449 827583 820309 824265 702179 720290 665406 666111 789552 760976 744993 746168 732258 368335 728142 474095 503431 443771 443334 439574 474680 477730 561042 389653 413081 451937 452121 471417 499553 520867 474080 485775 645822 609689 725561 464341 479102 450809 460906 385562 467469 471449 474104 474106 465825 465834 479103 487318 503811 484379 395704 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.76%) |
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 32999 118109 187709 188462 368335 382947 385562 385974 386866 389653 390728 395704 398969 403322 407759 411333 411338 411349 413081 439574 443334 443771 450809 451937 452121 452234 460906 464341 465825 465834 467469 471417 471449 474080 474095 474104 474106 474478 474485 474506 474680 474824 474843 477718 477730 479102 479103 479136 484379 484435 485775 487318 490193 499553 502724 503431 503811 520867 526208 561042 589662 591877 591910 601869 609689 645822 665406 665414 665415 665461 666111 667196 696312 702179 710531 710560 714199 716221 719898 720264 720290 720599 721974 721983 724233 724702 725537 725561 726838 728142 728237 728445 732258 732373 735484 736399 742249 742433 743780 743803 744993 745196 745397 746168 748206 748234 748238 760976 761012 761326 769491 772459 789552 790813 811475 814125 818449 820309 824265 827583 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature большие"
]
|
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.